Show multiple Time dimension on same axis

[#1]

Hi, using below data,how to plot a multiple time dimension on same axis and create column chart ?

Data:

InvoiceDate	Sales	Week	Month
09/09/2014	100	37	Sep
10/09/2014	200	37	Sep
11/09/2014	400	37	Sep
12/09/2014	800	37	Sep
13/09/2014	900	37	Sep
14/09/2014	1200	38	Sep
15/09/2014	1400	38	Sep
16/09/2014	2500	38	Sep

Desire Output:

Please refer to attahcment

Message was edited by: Kaustubh Bagal

[MarcoWedel]

there is no attachment?

[#3]

Hi Marco, now attachment added. Please check.

[Anonymous · Accepted solution]

hi,

try aggregating the data in the script

TimeTable:

load

Month as Time,

sum(Sales) as Sales,

1 as SortPrio

Resident Data Group by Month;

concatenate (TimeTable)

load

Week as Time,

sum(Sales) as Sales,

2 as SortPrio

Resident Data Group by Week;

concatenate (TimeTable)

load

InvoiceDate as Time,

sum(Sales) as Sales,

3 as SortPrio

Resident Data Group by InvoiceDate;

you can skip the last sum(Sales) and group by InvoieDate if you only have one data entry for a specific day.

Use Time as Dimension in your chart.

Best

Stefan

[#5]

Thanks Stefan