Forum Discussion

jscottNRG's avatar
jscottNRG
Icon for Helper II rankHelper II
8 years ago
Solved

Single date slicer to filter multiple date tables

I'm hoping this isn't actually so difficult, but I've had a tough time trying to figure out the proper setup. I'd like to use a single date slicer to filter multiple tables with dates in them. The ta...
Need Help
  • edhans's avatar
    edhans
    8 years ago

    Shouldn't your slicer be based on the dates in a Date Table where the Date field is related to all of the relevant date fields in your other tables?

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
8 years ago

Shouldn't your slicer be based on the dates in a Date Table where the Date field is related to all of the relevant date fields in your other tables?

jscottNRG's avatar
jscottNRG
Icon for Helper II rankHelper II
8 years ago

Thanks edhans, do you know of a good resource describing how to do that?

 

I tried setting up a slicer with a Date Table, and added calculated columns to RoughInspections and FinalInspections looking to see if each record was "in range" per the sliced Date Table, but no luck.  I didn't think to set up relations between the Date Table and the other tables, though.