Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I need more help.
Is it possible to draw line graphs from multiple dimensions, for example,
Customer Day1 Day2 Day2
Fred 5 6 7
Jane 8 9 10
I want a line graph that shows Fred going up day 1 to day 3.
Is this possible as Day1, Day2 and Day3 are separate dimensions?
Thanks Paul
Script:
LOAD Customer,
Day1 as Value,
'Day1' as Day
FROM
(ooxml, embedded labels, table is Sheet1);
LOAD Customer,
Day2 as Value,
'Day2' as Day
FROM
(ooxml, embedded labels, table is Sheet1);
LOAD Customer,
Day3 as Value,
'Day3' as Day
FROM
(ooxml, embedded labels, table is Sheet1);
Line Chart
Dimension: Day,Customer
Expression: Sum(Value)
some thing like this..
Sorry, like what??
Hi paul,
separate dimensions in single chart or multiple charts
see the attchment..
Single chart. Thanks
Hello, sorry I haven't been very clear. I have attached example of the script. Are you able to show how to draw the graph from this example??
Attached
Hello, I have added an attachment of my script. Are you able to help?
Script:
LOAD Customer,
Day1 as Value,
'Day1' as Day
FROM
(ooxml, embedded labels, table is Sheet1);
LOAD Customer,
Day2 as Value,
'Day2' as Day
FROM
(ooxml, embedded labels, table is Sheet1);
LOAD Customer,
Day3 as Value,
'Day3' as Day
FROM
(ooxml, embedded labels, table is Sheet1);
Line Chart
Dimension: Day,Customer
Expression: Sum(Value)