formula as a filter

Follow

John Sirko

March 05, 2018 16:05

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?

0

• 

  Michael Becker March 05, 2018 16:26

  Hi John,

  if you go to edit mode for widget, on values panel on the left hand side you can see that each measure has a funnel icon on it. If you click it you can now configure filter based on formula.Hope it helps.

  Regards,

  Michał

  1

  Comment actions Permalink
• 

  John Sirko March 05, 2018 16:36

  To clarify, this is an actual widget filter, on the right of the design interface, in the filter section.. There is a filter that has been created that is a formula (see below). If I hover over this filter, it shows an equation.

  

  0

  Comment actions Permalink
• 

  Andrew Block March 06, 2018 15:58

  John,
  
  When you hover over it, it should tell you the table and column it is based on 

  

  0

  Comment actions Permalink
• 

  John Sirko March 06, 2018 16:04

  That's correct, but in this instance, I see a formula (see below), and want to know how this happened, and how to replicate?

   

  0

  Comment actions Permalink
• 

  Michael Becker March 06, 2018 16:08

  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ł

  1

  Comment actions Permalink
• 

  John Sirko March 06, 2018 16:12

  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!

  0

  Comment actions Permalink

Please sign in to leave a comment.