Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
Hi Sunny,
It's Worked,
But I am still not fully understand about the logic of this Set Analysis.
Could you give me some explanation about this logic.
Thanks so much.
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 = >}
Thanks again for your information.