Task #16739
openTask #18713: Sprint Planning for 08/09/2025 - 19/09/2025
Dashboard for Salesperson or Operations
100%
Description
Sales Dashboard
This dashboard loads when a user with 'sales' authority logs in. This typically refers to sales or operations officers who create File References, House BLs and Quotations.
Data Visibility: Each user sees only their own data.
The general filters defined in 1 above apply.
The default time span selected will be 'this month'.
Apply predictive analysis where applicable—normally this applies to charts (e.g., forecast next month’s sales based on historical patterns).
All reports should be able to filter by the following where applicable:
- Transport Mode: Ocean / Air (multi-select)
- Shipment Type: Import/Export (multi-select)
- Client(s) (multi-select search)
- Vessel (search)
- Custom Date Range (ETA)
- Custom Date Range (ETD)
Note: Default filter selection = Current Month (based on ETA).
My Sales
The user needs to see:
KPIs: (Default: Current Month—split by Import/Export)
- Total Quotations – Total HBLs
- Total Sales (MUR)—with Import/Export breakdown (e.g., “Import: 5.2M | Export: 3.8M”).
- Total Shipments—with Import/Export count (e.g., “Import: 120 | Export: 85”).
- Total Cost (MUR)
- Total Profit (MUR)
- Gross Profit Margin (%) - (Total Profit ÷ Total Sales) × 100.
- Sales Target vs Actual (%—shown separately for Import and Export
Charts:¶
- Bar/Column Chart: Cost vs Sales for all BLs within the selected period (default: this month)—split Import/Export.
- Stacked Bar or Pie: Import vs. Export Split showing shipment count and sales value.
- Trend Line Chart: Sales trend over time (e.g., weekly or monthly)—includes forecast line.
- Pareto Chart (80/20)—Identify which clients contribute the majority of sales.
- Pie/Bar Chart—showing % sales by service type (Freight, Clearing, Transport, et
Tables:
House BL Table:
- Shipment Type (Import/Export)
- BL Ref
- Status of BL
- File Reference containing the BL
- File Ref Status
- Cost Amount (per House BL) - MUR
- Sales Amount (per House BL) - MUR
- Profit- MUR
- Vessel Schedule (Date & Vessel Name)
- Client Name
File Reference Table:
- Shipment Type (Import/Export)
- Total Number of BLs
- File Ref Status
- Total Cost (per File Reference) - MUR
- Total Sales (per File Reference) - MUR
- Total Profit- MUR
- Vessel Schedule (Date & Vessel Name)
- Client Name
My Clients
Charts:
- Pie Chart: New vs. Existing Clients.
- Bar Chart: Most Active vs. Least Active Clients (number of shipments).
- Horizontal Bar Chart: Top 10 Clients—drill down to shipment details.
Tables:
Client list with:¶
- Client Name
- Status (New / Existing)
- Label—blacklisted, etc.
- How many days inactive?
- Total Shipments
- Total Sales Value
- Last Shipment Date
- Average Sales Value per Shipment
3. My Quotations
Charts:
- Stacked Bar Chart: Quotations by Status (Requested, Approved, Cancelled, etc..).
- Win/Loss Ratio Chart – % of quotations converted to confirmed bookings.
Tables:
- Quotation Ref.
- Client Name
- Status
- Date Created
- Requested Service – Freight, Clearing, transport, etc.
- Quotation Validity Date – Last Date for Validity -expiry….
- Converted to BL? (Yes/No)
- Ageing Days (e.g., "Waiting for Supervisor Approval" for X days)
- Quotation Total Charges
GitLab Sync Log
[{"id": "27639", "author": "Avisham", "hours": 2.0, "created": "2025-08-04T09:15:08.508Z", "log_date": "2025-08-03", "comment": "Imported from GitLab by @Avisham on 2025-08-04T09:15:08.508Z: 2h-(2.0)h spend at: 2025-08-03", "status": "active", "deleted_by": "", "redmine_entry_id": 10028}, {"id": "29992", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-09-01T05:18:16.288Z", "log_date": "2025-08-26", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-01T05:18:16.288Z: 1d-(8.0)h spend at: 2025-08-26", "status": "active", "deleted_by": "", "redmine_entry_id": 10140}, {"id": "28666", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-08-25T09:26:26.162Z", "log_date": "2025-08-20", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-08-25T09:26:26.162Z: 1d-(8.0)h spend at: 2025-08-20", "status": "active", "deleted_by": "", "redmine_entry_id": 10141}, {"id": "28665", "author": "Ra-ees Peeroo", "hours": 6.0, "created": "2025-08-25T09:26:13.444Z", "log_date": "2025-08-21", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-08-25T09:26:13.444Z: 6h-(6.0)h spend at: 2025-08-21", "status": "active", "deleted_by": "", "redmine_entry_id": 10142}, {"id": "30158", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-09-04T10:45:30.470Z", "log_date": "2025-08-31", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-04T10:45:30.470Z: 1d-(8.0)h spend at: 2025-08-31", "status": "active", "deleted_by": "", "redmine_entry_id": 10269}, {"id": "30157", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-09-04T10:45:11.465Z", "log_date": "2025-09-01", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-04T10:45:11.465Z: 1d-(8.0)h spend at: 2025-09-01", "status": "active", "deleted_by": "", "redmine_entry_id": 10270}, {"id": "30156", "author": "Ra-ees Peeroo", "hours": 6.0, "created": "2025-09-04T10:45:00.212Z", "log_date": "2025-09-03", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-04T10:45:00.212Z: 6h-(6.0)h spend at: 2025-09-03", "status": "active", "deleted_by": "", "redmine_entry_id": 10271}, {"id": "30155", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-09-04T10:44:52.447Z", "log_date": "2025-09-02", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-04T10:44:52.447Z: 1d-(8.0)h spend at: 2025-09-02", "status": "active", "deleted_by": "", "redmine_entry_id": 10272}, {"id": "30179", "author": "Al-Shad Isaac", "hours": 5.0, "created": "2025-09-04T11:50:10.750Z", "log_date": "2025-09-04", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-09-04T11:50:10.750Z: 5h-(5.0)h spend at: 2025-09-04", "status": "active", "deleted_by": "", "redmine_entry_id": 10277}, {"id": "31173", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-09-30T09:57:57.132Z", "log_date": "2025-09-28", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-30T09:57:57.132Z: 1d-(8.0)h spend at: 2025-09-28", "status": "active", "deleted_by": "", "redmine_entry_id": 10459}, {"id": "31484", "author": "Waliyuddin Delba", "hours": 8.0, "created": "2025-10-06T06:52:26.345Z", "log_date": "2025-09-29", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-06T06:52:26.345Z: 1d-(8.0)h spend at: 2025-09-29", "status": "active", "deleted_by": "", "redmine_entry_id": 10602}, {"id": "31483", "author": "Waliyuddin Delba", "hours": 8.0, "created": "2025-10-06T06:51:32.873Z", "log_date": "2025-09-28", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-06T06:51:32.873Z: 1d-(8.0)h spend at: 2025-09-28", "status": "active", "deleted_by": "", "redmine_entry_id": 10603}]
Updated by Redmine Admin 6 months ago
- gitlab project trace deleted (
Ocean Sprint Planning for 19/05/2025 - 30/05/2025)
Updated by Redmine Admin 4 months ago
- Parent task changed from #16323 to #18549
- GitLab Time Logged changed from 0 to 7200
- gitlab project trace set to Ocean Sprint Planning for 28/07/2025 - 08/08/2025
Updated by Redmine Admin 3 months ago
- Subject changed from Dashboard per Role to Dashboard for Salesperson or Operations
- Description updated (diff)
- Due date changed from 02/04/2025 to 09/05/2025
- % Done changed from 0 to 60
- Estimated time changed from 0:00 h to 40:00 h
- Parent task changed from #18549 to #18634
- GitLab Time Logged changed from 7200 to 86400
- gitlab project trace changed from Ocean Sprint Planning for 28/07/2025 - 08/08/2025 to Sprint Planning for 25/08/2025 - 05/09/2025
Updated by Redmine Admin 3 months ago
- GitLab Time Logged changed from 86400 to 194400
- Status changed from New to Development Done
- % Done changed from 60 to 100
Updated by Redmine Admin 3 months ago
- GitLab Time Logged changed from 194400 to 212400
Updated by Redmine Admin 3 months ago
- Status changed from Development Done to New
Updated by Redmine Admin 3 months ago
- Due date changed from 09/05/2025 to 09/19/2025
- Parent task changed from #18634 to #18713
- gitlab project trace changed from Sprint Planning for 25/08/2025 - 05/09/2025 to Sprint Planning for 08/09/2025 - 19/09/2025
Updated by Redmine Admin 3 months ago
- Status changed from New to Development Done
Updated by Redmine Admin 3 months ago
- Status changed from Development Done to New
Updated by Redmine Admin 2 months ago
- Status changed from New to Development Done
- GitLab Time Logged changed from 212400 to 241200
Updated by Redmine Admin 2 months ago
- Status changed from Development Done to QA
Updated by Redmine Admin 2 months ago
- GitLab Time Logged changed from 241200 to 298800