Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measurement Filtered only by one slicer

Hi 🙂   I have a table with 3 fields: Ticket ID, Closed Date, Assigned To.   I added 2 slycers: Closed Date and Assigned To. I would like to create a measurement that only respects Closed Date s...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    Do you have a calendar table as a dimension? Or are you using the slicer from your closed date column?

     

    If you are using a column from your data you may not get the expected result since all your context is overlapping with different context from other interactions on the table.

     

    Is it possible to share a sample?

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Do you have a calendar table as a dimension? Or are you using the slicer from your closed date column?

 

If you are using a column from your data you may not get the expected result since all your context is overlapping with different context from other interactions on the table.

 

Is it possible to share a sample?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks MFelix 

I created a dimension table for dates and it solved the issue.

 

 

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    Ussually when using dates it's a good practice to use a calendar table to make the interactions.

     

    Glad I could help.