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!