Ability to Exclude Weekends from Reporting
None
It would be helpful to be able to skip weekends in reporting. Especially around reports that look at weekly/daily performance by individuals, it would be nice to be able to exclude weekends.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Here is an example of a report we use to show a CSM their daily email activity. In this case, it would be nice to be able to exclude weekends and only showing working days. We have other cases where we have looked at things like our average time to complete a training in which case it would have been nice to exclude weekends, but we ended up having to build it into Salesforce since we were not able to do it within Gainsight.
I'm not aware of any way to exclude holidays at an aggregate level across all reports. Further, it would require a separate table to define your company holidays as not every region or country recognizes the same holidays. Even within the same country, not every company recognizes the same holidays.
This is still very much needed for us, and would be great if the solution came from Gainsight instead of SFDC, especially with the NXT platform being such a push. Anything currently in the works?@dan_ahrens
Hi@dan_ahrens do you know if there are any updates to this?
So there’s a way you can do this with data designer. It takes 3 transform steps and goes like this:
This will drop any weekend dates from your data sets and only give you dates which fell on the M-F days of the week.
Thank you@dan_ahrens ! Will try this tomorrow. I appreciate the quick response! :)