Sum Up Top N

[qolkaram]

HI every one ,

I have below sample data:

REPORT_DATE	month	Site_ID	outage
6/1/2016	2016-06	1	120
6/2/2016	2016-06	1	500
6/1/2016	2016-06	2	300
7/1/2016	2016-07	4	120
7/2/2016	2016-07	3	500
7/2/2016	2016-07	3	300

I want to sum up Top N Site Outage per month (first i should calculate site outage per month then sum up top N site outage per month) .  I have to do it in front end (in expression) not in script.

I appreciate if someone help me.

[qolkaram]

here is my requirement:

1- calculate total monthly outage  for each site_id 

2- select top 25 side_id with highest outage for each month .

3- sum up the 25 outage for each month and plot it in a bar chart

[tresesco]

Do you want to see single bar for each month?

[sdmech81]

Hi May be like this:

Add dimension I graph as =month(Date(Date#(month,'YYYY-MM')))

and expression as =Aggr(Rank(sum(outage),25),Site_ID)

Plss try and let me know..

[qolkaram]

yes,like the chart attached in my previews post

[qolkaram]

there is a meesage  "No Data To display" on the chart

[qolkaram]

can any one help me to overcome to this issue??