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!