I am having a problem where in a sales environment when there are weeks with no sales the averages are only worked out across the weeks where sales occurred. Is there a fix for this? Many thanks in advance. Sean
Apologies if you've already tried an discounted the below method.
I'm not sure if this will work for your true setup, but I think you could try
manually dividing the sum of sales by the number of weeks, something along the lines of:
( DATEDIFF('week',WINDOW_MIN(MIN([Datefield)),WINDOW_MAX(MAX([Datefield])) )
could also be done with level of detail equations.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...