/
Displaying Days Instead of Hours in a Pivot Table

Displaying Days Instead of Hours in a Pivot Table

πŸ“ Context: Creating a custom format in the Time in Status app allows you to tailor the presentation of your data to better suit your needs. This guide provides step-by-step instructions to create a custom format that will appear in the β€œFormat cells” field.

πŸ“ Context: Creating a custom format in the Time in Status app allows you to tailor the presentation of your data to better suit your needs. This guide provides step-by-step instructions to create a custom format that will appear in the β€œFormat cells” field.

πŸ€” User Problem: Users need a way to create custom formats for their reports to better visualize and analyze the data. They want to format cells to display specific calculated values, such as the sum of time in hours.

πŸ€” User Problem: Users need a way to create custom formats for their reports to better visualize and analyze the data. They want to format cells to display specific calculated values, such as the sum of time in hours.

Here are a few steps on how you can create a custom format (which will appear in the β€œ Format cells” field):

  1. Tap on the β€œFields” field.

image-20240828-081120.png

Β 

2. Then tap on the β€œCalculated value” field and choose Time (hours) (Sum) from a drop-down list.

image-20240828-081537.png

πŸ“ˆ Outcomes:

  • Customizable Reports: Tailor reports to specific needs by creating custom formats.

  • Enhanced Visualization: Improve the presentation of data to make it more understandable and actionable.

  • Better Analysis: Use custom formats to gain deeper insights into your data.

πŸ“ˆ Outcomes:

  • Customizable Reports: Tailor reports to specific needs by creating custom formats.

  • Enhanced Visualization: Improve the presentation of data to make it more understandable and actionable.

  • Better Analysis: Use custom formats to gain deeper insights into your data.

If you need help or want to ask questions, please contactΒ SaaSJet SupportΒ or email us atΒ support@saasjet.atlassian.net

Haven't used this add-on yet?Β Try it now!

Related content

Current Week's Time in Status Report
Current Week's Time in Status Report
Read with this
Time and Story Points Estimation Using Pivot Table
Time and Story Points Estimation Using Pivot Table
Read with this
Tracking Spent Time in Each Issue Field
Tracking Spent Time in Each Issue Field
Read with this
Generating a Status Count Report with the Pivot Table
Generating a Status Count Report with the Pivot Table
Read with this
Understanding Business Decimal Days Calculation
Understanding Business Decimal Days Calculation
Read with this
Getting Time in Status Data by Epics
Getting Time in Status Data by Epics
Read with this