5 Replies Latest reply: Jun 13, 2018 5:29 AM by Karen Bravo RSS

    KPI by month

    Karen Bravo

      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