3 Replies Latest reply on Jun 6, 2016 11:56 PM by kumar.c

    Average excluding Zero value

    Jordan Lau

      Could any expert can tell me the best way to get the average value of several measures ?

      the case is that.

      I upload several data sources (in csv format) into tableau

      there are several measures in each data source (ie each csv carry several measures)

      I need to calculate the average of each measure, excluding those cells with ZERO in values

       

      I know creating calculated filed can fix it. However, I need to create many calculated fields.

      is there a way I can do it once ?

       

      I have tried another way to put the data source in excel and converting those ZERO value into Null. However, it takes a long time because there are too many records.

       

      thanks