topic Change to Set Analysis in App Development

Change to Set Analysis

antonaks — Tue, 21 Dec 2021 20:43:45 GMT

Hello colleagues,

Please, give me advice how, can I change this IF expression for set analysis analog?

if ((Date(last_date) - Date(date)) > 30, Count(distinct user_id),0)

jonathandienst — Mon, 03 Feb 2020 09:55:12 GMT

Set analysis is a filter, not a conditional. Therefore you can't replace that If with a set expression.

If you meant Count(If(....)), then you could use a set expression, but that is very different (with a different result) to what you posted.

antonaks — Mon, 03 Feb 2020 10:19:39 GMT

I'm sorry. Yes I mean Count(If(....)) expression.

Kashyap_R — Mon, 03 Feb 2020 10:22:02 GMT

Maybe you can create the day's difference in the back end

Date(last_date) - Date(date) as DateDiff

you can use this expression in the front end

Count({<Days={">=30"}>}OrderID)

You can use directly in expression but it should be KPI and dates should be filtered

Count(distinct {<$(=Fabs(max(last_date) - max(date)))={">=30"}>}user_id)

Hope this info helps

Thanks