Crosstable Line Chart

[#1]

Hello,

Looking for some guidance here, I'd like to create a line chart off of a crosstable so as to make my headers selectable: (if this isn't the best method please advise!). So below is an example of my data, i have dates corresponding to values for a number of different projects. I initially loaded this in as a table regularly (no crosstable) and set my dimension to date and had 3 expressions for my projects, however I discovered that when I clicked on a particular project in list view it didn't isolate that project on my line chart. I figured by loading it once again, but this time as a cross table it would solve my problem - but again unfortunately no luck.

Date	Project1	Project2	Project3
01/01/2014	200	300	250
01/08/2014	150	400	100
01/15/2014	165	320	155

Looking for any help.

Cheers,

Ahmad

[MK_QSL · Accepted solution]

CrossTable(Project, Value)

Load

  Date(Date#(Date,'MM/DD/YYYY')) as Date,

  Project1,

  Project2,

  Project3

Inline

[

  Date, Project1, Project2, Project3

  01/01/2014, 200, 300, 250

  01/08/2014, 150, 400, 100

  01/15/2014, 165, 320, 155

];

Create a Line Chart

Dimension

Date

Project

Expression

SUM(Value)

[#3]

thank you !!!!

[MK_QSL]

IF this is working for you, kindly close the thread by selecting correct/helpful answer...

Thanks