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!