9 Replies Latest reply: Jan 12, 2018 9:35 AM by Nicolas Albert RSS

    Counting yesterday values in QV

    Nicolas Albert

      Hello community,


      I'm working on a simple dashboard and I'm having troubles trying to count the numbers of items that were created "yesterday". I'm presenting the overall count of items and need to display "yesterday's" count as well. It would give something like:


      • 492 items made in total
      • 13 made yesterday


      As you would imagine, "yesterday" needs to be a dynamic value based on today's date.


      I did try many ways, but they all end up with a zero value or an error in the expression. I'm using the following items:

      • ItemCreatedDate, format is YYYY-MM-DD
      • ItemId

      Can anyone help me on that?