5 Replies Latest reply on Feb 24, 2017 5:06 AM by Mark Fraser

# Formula

Why is it not working:

• ###### 1. Re: Formula

Hello suvas.chandra,

Just a question, what are you trying to return in here?

Also can you attach a sample of your workbook?

Thank you!

• ###### 2. Re: Formula

I have three sheets in the dashboard. I have created this parameter to filter data in three different sheets to satisfy four different scenarios:

1) Grid 1, Graph 1, Graph 2

2) Grid 2, Graph 3, Graph 4

3) Grid 3, Graph 5, Graph 6

4) Grid 4, Graph 7, Graph 8

Workbook is attached.

• ###### 3. Re: Formula

Hi Suvas

i note you switched the parameter from float to string - thats the first issue now, you need "1", "2" etc... doesnt matter though you have bigger problems...

I think i see what you're trying to do,

what i think you want to do - is display 3 graphs based on a single parameter - based on specific values - which are based on the parameter selection

but it wont work in that way unfortunately - i think you'll get further with dashboard actions but even then its going to take some thought...

You may need to define the report selections (somehow) first, and then use the result of this test in the paramater - kind of cascading the logic but not sure how much is possible

Will give it some thought - i hope some of this makes sense, and helps you and others

Cheers

Mark

• ###### 4. Re: Formula

Suvas,

Your formula isn't formed correctly. Take a look at the help documentation for IF statements - Understanding Logical Calculations | Tableau Software

The correct logic for an IF statement is along the lines of

IF [statement] THEN [result]

ELSEIF [statement] THEN [result]

You are writing IF [statement] THEN [statement] AND [statement]

It looks like you might be misunderstanding how a calculated field works - it does not assign a value to another field, it will return a value as per my sample above.

1 of 1 people found this helpful
• ###### 5. Re: Formula

Thanks Tom - helpful explanation.

From what I could work out, I believe the OP wants to pass values (for filtering the 3 graphs) based on selections via the parameter.

Kinda like dashboard actions, via an IF statement... inventive but dont think its going to work.

There must be a way to use the outcome of one function to pass a value and then filter another item (assuming so kind of hand-off or cascading) but havent given it too much thought, yet.

my gut feeling was that dashboard actions maybe better to drive the contents of the graphs via filters - thats essentially what the problem is

Mark