SMAX Open Jobs Report
$750-1500 AUD
Paid on delivery
SGESCO-Max requires a PowerBI report to interpret the Open Jobs data – which is in the form of a CSV file.
The report needs to display data by:
• Cost Centre
• Customer Name
• Date Required
• Job Status
The Sell Price will be the core metric by customer (horizontal bar graph sorted by highest value to least).
The data selection needs to include:
• A date slider
• Month buttons
• Cost code buttons (multiple can be selected – see below)
• Job status buttons (multiple can be selected – see below)
• When clicking on a Customer Name (which gives the total) – Job No. with the Work Required will be displayed in a table/view)
Cost Centre Groupings Buttons:
External = 00-09, 10-19, 20-29, 30-39, 40-49, 60-69
Internal = 70-79, 80-89, 90-99
Inter-Company = 50-59
Job Status Buttons:
55xx =
66xx =
77xx = Needs Authorisation
88xx = Ready to Invoice
Project ID: #29451837
About the project
Awarded to:
Hi, Greetings! ✅checked your project details : SMAX Open Jobs Report Attachments [login to view URL] SMAX PowerBI - Open Jobs Example [login to view URL] PowerBI Report - Open [login to view URL] ✅Completed Time : 24 hours or your More