Allow Value type filters to use formulas rather than just hardcoded values

[wallingfordce]

When filtering on a numeric field and using a Value type filter, I often want to filter on a dynamic value. As the Ranking type filter can take a formula, I would make good use of a Value type filter that also allowed for a formula.

[DRay]

Hi @wallingfordce.

Thank you for your feedback! Have you looked at Measured Values, and will they help your use case?

https://docs.sisense.com/main/SisenseLinux/creating-formulas-based-on-criteria-and-conditions-filter...

[wallingfordce]

Yes. Very familiar with measured values. Thanks @DRay.

With Conditional Color we are allowed to compare the results of a value or formula to another value or formula.

There are times when users find themselves wanting to do similar within filters on dashboard, widgets, or in measured values. Filtering on a numeric, selecting Value type filter and wishing to use a formula rather than a hard-coded value against which the source value is to be compared.

The most common use case surrounds using what we call Relative Milestone Anchor dimensions. These are numeric fields that represent the time in days, weeks, or months between two customer interactions in time. For example, the time between the start of a fundraising campaign and a person's contribution. The time between a product on-sale and a customer's purchase of that product. The time between the customer's purchase of an event ticket and the date on which the event occurs. These fields allow time series and sales cycle analysis for anchor dates that do not share a common time within a period. In other words, it's not possible to compare the sales cycles using date fields in combination with date functions.

We then often field questions around limiting the scope of days on the x-axis to the same set of days for the currently on-sale product. For example, if the green line in the image represents something that's currently on sale and the other three are past / completed sales cycles, then limiting the widget to only days 0 through 7. Then the next day, without a designer having to change anything, the widget shows days 0 through 8 because the green line would cover only that range.

Being able to filter the x-axis numeric field on a Value type formula for something like this would be helpful:

<= ( MAX ( [Days Since On-sale] ) , [Product = Currently On Sale Product] , ALL( [Days Since On-sale] ) )