100% barchart

[Anonymous]

Hello community,

I would like to make a 100% stacked bar chart.

Can someone help me with this?

now I get this.

I use 1 dimension and 2 measure.

(Count(if(Doorlooptijd<2,ID))/Count(ID))

(Count(if(Doorlooptijd>2,ID))/Count(ID))

Thanks

[niclaz79]

Hi,

You have to have each value represent the percentage of the total for the week in order to make it work properly.

(Count(if(Doorlooptijd<2,ID))/Count(TOTAL ID))

(Count(if(Doorlooptijd>2,ID))/Count(TOTAL ID))

The below would get you closer to your goal, however you are missing the instance in which Doorlooptijd = 2. Should one of your if-statements include that?

Otherwise you need to use

(Count(if(Doorlooptijd<2,ID))/Count(TOTAL if(Doorlooptijd<>2,ID))

(Count(if(Doorlooptijd>2,ID))/Count(TOTAL f(Doorlooptijd<>2,ID))

[Anonymous]

Hi Niclas,

Thx but these formulas returns me this chart.

[niclaz79 · Accepted solution]

Hi,

Try this to ensure that the TOTAL still takes into account the dimension:

(Count(if(Doorlooptijd<2,ID))/Count(TOTAL <DATUM_ERF.Week>  if(Doorlooptijd<>2,ID))

(Count(if(Doorlooptijd>2,ID))/Count(TOTAL <DATUM_ERF.Week> if(Doorlooptijd<>2,ID))

If it's still off, can you provide a qvw with the data so we can tinker with it? It's hard to find what goes wrong without seeing the background data.

[Anonymous]

Thx

It worked