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

# Calculated row creation

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

Colby, would be able to post your sample?

• ###### 2. Re: Calculated row creation

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

• ###### 3. Re: Calculated row creation

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.