3 Replies Latest reply on Feb 17, 2020 3:15 AM by Elvira Miró

    Sum of averages not using LODs

    Elvira Miró

      Hi all,

       

      I am using the average of variable X as a text mark in a table graph (as I only want to keep the month values for this variable). In the view, I have other variables that are not duplicated but single values for the same month (they don't have the same aggregation) and come from a different source, thus I cannot use LOD calculations. I want to have the total as the sum of AVG(X), but coming from blended data, I cannot do it simply by clicking on the total (e.g. http://www.tableausoftware.com/new-features/two-pass-totals). Is there any kind of Table Calculation to do it the elegant way? I have tried WINDOW_SUM(AVG(X) but it doesn't work either (gives me the average of all rows).

       

      Thanks in advance,

       

      XDate
      131/01/2018
      128/02/2018
      131/03/2018
      130/04/2018
      131/05/2018
      130/06/2018
      131/07/2018
      131/08/2018
      130/09/2018
      131/10/2018
      130/11/2018
      131/12/2018
      731/01/2018
      728/02/2018
      731/03/2018
      730/04/2018
      731/05/2018
      730/06/2018
      731/07/2018
      731/08/2018
      730/09/2018
      731/10/2018
      730/11/2018
      731/12/2018
      931/01/2018
      928/02/2018
      931/03/2018
      930/04/2018
      931/05/2018
      930/06/2018
      931/07/2018
      931/08/2018
      930/09/2018
      931/10/2018
      930/11/2018
      931/12/2018