Forum Discussion

sebaskl's avatar
sebaskl
Frequent Visitor
2 years ago
Solved

Intersection Between Slicer Range and Date Range in Table

Hello everyone,

 

I have a dataset with contract data, and each contract has a start date and an end date. Let's call that range Contract Period

I have a main table in my dashboard that has the info about every individual contract, like so:

contract_numberstart_contractend_contract
101/01/202012/31/2026
201/01/202312/31/2024
301/01/202412/31/2024
401/01/202412/31/2026
501/01/202512/31/2027
601/01/202012/31/2021

 

I want to have a date slicer like this:

I want this slicer to, with the date range chosen, let's call it Slicer Period, only showcase the contracts whose Contract Period intersect in any way with the Slicer Period. With any way, I say every type of interception, like these ones:

I specify this because I only have been able to acheive a slicer that only works for the last type of intersection in the above picture, although I also want the other 3 possibilities included.

To sum up, for the Slicer Range I select with my slicer, I want to see every contract that was active at some point.

 

I have no idea on how to do this, so if someone could help I would really appreciate it!