Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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))
Hi Niclas,
Thx but these formulas returns me this chart.
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.
Thx
It worked