topic Set analysis with Date in App Development

Set analysis with Date

Husky_Bab12 — Mon, 05 Sep 2022 23:21:58 GMT

Hi ,

I need to sum quantity based on input dates with below expression. Please, some one help let me know where I'm going wrong

=sum({<$(='[Shift Date]')={">=$(vStart)<=$(vEnd)"}>} Quantity)

The shift date is in the format, 2022-Sep-02.

I'm receiving 0 no matter the input I give on vStart and vEnd.

Where , vStart= 0 and vEnd = 0.

Re: Set analysis with Date

Lisa_P — Mon, 05 Sep 2022 23:55:57 GMT

Try just using the field [Shift Date] instead of $(='[Shift Date])

Re: Set analysis with Date

Husky_Bab12 — Tue, 06 Sep 2022 00:14:27 GMT

I tried the below its still giving me 0.

=sum({<[Shift Date]={">=$(vStart)<=$(vEnd)"}>} Quantity)

Re: Set analysis with Date

Lisa_P — Tue, 06 Sep 2022 00:23:53 GMT

What does it show in the expression editor at the bottom of the screen ? This should give you a clue to the issue.

Re: Set analysis with Date

Husky_Bab12 — Tue, 06 Sep 2022 00:28:27 GMT

It says expression okay. I think it is because of the shift date format. what do you say?

Re: Set analysis with Date

Lisa_P — Tue, 06 Sep 2022 00:30:51 GMT

Is the Shift Date detected as a date in the data or a string ? What format are your variables showing ?

Re: Set analysis with Date

Husky_Bab12 — Tue, 06 Sep 2022 00:38:08 GMT

it is loaded in date format.

Re: Set analysis with Date

Vegar — Tue, 06 Sep 2022 04:54:22 GMT

Try this

=sum({<[Shift Date]={">='$(vStart)'<='$(vEnd)'"}>} Quantity)