How to segregate reporting based on months with some interval?

[Lakshya Chaudha]

Hi Team,

For information,

In current scenario, I am using Trend TYPE report and in configuration, It is grouped by 'Employee' and Trend by 'Start date'

I am having a Leave request table where we are having start date and End date . Suppose I am selecting date from 29th Sep to 5th oct. Here total number of leaves are combinations of 2 months i.e. Sept and oct. However, In reporting, total number of leaves will be shown in Sept month as Start date is selected of Sept month.

So, What methodology can be used to segregate no. of leaves in Sept as 2 and remaining in Oct month?

[Saurabh Anand · Accepted solution]

Hi Lakshya,

Can you please use add drill down option and check also you can use performance analytics and interactive filters for this.