1 Reply Latest reply on Sep 28, 2018 7:25 AM by Naveen B

    Can you build an aggregate calculation into a Tableau data source?

    Joshua Manning

      Let's say I have a dataset of car collectors:

      PersonTotalCarsRedCars
      A102
      B122
      C53

       

      I know how to build an aggregate calculation in a workbook for PercentRedCars: SUM([RedCars])/SUM([TotalCars])

       

      What I'm wondering is if I can build PercentRedCars directly into a .hyper file saved on a network drive, or alternatively publish a data source with PercentRedCars as a data source on Tableau Server, so that if someone wanted to create a new workbook using my car collector data, they'd already have that measure built in simply by connecting to that datasource

       

      Right now I only have Tableau Desktop, but my organization may be moving towards getting Tableau Server, but understanding whether this is a capability of any Tableau products will make a lot of difference in how viable it is for our use.