How to calculate by month
I'm wanting to output totals from 2 months ago, 3 months ago, etc; but when I use "Previous N Months", it's a cumulative total. How do I get a total for ONLY the single month 2 months ago, and ONLY the single month 3 months ago, etc?
Current code:
- <panel>
- <pr width='fill' height='fill'>
- <pc padding='20px' bgColor='#FFFFFF' width='100%' hAlign='center' vAlign='middle'>
- <pr width='auto' height='auto'>
- <pc>
- <text color='#000000' size='36px' uppercase='false' underline='false' bold='true' italic='false' type='Form Data' displayType='actual' thousandsSeperator='LOCALE' decimalSeperator='DOT' numberScale='none' criteria='BUILDER.contains("builder") && !BUILDER.contains("city") && DELIVERED_DATE in 2 months ago && QTY > 5' value='thisapp.LOG.ID.count'> </text>
- </pc>
- </pr>
- </pc>
- </pr>
- </panel>