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

  • nn92's avatar
    nn92
    Frequent Visitor
    8 years ago

    Hi, alexei7 ,

    thanks for trying to help!

     

    I posted bigger screenshot, with more info. Could you please tell me where exactly I need to type in this filter, and where to create new line (if it is under tabel->edit query...) or something ele?

     

    THanks in advance!

     

     

    • alexei7's avatar
      alexei7
      Continued Contributor
      8 years ago

      Hi nn92,

       

      These are measures not filters.

      One way you can create them is by right-clicking on the table and selecting "New Measure".

       

      If you're able to remove any confidential information and share the model, I'm happy to help create the measures for you.

       

      Alex

      • nn92's avatar
        nn92
        Frequent Visitor
        8 years ago

        alexei7  maybe this could help?

         

        Problem is that my dataset is few GBs, so the model has 200mb and I cant upload it so easily.

         

        Maybe this could help:

        Axis = lead_time

        Legent = RESERVATION_CASE_DESC

        Values = Count of RESERVATION_CASE_DESC

        Filters = ADEP is LEMD    ***this is the one I want to vary for different lines

                      RESERVATION_CASE_DESC is True Revision

         

        Table name is "TRP-visual"

         

        Is this enough to write measure in the code? It takes a lot of space so I cant upload, sorry...