Monitor Daily Changes in Data

smithc2005 — Wed, 22 Apr 2020 22:01:35 GMT

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

topic Monitor Daily Changes in Data in App Development

Monitor Daily Changes in Data