Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am trying to build a stacked chart with 2 dimensions, one of which is a date and the other is a character.
Please find the attachment with the excel equivalent of what I am trying to achieve.
One thing I tried is creating a new dimension combining the two (Type&Date) but then the problem is the axis won't be sorted properly as the new variable will be a character and will ignore the date within.
Please, could anyone advise if there is a better way to achieve this ?
Thanks very much
Arun
What about doing it like this may be:
Dual(Type&Date, Date)
Or maybe like this: Dual(Type & ' - ' & Date, FieldIndex('Type',Type)*100000 + Date)