Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Oct 13, 2018, 4:22 AM

Remove first month of data for all products

Hello. I haven't had any luck getting help on this question

 

I have products and I have a daily average for each month by product. HOWEVER, when a product is in it's first month, sometimes it starts on the 15th of the month as an example, but the formula I'm using counts all days in that month so the average is lower than it should be. How can I accommodate for these types of products (they are the ones with 0's in a lot of months)?

 

This is the average formula I'm currently using:

 

AVG({ FIXED [Category], [Date]: SUM([Sales Volume])})

2 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Oct 13, 2018, 12:44 PM

    Hi Alex,

     

    Put the same calculated field on filter.

    Hi Alex, Put the same calculated field on filter.Select the aggregation what you have used on report, in your it must be Average. The select 'Atleast' and set as 0.1 Now you should not see the 0.

    Select the aggregation what you have used on report, in your it must be Average.

     

    The select 'Atleast' and set as 0.1

     

    pastedImage_1.png

     

    Now you should not see the 0.0 values on the report

Write an answer...
0/9000