Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
I have a average problem. I have attached a screenshot and a sample.
Try to select customer bbtkljaorrx.
Then in the big straight table you get a TOTAL of 260.293 sessions which is based on all 3 months (jul,aug,sep)
To calculate Monthly Average i need a weighted average, due to september is not completed. Therefore i take this calculation to determine average on a month which is not done TotalSession / (Total days with data / with total days in month)
But as you can see on my textbox my set analysis expressions calculates my weigthed average on all months which means it takes
260.293 / (83/92) which = 288.518
Divivde 288.518 with total months to find Monthly average = 288.518 / 3 = 96173 - But this is wrong.
My total should be as in my TEST straight table (82771+101200+109028) = 292.999 / 3months = 97.667.
Does anyone know what if have done wrong in my set analysis? Cause it only calculates correctly when i choose a month /but then i cannot calculate the average in another textbox.
Sample attached.
Screenshot:
Test straight table is correct.