I have created a filter in our JIRA. I understand that a filter can be scheduled through email for any time, but i want to export as excel or .csv file format and schedule this file to some FTP address. Is it doable?
Hi Dave, thanks for responding. Initially we are trying to figure out how we can filter by assignee and by month for a saved filter within a gadget in dashboard. Then i figured out without any plug in, i will not be able to filter by assignee or by month within a single saved filter.
Then my next approach is trying to get an global data search result, export to an excel or csv file and FTPed to some location every month so that our data warehouse or tableau can pick up the excel and massage the data whatever way we want.
Does that make sense? please point me to the right direction if there is other option available to solve my challenge here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For auditing purpose, our finance team needs to see at a high level for each month, each assignee has worked on what tickets. So I created a filter for them to include all tickets in JIRa with specific columns. but i want them to be able to filter by month and by assignee. In the dashboard, creating issue filter gadget does not work since they cannot be filtered within the gadget.
So the alternative approach i'm thinking is to get a data dump from JIRA and auto saved in our Finance shared drive. Once they get the excel, they can filter by themselves.
My last option but not preferred is that save and share the filter and let our finance team to go directly in JIRA to filter by themselves. But is there any way that when they get my link and come in JIRA, my saved columns will also display for them?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I suggest creating an issue filter that pulls the issues Finance wants insight on. Monthly, a Financial analyst can run the issue filter. Teach them how to adjust the filter to pull issues between two specific dates.
This will avoid the piling of data on a fileshare somewhere. If Finance can pull what they need on-demand from Jira - then export the data and massage in their tool of choice - everyone wins.
Long-term: If you want to augment reporting within Jira, consider eazyBI. (Normally I would also recommend Rich Filters for Jira, but that add-on doesn't have a Cloud version yet...)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.