Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help in creating a bar chart as under
The Db table 'X' the chart is pointing to has following columns:
1) Column 'Cycles' that has values Cycle 1, Cycle 2 etc (it can go upto Cycle 'n')
2) Columns 'P', 'F', 'B'.
On the chart,
X axis to have cycles as separate bars based on the max value in Cycles column
Each cycle bar will have count of 'P', 'F', and 'B'.
What should be the expressions and dimensions for the chart?
Thanks in advance.
Try one dimension, Cycles and three expressions:
=Count(P)
=Count(F)
=Count(B)
and set style to stacked in bar properties.
Or use a CROSSTABLE LOAD prefix in your script:
CROSSTABLE (Column, Value)
LOAD Cycles, P,F,B
FROM ...;
Then use dimensions Cycles and Column and as expression
=Count(Value)
Try one dimension, Cycles and three expressions:
=Count(P)
=Count(F)
=Count(B)
and set style to stacked in bar properties.
Or use a CROSSTABLE LOAD prefix in your script:
CROSSTABLE (Column, Value)
LOAD Cycles, P,F,B
FROM ...;
Then use dimensions Cycles and Column and as expression
=Count(Value)
Thanks a ton, Swuehl. The first option worked.