Forum Discussion

nn92's avatar
nn92
Frequent Visitor
8 years ago

plot multiple lines with different data filters on one graph

Hi,   I would like to plot multiple line on one graph, but I can't do it with simple "line chart".   I have only one dataset, and what I want to do is to use lines to represent different filters....
Need Help
Show and Tell
nn92's avatar
nn92
Frequent Visitor
8 years ago

Hi,

 

 

I attached you the current setings, if you could help, I would appreciate a lot.

 

I need to keep everything the same, only change the "ADEP is LEMD" into "ADEP is XXXX" and plot several same lines on one graph?

 

***edit: Table name is: TRP-Visual

 

Many thanks in advance!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

alexei7's avatar
alexei7
Continued Contributor
8 years ago

Hi nn92

 

I can't see everything in the screenshot you posted. If you can upload/post your model that would be helpful.

 

Your formulas would look something like this for each measure:

 

LEMD = calculate(countrows(RESERVATION_....),filter(ADEP="LEMD")

XXXX  = calculate(countrows(RESERVATION_....),filter(ADEP="XXXX") etc

 

Hope that helps,

Alex