KPI by month

[vbravomo]

Hi everyone,

I need some help. I'm trying to create a KPI with the number of users in the current month. But it doesn't work with the following line:

Count({<Year(Num([Started On]))={$(year(today()))},Month(Num([Started On]))={$(upper(Month(today())))}>}USER)

I'm not sure if the problem could be USER is a dim; or if you can use this sentence only with SUM (But I need to count the users)

Thank you

Note: Started On is the date in this format: DD/MM/YY

[Chanty4u]

try this

Note:  Started on   should be mapped with Master calendar 

count({<Year={$(=year(today()))},Month={'$(=upper(Month(today())))'}>}USER).

[sunny_talwar · Accepted solution]

May be try this

Count({<[Started On] = {"$(='>=' & Date(MonthStart(Today()), 'DD/MM/YY') & '<' & Date(MonthStart(Today(), 1), 'DD/MM/YY'))"}>} USER)

[francisco_valle]

Hi Karen,

Try the following:

Count({<[Started On]={">=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))"}>}USER)

[vbravomo]

Thank you!!!

[vbravomo]

Thank you