Skip to Content

Ranking in Graph

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 05, 2017 at 07:52 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 06, 2017 at 03:47 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded