2 Replies Latest reply: Aug 18, 2016 5:27 AM by Manuel Capella

# How to Ignore Day Selection

Hi,

Anyone can help me how to Ignore DAY Selection from these Set Analysis ?

I have two set analysis :

1. Max(Aggr(Avg({\$<YEAR_MONTH = {"\$(=max(YEAR_MONTH))"},  ONL_BTC = {"BTC"}, WEEKDAY-={'Sun','Sat'}, HOLIDAY_FLG={'N'}>}ESAP),DT))

2. FirstSortedValue(DT, -Aggr(Avg({< ONL_BTC = {"BTC"}, YEAR_MONTH = {"\$(=max(YEAR_MONTH))"}, WEEKDAY-={'Sun','Sat'}, HOLIDAY_FLG={'N'}>} ESAP), DT))

I want the Value of Max AVG CPU 1 (21.90) and DT Max Avg CPU (15 Jun 2016) are not Change, when I click the number of DAY

Right now the value of those KPI, are changed when I click the DAY.

Thanks

• ###### Re: How to Ignore Day Selection

See if my response here helps: Ignore Selection for Max Avg

• ###### Re: How to Ignore Day Selection

1. Max(Aggr(Avg({\$<YEAR_MONTH = {"\$(=max(YEAR_MONTH))"},  ONL_BTC = {"BTC"}, WEEKDAY-={'Sun','Sat'}, HOLIDAY_FLG={'N'}, DAY=>}ESAP),DT))

2. FirstSortedValue(DT, -Aggr(Avg({< ONL_BTC = {"BTC"}, YEAR_MONTH = {"\$(=max(YEAR_MONTH))"}, WEEKDAY-={'Sun','Sat'}, HOLIDAY_FLG={'N'}, DAY=>} ESAP), DT))