2 Replies Latest reply: Jun 29, 2017 2:12 PM by neelam sehrawat RSS

    Rolling Yearly Usage

    Cassandra Baqir

      I am trying to create a graph for NPrinting that shows Usage over the past rolling year.

       

      The original expression is:

      sum(aggr(sum({$}CNT_USAGE),DOMAIN,GOVERNING_CCG,DESCRIPTION,LAST_REVIEW_DATE))

       

      This is what I was trying for rolling but it is not working:

       

      sum(aggr(sum({$<TRX_DATE={">=$(=addmonths(monthend(today()),-12))<=$(=addmonths(monthend(today()),0))"}>}CNT_USAGE),DOMAIN,GOVERNING_CCG,DESCRIPTION,LAST_REVIEW_DATE))

       

      or

       

      sum({$<TRX_DATE={">=$(=addmonths(monthend(today()),-12))<=$(=addmonths(monthend(today()),0))"}>}CNT_USAGE)