3 Replies Latest reply on May 11, 2017 7:36 AM by Colby McNichols

    Calculated row creation

    Colby McNichols

      I'm not sure if the title of this discussion is correct, but it's the best I could come up with.

       

      Basically I was asked to create a dashboard that would show different options the business can go with based off a user input parameter.

      So what I need is the ability to create a few rows of data points based off a parameter.


      Example will probably clear this up...

       

      User enters 2000 in a parameter box. I need to have a table show 5 rows with the values of 1000, 1500, 2000, 2500 and 3000 in a column.

      From there I can use the values in the column to do calculations with.

       

      DeductibleCustomer Count
      1000 (parameter - 1000)123
      1500 (parameter - 500)6546
      2000 (this would be from the user input parameter)6546
      2500 (parameter + 500)145
      3000 (parameter + 1000)978

       

       

       

      * Added attached .twbx Created in Tableau 10.1.4

      * In the attached example, would like to have 2 rows above at 400 and 300, as well as 2 rows below at 600 and 700.

        • 1. Re: Calculated row creation
          Sherzodbek Ibragimov

          Colby, would be able to post your sample?

          • 2. Re: Calculated row creation
            Lisa Li

            Hello Colby,

             

            You can use a calculation similar to below:

            if [Minimum DWP] = [DWP] or [Minimum DWP] +100 = [DWP] or [Minimum DWP] +200 = [DWP]

                 or [Minimum DWP] -100 = [DWP] or [Minimum DWP] -200 = [DWP] then [DWP]

            end

             

            Based on the twbx file you shared, [Minimum DWP] the parameter is the graphed [Min DWP] field so every row of data has [Min DWP] = 500. Is there a field in the data you can use in the calculated field above that represents deductible (DWP)?

             

            -Lisa

            CoEnterprise | Home

            • 3. Re: Calculated row creation
              Colby McNichols

              Sorry should have been more clear.

               

              So with the twbx file I gave, my desired table I would like to show would be this when 300 is entered in the Minimum DWP parameter...

               

              Lob Jfmin dwpNumber of RecordsCount BelowCount Above
              CR10041572446

              1711

              CR200415726401517
              CR300415727821375
              CR400415729211236
              CR500415730891068

               

              When you change the Minimum DWP parameter to 600, the table would look like this...

                  

              Lob Jfmin dwpNumber of RecordsCount BelowCount Above
              CR40041572921

              1236

              CR500415730891068
              CR60041573212945
              CR70041573315842
              CR80041573402755

                  

               

              I obviously have the count calculations working, but I can't get the generated +/- rows to generate. Not even sure if this is possible.