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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,466,614
Community Members
 
Community Events
176
Community Groups

Tempo Time Sheet Reports

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

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

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

Comment

Log in or Sign up to comment