When creating a report on events within a specific timeframe you want to include the 'Date-Wise Breakup' field, this shows every day of the event separately and therefore you can make sure you include all events, even if they overlap the next or last month.
Note - If you only want to show events that started this month, you do not need to use the date-wise breakup.
View the video, or use the step-by-step below:
How to create the report:
Go to Reports
Select 'All events'
Click 'Create'
Use the following fields (you can add any additional fields that you may need)
Click 'Next'
On the date-wise breakup field, select the filter icon
Change the filter to - date is between and click on the dates required
Ensure you click 'Apply' on the filter
Select 'Next'
Change the name of the report and save
Go back into the report you have just created
Click 'Export' in the top right
Choose Excel, then Export
How to remove duplicate rows in Excel:
Open up the report in Excel
Highlight the date-wise breakup column
Delete the date-wise breakup column (we no longer need this as we filtered on it within Sense)
Highlight all the remaining data
Go to the data tab in Excel
Click the Remove Duplicates option:
Click 'OK' on the pop out:
