Forum Discussion

sefreeman1's avatar
sefreeman1
Frequent Visitor
2 years ago

Switching between Order date and Ship date

I've seen a few options on how I can select between two different date columns on the same row but they all go back to "userelationship" or an "if" statement that is needed for every single measure w...
sefreeman1's avatar
sefreeman1
Frequent Visitor
2 years ago

My understanding of USERELATIONSHIP is that it is on the measure level/calculation only.  I'm looking to allow users to look at the same dash but select which date they want to view it by.  So I want to see all my measures by order date or I want to see all my measures by ship date.  Not necessarily both in the same view.

lbendlin's avatar
lbendlin
Super User
2 years ago

Yes, create separate measures and use them in a field parameter.

  • sefreeman1's avatar
    sefreeman1
    Frequent Visitor
    2 years ago

    Then a user has to select every field parameter each time right?  i.e. Margin - Ship date, Trailing 7 days Margin - Ship date, Rev, YTD Rev, etc. instead of just clicking "ship date" and all metrics changing.  

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      That sounds like you want to combine this with calculation groups.

      • sefreeman1's avatar
        sefreeman1
        Frequent Visitor
        2 years ago

        THought it might help to see what I'd like for the final output.  Would calculation groups help with this?  Is this in the model portion correct?

         

        I'd like to filter by a data type, the date range and then pick a metric