Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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.
Thanks for the help!!