Hi @Piotrexpondo ,
You can use CountIf function for all these requirements.
For open tickets:
"(Number of open tickets " & CountIf(
'Helpdesk Jira Tickets',
'Ticket Status'.Value = "open"
)
& ")"
For closed tickets:
"(Number of closed tickets " & CountIf(
'Helpdesk Jira Tickets',
'Ticket Status'.Value = "closed"
)
& ")"
For closed tickets in the current month:
"(Number of current month's tickets " & CountIf(
'Helpdesk Jira Tickets',
Month(Date) = Month(Today()) && 'Ticket Status'.Value = "closed"
)
& ")"
For closed tickets in the current year:
"(Number of current year's tickets " & CountIf(
'Helpdesk Jira Tickets',
Year(Date) = Year(Today()) && 'Ticket Status'.Value = "closed"
)
& ")"
For closed tickets in January:
"(Number of current year's tickets " & CountIf(
'Helpdesk Jira Tickets',
Month(Date) = 1 && 'Ticket Status'.Value = "closed"
)
& ")"
and so on.
Best regards,