5 Replies Latest reply on Aug 16, 2018 6:25 AM by Dileep Reddy

    How to break down the count for creating Up/Down side bar??

    Dileep Reddy

      Hi,

       

      I created a stacked bar chart with count as measure. And converted that to upside and downside for temporary.

       

      In total I have 12 quick filters with in the sheet based on the selection the count is changing which is good. But where I have 1 quick filter as CHANGE, which has total 3 values. Those are

      1) up

      2) down

      3) na

       

      Now I need to create a sheet with upside and downside stacked bar on the same but "down" CHANGE value should displayed in the bottom or downside. For that do I need to create a new caluculated fields for down count and other 2 values count?

       

      But when I tried with if condition or Lod I'm getting errors.

       

      Please advise me.

       

      Really sorry can't share the data.