Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I wonder if it is possible to create other than normal (different) chart type...
I have a table:
ID | Date | Stop code | Time |
1 | x1 | 1 | 234 |
2 | x1 | 3 | 24 |
3 | x1 | 2 | 63 |
4 | x1 | 4 | 126 |
5 | x1 | Production | 46 |
6 | x1 | 3 | 71 |
7 | x1 | 4 | 3 |
8 | x1 | Production | 95 |
9 | x2 | 1 | 24 |
10 | x2 | 1 | 673 |
11 | x2 | 5 | 32 |
The ID and Date are not important for the example, but I have there Stop codes and Time of each stop that happened. I'd like to create a bar chart as showed on attached picture. Is it possible? I hope the picture is understandable, if not than please let me know.
Yes, it's a waterfall chart!
You have two methods:
1) bar chart with dimension,
one expression,
Total option in dimension limits tab, and with this Bar offset expression:
if(Dimensionality()=0,0,rangesum(above(sum(Time),1,RowNo()))).
2)bar chart without dimension, with n expression and with classic bar offest for any column.
look at this sample
Regards
MC
Yes, it's a waterfall chart!
You have two methods:
1) bar chart with dimension,
one expression,
Total option in dimension limits tab, and with this Bar offset expression:
if(Dimensionality()=0,0,rangesum(above(sum(Time),1,RowNo()))).
2)bar chart without dimension, with n expression and with classic bar offest for any column.
look at this sample
Regards
MC
Great! This is it! Works almost perfect Almost because... is it possible to have the Total bar on the left side? Than it would be perfect totally
BR
Hi again,
Also - how to show the chart in percent? I wasn't able to do it using Bar Offset...
Hi,
in this sample the percentage.
Regards
MC
Hi,
The problem is that normally there are only few stopcodes for a specific date - not all of them... That is why I want to do it with you first advice (with Dimension in chart), not to write all possible stop codes in expression...