2 Replies Latest reply on Nov 10, 2018 6:52 PM by Paul Wachtler

    Calculate Trend but show only one period

    Kamil Nikiel

      Hi All,

       

      I'm struggling with a KPI dashboard I work on, my data look like:

       

       

       

      KPI Name
      PeriodValue
      KPI AJANUARY5
      KPI AMARCH2
      KPI BMARCH1

       

      I can easily achieve my goal when show both periods

       

       

       

      KPI NameJanuaryMarchTrend
      KPI A52DOWN
      KPI B01UP


      But I need to show only one period in the table, and when I filter it out I loose the trend, is there a way to show only 1 month and keep the trend?