Forum Discussion

CatLowe's avatar
CatLowe
New Member
2 years ago

Custom Date Table slicer causing data to vanish

Hi,   I've been building a report for a client and we need to create a central Calendar table which we can use for filtering purposes and for calculations. I've read up about this online and the pr...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Which fields are in the table visual (please be exact here - including any aggregations ) and what fields are in the slicer?

I'm noticing that Created On (please state which table it is from and the relationships it is included in) is a datetime value.

  • CatLowe's avatar
    CatLowe
    New Member
    2 years ago

    All fields in the table are from the Incident table:
    Client - Text field
    Property Address - Text field

    Created On - Date/Time field

    In the slicer we only have Date - Date/Time field, and there is a Many-to-One relationship going from Incident - Created On to Calendar - Date