Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
sum({$<TRX_DATE={">=$(=Date(addmonths(monthend(today()),-12),'MM-DD-YYYY'))<=$(=Date(addmonths(monthend(today()),0),'MM-DD-YYYY'))"}>}CNT_USAGE)
Try this, its the date format which is different from your field format.
sum({$<TRX_DATE={">=$(=Date(addmonths(monthend(today()),-12),'MM-DD-YYYY'))<=$(=Date(addmonths(monthend(today()),0),'MM-DD-YYYY'))"}>}CNT_USAGE)
Try this, its the date format which is different from your field format.