Hi All,
I have a requirement where I have to present top 10 plate number (vehicle registration number) which has visited the most in a site for each month. For this requirement I develop a custom SQL script by using dense_rank function and got my data ready. Now i want to present the data in a bar chart .
The Challange I am facing while I am trying to prsent these plate number in a bar chart , while this can be represent in a tabular view with the total visit count details as well. But when i am trying to represent this data in a bar chart, not only facing challenges to represent all 10 plate number (you can see in the graph for some month it is showing 6 bars and for some it is showing 4 bars) but also sort them as per their rank.
Can anyone help me to understand why I am getting this sort of result and what is the right approach for the same.
Thank you
Barnana