Report Must be Manually Refreshed
I have made a report today where there are 2 subqueries where store = store. the first 3 fields are filtered with a Last hour filter and the last 3 are filtered by between current date - 2 hrs and current date - 1 hr. Whenever I go to check my report it looks like this http://prntscr.com/lcu65o even if there is data in it. The only way to get the data to reappear is if I go in to "edit" the report and then republish it. This is what it should look like http://prntscr.com/lcu83l (we are getting new data every hour so this should never be completely blank). This is very problematic because we are trying to create a broadcast off of this report for if the flag column = 1 we are notified, but the report never seems to be working properly, so I am worried we won't ever get a broadcast if it does change.