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