topic Re: Chart top categories over time in Dashboards & Visualizations

How do I chart top categories over time?

POR160893 — Mon, 21 Mar 2022 19:08:05 GMT

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

Re: Chart top categories over time

ITWhisperer — Mon, 21 Mar 2022 13:05:28 GMT

Change the chart type from Bar chart to Column chart

Re: Chart top categories over time

POR160893 — Mon, 21 Mar 2022 13:22:33 GMT

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.

POR160893_0-1647868943770.png

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

Re: Chart top categories over time

ITWhisperer — Mon, 21 Mar 2022 13:34:51 GMT

A couple of things you could try.

Change the y-axis scale to a logarithmic scale.

ITWhisperer_0-1647869493558.png

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

ITWhisperer_1-1647869647783.png

Re: Chart top categories over time

POR160893 — Mon, 21 Mar 2022 13:51:28 GMT

Perfect, this solved my issue 100% 😀