1 Reply Latest reply on Oct 25, 2016 4:51 AM by Tharashasank Davuluru

    Exporting Data from Tableau

    Ramz Aftab

      Experts,

       

      I have a scenario where I have to create %ages formulas using SQL data source in Tableau. This would create additional set of measures in Tableau e.g. %age of Cost and other calc. fields and in the second step, I have to PIVOT these measures that we've just created in Tableau. i.e %age of Cost

       

          

      Entity SalesCost%age of Cost
      A4094209451%
      A5038403880%
      B1741154189%
      X5099489996%
      Y57675765100%

       

      Constraints that I'm encountering:
      1) Data Interpreter doesn't work with SQL data. It only works with Excel. (Note: The data is big enough for Excel to handle)
      2) PIVOT is a manual process in Tableau. I reckon that it won't automatically pivot (new % measures)  data on refresh every time data is reloaded ? I think it's a bummer. 

       

      What alternative approach do we have ?

       

      Ramz