Help with Visualization of data with open and closed statuses dates
Hello i might be over thinking this but what im trying to do is show open and closed records based on dates I have the following tables:
ID
Report Date
Amount
Category
Report Count
Open date
Closed date
Status
1
9/14/2022
20
Clothing
4
9/11/2022
Null
Open
2
9/10/2022
100
Furniture
6
9/4/2022
9/10/2022
Closed
Max Date
9/14/2022
If the Max date is the same as the Report Date then the status is 'Open' else it is 'closed'.
I would like to visualization this in a bar chart using Report date and Status as a Dimension so for example ID = 2 there would be a Open count for 9/4/2022 and then a closed count for 9/10/2022.
