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.
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)
• Event name• Start date (All events)
• End date (All events)
• Status (All events)
• Recorded in
• Duration
• Type
• Booking breakdown
• Start day shift portion
• End day shift portion
• Start time
• End time, and
• Date-wise breakup
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
Click Report details
Update the Report Name
Close the Report details dialog and click Save Changes
Click Export
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 (you 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:
