Good morning, Is there any way to count the difference in days of two dates without counting holidays?
Best answer by Moises Morales
View originalDiference between dates
Userlevel 3
Hi Thiago, unfortunately its a little difficult for us to provide you with the correct metric, without knowing, and looking into the project. However, at this time I can provide you with the guidelines on how to create such a metric - This article should help you get started:Â Date Attribute Arithmetic - Gooddata Classic
Example: Your metric would look something like this:Â SELECT AVG(Select Date (CreatedDate) - Date (TakeDownDate) BY TicketId)
Â
Due to different holidays being relevant in different countries, we don't have a systematic way to exclude holidays. But, you can omit specific dates from your reports. For example, if you'd like to exclude tickets created December 25 from his reports,you can create a filter such as "Date (Created) isn't 12/24/2015, 12/25/2015, etc.
Â
-Moises
Reply
Login to the community
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Social Login
or
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.