Date range from mashup to expression

pdimiel — Sat, 16 Nov 2024 03:26:37 GMT

Hi everyone.

I am trying to pass date values from mashup to variables in order to use them as a date range filter in a set analysis expression.

In the mashup i have
app.variable.setStringValue("vSTARTDATE", "2015-01-01");
app.variable.setStringValue("vENDDATE", "2015-01-31");

And in the set analysis expression I have the following to count the reviews in the date range

Count(distinct{<review_date={">=$(=$(vSTARTDATE))<=$(=$(vENDDATE))"}>}[review_id])

The above does not work and I cannot figure out why.

Any help is welcome

topic Date range from mashup to expression in App Development