Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
there is no attachment?
Hi Marco, now attachment added. Please check.
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
Thanks Stefan