topic Re: Date picker in set analysis in App Development

Date picker in set analysis

DevelopCal — Fri, 02 Apr 2021 08:39:39 GMT

How can i add the month selected in the "date picker" and recalculate the following KPI depending on selection?

=Money(avg(distinct{<Month={"$(vMesultimo)"}>}PayingCustomer),'###,##€',',','.')

vMesultimo=Date(Max(Month),'YYYY-MM-DD')

Thanks!

sunny_talwar — Mon, 28 Sep 2020 14:05:55 GMT

How is Month field created in the script? Is it just Month(Date) as Month or do you have Month stored as a Date?

DevelopCal — Mon, 28 Sep 2020 14:10:33 GMT

just Month in the loading script

DevelopCal — Tue, 29 Sep 2020 08:42:20 GMT

is there any option?

Anil_Babu_Samineni — Tue, 29 Sep 2020 09:32:45 GMT

Let's say you have DateField and You've associated model, The below expression will give by default filter selection

=Money(avg(distinct{<Month={"$(vMesultimo)"}>}PayingCustomer),'###,##€',',','.')

In case, If you want to use the same what you have done in the date picket

=Money(avg(distinct{<DateField=P(DateField), Month={"$(vMesultimo)"}>}PayingCustomer),'###,##€',',','.')

In case, If you required to get Max Date - Then you can call as

=Money(avg(distinct{<DateField={"$(=Max(DateField))"}, Month={"$(vMesultimo)"}>}PayingCustomer),'###,##€',',','.')