select/view only one of many lines in a line chart with multiple expressions

[stevelord]

Hi, I have a line chart with a sum(field) expression for each line plotted on the graph.  The main data source structure is like this:

Client          Date     Field1     Field2     Field3

a               1/1/14     3          5               1

b               1/1/14     5          6               0

a              1/2/14     0          1               2

c               1/2/14     1          1               1

d               1/3/14     2          3               4

I have Date as the dimension, then three expressions summing each of the three fields.  The line chart looks nice, and when I hover over it I see the value of whatever at any given point.  How do I make it so the end user can click on one of the lines or legend labels to see only that line or legend label?

I suspect I have to put the fields under a parent field and make date and parent field the two dimensions... maybe crosstable to keep client and date, then pivot the fields with the values I want to sum to attributename field, and the values to attributevalue.. then have date and attribute name as the dimensions, and sum attributevalue for one expression...

Sorry, I might've answered my own question but will leave it here in case anyone else needs it.  Feel free to confirm or deny or let me/us know about any potential landmines if it's not as straightforward as I think now.

[stevelord]

PS> The post is a 30 second read, but I actually spent 20 minutes or so staring at my graph and thinking about the data structure to formulate the question.  The solution in turn began to form  while I was composing the post.

[#3 · Accepted solution]

Hi Steve,

attached with the example where in a dummy field created, you can select to view per line in line chart.

Regards,

Lalit

[stevelord]

Cool, sorry for the delayed response but that's a good solution you posted.  Thanks!

[#5]

I have built a line chart with 10 expressions and 2 dimensions. One of the dimension is Month-date. Since there are 10 expressions the chart looks clumsy to analyze.  So can I select any particular expression alone in the chart itself to analyze? if not required I should be able to see all the lines.

I cannot do as the example you had given. Because my Data model is different and the calculations have set analysis too.