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".
