How does the 'Quote Score' dashboard work?
General Function
In the Quote Score dashboard, a scoring analysis is made based on the sales quotes. At a glance, you get all quote values per relationship or per salesperson, divided into 'Order' and 'No Order'.
Target Group
- Salespeople
Where in MKG?
- Open the module Sales Dashboard.
- If the dashboard is not displayed immediately: click the hamburger in the top right corner of the button bar and select the option 'Forms' » 'Dashboard'.
- Click the Views button and select Sales Quote Scoring Analysis (8011).
Main Components
- A division between order and no order.
- A monthly graph with both results, score percentage, and trend line.
- Relationship and salesperson tables with total, order, no order, score, and share in obtained orders.
- An overview of rejection reasons with value and share.
- A period choice, a choice for the score basis, and filters for sales group, year, quarter, and month.
Display and Use
You choose a period based on the date when the quote line became historical. Option lines are excluded. The score can be calculated based on total prices, quantities, or number of lines. By default, the dashboard uses total prices.
The score is the share with order result within the selected total. With a basis of 0, the score becomes 0. You can select multiple filter values, relationships, salespeople, or rejection reasons to limit the linked analyses.
|
Please note! |
Technical Explanation
Data Sources
- Primary data source:
dashboard_vofr. - Indirectly consulted data sources: Sales Quotes (
vofh), Salespeople (verk), and Relations (rela).
Selection and Interaction
The source filter limits vofr_dat_historisch with DateFrom and DateTo and requires vofr_is_optie = false. The parameter ScoreType offers values 1, 2, and 3 and is set to 1 by default.
The stored values are January 1, 2025, for DateFrom and December 31, 0001, for DateTo. These do not form an ascending period and must be adjusted for a usable selection.
The relationship, salesperson, and rejection reason tables support multiple filter selection. The rejection reason overview selects only lines for which Result = false. The monthly graph groups Date by month and year and includes regression line indicator1 with display name "Trend".
Calculated Fields
Result description: describes the result of the quote line.
Calculation: gives ‘{Order}’ whenResult= true; otherwise ‘{No Order}’.Seller: provides the salesperson name for the salesperson analysis.
Calculation: gives ‘{- No salesperson}’ whenvofh_num.verk_num.verk_naamis an empty string; otherwise, this name is adopted.Reason rejected<: provides the rejection reason or a substitute designation.
Calculation: gives ‘{- Not rejected}’ atvfst_status= 30. Otherwise, at 0 int_vofr_vfra, ‘{- No reason}’ is shown, and in other cases,_desc_t_vofr_vfra.Sales quote: combines quote and line number.
Calculation: combinesvofh_numandvofr_numwith a space and slash in between.DateFrom: provides the start date for the period indication.
Calculation: adoptsParameters.DateFrom.DateTo: provides the end date for the period indication.
Calculation: adoptsParameters.DateTo.Relation: makes the relation recognizable in the relation overview.
Calculation: combinesvofh_num.rela_num.rela_naamwithvofh_num.rela_numin parentheses.MKGDataDashboardTitle: provides an empty text value.
Calculation: returns an empty string.Result: determines whether the line counts as an order.
Calculation: gives true whenvfst_status= 30; otherwise false.Value order: provides the score value for obtained orders.
Calculation: givesValuewhenResult= true; otherwise 0.Value no order
Provides the score value for lines without an order.
Calculation: givesValuewhenResult= false; otherwise 0.Value: determines the contribution of each line according to the chosen score basis.
Calculation: usesvofr_totaalprijs_avatParameters.ScoreType= 1,vofr_order_aantalat 2, and the value 1 at 3. Other values give a missing value.ScoreType: describes the chosen score basis.
Calculation: translatesParameters.ScoreType1 to ‘{prices}’, 2 to ‘{quantities}’, and 3 to ‘{lines}’. Other values give a missing value.Date: provides the date for time analyses.
Calculation: adoptsvofr_dat_historisch.Score %: determines the share that led to an order.
Calculation: divides the sum ofValue orderby the sum ofValue. If the total is 0, 0 is returned.
Additional Percentage Calculations
The relationship and salesperson tables calculate for the column % of 'Order' the share of Value order in the respective table total. This is a different measure than Score %.
The column % of 'No Order' in the rejection reasons overview calculates the share of vofr_totaalprijs_av per reason. The 'No Order' column, on the other hand, uses Value and thus follows the chosen score basis.
Result description, Sales quote, and MKGDataDashboardTitle are not linked to visible dashboard components.
Add to 'My Dashboards'
Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homepage. In this way, you create your own cockpit from the data in your database. How to add dashboards can be read in How to set up 'My Dashboards'
- Published:6 Nov 2026 11:49
- Latest update:6 Nov 2026 12:49
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar