Good morning, Is there any way to count the difference in days of two dates without counting holidays?
Best answer by Moises Morales
View originalGood morning, Is there any way to count the difference in days of two dates without counting holidays?
Best answer by Moises Morales
View originalHi 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
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.