Forum Discussion
2 date ranges for data
I am currently working with a large data set and I am using created date as the driver for the majority of my reports. Currently created date spans from 01/01/2016 to current day but will be includin...
I am averging business hours because each location is open the same amount of hours for each day of the week Monday through Friday is 8 hours, Saturday is 7 hours and Sunday is 4 hours, by dividing the total number of guest cards by the number of hours we were open it normalizes the counts of guest cards so that Sunday and Saturday are more in line with the rest of the week even though they were open for fewer hours. Your suggestion on removing the sum worked! Thank you so much!
Anonymous.
Glad to hear the issue is solved. Please mark appropriate replies as solutions, that way, other community members would easily find the answer when they get same issues.
Regards,
Lydia