Count the number of reservations per day

Questions & Answers
1

Hi team,

I need your help.

I have a project in Jira which is used to reserve work days. These days are always consecutive. Example: (Monday, Tuesday, Wednesday) or (Tuesday, Wednesday, Thursday) or (Wednesday, Thursday and Friday.)

I will give you an example so that you can understand me better:

  1. I have the following information on the ticket in Jira:

  1. You should create something similar to this in Eazybi

image
image907×141 25 KB

If we look at the box in red, what I am looking for is, that the number “1” can be added in that sequence of dates as appropriate and additional, if another user reserves the same dates, then add it and show me the number “2” as below.

image
image907×142 25.1 KB

I hope this is possible,
Best regards,

3

Hi,

Yes, it is possible.

If you have imported the date fields as issue properties, the following formula gives the count of issues for each day where the day is between the two dates of issues:

Nonzero(Count(
  Filter(Descendants(
    [Issue].CurrentMember,[Issue].[Issue]
  ),
  DateBetween(
    [Time].CurrentHierarchyMember.StartDate,
    [Measures].[Issue Date],
    [Measures].[Issue End date]
  )
  AND
  ([Measures].[Issues created],
   [Time].CurrentHierarchy.DefaultMember)>0
  )
))

Kindly,
Janis, eazyBI support