Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am preparing a Line where my Dimensions are State and month. In the line chart, I am trying to represent the accident reported in each month from all state. In the line chart, I am showing Top file states having more accidents each month.
State Month Accident Count %
A Jan'15 100
A Feb'15 150
A Mar'15 140
B Jan'15 80
B Feb'15 100
B Mar'15 110
B Jan'15 180
B Feb'15 110
B Mar'15 140
Percentage calculation will happen accident reported each month for each state/total accident reported. I want to my Line chart to show top 5 states having highest accident on a monthly basis but the value which will represent on the chart would be % of accident.
In short, top 5 states having highest accident count month on month.
Hope i explained it well.
Thanks in advance.
Regards,
Imran Khan
Set the state to be the first dimension.
In the Sort tab /Sort By, check the box "Y Value".
In the Presentation tab, check the Maximum Visible Number and enter 5 next to it.
Hope this helps if I understood it correctly.
See this example
Or this: