How to calculate a window average of any measure over time excluding a non null particular month or quarter value (probably a mid quarter or mid month in a series) ?
You could look to create a new field to use in the window function.
If you want to exclude November sales for instance:
WINDOW_AVG(SUM(IF MONTH([Order Date])<>11 THEN [Sales] END))
Excluding November from the viz shows it match:
Not entirely sure of your end goal, but hopefully this helps!
Thank you so much. It helps a lot !
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...