Average invoiced shown instead of totals
I'm so lost here that I had to draw it by hand! haha. How do I do this properly? I'm actually just grasping at straws at the moment and need some expertise. (Ignore february, I draw this before my morning coffee).
6 replies
-
Are you looking for the daily average? so the average total invoiced per day by months?
A. You need to reverse the order:
or:
Here it is:
Do notice that you will get the average for days where you had sales - so If I filter to just one product:
If you need this always divided by the number of days in a month you'll need to do it more explicitly:
(you can add a count of days to your model - make sure it is a separate dimension).
Which yields:
-
how do I exclude the weekends?
-
If you use the second example - you can simply filter them out in the discover
-
ok. So It's not working for me. The average should be 145,086.25, but instead this is what I get:
-
Could it be that you only have 19 actual days in Feb 2025? Do you have a date dimension or are the dates from the invoice tables?
-
GENIUS!
-