Forum Discussion

Nudo's avatar
Nudo
Icon for Helper I rankHelper I
4 years ago

One slicer with multiple date columns filter

Hey I've been trying this for awhile. I've created a Date Table with relationships to the other columns I want to filter by, but for some reason they only filter to blank. I'm at a loss as to why ...
Need Help
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Nudo 

 

Okay, thanks for that.  I just realised you have bi-directional one to many relationships from your Date table to your fact tables.  Can you turn these into one to many, single direction?  The one should be on the Date table side and the many should be on the fact table side, and the direction should be pointing toward the Fact tables (arrow away from the Date table).  

 

Let me know whether this corrects the issue once done.

 

Theo 

 

Nudo's avatar
Nudo
Icon for Helper I rankHelper I
4 years ago

Yea I saw it in a video so tried it out, as I had the previous options you've suggested. But I tried again anyway just incase.

Just so you're aware the field these 3 options that are showing, are a count of "ID" but I'm trying to filter on created date do I need to do something else here?

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Nudo thanks for letting me know!  In terms of the IDs, are they in the fact tables that the Date table is related to?

    • Nudo's avatar
      Nudo
      Icon for Helper I rankHelper I
      4 years ago

      Yea so its the ID of the row that has the created date that I've related to the date table. 

      • TheoC's avatar
        TheoC
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Thanks for that Nudo - in terms of the Inspections and Converted Leads, are these a measure?