I am trying to understand the % increase and decrease in the number of orders on a daily basis.
Sure, I do have a line chart, which tells me if I am doing better or worse from yesterday but it does not tell me how much better or worse I am doing. This is where the trend visualization in Metabase comes really handy.
Let’s consider this situation -
Date # Orders
6/03. 3
7/03. 6
8/03. 12
Now, when I check on 7/03 it will show me 6 orders today which is fine. But when I see on 8/03 it still shows me 6 orders today.
When I dug into it, I figured that I checked at 10 am on 8/03 and the first order placed was at 11 am on 8/03.
This means it will keep showing the previous day’s result until there is a new entry on the current day rather than just showing 0 for the current day.
Can this be changed to show 0 for the current date? Please let me know if anyone has any idea about this.