Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Steve,
attached with the example where in a dummy field created, you can select to view per line in line chart.
Regards,
Lalit
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.
Hi Steve,
attached with the example where in a dummy field created, you can select to view per line in line chart.
Regards,
Lalit
Cool, sorry for the delayed response but that's a good solution you posted. Thanks!
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.