Forum Discussion
bubbaallred
3 years agoFrequent Visitor
Rolling Average on non-summarized data
I'm trying to create a rolling average measure but instead of returning the average of the period, I just get the total for the single date/7. I've tried multiple measures using the days in period f...
Padycosmos
Solution Sage
3 years agoHope this video helps:
bubbaallred
3 years agoFrequent Visitor
I appreciate your response. This method returned exactly the same bad result. For a given date, the rolling average is the same as the sum for that date.
I did discover when fooling around with it some more that If i simply change the date field in the visual to a Date instead of a Date Hierarchy, all the functions I've tried begin working. There's something about using that Date Hierarchy which breaks all these rolling average measures...
At this point I have the visual working, I just have no idea why that fixed the issue.
Thanks for the help though!