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
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? 

     

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

    Nope, objects from Salesforce so a row is a certain Inspection/Converted Lead with columns being all the info associated with that object etc created date, name