2 Replies Latest reply on May 8, 2013 7:23 AM by buildstar

    Parameters as columns

    buildstar

      Hi All,

       

      Attached is screen shot from tableau.

       

      I have 2 parametrized query parameter dropdowns. Now I want to display the selections as 2 columns next to date.

       

      So the column order needs to be Date | ISQLParam | QLParam

       

      Also I want additional 4th column that sums up each row value and displays as sum

       

      Ex:

       

      ISQLParam | QLParam | Sum

      200 | 300 | 500

       

      Thanks

        • 1. Re: Parameters as columns
          Alex Kerin

          Do you have multiple rows per date? If you do, do you want the sum of all of the parameter values for every row for that date?

           

          You can create a calculated field that is simply your parameter, then drag that over.

           

          You can also create one that sums these together.

          • 2. Re: Parameters as columns
            buildstar

            Hi Alex,

             

            Thanks.

             

            I have 2 parameters and I have created 2 calculated fields with the parameter. When I drag on calculated field on column it displays data fine but on adding 2nd parameter to column it does not display data for that column and is not aligned as desired. Also we have only one row per day.

             

            Also attaching the same data available in excel.I want the report same as in the excel.

             

            Have also attached a sample workbook.

             

            Untitled.png

             

             

            Thanks