5 Replies Latest reply on Sep 16, 2013 1:34 AM by bart.groots





      I like to have a row with average instead of a row with Grand Total.

      See picture & packaged workbook.












        • 1. Re: Average
          Robin Kennedy

          Hi Bart,


          A quick and easy way to do this would be to combine two views onto a single dashboard so they're next to each other.


          There are other solutions but they're quite complex to implement -- there are some great ideas, courtesy of Mr Jonathan Drummey, here: Customizing Grand Totals – Part 1 | Drawing with Numbers

          1 of 1 people found this helpful
          • 2. Re: Average

            Robin Thanks,


            Unfortunately, to hear that this is not easy to accomplish in Tableau but great idea to combine two views!



            • 3. Re: Average
              Kris Erickson

              So I put Sales per Year in one dashboard.  Next I made a custom calculation for average and placed it in a 2nd sheet.

              (I used this calculation: sum([Sales])/COUNTD(YEAR([Order Date]) )


              Then I made a dashboard and placed the 2 tabs in it.  It is acceptable and quick:


              The blue line will dissapear when not hovered over, but I have it there to show you how close you can get the sections using the tiled approach.  This seems like the quickest way to get a Grand Average.

              • 4. Re: Average
                Tracy Rodgers

                Hi Bart,


                Your Calculation1 looks good for getting the desired outcome for Aandeel. ketels warmte [Gj]. Place MONTH(Maand (copy)) on the level of detail shelf. Then, right click on Calculation1 on the measure values card and select Compute Using...>Maand (copy). Finally, right click on Calculation1 in the data box and select Default Properties>Number Format... and select Number (Custom) and change the number of decimal places to 3.


                Create calculated fields similar for the other two calculations.


                Hope this helps!



                • 5. Re: Average

                  Thanks Tracy,


                  I do understand the formule but i dont understand how i can combine the packaged workbook  with the AVG in one worksheet?