Recording Metadata
- System
- Windows
- Version
- 10 (10.0.19045)
- Processor
- Intel64 Family 6 Model 94 Stepping 3, GenuineIntel
- Resolution
1920 x 1080 px
Reasoning Steps
Step 1
Open the Excel file containing the dataset to begin analyzing your data.
Step 2
Click anywhere inside the dataset to ensure Excel recognizes the data range for the Pivot Table.
Step 3
Go to the “Insert” tab in the Excel ribbon and click on “PivotTable” to open the creation dialog.
Step 4
In the PivotTable Fields pane, drag a categorical field (here “Region”) to the Rows area to group
Step 5
Drag another categorical field(here "product") to the columns area to group
Step 6
Drag a numerical field (here "total sales") to the Values area to apply automatic aggregation like SUM or COUNT.
Step 7
Optionally, drag another categorical field (here "Product" and "Date") into the Filters area to break down the summary by filter
Step 8
Analyze the generated Pivot Table to interpret the summarized data and draw insights.
Step 9
Stop the screen recording once the summary is complete.
Step 10
The recording will be saved automatically to Documents > DuckTrack Recordings on your local machine. Open the Paradigm Shift AI portal in the browser, locate and click the “Select video file” button, and it will prompt to the file manager pop up Navigate to the 'DuckTrack Recordings' folder, select the relevant screen recording file, and confirm the upload to associate it with the task.
Video
Loading tracking data...