I have a mysql database with a list of records and hoping to get a stat that shows the percentage change of the count of the submissions in the current time period compared to the same period before it.
e.g., If we are viewing this week we would see percentage change from this week compared to last week (positive or negative) or month or year.
I thought that time shift might be a useful start but it seems to apply to all queries for that panel and isn’t dynamic based on the time period chosen.
If adjusting for time period isn’t possible then this month (so far) compared to last month, or fixed 30 day blocks would be acceptable.
I’ve tried a single simple query and then in query options putting min interval 30d and in the Stat Display options chosen difference percent. It shows a number but its not correct for what I need. for example on the 2nd of May it’ll show two days of may compared to 30 days of april, not the same ‘sized’ periods for comparison.
Thanks in advance!