formula as a filter

Comments

6 comments

  • Avatar
    Michael Becker

    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
  • Avatar
    John Sirko

    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
  • Avatar
    Andrew Block

    John,

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

    0
    Comment actions Permalink
  • Avatar
    John Sirko

    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
  • Avatar
    Michael Becker

    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
  • Avatar
    John Sirko

    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.