how to get delta valuefor a metric (current month - prev month)

[alamrin]

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.

[tjohnson3050]

Is this a relational or dimensional package?

[alamrin]

relational package will be used.

[pricter]

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.