I have a query that returns a sequence of metrics for up to 20 categories. Some categories have values in the 1-5 range, others in 10-50, and yet others where the values are typically 1000+.
What I am interested in, is seeing the trend for each category, and still be able to somehow see the actual values.
For now, I am just creating a line-chart where I group by the categories. So a series per category. But they are hard to read, as the categories with low values range just end up in the bottom as a more or less straight line.
In other visualization tools, I have been able to create a chart per category dynamically as a solution to this. Which has worked fine. I don’t see this option in redash. Any suggestions or recommendations?