I have a measurement with “customerCountIN” as field and “hour”, “weekday” as tags. I want to retrieve the top 3 customerCountIN with corresponding hour and weekday as tags.
Running the below query returns hour and weekday as fields and NOT as tags:
> select top(customerCountIN, hour, weekday, 3) from "PcDetailedDaily"
name: PcDetailedDaily
time top hour weekday
---- --- ---- -------
1542962700000000000 117 8 Fri
1542963600000000000 132 9 Fri
1542969000000000000 126 10 Fri
How do I retain the tags?