formula as a filter
I have dashboard that was designed (prior to my joining the team) that has a widget filter comprised of a formula. However, I can't figure out how it was created. Does anyone know how to do this?
-
Hi John,
as I mentioned in my initial post. If you create a formula in Values section of widget (panel on the left hand side), it will have a funnel icon on top of it. If you click it, now you have the ability to setup a filter based on that formula. Basically in your case you have a formula which is dividing Fuel usage by cumulative load, in values panel on the left hand side, and somebody has just clicked that funnel and setup filter equal or grater than 0. If you want to replicate that behavior, create a new formula in values panel on the left hand side and then click on funnel icon on it.
Regards,
Michał
-
Ok, Now it is starting to make sense! What happened what that the user must have created the formula with a filter on the left, and then deleted it...leaving the filter on the right. This is what caused my confusion, as the right-side fitler-formula did not exist on the left. Thanks for helping to clarify!
Please sign in to leave a comment.
Comments
6 comments