Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I saw this interesting chart in a qview presentation.
I have three fields (Year , Buget ans LastYear) and I would like to present Year like 'Actual' in the sample that is as a bar, and the other dimensions as dots like 'Ideal'.
How is it possible to present expressions like this?
Thanks.
Us a combi chart with only Stage (or whatever dimension you want on the x-axis) as dimension. Add three expressions:
Actual: sum(Year)
Budget: sum(Budget)
LastYear: sum(LastYear)
Choose Bar as display type for the Actual expression and for the two others choose Symbol. You can then select Dots as the symbol type. You can increas the symbol size on the Presentation tab if nessary.
Us a combi chart with only Stage (or whatever dimension you want on the x-axis) as dimension. Add three expressions:
Actual: sum(Year)
Budget: sum(Budget)
LastYear: sum(LastYear)
Choose Bar as display type for the Actual expression and for the two others choose Symbol. You can then select Dots as the symbol type. You can increas the symbol size on the Presentation tab if nessary.