3 Replies Latest reply on Oct 16, 2018 12:08 PM by Yuriy Fal

    Difference % from the first

    Joaquín Chemile

      Hello!

       

      I want to recreate each grey bar in separately Tabs:

       

      Captura.JPG

      But I cant compute a Tablea calculation in the Pill:

       

      Step.JPG

       

      Shoud I create a calculation with a LOD expressions?

        • 1. Re: Difference % from the first
          Yuriy Fal

          Hi Joaquín,

           

          If i understand you correctly, you may want

          to put each Step on a distinct worksheet,

          then combine them all on a 'Sankey' dashboard --

          together with some other ('flow') worksheets in between.

           

          For that you'd like to have all Steps (Dimension Values)

          on a view unfiltered, and use a Table Calculation Filter instead.

           

          Please find the attached w/mods.

          Hope it could help.

           

          Yours,

          Yuri

          • 2. Re: Difference % from the first
            Joaquín Chemile

            Excellent! How did you make the filter?

            • 3. Re: Difference % from the first
              Yuriy Fal

              Edit in-place.

               

              Create a new pill right on a view -- for example,

              by double-clicking in Rows / Columns / Details --

              then write a calculation and hit Enter.

               

              The calculation itself is rather simple:

              LOOKUP(MIN([Step]),0)

              It is a Table Calculation, and as a Filter,

              it is effectively hiding the Marks on a view --

              not filtering them out -- thus preserving

              any other Table Calculation based logic.

               

              To have this calculation as a distinct Pill in the schema,

              simply Ctrl-drag a copy from the Filter shelf to the Measures.

               

              Hope it could help understanding.

               

              Yours,

              Yuri

              1 of 1 people found this helpful