5 Replies Latest reply on Aug 1, 2018 3:02 PM by Peter Fakan

# How to filter only one parameter on the visualization

I want to filter only one of the parameter in the attached visualization ie "is churn final" .( PARAMETERS - is churn final and amount paid)

Would like to keep the "amount paid" [sum(amount paid) ](which should show total amount paid per quarter irrespective of any filter ) to be constant value in the visualization.

Currently when i filter "is churn final" as No or Yes

the parameter "amount paid " considers the sum of rows which has a value No and Yes respectively.

Is there a solution for this ? Kindly help

Attached is the workbook.

Thank You

• ###### 1. Re: How to filter only one parameter on the visualization

Hi Suhas,

My initial thoughts are we could create a calculated field to add this constant value to the end of your viz, or we could simply create a new worksheet that has the constant value and not have it affected by any filters and add this to your dashboard.

HTH

Peter

• ###### 2. Re: How to filter only one parameter on the visualization

Hello Peter , thank you for looking into this.

I did create a calculated field but it does not seem to work as expected.

Kindly let me know your thoughts.

File attached.

• ###### 3. Re: How to filter only one parameter on the visualization

Hi Suhas,

Is this what you are looking for ?

HTH 18.1 attached

Peter

1 of 1 people found this helpful
• ###### 4. Re: How to filter only one parameter on the visualization

Hello Peter Fakan,

Thank you so much for your help.

However can you kindly share the brief logic behind the calculation ?

Moreover

Can this be achieved using parameter ?

Again , thank you for your help

• ###### 5. Re: How to filter only one parameter on the visualization

Hi Suhas,

I'm not so good at explaining fixed calculations, but by using fixed it took the [date final] out of the calculation, and calculated the rest of the average as if there are no other filters on it. When this is put onto the viz, because [date final] is on the left side of the : it puts down the average but distributes it for each [date final] reference point.

I'm not sure what you mean by using parameters, they work differently to calculated fields. You can use parameters to change components inside calculated fields, and you can use parameters to change entire calculated fields if that helps

HTH

Peter