how to get current month and date count details based on user selection

[gyuvaraj]

Hi All,

I am trying to get the Daily and Month to date(MTD) count, Here i got results for current day and current month count but when user is selected previous month its not showing data in KPI.

For example:

max date -15/10/2020
max month - Oct

KPI's: 

Daily -  60

Month - 180

Here when user is selected previous month(SEP) in calendar the KPI's shows - (dash) in text object am expecting here it should show the SEP month max date count in daily and total SEP month count in MTD.

Thanks in advance

Regards,

Yuvaraj

[Chanty4u]

is this?

Count({$<Month = {"$(=Month(Today()))"}>} ID)

or

Count({<Date = {"$(='>=' & Date(MonthStart(Today()), 'DD/MM/YYYY') & '<' & Date(MonthStart(Today(), 1), 'DD/MM/YYYY'))"}>} ID)

[gyuvaraj]

Hi,

Thanks for your reply.

Its working fine for Oct month when i choose Sep its not showing any count.

[MayilVahanan · Accepted solution]

Hi @gyuvaraj 

Try like below

For Daily: Sum({$<Date= {"$(=Date(Max(Date),'DD/MM/YYYY'))"}>} Sales)

For MTD: Sum({<Date = {"$(='>=' & Date(MonthStart(Max(Date)), 'DD/MM/YYYY') & '<=' & Date(MonthEnd(Max(Date)), 'DD/MM/YYYY'))"}>} Sales)