0 Replies Latest reply: Aug 21, 2018 4:00 PM by Anastasiia Glebova RSS

    KPI object to display last month

    Anastasiia Glebova

      Hi, I am creating a KPI object. I want to display last month data when no selections are made. For this reason I added new variable "LastMonth" = max(YearMonth). In KPI object I set expression for measure avg({<[Date]={'$(vMaxYearMonth)'}>}[KPIname]). It gives me still average of all months instead of just one last month value. Can someone help with this?