Forum Discussion
andy_scott42
Helper II
Helper IISumming data with different date frequencies
I have some sales data from a Snapshot Fact tale aggregating some sales data for different sites. However, the frequency of the data I receive from the sites is different i.e. some are daily and ...
The solution I came up with was to add a Row Number to the data based on WeekDay desc, so for each site I could filter to show the latest data per site per week. I then changed the axis of my chart to weekly, showing the first date of each week.
andy_scott42Helper II
Helper IIThe solution I came up with was to add a Row Number to the data based on WeekDay desc, so for each site I could filter to show the latest data per site per week. I then changed the axis of my chart to weekly, showing the first date of each week.