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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

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
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you