I'm trying to create a line and stacked column chart that shows the running total for each day and also have another line value to compare against that would be a running total calculated measure (average of a different month based on if the date is a weekday or weekend) for a specific month.
I can get the running total to work ok but when I try to add the the average for a different month measure for each day to compare against, it doesnt take the average of that month it only shows the average for that day. It's like I cant get a day to month comparison.
Is there a way to accomplish this? Any examples would be great. Thanks!
Comments
Post a Comment