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

    Ignore Selection for Max Avg

    Darmawan Suria

      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.

       

      Max Avg.jpgMax Avg Selection.jpg

      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