| Reference
|
Calculation
|
Description
|
|
|
| 1. |
|
The Clustered bar chart breaks down the prequote by Month.
|
|
|
| 2. |
|
The table breaks down Total pre quotes, Deleted Incorrect Pre quotes and Accuracy.
|
|
|
| 3. |
|
The table breaks down pre quotes created over Time by Mailbox
|
|
|
| 4. |
|
The table breaks down Delete Reasons by total deleted pre quotes
|
|
|
| 5.
Total Pre quotes
|
Formula:
Total Prequotes = CALCULATE( COUNTROWS(quotations), USERELATIONSHIP(DimDate[Date], quotations[pre_quoted_at]), NOT(ISBLANK(quotations[pre_quoted_at])) ) + 0
|
- Counts the number of prequotes: It counts the rows in the quotations table where the pre_quoted_at column is not blank, indicating a valid prequote.
- Uses the date relationship: It activates the relationship between the DimDate[Date] column and the quotations[pre_quoted_at] column, ensuring that the data is filtered by the selected time range.
- Ensures the measure returns a numeric value: The + 0 ensures that the measure doesn't return a blank value when there are no matching records.
Purpose
This measure helps track the total number of prequotes within a specific date range, providing insights into the total number of prequotes made.
|
|
|
| 6. Lost Pre quotes |
Formula:
Total Lost Prequotes = CALCULATE( COUNTROWS(quotations), USERELATIONSHIP(DimDate[Date], quotations[pre_quoted_at]), NOT(ISBLANK(quotations[pre_quoted_at])), NOT(ISBLANK(quotations[lost_at])) ) + 0
|
- Counts the number of lost prequotes: It counts the rows in the quotations table where the pre_quoted_at column is not blank (indicating a valid prequote), and the lost_at column is not blank, indicating that the prequote has been lost.
- Uses the date relationship: It activates the relationship between the DimDate[Date] column and the quotations[pre_quoted_at] column, ensuring that the data is filtered by the selected time range.
- Ensures the measure returns a numeric value: The + 0 ensures that the measure doesn't return a blank value when there are no matching records.
Purpose
This measure helps track the total number of lost prequotes within a specific date range.
|
|
|
| 7.Deleted pre quotes |
Formula:
Total Deleted Prequotes = CALCULATE( COUNTROWS(quotations), USERELATIONSHIP(DimDate[Date], quotations[pre_quoted_at]), NOT(ISBLANK(quotations[pre_quoted_at])), NOT(ISBLANK(quotations[deleted_at])) ) + 0
|
- Counts the number of deleted prequotes: It counts the rows in the quotations table where the pre_quoted_at column is not blank (indicating a valid prequote), and the deleted_at column is not blank, indicating that the prequote has been deleted.
- Uses the date relationship: It activates the relationship between the DimDate[Date] column and the quotations[pre_quoted_at] column, ensuring that the data is filtered by the selected time range.
- Ensures the measure returns a numeric value: The + 0 ensures that the measure doesn't return a blank value when there are no matching records.
Purpose
This measure helps track the total number of deleted prequotes within a specific date range, providing insights into the volume of prequotes that were removed
|
|
|
| 8.Pre quote to bookings |
Total Pre-quote to Converted =
CALCULATE(
COUNTROWS(quotations),
quotations[Booking_categories] = "Pre-quote to Booking"
) + 0
|
- Counts the number of prequotes converted to bookings: It counts the rows in the quotations table where the Booking_categories column equals "Pre-quote to Booking," indicating that the prequote has been successfully converted into a booking.
- Ensures the measure returns a numeric value: The + 0 ensures that the measure doesn't return a blank value when there are no matching records.
Purpose
This measure helps track the total number of prequotes that have successfully been converted into bookings, providing insights into the conversion rate of prequotes to actual bookings.
|
|
|
| 9. Incorrect prequote |
Formula:
Total Prequotes with IQ = CALCULATE( COUNTROWS(quotations), USERELATIONSHIP(DimDate[Date], quotations[pre_quoted_at]), NOT(ISBLANK(quotations[pre_quoted_at])), quotations[delete_reasons] = "IQ" )
|
- counts prequotes with "IQ" delete reason: It counts the rows in the quotations table where the pre_quoted_at column is not blank (indicating a valid prequote), and the delete_reasons column equals "IQ," indicating that the prequote was deleted due to an incorrect quotation.
- Uses the date relationship: It activates the relationship between the DimDate[Date] column and the quotations[pre_quoted_at] column, ensuring that the data is filtered by the selected time range.
Purpose
This measure helps track the total number of prequotes with the "IQ" delete reason, providing insights into the volume of prequotes that were deleted due to IQ-related issues.
|
|
|
| 10.Prequote conversion
|
Formula:
Prequote Conversion =
DIVIDE([Total Pre-quote to Converted], [Total Prequotes])
|
- Total Pre-quote to Converted: This represents the number of prequotes that were converted to bookings.
- Total Prequotes: This is the total number of prequotes made.
- DIVIDE function: It divides the number of converted prequotes by the total prequotes to calculate the conversion rate. The DIVIDE function ensures that any division by zero returns a blank result instead of an error.
Purpose
This measure helps track the conversion rate of prequotes to bookings, providing insights into how many prequotes are successfully turned into actual bookings.
|
