I have a customer table that is rebuilt by a SQL query every day. It has to meet certain conditions to make it onto this table. I'm capturing the table every day and writing it a CSV file (a new one each day).
I have another app that is loading all of these files into it, daily.
Each day, customers may be added, some removed. I need to be able to monitor these changes. I'm able to count the distinct amount of customers each day by attaching a date onto the data model of each build. The issue I'm stuck is, I need to return a text field on the unique values between days.
For example, Monday to Tuesday.
1/1/2020
| Customer # | Customer Name |
| 1 | Customer One |
| 2 | Customer Two |
| 3 | Customer Three |
1/2/2020
| Customer # | Customer Name |
| 2 | Customer Two |
| 3 | Customer Three |
| 4 | Customer Four |
This data model is joined together in my app. It's all one table. Is it even possible to make a chart table by the date dimension that has two measures "Customers Added" and "Customers Removed".
Something like this?
| Date | Customers Added | Customers Removed |
| 1/1/2020 | - | - |
| 1/2/2020 | Customer Four | Customer One |
