- Last 24 month
Untuk membatasi tampilan visualisasi yang muncul hanya 24 bulan terakhir.
| Period: Months to Current Month |
| -1*(([Current Year]- [Main Date: Year])*12+([Current Month] – [Main Date: Month])) |
| Filter: Performance Card |
| IF [Period: Months to Current Month] <= 0 AND [Period: Months to Current Month] >= -24 THEN “Y” ELSE “N” END |
Pilih Filter: Performance Card: Y pada filter.
- Performance KPI
Untuk membatasi value yang tampil sesuai dengan performance scope yang dipilih. Misalnya apabila dipilih [Period: Months to Current Month] = 0 maka value yang tampil adalah di bulan tersebut, dan [Period: Months to Current Month] = -1 maka value yang tampil adalah 1 bulan sebelumnya.
| Filter: Performance KPI |
| CASE [Performance Scope] WHEN “CM_vs_PM” THEN IF [Period: Months to Current Month] = 0 OR [Period: Months to Current Month] = -1 THEN “Y” ELSE “N” END WHEN “CM_vs_PY” THEN IF [Period: Months to Current Month] = 0 OR [Period: Months to Current Month] = -12 THEN “Y” ELSE “N” END WHEN “ACT_vs_TGT” THEN IF [Period: Months to Current Month] = 0 THEN “Y” ELSE “N” END WHEN “CYTD_vs_PYTD” THEN IF ([Main Date: Year] = [Current Year] OR [Main Date: Year] = [Current Year]-1) AND [Main Date: Month] <= [Current Month] THEN “Y” ELSE “N” END WHEN “YTDACT_vs_YTDTGT” THEN IF [Main Date: Year] = [Current Year] AND [Main Date: Month] <= [Current Month] THEN “Y” ELSE “N” END WHEN “NONE” THEN NULL END |
Pilih Filter: Performance KPI: Y pada filter.