Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Tempo Time Sheet Reports

Nandan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 6, 2020

Good Morning,

I want to extract a monthly report of individual user and export into excel sheet

So when I extract data into excel sheet there is a column called "WORK DATE"

In that column I'm getting a dates like 


Issue Key       Summary       Hours       Work Date
WEB 1               AAA                 2           02-03-2020
WEB 2               BBB                  1          02-03-2020
WEB 3               CCC                  3          02-03-2020
WEB 4               DDD                 4          03-03-2020
WEB 55             DDD                 4          03-03-2020
WEB 44             DDD                 4          03-03-2020
WEB 42             DDD                 4          04-03-2020
WEB 14             DDD                 4          04-03-2020
WEB 40             DDD                 4          04-03-2020



Here I want that "Work Date" column to be like SUM UP,
To get on all the column data in one date

Example:

Issue Key       Summary       Hours       Work Date
WEB 1               AAA                 2           02-03-2020
WEB 2               BBB                  1
WEB 3               CCC                  3

WEB 4               DDD                 4           03-03-2020
WEB 55             DDD                 4           
WEB 44             DDD                 4           

WEB 42             DDD                 4           04-03-2020
WEB 14             DDD                 4           
WEB 40             DDD                 4           

Example which I explained the "Work Date" Format Should Be Only One Date 

So please help me to solve this issue while how to get that example data which I mention above.. And Please let me know is there any option to make "Work Dates" into Sum Up 

Priority : "VERY HIGH"


2 comments

Comment

Log in or Sign up to comment
Alexander Eck [Tempo]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2020

Hi Nandan,

the Tempo export is always a complete data dump and not groupable as such. But you could use any excel application and use the Pivot table functionality to achieve that. 
Other solutions might be offered by third party reporting tools like EazyBI.

Best regards

Navarambh Software - Gmail
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2020

Hi,

This is possible with our app: AIO Reports and Timesheets for Jira

https://marketplace.atlassian.com/apps/1212942/aio-reports-and-timesheets-for-jira?hosting=cloud&tab=overview

Documentation link:

https://aioreports.atlassian.net/wiki/spaces/ART/overview

The app integrates with Tempo timesheets to fetch the data from Tempo for reporting.

For any questions or issues, please email us at support@aioreports.com

Regards

AIO Support

Like # people like this
TAGS
AUG Leaders

Atlassian Community Events