| Columns
|
Calculation
|
Description
|
| 1. Total Revenue
|
|
|
| 2. Total Bookings(Confirmed)
|
|
|
| 3. Total Direct Bookings(Confirmed)
|
|
|
| 4. Total Converted Booking(Confirmed)
|
|
|
| 5. Total Chargeable Weight
|
|
|
| 6. Top Customers By Revenue
|
Aggregates total revenue from confirmed bookings and groups it by customer to compare side by side in a clustered bar chart and with specific currency used for each.
|
This chart displays the highest revenue-generating customers, showing amounts in their respective currencies.
|
| 7. Top Bookings (Confirmed) by Origin
|
Counts only confirmed bookings (converted quotes that have been finalized as bookings), then groups them by origin to compare side by side in a clustered bar chart.
|
This chart shows the total confirmed bookings for each origin location, making it easy to identify which origins generate the highest booking volumes and highlight performance differences across locations.
|
| 8. Top Bookings(Confirmed) by Destination
|
Counts only confirmed bookings (converted quotes that have been finalized as bookings), then groups them by destination to compare side by side in a clustered bar chart.
|
This chart shows the total confirmed bookings for each destination location, making it easy to identify which destinations receive the highest booking volumes and highlight performance differences across locations.
|
| 9. Top Bookings by Service
|
Counts only confirmed bookings and groups them by service type to compare in a clustered bar chart.
|
This chart highlights the total confirmed bookings for each service type, making it easy to see which services are most in demand and where performance differences exist across offerings.
|
| 10. Bookings by Weight Breaks Matrix Table
|
|
|
| 11.Conversion Rate by Month
|
Calculates the percentage of quotes converted into confirmed bookings for each month, grouping results over time to show conversion trends.
|
This chart highlights how effectively quotes are turning into bookings month by month.
|
| 12. Total Monthly Revenue
|
Aggregates total revenue from confirmed bookings and groups it by month to show revenue trends over time, plus the respective currencies.
|
This chart provides a clear view of monthly revenue performance, showing amounts in their original currencies.
|
| 13. Total Chargeable Weight by Customer
|
Aggregates the total chargeable weight and groups it by customer to compare side by side in a clustered bar chart.
|
This chart displays the total chargeable weight attributed to each customer.
|
