Top5 using Set analysis with rank() in Line Chart

[ravikumar_iyana]

Hi Community,

I'm facing an one issue in evaluate expression.

I'm providing sample data please check below:

workload:

Log Hour	WDNAME	Delay_time_min
0	WD-BATCH	30.73
1	WD-Stats	30.62
5	WD-BATCH-NoUtil-AllAmp	29.50
6	WD-BATCH-NoUtil-AllAmp	29.42
7	WD-RPT-Short-Tblu	29.26
8	WD-BATCH-High-NoUtil-AllAmp	26.93
9	WD-Stats	26.64
15	WD-Stats	45.63
16	WD-BATCH-NoUtil-AllAmp	22.67
20	WD-BATCH-NoUtil-AllAmp	43.89
23	WD-RPT-Short-FDW	24.66

Required line chart:

I'm taking: 

Dimensions 1.Log Hour

                         2. WDNAME(Top 5)

trying expression like this =Sum({<workload= {'Rank(Sum(DelayTime_Mins),4) <= 5'}>} DelayTime_Mins)

note: table name: workload

Measure: Delay_time_min

[Frank_Hartmann]

what about this?:

Sum({<Delay_time_min= {"=Rank(Sum(Delay_time_min),4) <= 5"}>} Delay_time_min)

[ravikumar_iyana · Accepted solution]

Hi All,

Thanks for your suggestion.

I tried like this expression in 2nd dimension level "=IF(Aggr(Rank(SUM(DelayTime_Mins),4),WDName)<=5,WDName)"