nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Show day of week of Created field in filter

Michael Bevilacqua_pxletf

I've created a filter and want a column returned that displays the Day of Week for the Created field.

Story Type - business

Created - 25/Jul/23

Day Of The Week (Created) - Tuesday <------------- This is the column I want

Screenshot 2023-07-28 at 11.58.03 AM.png

Accepted answers

All comments

Bill Sheboy

Hi @Michael Bevilacqua

That is not possible with the out-of-the-box JQL features.

What problem are you trying to solve by doing this? Knowing that may help the community to offer suggestions. Thanks!

Kind regards,
Bill

Michael Bevilacqua_pxletf

Hey Bill,

Thanks for the thought! I'd like a report showing which day of the week and issue was created. Our team thinks we experience production incidents mostly on Fridays, so I wanted to see if that is the case based on the Day of Week of the issue create date.

Ste Wright

Hi @Michael Bevilacqua

You'll need a field to refer to in search, and to add as a column. You could though...

Add a field to capture the day
Use Automation to populate it.

See how I'd do it below!

---

Custom Field:

You'll need to a Product Admin, and then...

Go to Settings (cog icon in top-right) > Issues
Select Custom Fields from the left-hand menu
Press the "Create custom field" button
Choose a "Select List (single choice)" field, adding the days of the week as options
Give the field a name - eg. Day of Week
Either leave it off the screen, or add it to a view-only version of the screen, as it will only be set via automation

Note: I'd use a shared field even if this is a Team-managed Project, so the field is consistent across all Projects.

---

Automation Rule:

Trigger: Issue Created
Action: Create Variable
- Name = DayOfWeek
- Smart Value = {{issue.created.fullDate}}
Condition: IF Block
- IF...
  - Sub-Condition: Advanced Compare Condition
    - First Value = {{DayOfWeek}}
    - Condition = Contains
    - Second Value = Monday
  - Sub-Action: Edit Issue
    - Field = Day of Week
      - Value = Monday
- ELSE-IF...
  - Sub-Condition: Advanced Compare Condition
    - First Value = {{DayOfWeek}}
    - Condition = Contains
    - Second Value = Tuesday
  - Sub-Action: Edit Issue
    - Field = Day of Week
      - Value = Tuesday
- ELSE-IF...
  - Sub-Condition: Advanced Compare Condition
    - First Value = {{DayOfWeek}}
    - Condition = Contains
    - Second Value =
  - Sub-Action: Edit Issue
    - Field = Day of Week
      - Value = Tuesday
- ELSE-IF...
  - Sub-Condition: Advanced Compare Condition
    - First Value = {{DayOfWeek}}
    - Condition = Contains
    - Second Value = Wednesday
  - Sub-Action: Edit Issue
    - Field = Day of Week
      - Value = Wednesday
- ELSE-IF...
  - Sub-Condition: Advanced Compare Condition
    - First Value = {{DayOfWeek}}
    - Condition = Contains
    - Second Value = Thursday
  - Sub-Action: Edit Issue
    - Field = Day of Week
      - Value = Thursday
- ELSE-IF...
  - Sub-Condition: Advanced Compare Condition
    - First Value = {{DayOfWeek}}
    - Condition = Contains
    - Second Value = Friday
  - Sub-Action: Edit Issue
    - Field = Day of Week
      - Value = Friday
- ELSE-IF...
  - Sub-Condition: Advanced Compare Condition
    - First Value = {{DayOfWeek}}
    - Condition = Contains
    - Second Value = Saturday
  - Sub-Action: Edit Issue
    - Field = Day of Week
      - Value = Saturday
- ELSE-IF...
  - Sub-Condition: Advanced Compare Condition
    - First Value = {{DayOfWeek}}
    - Condition = Contains
    - Second Value = Sunday
  - Sub-Action: Edit Issue
    - Field = Day of Week
      - Value = Sunday

---

A few notes on this approach:

Using IF/ELSE-IF was the most stable method I found to do this, and given there's only 7 possible routes it felt suitable to do it per day.
I used a Select List field, rather than a text field, so it could be used in dashboards, easily used in JQL, etc.
You could set the Day of Week for previously created issues also if you'd like (this will updated the issue's updated date) - to do this...
- Create a Copy of the rule above
- Change the original Trigger to be "Scheduled"
- Check the box "Run a JQL search and execute actions for each issue in the query"
- Put in a suitable JQL query - eg.
  - All Issues - project = ABC
  - All Incidents - project = ABC and issuetype = Incident
  - Just Incidents from 2023 - project = ABC and issuetype = Incident and created >= startOfYear()
- Uncheck the box "Only include issues that have changed since the last time this rule executed"
- Publish the rule and run it
- Once all fields are populated, disable and/or delete the rule. It's only needed once.

---

Let us know if this works for you!

Ste

Bill Sheboy

Thanks for that information, Michael. Is this seems information to support a short-term (and not permanent) investigation, perhaps consider using the advanced search to find all issues for a time range, export them to a spreadsheet, and then perform the analysis there.