Hi,I have a Time dimension on the "pages" (filter) section. I want to create a calculated measure, where I want to return the number of workdays using the DateDiffWorkdays function. So, I need to retrieve the Min and Max date of my selection (assuming multiple selection).How can I do that (using EazyBI 4.6.0 and Jira 7)Thanks for your help!

Community
Q&A
Jira
Questions
Calculate date delta on a min and max date from a set of selected Time dimension

Looking for integration of Jira Dashboard in Google site

I am planning to integrate Jira Dashboard in Google site. Can you please guide me how to do this?

1 answer

1 accepted

0 votes

Answer accepted

Hi @Jerome Renaud,

You could generate the set of all days and get the first and last item from it. Please try the following formula

DateDiffWorkdays(Generate(
    ChildrenSet([Time].CurrentHierarchyMember),
    Descendants([Time].CurrentHierarchyMember, [Time].[Day])
  ).Item(0).StartDate,
  Tail(Generate(
    ChildrenSet([Time].CurrentHierarchyMember),
    Descendants([Time].CurrentHierarchyMember, [Time].[Day])
  )).Item(0).StartDate
)

Lauma / support@eazybi.com

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Works perfectly, thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Lauma Cīrule likes this

Suggest an answer

Was this helpful?

Thanks!

Jira

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Looking for integration of Jira Dashboard in Google site

1 answer

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events