100% stack bar chart

[ishanbansal1204]

Hi All,

I am working on creating 100 % stack bar chart.

i have selected dimensions as week and category

category includes

IF (Aggr(Sum(AMOUNT_CLIENT), [CLIENT],[YEAR],[WEEK]) < 10, 'Spender 1')

this if conditions different types of spenders.

my measure has count(distinct client)

value wise data is displayed fine but i want to convert the value into % (100 % stack bar chart)

can some one pls suggest .

[ishanbansal1204]

Hi,

Its very urgent, Please help me out.

[sunny_talwar]

Would you be able to share a sample?

[ishanbansal1204]

sample? how do you want that? any specific format?

[Anonymous]

Hi

use following for getting 100% for Max ...

First expression :

Sum(AMOUNT_CLIENT)

Second expression

Sum(AMOUNT_CLIENT)

/

Max(TOTAL Aggr(Sum (AMOUNT_CLIENT)

  , [CLIENT],[YEAR],[WEEK]))

[ishanbansal1204]

Hi,

Where shall i keep this expressions?

[ishanbansal1204]

Its coming as NULL Now.

[sunny_talwar]

a qvf file or excel data with your expected output will be helpful

[ishanbansal1204]

[ishanbansal1204]

no option of attaching the file.

In the above screen.

at a week year level i have to show them 100 percent stack bar chart

condition being the last column.

if client count is 1 then 1st bucket, if client count is between 2 to 4 then 2nd bucket and so on..

[sunny_talwar]

Check here to see how you can upload samples:

Uploading a Sample