Line Chart: 2 Static Lines and 1 Dynamic Line

#1

Hi,


I have a line chart, but I want to always have 2 Static lines (that show the same data as comparators) to always be present on the graph. I want to make the 3rd line dynamic from a drop-down list. Any ideas on how to do this? Any scripting involved?


I essentially have an ID column in my data

e.g. the 2 static lines should always be ID = 1 and 2, the 3rd line can be any of the other ID's


Any help would be appreciated.


Thanks!

#2

https://www.dundas.com/support/learning/videos-tutorials/designing-views/working-with-formulas


I know you can make a formula for the static line, and I am sure you can work one out for the dynamic one, there might be some scripting to it i not come across a need for something like that yet.


Wait so the two static lines are the values of ID 1 and 2 repsectivly. If i was doing this I would make two metric sets one for each ID you want and have them always filtered to those ID's.

Then a third one that you could filter to any one you want.


Then you just add them alltogether into one graph on the dashboard. (looking for example on support site on how to do that......) cant find it (i know it is there, I have done this).


Add the first one then drag the other one on top of it, then repeate for third one (correct me if i am wrong) then you should be able to set up a filter that only filters the one you want to be dynamic.



#3

Assuming you have the following data structure:

Image title
6OWJ70dQ9atRvjITfRw4_static%20lines.PNG205×628

then I agree with James's answer with the exception that you don't need 3 metric sets - just two. The first one will be filtered on ID 1 and 2 and the second metric set will be connected to a filter for the ID column that the user can easily control. A few tips on setting this up:


  • To add a second metric set on the same line chart just click on the "Add new" button within the data analysis panel. Then drag in the same measure and dimensions setting as for the first metric set.
  • Add a member filter and connect it to the ID column on the second metric set only. Set the default filter for the ID to be an ID which isn't 1 or 2.
  • You can also change the "Shown Members" property of the member filter drop down list to only list the IDs that are not ID 1 or 2.


The end result should look like this:


Image title
XG0F8w9kRry3P8YX2mHf_static%20lines2.PNG1271×487



#4

That what I was talking about and looking for how to do.