I am trying to aggregate some information, but am not super familiar with Influx, let alone the language.
I have a dataset I have already filtered down:
What I would like to do is count how many instances of each lookup (DE:2,FR:1,RO:1,US:3 for this screenshot)
Whenever I uncomment count, regardless of what I count it off of, I get 1 column returned, with numbers returned, but there is no
lookup column, to link the numbers to anything useful.
How can I produce useful aggregate data for the above, and keep it as one table output as well?