4 Replies Latest reply: Aug 18, 2016 6:33 AM by Darmawan Suria

# Ignore Selection for Max Avg

Hi,

anyone can help me, I need to ignore the DAY selection from my Set Analysis.

I only have data on Day 1. If someone click the DAY other than DAY 1, I want this KPI keep showing the Value.

The point is, I want to Ignore the DAY selection.

These are my Set Analysis :

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

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

Thanks

• ###### Re: Ignore Selection for Max Avg

May be this:

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

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

• ###### Re: Ignore Selection for Max Avg

Hi Sunny,

It's Worked,

But I am still not fully understand about the logic of this Set Analysis.

Thanks so much.

• ###### Re: Ignore Selection for Max Avg

Basically telling the expression to ignore selection in DAY in every possible Aggregation function that I see in those two expression.

Min, Max, Sum, Avg, FirstSortedValue, Only, Median...... Everywhere you see these, you will have to add a set analysis to ignore selection in DAY. This can be done like this {<DAY>} or {<DAY = >}