4 Replies Latest reply on Mar 16, 2016 9:52 AM by Yan Wu

    Using {FIXED} formula does not recognize date filter

    Yan Wu

      Hi everyone,

       

      I am using FIXED function to calculate average of VALUE over a dimension called FIELD.

       

      { FIXED [Field]: AVG([Value])}

       

      However, this does not recognize any other filters.  For example, when I added a date filter, this doesn't effect what is happening in the date filter.

       

      You will see in the Tableau Workbook that the "average over field" column does not change when I change the asof_dt filter.

       

      Is there a way to have the formula recognize the other filters in the workbook?  Or is there more efficient way aside from using the FIXED function?

       

      Thank you very much!