Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter a date table, show dates from other tables without synchronized slicers

Hi folks!   I have the following data structure:     I would like to have a filter (page filter) to set year and month (date hierarchy) of the dates table and then show only data that was ...
Need Help
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , ideally evens and ticket should not join and both tables should have single directional relation with date table (1 -M where date table is on one side)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak, yes sure this would be the ideal case but unforunatly this dataset was justn an example to show the need. My real example is like this:
    Server (created date, ...)
    Ticket (created date, affected server id)
    so I need to have the relation between server and ticket but also I want users to be able to pick up a month they want to see and get server and ticket data on one or multiple page. Of couse I could say ok users then please select 2 fields there, but the problem is there are even more tables with the same approach with a link to an item and an additional date field. Thanks