Data from not showing from select

1

Good evening all - I am trying to get some top xx data out of influx, and being both a influx and sqlish newbie I am struggling to understand what I am doing wrong

If have this query

SELECT sum(value) as total FROM issue GROUP BY user

where value is a field that is 1 , and user is a tag

this does give me the data I want : a list of all the users with the total number of issues

so, now I want a “top 10”, and change the query to this

SELECT top(total,10), user from (SELECT sum(value) as total FROM issue GROUP BY user)

I do indeed get the top 10 records, but the user column is blank

what am I missing ?

thanks

2

no takers ? I really would like to know what I am doing wrong , as I think I have done everything right :slight_smile:

3

Try grouping it by user under top query like this

SELECT top(total,10) from (SELECT sum(value) as total FROM issue GROUP BY user) GROUP BY user