Hello everyone,
I have one table called "process fact table" with the follwing columns:
| UID | processID | Start Date | End Date |
| 1aa | 1 | 2022-01-01 | 2022-01-01 |
| 1aa | 2 | 2022-01-01 | 2022-01-02 |
| 2ab | 1 | 2022-01-01 | 2022-01-02 |
| 2ab | 2 | 2022-01-02 | 2022-01-02 |
| 2ab | 3 | 2022-01-02 | 2022-01-03 |
| 3cd | 1 | 2022-01-01 | 2022-01-03 |
| 3cd | 2 | 2022-01-03 | 2022-01-04 |
| 3cd | 3 | 2022-01-04 | 2022-01-06 |
When a user reaches processID 3, he will be counted as he finished this process. The start data and end date are for each step.
There is another "user meta table" with following columns. It is to be noted that when a client didn't reach step 3 yet, the value of "Days needed to reach step3" will be showed as -1.
| UID | Days needed to reach step3 |
| 1aa | -1 |
| 2ab | 2 |
| 3cd | 5 |
I built then two measures: measure1 called "registration" count how many user started process 1 on certain date, so here for 2022-01-01 as start date this measure should be 2; measure 2 called "finished", to measure how many user have reached step3, so for 2022-01-01 as start date this should be 2.
I created a visual containing measure 1 and 2. with slicer "Date" having "Start Date" as values and "days to finish" having "Days needed to reach step3" as values. "Date" slicer should filter both measures, while "days to finish" slicer should just filter measure "finished" in this visual. How should make that possible?
Thank you!
