2 Replies Latest reply on Oct 11, 2018 6:58 PM by Alex Martino

    Averages with conditions

    Alex Martino

      Hello. I'm having a heck of a time with averages in tableau.

       

      I have a file that shows monthly averages (by dad) by product line.

       

      I would like to do the following:

       

      1) In any month, I want to get the average FROM the first day of sales. This affects products that launched in the middle of the month. I want it to just take the average of the days where there was activity.

       

      2) In the final month of the data set, I want it to take the average of only the days active (so if the last date is the 18th, the average would be based on 18 days, not 30)

       

      3) Finally, I would like to create yearly averages by month and by day, with the same criteria for each product. That is, for days, it only shows the average from the point where the data started. And for months, it does not include months where the average is 0 (since the product did not exist)

       

       

      If this doesn't make sense please let me know and I'll try to explain further. Thanks. Spreadsheet attached.