Hi,
I have a Dataset with 2 dates open_date,closed_date for a category(has 2 values open,closed).
I want to build a weekly bar chart with a count of category where the date range is selected for the column open_date but the date range should also be applied to closed_date as well.
For Ex:-
Open Date | Closed Date | Category |
2020-07-01 | 2020-07-07 | Closed |
2020-06-30 | | Open |
2020-07-02 | 2020-07-20 | Closed |
For the example above if i keep the bar chart as weekly and select the date between 2020-07-01 and 2020-07-07 it should give me a count 1 as the category open and closed between that date is 1.
Can somebody help with this