Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Connect two date columns and visuals in the same table

Hi.

 

I have two dates within the same table start date and closing date. 

I want to visuals how many cases came in last week (start date) and how many cases were closed (closing date). 

 
How do I create a relationship between the two dates so I can showcase it in the same table? 
I dont need to calculate some sales amount, I just need to count the start date and closing date. 
Need Help

1 Reply

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Anonymous 

    You can either create 2 inactive relationships with these columns or you can use CROSSFILTER and TREATAS in the same measure.

    Please let me know if you need any help.