I am using Druid to visualize a high cardinality data set. Ideally, I would like to issue a TopN query over my data set and have it return the dimensions with the highest average over the entire query interval.
Specifically, I would like to get the Top 5 highest dimensions if you were to take all points and average them across the entire dataset. Then I would like it to return all data points in that entire interval inclusive of the timestamp to draw a line graph.
Let me know if there are any questions or confusion, I really appreciate the help!