How to Set Data Field Style in Insights

Data field styles allow you to create custom labels and apply formatting to specific field types, making your reports more readable and tailored to your needs.

Getting Started

To begin, create a new report or edit an existing one. If you haven't added any data fields yet, add a few to serve as data points.

Next, expand the Table Fields or Group Fields section and navigate to the Style tab. Here, you'll find two key options:

• Column Label – Customize the header text for the field.
• Format – Adjust how the data is displayed.

For this example, we'll modify the Check-in Date/Time field.

Updating Column Labels

Let’s start by changing the column header. In the Column Label field, enter "Arrival Time", click Apply, and run your report.

Your report will now display "Arrival Time" as the column header instead of "Check-in Time".

Formatting Date and Time

By default, the Check-in Date/Time field will appear in the following format:
Thu, 06 Mar 2025 09:49:22 AM

If you prefer a simpler format—showing just the month, day, and time—you can customize it. In the Format field, enter:
MMM dd, HH:mm

Click Apply, run your report, and the time will now display as:
Mar 06, 09:49

Additional Formatting Options

You can also use different formats to match your preferred date style:

• MM/dd/yyyy – Standard U.S. format (e.g., 11/20/2023).
• dd/MM/yyyy – European format (e.g., 20/11/2023).
• MM/dd/yyyy HH:mm – U.S. format with time (e.g., 11/20/2023 09:44).
• dd/MM/yyyy HH:mm – European format with time (e.g., 20/11/2023 09:44).
• yyyy-MM-dd – ISO format (e.g., 2023-11-20).
• dd-MM-yyyy – Alternative format used in various regions (e.g., 20-11-2023).

Exporting Reports

All customized labels and formatting styles will automatically apply to exported reports. If you need help exporting, refer to this guide: How to export an Insights report?

If you still have any questions, please feel free to get in touch with our Qtrac Help Desk.