Skip to Content
0

Ranking in Graph

Aug 04, 2017 at 03:58 PM

51

avatar image
Former Member

Hello all,

Please advice on resolving issues with the following requirement. Note that I do not have the ability to make any changes to the Universe at this time, so the solution has to be on WebI.

Query output (filtered for last 3 years)-

Incident_ID, Description, Location, Year, Month

Measure - Incident Count = Count (Distinct Incident ID)

Report has Line graph for Monthly Incident Count for each year. Category Axis = Month, Measure = Incident Count, Region Color = Year.

The requirement here is to include data from only top 5 locations in the graph. I get the ranks using RANK function for location. However it does not work when applied to the graph as Location dimension is not included in the graph data set. Is there a way to overcome this issue? I tried adding ForEach context to the measure, but maybe I am not doing it right.

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Aug 05, 2017 at 07:52 PM
0

have you tried to inculde the location dimension in graph and hide it.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 06, 2017 at 03:47 PM
0

Hello Amit,

I tried that but it returns multiple x-axis instances for each month. There are 5 distinct locations in the data set which return 5 ticks for Jan, 5 for Feb and so on.

Share
10 |10000 characters needed characters left characters exceeded