13 Replies Latest reply: Oct 4, 2016 5:30 AM by Sunny Talwar RSS

    Stack Bar Chart  - 100% Stack Bar Chart

    Ishan Kumar

      Hi Experts,

       

      Facing a scenario where in i am getting the values in the form of stack bar chart but i want to show that in the form of 100% stack bar chart.

       

      Dimensions - Week and Category

      Category has the formula -

      IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) < 10, 'Low Spender',

      IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) >= 10 AND Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) <25, 'Average Spender',

      IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) >= 25 AND Aggr(Sum(AMOUNT_CLIENT), [CLIENTNUMBER],[YEAR],[WEEK]) <50, 'Hign Spender',' Very Hign Spender')))

       

       

      Measure is Count(DISTINCT [CLIENTNUMBER])

       

      These are basically categorized in Bucketing system.

       

      If you need any more details let me know.

       

      Thanks

       

      Message was edited by: Ishan Kumar