7 Replies Latest reply: Mar 21, 2016 5:47 AM by Sangram Reddy RSS

    Cumulative distinct bar charts

    Andrea Ang

      Hi, I am trying to plot 2 charts.

      (1) A cumulative distinct bar chart for 5 days.

      (2) A bar chart that shows number of new customers per day.

       

      I have given some sample data and expected results shown below. Can please advise how I should do it? Thanks in advance!!

       

      Day 1    Customer    Expected Results for (1)    Expected Results for (2)

                          A                        2                                                2

                          B

       

      Day 2    Customer    Expected Results for (1)    Expected Results for (2)

                          A                    3 (2+1)                                          1

                          B

                          C

       

      Day 3    Customer    Expected Results for (1)     Expected Results for (2)

                          A                    4 (3+1)                                          1

                          B

                          D

       

      Day 4  Customer    Expected Results for (1)       Expected Results for (2)

                          A                          4                                            0

                          B

                          C

                          D

       

      Day 5  Customer    Expected Results for (1)        Expected Results for (2)

                          A                    5 (4+1)                                          1

                          B

                          C

                          D

                          E

        • Re: Cumulative distinct bar charts
          Sunny Talwar

          Would you be able to share the raw data behind this chart you are looking for? Do you have something like this?

           

          Day     Customer

          1,          A

          1,          B

          2,          A

          2,          B

          2,          C

          3,          A

          3,          B

          3,          C

          3,          D

           

          and so on?

            • Re: Cumulative distinct bar charts
              Andrea Ang

              The raw data is like this. How do you suggest I should plot the charts? Can it be done by using expressions in the measure?

               

              Day     Customer

              1,          A

              1,          B

              2,          A

              2,          B

              2,          C

              3,          A

              3,          B

              3,          D

              4,          A

              4,          B

              4,          C

              4,          D

              5,          A

              5,          B

              5,          C

              5,          D

              5,          E