% Total stacked bar

[Ronald]

Hi everyone,

I have a problem with calculating the % total of each stacked bar; but it must be for every month, but for the calculation I use count (Distinct {<CUST_CONT={'CONTACTS'}>} Event_ID), then the final measure could be:

count (Distinct {<CUST_CONT={'CONTACTS'}>} Event_ID)/count (TOTAL <DATE>Distinct {<CUST_CONT={'CONTACTS'}>} Event_ID)

but don´t work.

Please your help.

[JuanGerardo · Accepted solution]

Hi @Ronald, when using TOTAL you can use field names in <> to have subtotals. In your case you are showing months but subtotaling by days. I think you need to use a month field (create it as Month(DATE) in script if you need), then use it as chart dimension and subtotal by this field:

count (Distinct {<CUST_CONT={'CONTACTS'}>} Event_ID)/count (TOTAL <MONTH> Distinct {<CUST_CONT={'CONTACTS'}>} Event_ID)

JG

[Ronald]

Thanks,  it works!!! great.