I struggle with averages in tableau I have twelve months showing on x axis. And then I have product along the rows. How can I get the daily average for each month, but only in months that have data and that are complete (basically, excluding most recent month if it is incomplete and months where the product was not yet launched)
On the same note, how can I get the average monthly average for the entire year? Using the same conditions.
I would check out some of the following blogs and posts about averages within Tableau.
Hope this helps!