Forum Discussion

LuckyLuke's avatar
LuckyLuke
Frequent Visitor
6 years ago
Solved

Line chart showing two different cohorts from a single table.

Hi, I have a database for managing cases. Each case has a record in a table with a date received and date resolved. I want to be able to show a line chart visual that plots both the number of cas...
Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    LuckyLuke 

     

    Create a date/calender table and define a relationship between your table based on date from calender and date received in your table and make it as active. 

    Create a measure to count the case. This will give you the case counts based on date received.

     

    Define another relationship between calender and your table based on date from calender and date resolved. This will be an inactive relationship.

    Create a measure with USERELATIONSHIP.

     

    For example

     

    = CALCULATE(COUNT(CASES),USERELATIONSHIP(DATE,DATE_RESOLVED))

     

     

    If it helps, mark it as a solution

    Kudos are nice too

     

LuckyLuke's avatar
LuckyLuke
Frequent Visitor
6 years ago

Hi v-lili6-msft 

 

Thanks you for your reply.  The second post you linked was quite interesting and I may use that elsewhere but I think for my needs the best answer so far was the one marked as solution.

 

Thanks!