Forum Discussion
Solved
Filtering data based on last 7 days aggregate
Hello! I'm hoping somebody can help! I have data at a daily level in my fact. I would like to be able to filter months and show all days in that month where the sum of sales in the last 7 day...
Hi mlmchilli ,
Is this the result you want?
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In the screenshot of your results you only have the last 7 days of data for product 1 so Jan 1,2,3 are missing. We would need to see all days data where the total sales amount in the last 7 days is over £1000. Perhaps this is because you are filtering the fact table down to the last 7 days in your first statement?
Hi mlmchilli ,
Is this the result you want?
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.