2 Replies Latest reply on Jul 8, 2016 4:14 PM by Ashwin Chandak

    Discrete Fixed Calculation Not Averaging Correctly

    Ashwin Chandak

      Hello guys,


      Please find attached a dummy data file in excel and a tableau workbook to demonstrate the issue I am encountering.


      I am trying to create a view to show average metric values for a chosen date ranged (based on a date parameters) and a spark line/ trend line for the corresponding date range.


      The aggregated number should be an average of all the data points on the sparkline


      For this, I have set up a calculated field called 'Fixed Value' with the following formula : { FIXED [Metric]: AVG([Param Value])}, and converted it to discrete.


      The issue is that the average of the sparkline is not being correctly calculated for the fixed calculation


      Is there something I am missing or is there a workaround to achieve the same?


      Please find the workbook attached. Kindly let me know. Thanks!