Back to Use Cases
CREATE_CHART

Stamping Fleet Production Adherence

Use Template
Stamping Fleet Production Adherence

Description

Monitor daily actual output versus operational targets to visualize performance gaps and guide resource allocation decisions.

Input Settings

Action: chartDeep Think: falseWeb Search: Disable

Recommended Prompt

Create a Single Area Chart in English for 'Stamping_Press' production trends. Data Logic: Source: Join fact_production_hourly with dim_machines. Filter: ModelType = 'Stamping_Press'. Aggregate: Sum ActualOutput and TargetOutput by Date. Visual Styling: Series 1 (Target): TargetOutput as a Bold Dashed Line (Dark Grey). Series 2 (Actual): ActualOutput as a Filled Area (Emerald Green, 50% opacity). Layering: Target Line on top of Actual Area. Specific Fixes (CRITICAL): Legend Layout: Ensure the legend icons match the series style exactly. The icon for 'Target Output' must be a pure dashed line segment. Do NOT overlay any circular markers or dots on the legend line. The icon for 'Actual Output' must be a solid color block or a clean line. X-Axis: Maintain the previous fix: Display a date label ONLY every 5 days to ensure zero overlap. Remove the axis title 'Date'. Goal: A clean chart where the legend clearly shows a dashed line vs. a filled area without obstructing markers.

Sample Datasets

dim_machines.csv

815 B

dim_products.csv

243 B

fact_defects.csv

176.45 KB

fact_energy.csv

255.79 KB

fact_production_hourly.csv

430.86 KB