Grafana 7: table aggregate values to the same column

Grafana
1

Hello, I have an influxdb that has information on the users in each server. I would like to aggregate the information so that I will be able to see a list of all hosts and a user for each host. I’ve tried with aliasing but it does not work.
For some reason the I have two user columns
Is it possible to do it?

Thanks

image
image1163×531 40.1 KB

2

I don’t know influxdb as such but you can probably use a database table UNION or UNION ALL something like:

select user1 as user from ? where ? group by ?
UNION
select user2 as user from ? where ? group by ?

Take a look at influxdb docs for union.

3

I’ve tried, but I can manage to find the correct query, can you offer any more help? Thank you very much!