Development Graph - How??

[bazzaonline]

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

[PradeepReddy]

some thing like this..

[bazzaonline]

Sorry, like what??

[#4]

Hi paul,

separate dimensions in single chart or multiple charts

[PradeepReddy]

see the attchment..

[bazzaonline]

Single chart. Thanks

[bazzaonline]

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??

[bazzaonline]

Attached

[bazzaonline]

Hello, I have added an attachment of my script.  Are you able to help?

[PradeepReddy · Accepted solution]

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)