topic Re: Concern on scope of set analytics in App Development

Concern on scope of set analytics

thi_pham — Mon, 20 Dec 2021 21:08:46 GMT

I have a concern on this case, I have a date field which value from 2020-01-01 -> today()

I have a measure like: sum({<Date={"<=$(vMaxDate)"} Sale) with vMaxDate = date(max(Date),'YYYY-MM-DD')

When I filter date = 1 value such as 2020-09-01

Then measure return value of sum sale from 2020-01-01 to 2020-09-01. Or just sum sale in 1 date 2020-09-01. ????

From my understanding , without specify 1 in the set analytics, the scope of it will be on filtered values -> it should be return sum sale of 1 date only, but when I tried, it actually return sum sale of whole period, how it possible?

Re: Concern on scope of set analytics

tresB — Wed, 09 Sep 2020 06:11:31 GMT

@thi_pham , when you are selecting a date, your expression is essentially, becoming like:

sum({<Date={"<=selectedDate"} Sale) . Therefore, it would give sale for all dates '<=' selectedDate.

Re: Concern on scope of set analytics

thi_pham — Wed, 09 Sep 2020 06:17:04 GMT

Yes, it will be your mentioned expression. However, my concern is when I filter the date field by selecting 1 date only, the scope of data for this expression is just on 1 date only, not whole dataset.

If it behave like this, then what's different between

sum({<Date={"<=selectedDate"} Sale) VS sum({1<Date={"<=selectedDate"} Sale)

Re: Concern on scope of set analytics

tresB — Wed, 09 Sep 2020 06:28:57 GMT

@thi_pham

With sum({1<Date={"<=selectedDate"} Sale), you are telling to ignore ALL fields' selection (date field as defined in expression), whereas, without {1}, you are telling to disregard only the Date field selection (and consider dates as defined in the expression).

Re: Concern on scope of set analytics

thi_pham — Wed, 09 Sep 2020 06:26:22 GMT

woa, thanks for your explanation. I just thought that prefix $, 1 will affect to all fields (include the field specified in the set analytics), then with $, it will be and condition between value in set analytics and current filtered value of app.