count delta is requried of a metric from current month to previous month in the dashboard.
count of reports from current month - count of reports for previous month
This delta value is to be displayed in a singleton separately.
for eg:
reports for aug=10
reports for jul=2
then delta should be 8
sounds easy but its deceptively hard to implement.
any input regarding this help immensely.
Is this a relational or dimensional package?
relational package will be used.
The one is to apply a filter to the query that the month should be either "current month" or "previous month"
Then create two data items one for current month
if (month=current month) then (reports measure) else (0)
and one for the previous month.
if (month=previous month) then (reports measure) else (0)
and then add a third item to subtract the previous data item from the current data.