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.
I don’t have any solutions, but I can offer some explanations.
For showing all 10 plate numbers - that should come down to what data you have. If a month only shows 6 bars, that would mean that there is only data for 6 plates in that month. Are you seeing that as well?
For sorting by rank, this will be basically impossible to do per-month. The sorting of bars per month will be the same for every month in Looker Studio. In your results, I think it is sorted by plate number.
You could in theory have it sorted by rank, but then it will only sort by the global rank over all months, not the rank of each month. Also, that will cause the legend to show the rank number and not the plate number, which is not ideal.
