4 Replies Latest reply on Sep 11, 2019 10:03 AM by Vikram Gokhale

    Data blending and stacked bar

    Ani p

      Hi Team,

       

      i have a view like below.

       

      Need to develop the stacked bar with 3 metrics which are coming from different data sources and blended with date.

       

      I could do with two metrics but now with 3.

       

      Can any one please help me on this?

       

        • 1. Re: Data blending and stacked bar
          Vikram Gokhale

          Can you create a JOIN instead of a Blend ? You can then PIVOT create a new field "Metric Type" and use that in Color Shelf to create a Stacked chart...

          • 2. Re: Data blending and stacked bar
            Laurence Turner

            Hi Ani,

             

            I don't think it is possible to stack three separate values from three measures in a "dual axis" (or triple axis!) bar chart.

             

            It looks like you may need to re-structure your data, so that you have one measure, and use a dimension to distinguish between the data sources.

             

            I imagine you have something like this:

             

            DateBlueOrangeGrey
            01/01/19901127190
            01/02/1990189779
            01/03/199054141140
            01/04/1990179156180
            01/05/1990766192
            01/06/19907598126
            01/07/199017798195
            01/08/19901965639

             

             

            But you need your data structured like this:

             

            DateValueSource
            01/01/199011Blue
            01/02/1990189Blue
            01/03/199054Blue
            01/04/1990179Blue
            01/05/19907Blue
            01/06/199075Blue
            01/07/1990177Blue
            01/08/1990196Blue
            01/01/199027Orange
            01/02/19907Orange
            01/03/1990141Orange
            01/04/1990156Orange
            01/05/199066Orange
            01/06/199098Orange
            01/07/199098Orange
            01/08/199056Orange
            01/01/1990190Grey
            01/02/199079Grey
            01/03/1990140Grey
            01/04/1990180Grey
            01/05/1990192Grey
            01/06/1990126Grey
            01/07/1990195Grey
            01/08/199039Grey

             

             

            Does that make sense? I've attached a workbook using this data as an example.

             

            Best,
            Laurence

            • 3. Re: Data blending and stacked bar
              Ani p

              Hi Vikram,

               

              How to join different data sets.  In my case, i have different files, not in a single excel file.

               

              If i have 3 sheets in a excel file then i can join.

               

              but how to join 3 different datasets ?