Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
selvakumara
Creator
Creator

Get Previous Fiscal year Monthwise Data

If a single month, or multiple months are selected


  • Count events in the selected month(s) as current and count the same months in the previous FY year (if they select June FY16, July FY17, August FY17 as the current selection then for previous year show June FY15, July FY16 and August FY16
2 Replies
tresesco
MVP
MVP

Try to share a sample with representative data to work upon to help you.

selvakumara
Creator
Creator
Author

I don't have a permission to export my apps.

[Year Month] = 2016-06,2016-07 i have selected two months.


I want to compare the data for Previous year [Year Month] = 2015-06,2015-07

This is my set expression

Count({<[Year Month]= P([Year Month]) ,[Event Group]={'fdfgdffgd'}>} DISTINCT EventRecord)

How can i achieve this functionality?