`
Easy Insight Logo
Call 1-(720)-316-8174

Filter Functions

singlefiltervalue returns the value of a single, multi, or pattern match filter.

singlefiltervalue("Filter Name")

would return the selected value of the filter matching to Filter Name. If it's a multiple value filter or a single value filter set to All, null will be returned.

datefilterstartvalue returns the start date of the specified date filter.

datefilterstartvalue("Filter Name")

would return the start date of the filter matching to Filter Name.

datefilterstartvalue returns the end date of the specified date filter.

datefilterstartvalue("Filter Name")

would return the end date of the filter matching to Filter Name.

fieldchoice returns the field selected by the specified field choice filter.

fieldchoice([Metric])

looks for the field selected in the Metric field choice filter.

As an example of where you might use this function, you could do a Numerator as one field choice and a Denominator as a second, with a calculation of:

fieldchoice([Numerator]) / fieldchoice([Denominator])

togglefilter enables or disables the selected filter.

togglefilter("SalesRep", "off")

disables the SalesRep filter.

RESOURCES
Twitter Logo