Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all
I am trying to create a chart that has on the x-axis hour of day. I then have two expressions, one: total activity (displaying this as a bar). Two: Average time from request to activity performed (displaying this as a line). This works fine.
What i would then like to do is:
- For the bar showing total activity, turn this into a stacked bar which shows the type of activity making up the total.
Any help would be much appreciated.
Kind regards,
Dan
Hi Dan,
do you want something like this?
I think you need an expression for each type of activity, like
Label = type A, expression =count (if (type='A', type))
Label = type B, expression =count(if (type='B', type))
etc.
Then use style subtype "stacked" and in Expressions display options "line" for the line chart (I also used a second y-axis) and "bar" for the two bar charts.
You probably tried using a second dimension, I think this is problematic because you don't want it to apply to the line chart (and this results in a non-stacked bar chart).
Regards,
Stefan
Hi Dan,
do you want something like this?
I think you need an expression for each type of activity, like
Label = type A, expression =count (if (type='A', type))
Label = type B, expression =count(if (type='B', type))
etc.
Then use style subtype "stacked" and in Expressions display options "line" for the line chart (I also used a second y-axis) and "bar" for the two bar charts.
You probably tried using a second dimension, I think this is problematic because you don't want it to apply to the line chart (and this results in a non-stacked bar chart).
Regards,
Stefan
thanks for you help,
dan