Date picker in set analysis

[DevelopCal]

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]

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]

just Month in the loading script

[DevelopCal]

is there any option?

[Anil_Babu_Samineni]

@DevelopCal  

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),'###,##€',',','.')