Stack Bar Chart - 100% Stack Bar Chart

[ishanbansal1204]

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

[sunny_talwar]

May be try this:

Count(DISTINCT [CLIENTNUMBER])/Count(TOTAL <Week> DISTINCT [CLIENTNUMBER])

[ishanbansal1204]

Hi Sunny,

I go the values as 400%

may be because i have bucketing involved in this?

[ishanbansal1204]

Hi Sunny,

It is showing me as 400%.

have checked but the values are not right.

we have bucketing as part of my dimension and i feel that might be creating a problem.

[ishanbansal1204]

Not Working..

Its showing me in the form of 400%

I think i am using bucketing here so it is taking 100% each for bucketing.

Please suggest further.

[sunny_talwar]

Can you share a sample?

[rupamjyotidas]

Taking help of Sunny Equation here

this will group it more detailed

Count(DISTINCT [CLIENTNUMBER])/Count(TOTAL <Year,Week> DISTINCT [CLIENTNUMBER])

[ishanbansal1204]

Hi Sunny,

I have attached the sample in the start Bucketing.csv

Please let me know the solution for it.

[sunny_talwar]

See if this is what you wanted Ishan

Count(DISTINCT [CLIENTNUMBER])/Avg(Aggr(NODISTINCT Count(DISTINCT [CLIENTNUMBER]), WEEK))

[ishanbansal1204]

Hi Sunny,

Yes this is what i wanted.

How did you achieve this?

What should be in the dimension and measure?