I have built a QVD to take a "SnapShot" of our database. This allows me to compare specific days, weeks or months to see if theres any changes against our live data.
Since this is now a QVD I am not sure how to correctly take the QVD snapshot hisotry data and now measure the following:
Beginning of Month Date - End of Month Date
Week 1 versus Week 2 (weekly)
Beginning of the Month Date - Today
My QVD is a daily snapshot starting in 7/01/2020, but when i try to perform the above it SUMS everything instead of applying for a specific time frame (example- if I want to plot my totals for Beginning of the Month 7/1/2020 it sums all data since everything from 7/1 to today is beginning of the month 7/1)
