Forum Discussion
AdministratorMerge Line Chart with Stacked and Grouped Columns
Nice day!
I need to put together a chart that shows the following:
Bars show new or stopping patients
The line shows patients who are still in treatment
(x-axis is time)
I need the bars to be separated into two (new and the ones that slow down the treatment, this would be grouped together) and in turn I need each resulting bar to be divided by the specification of each one (this would be the stacked bars)
Suppose a patient may be new by medical decision or self-decision
I need the bars first to be divided between those who stopped the treatment and those who started it (they are the new ones) and that this last bar is colored two different colors, "medical decision", "own decision"
Thank you in advance!
2 Replies
- amitchandak
Super User
Syndicate_Admin , You can use Stacked Line visual. You can use measures On y-axis , where you want to add treatment data. and you can use one or measures for line
If you need to split the stack further
Creating Clustered Stacked Bar Visuals with Calculation Groups and Measures: https://www.youtube.com/watch?v=Z1Jx1hPtzbM&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
Syndicate_AdminGood! If I was working like that, the issue is that I also have to put a line with values, and that generates twice the value for each month according to what it finds on the x-axis
