Forum Discussion

Rachna_saini's avatar
Rachna_saini
Regular Visitor
4 years ago

Daily count against date

Hi, I have a source table that has tickets created against creation dates, I have created a date table with all distinct dates.
Now I want to create a measure that gives me total ticket counts against each date. I tried multiple measures but everytime I am getting overall total count against each date in reapeated manner. Like if total tickets in the file are 5000, I get 5000 against each date.

Please help, Thanks !

Daily count

1 Reply

  • Shahfaisal's avatar
    Shahfaisal
    Solution Sage
    4 years ago

    That sounds like the relationship between the tickets table and the date table is missing or not setup correctly. Please take a look. There should be a valid relationshp between those two tables for your measure to work.