Dashboard control value to filter by the previous hour, day or week

[Jes Kampman]

I want to create a Dashboard control dropdown where the user can select from Hour, Day or Week.   

That selection should then be used to filter the data to be data from the last Hour, Day or Month.

Let's say the Control is called TimePeriod, then the WHERE clause would say something like 

WHERE resolution_at > {TimePeriod}

In reality I want to filter to the previous Calendar month - the SQL would be slightly more complex but the idea is the same.   I could not get Atlassian Analytics to use the Control to accept the variable name as I tried to above.

Is what I am trying to do even possible?   Thanks in advance.

[David Nickell]

I can't speak for Atlassian Analytics, but

"Boards" (Kanban/Scrum) support the concept of Quick Filters that add on to your filter's jql.  in yur example you woould create 3 -- hour, day, month 

Traditional Dashboards used to have a control gadget (I think) but at a glance I don't see anything like that available.

You could also create three filters and if you're worried about repeating the main logic 3x and keep it updated, your three filters could use this type of  JQL :

1. filter=10145 and updatedDate >=-1h
2. filter=10145 and updatedDate >=-1d
3. filter=10145 and updatedDate >=-30d

Assuming 10145 has your core logic

Hope this helps

[Rodney Dsouza _Atlassian Certified Expert_]

Thanks David but I need it in a visual chart since this is reporting that gets presented to management.   

I don't think regular/traditional Jira Dashboards have control gadgets, maybe some plugins do. 

We don't have any reporting plugins, but do have Atlassian Analytics and so looking for an answer in that feature.   Atlassian Analytics do have controls and so I was looking for some kind of 'trick' that could work for my use-case.

Thanks.