Filter Chart based on condition

[ivandrago]

Hi,

I have the attached document, there is a graph on there that I only want to show the names where they have a total amount over $400

Thanks

[Anonymous · Accepted solution]

Hi Ivan,

I have edit your Dimension.

Check teh file please.

Good Luck.

[ivandrago]

Thanks Dennis!

How hard is it to amend this so that it includes a Input box so the user can enter the amount they want to show, so the Graph will look at the amount the user has entered?

[Anonymous]

I added a variabel (vAmount) which you can fill or use the slide I add.
Let me know if this is what you need.

[Anonymous]

btw I would suggest that you SUM your amounts (grouped by person) in your script (as Amount_Total)

and then use that in your dimension:

=If(Amount_Total>vAmount,Name)

[ivandrago]

Thanks for the quick response! I

have tried the attached when I typed in 682 I expected to see the following names to show:

Bob (896)

Bill (1000)

Chris (2096.59)

This is because they are over 682, with Jack and John not showing because there Total Amount was under 682.

Thanks

[Anonymous]

Yes, see my previous comment.

You should SUM the amounts because now it leaves out ALL amounts lower then the variable.

[ivandrago]

Sorry Dennis, did not see that part of comment; so is that the only way I can aggregated this field is doing via the script?

[ivandrago]

Dennis, I have amended thescript so I have added another Field called "TotalAmmount", do you know why the graph is showing a bar that should not be there and also why does it not have a Name for this?

[Anonymous]

Hi Ivan,

Just check "Suppress When Value is Null" at the Dimension.

That will do the trick I think.