Worklog Report - Several questions for new user

[jeffboon97]

Dear @shridhar-tl good day to you, I have only recently started using your amazing application to generate useful reports for my management. However I am currently stucked and not able to meet some requirements set by my managements. May need your help to clarify if the following is possible to be achieved?

Question 1 - Is it possible to expand the tickets logged by user by default?
Reason - Because when I export the CSV report, the tickets summary is not shown in the CSV report. This is useful as management would like to know where did the developer logged their time spent.

Question 2 - Is it possible to show the timeline from the ticket creation date itself?
Reason - As of now, I am only able to filter the date range manually and it is difficult for management to know when was the ticket created

Question 3 - Is it possible to show log time comment column?
Reason - This is important for management to understand why developer spent certain hours or min completing the tasks given.

Question 4 - When export into CSV/Excel, is it possible to grey out holidays or weekend?

Thank you for your time in reading this, appreciate the time spent developing this tool!

[shridhar-tl]

Hi @jeffboon97 , Thank you for contacting me and here are my answers:

Question 1 - Is it possible to expand the tickets logged by user by default?
Answer: Yes it is possible now. In Worklog report, Click on show settings icon from top right corner of the page, then switch to "Formatting" tab and then click "Show more options" and you will see a checkbox added at the end. Selecting this would by default expand all the users when you generate a report.

Question 2 - Is it possible to show the timeline from the ticket creation date itself?
Answer: Yes is it possible now. Select "Issue Age" field from "Fields list" tab of report configurations and you should have it.

Question 3 - Is it possible to show log time comment column?
Answer: Yes, it is already part of Flat (Groupable) tab of worklog report. But if you are expecting it to be part of "Grouped - [User daywise]" tab then it is not feasible as single row contains worklog for multiple days and so having multiple comments is practically not possible. Any way, as it is available in Flat groupable report, you should be able to export it to excel and share it.

Question 4 - When export into CSV/Excel, is it possible to grey out holidays or weekend?
Answer: CSV is a text file. So it cannot have any formatting. However when it comes to Excel export, I can try it. Will try it and see if I could get something. But it would take couple of more weeks as I am quiet busy at this point for implement this.

Point 1 & 2 is a new implementation and is already available in web version of extension. You can switch to web seamlessly and you should be able to use this feature until it is published to extension in JA v2.49. Once your extension version gets updated to v2.49, you should see it working in extension as well.

[jeffboon97]

Good day to you @shridhar-tl ,

I have a few questions after testing out with the worklog report generation, hopefully you can answer.

Q1 - As referring image below, I notice that there's no sorting option available in JA, Therefore when generating the report into Excel. I wasn't able to display the report in chronological order. Wondering is there a way we can sort by worklog created date?

[jeffboon97]

Basically we are able to see a progressive view of the worklog, sort of like a Gantt Chart.

Thanks for your swift reply as always!

[shridhar-tl]

Apologies, unfortunately this image does not fully make sense to me. I am still trying to understand how it would work on different scenarios.

Towards left you have multiple issues. Each row representing single issue. So obviously I can show data of individual stories in single row only.

While that being said, this image means to me that for individual issues worklog is added only on consecutive days. If that is the case should be able to sort it based on worklog date.

But what if, for same issue, worklog is added on 1st day of month, then on 15th of month and then on 28th of month. What if worklog is added randomly on various day of month and this happens on multiple issues? I am not sure if such a case can happen, but just trying to understand.

[jeffboon97]

Dear @shridhar-tl , I should have given you some context. The info on the left is actually the worklog author, As we are generating worklog for a single project we know who is the worklog author's role and we want to identify the gaps in between worklog entries. As you can see below, There's a huge gap between 13 to 16 Feb and 20 to 23.

So my intention was to make the report more pretty in terms of visualization, so we can see the flow from 1 date to another date.

Once we can clear see the gap, then we will drill down to Flat (Groupable) to identify the time logged date, and check with each party why was there a delay in between worklog entries.

I hope you understand my explanation, thank you!

[jeffboon97]

Also Dear @shridhar-tl for your information, I wasn't able to contribute donation to you via PayPal.

[shridhar-tl]

@jeffboon97 - I have done the ordering based on first worklog date for each user and same with tickets as well. Now both user and tickets both would be sorted based on first worklog date. Hope that solves your issue.

This change would be published to extension users as part of JA v2.51. However it is already available in Web for you to try as of now. If you are an extension user, you can easily switch to Web version and use the latest version of tool always.

[jeffboon97]

Good day to you @shridhar-tl,

I am writing to you today to follow up on our recent conversation about the Worklog report. My team is generally satisfied with the report, but we have a few suggestions that we would like to share.

Currently, the Worklog report is sorted by worklog date and categorized into each worklog author

With that said we have few suggestions below:

1. We would like to request that the report be sorted by ticket and logged time instead. This would make it easier for us to track the time that each team member is spending on each ticket.

Meaning we are able to know per record basis who logged time and logged under which ticket and the issue type. We can form a Gantt Chart easily without exporting the data.

2. Additionally is it possible to add Issue Type to Report?

Sample report

Thank you for your time reading this and I hope you can understand what I am explaining.

Furthermore, please do let me know how can I contribute to you to make this changes possible.

Thank you for your time and consideration.

[jeffboon97]

Dear @shridhar-tl good day to you!

I hope this message finds you well. I am reaching out to understand from you if my enquiries above is feasible? I understand that you are likely busy, your response is much appreciated.

Thank you!

[shridhar-tl]

Hi @jeffboon97 - Have you tried this use case in Web version?

Your request regarding sorting has been implemented 3 weeks back upon your first clarification and I assumed I already responded to this message. But just realized, I did not.

As of now its available only in Web Version. You can have a look at it just by launching the Web version once and see if it works as you expect. If it does work, then I can publish it to extension.

By the way, you can directly use web version without providing any credentials. Web version will work with extension to display the data and it is just like a beta version for extension which contains latest changes always.

[jeffboon97]

Dear @shridhar-tl good day to you, may I know was you able to look into the issue and suggestion mentioned above? Thanks in advance!

[shridhar-tl]

Hi @jeffboon97, Was on a busy week and so far I haven't got a chance to look into it. However I have planned to look into it tomorrow and will try to publish it to web by tomorrow.

[shridhar-tl]

Hi @jeffboon97, enable the following configuration under "Formatting" tab and you should see it working.

Please verify if data is displayed appropriately and let me know, so that I will publish it to extension. I cannot frequently publish the changes to extension as it is a huge effort and so I would like to suggest you to check it well for all your use case. In case of any changes later, it would take more time to publish another version for extension.

[shridhar-tl]

Hi @jeffboon97 - Did you get a chance to have a look at the changes?

[jeffboon97]

Good day to you @shridhar-tl , yes I've given the new changes a look and the changes suits our needs for now. Thank you for your time and effort, I will proceed to close this discussion for now. :)

[shridhar-tl]

@jeffboon97 - If there are no issues in this functionality, please close this discussion and you can start a new discussion for anything not related to this.

In future in case of any feature suggestion or bugs, please use the issues tab instead. Only for questions or other discussions, use discussions tab as there are some technical limitations in using discussions tab for some of my internal use cases with committing code.

Thank you and good day