4 Replies Latest reply on Jun 23, 2016 7:49 AM by khalid norat

How to make a proxmity parameter affect only a specific filter selection on bar chart?

Sebastian Borys Jun 22, 2016 10:54 AM

Hello,

I have a vicinity parameter set that that affects a bubble chart illustrating a within / outside the proximity by color. It also affects a rank of individuals ordered by some number.

On the same dashboard I have a bar chart with a filter on it with two selections. I set the vicinity parameter to also affect the bar chart. However I wanted to affect only 1 selection of the bar chart, call it selection 1 and not the other.

Any idea on how to approach this, my goal is for the parameter to only affect filter selection 1 on my bar chart.

Thank you.

1. Re: How to make a proxmity parameter affect only a specific filter selection on bar chart?

khalid norat Jun 23, 2016 6:57 AM (in response to Sebastian Borys)

I'm not sure if I totally understand your requirement. But this maybe something that can be solved using LOD formulas
if you look the Exclude LOD formula this will allow you to ignore 1 more filters in your calculations
Like Show 0 Likes(0)

Actions
2. Re: How to make a proxmity parameter affect only a specific filter selection on bar chart?

Sebastian Borys Jun 23, 2016 7:07 AM (in response to khalid norat)

Thanks for your reply!

As for the parameter that I have , users enter a number in feet . The prameter affects multiple sections of the dashboard .

on the bar chart have a filter with two selections . I need the parameter to only affect the bar chart when only 1 of the selections is selected and not the other.

Can you provide an example of the exclude formula with a filter expression.

I tried but failed with it .

Thanks.
Like Show 0 Likes(0)

Actions
3. Re: How to make a proxmity parameter affect only a specific filter selection on bar chart?

khalid norat Jun 23, 2016 7:09 AM (in response to Sebastian Borys)

I think what you are looking for from this explanation maybe something different to what I first assumed.

Could you please share a sample workbook and possibly a screen shot of how it should work vs how it is working
Like Show 0 Likes(0)

Actions
4. Re: How to make a proxmity parameter affect only a specific filter selection on bar chart?

khalid norat Jun 23, 2016 7:49 AM (in response to Sebastian Borys)

sorry I just realised both are parameters

Is the graph on the left being affected at the moment

how is the graph on the left being calculated

is there anyway you can upload a sample workbook with some dummy data so I can assist more effectively
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

How to make a proxmity parameter affect only a specific filter selection on bar chart?

1. Re: How to make a proxmity parameter affect only a specific filter selection on bar chart?

2. Re: How to make a proxmity parameter affect only a specific filter selection on bar chart?

3. Re: How to make a proxmity parameter affect only a specific filter selection on bar chart?

4. Re: How to make a proxmity parameter affect only a specific filter selection on bar chart?

Actions

More Like This