Issues Graphing Data

[#1]

I am trying to create a chart that will display the data in the test csv I attached.  Essentially the data is column headers with people's names and the row headers are dates.  For each day there is a number associated with the person.  I am trying to create a bar graph that can be selectable for different people's names so you can switch between individuals.  Anyone have a hint as to how to do that?

[prieper · Accepted solution]

Think that conversion into a Crosstable might help:

Data:

CROSSTABLE (Person, Number, 1) LOAD

*;

LOAD DATE(DATE#(Date, 'M/D/YYYY')) AS Date,

     [Person 1],

     [Person 2],

     [Person 3]

FROM

.\Test_Date.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

and then make an ordinary bar-graph with Date and Person as Dimension and SUM(Number) as expression.

HTH

Peter

[stigchel]

You can use the crosstable load for the persons. You can make selections in the dimension in the chart, I've used a conditional dimension to display the dates when you select a person. See example attached.

[#4]

Thanks for the help!!