4 Replies Latest reply on Oct 30, 2018 3:00 AM by Prajval T

    side by side with stacks

    Prajval T

      Hi Team,

      Can we develop the view like below mentioned?

      I need side by side across time period and time period should come below not on top (Should be continuous).

      And Each bar should have two stacks like mentioned below.

       

       

        • 1. Re: side by side with stacks
          Sankarmagesh Rajan

          Hi Prajval

           

          Create piviot and add all measures first.

          Create calculation follows

          if

          DATETRUNC('month',[Date])+0

           

          elseif [Pivot Field Names]='New' then

          DATETRUNC('month',[Date])+3

           

          elseif [Pivot Field Names]='Open' then

          DATETRUNC('month',[Date])+6

              

          elseif [Pivot Field Names]='Planeed' then

          DATETRUNC('month',[Date]) +9

            

          END

           

          Drag to view and select exact date.

          drag pivot values into row.

          drag pivot name into color.

          • 2. Re: side by side with stacks
            Prajval T

            Thank you Sankar,

             

            exact solution for my requirement.

             

            Small addition to the calculation to get the exact view like i mentioned in my post like below.

            if you keep the same size for related measures(planned and actual, New and Open) stack is coming.

             

            if  [Pivot Field Names]='New' then

            DATETRUNC('month',[Date])+7

             

            elseif [Pivot Field Names]='Open' then

            DATETRUNC('month',[Date])+7

                  

            elseif [Pivot Field Names]='Planeed' then

            DATETRUNC('month',[Date]) +15

             

             

            ELSEIF  [Pivot Field Names]='Actual' then

            DATETRUNC('month',[Date])+15

                

            END

             

             

            Only issue is, Time period labels are not aligned to center and Jan 2018 is coming which is not there in the data set.

             

            Can you help me how to fix this done.

            • 3. Re: side by side with stacks
              Sankarmagesh Rajan

              Hi Prajval,

               

              Try this calc

              if [Pivot Field Names]='Actual' then

              DATETRUNC('month',[Date])-4

               

              elseif [Pivot Field Names]='New' then

              DATETRUNC('month',[Date])-1

               

              elseif [Pivot Field Names]='Open' then

              DATETRUNC('month',[Date])+2.5

                 

              elseif [Pivot Field Names]='Planeed' then

              DATETRUNC('month',[Date]) +6

               

              END

               

              i am not get any jan 2018 in my view

               

               

              Thanks

              sankar

              • 4. Re: side by side with stacks
                Prajval T

                Thank you so much shankar.

                 

                Solution helped.