How do I chart top categories over time?

[POR160893]

Hi,

I need to create a chart to show top categories per time.

At the moment, the timechart I am getting is placing the time axis on the y-axis and the categories on the x-axis. In addition, there are over 50 possible categories and the user should be seeing the top 20 categories with the respective count for each time period. So I would imagine 20 line of the graph, no?

Here is what I currently have:

Can you please help?


Many thanks,

Patrick

[ITWhisperer]

Change the chart type from Bar chart to Column chart

[POR160893]

Thanks 🙂

As I am showing the top categories by count over time, one of the categories makes up over 98% of the entries,. So, one the chart, that entry appears to be the only category being hit. 

Is it possible to shew the the count bar so that the other categories become visible too?

[ITWhisperer]

A couple of things you could try.

Change the y-axis scale to a logarithmic scale.

Move the high volume category into an overlay with View as Axis On.

[POR160893]

Perfect, this solved my issue 100% 😀