If statements conditional on multiple filter selection

tableaucommunity@tableau.com — Fri, 23 Aug 2013 10:57:35 GMT

Hi, I am new to tableau and I am having trouble creating a metric which responds to multiple filter selections.

Firstly my data is formatted as follows:

Date	Channel	Metric	value
week 1	Channel 1	Metric 1	100
week 1	Channel 1	Metric 2	200
week 1	Channel 1	Metric 3	300
week 1	Channel 1	Metric 4	300
week 2	Channel 1	Metric 1	400
week 2	Channel 1	Metric 2	500
week 2	Channel 1	Metric 3	500

The idea being that i am able filter for any given week any channel and metric combination via filter.

However I want to be able to perform a calculation if two metrics are selected. So far all tableau is doing is summing the value for the metrics.

I have tried to do this via a calculated filed using the following:

If [Metric] = "Metric 1" and "Metric 2" then (value/2)

else value

end

I have also tried nested if statements but it still just sums the two values.

I don't know if my data is in the correct format or if there is an error in the calculations. Please Help?

Thanks

Content in Tableau Community Forums