Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
is this?
Count({$<Month = {"$(=Month(Today()))"}>} ID)
or
Count({<Date = {"$(='>=' & Date(MonthStart(Today()), 'DD/MM/YYYY') & '<' & Date(MonthStart(Today(), 1), 'DD/MM/YYYY'))"}>} ID)
Hi,
Thanks for your reply.
Its working fine for Oct month when i choose Sep its not showing any count.
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)