3 Replies Latest reply: Oct 26, 2016 10:22 AM by Renata Ribeiro RSS

    I need to see the comparative month to month with set analysis

    Renata Ribeiro

      Hello guys,

       

      My KPI is not working. It does'nt  return the value according to my selection of months.

       

      It is linked to a set analysis condition to the comparative considering only sales PROMOTIONS.

      When you do not have any filter it returns me the difference between September x August (OK, that's what I want Too), but when I select August for example, it does not return any value to me, as if error in the formula. I need to see the comparative month to month depending on my selections.


      Example:


      selected october -  KPI shows difference (%) between october x september

      selected september - difference (%) between september x august

      selected augost - difference (%) between augost x july


      How do I do?


      App with no selection

      Capturar 3.JPG

      App with  month selection

      Capturar 2.JPG

       

      See the KPI expression:

      (Sum ({<Promotion = { 'Promotion'}, year = { '$ (Vano)'}, [Month] = { '$ (= Date (AddMonths (Max ([Month / Year]) - 1) 'MMM')) '}>} Quantity) /

      Sum ({<Promotion = { 'Promotion'}, year = { '$ (Vano)'}, [Month] = { '$ (= Date (AddMonths (Max ([Month / Year]), - 2),' MMM)) '}>} Amount)) - 1

       

      Expression of my chart:

      Sum ({<Promotion = { 'Promotion'}, [Month / Year] = { "> = $ (# = AddYears (Max ([Month / Year]) - 1)) <= $ (# = Max ([ month / Year])) "}>} Quantity)

       

      Sorry about my english, I'm brazilian


      can anyone help me?


      Tks!