0
0
Figmabi_tool~15 mins

Version history in Figma - Real Business Scenario

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
👤 Your Role: You are a product designer working with a team on a new app interface.
📋 Request: Your manager wants you to track and analyze the version history of design files to understand changes over time and identify who made key updates.
📊 Data: You have access to version history data from Figma showing file versions, timestamps, editor names, and brief change descriptions.
🎯 Deliverable: Create a report that summarizes the number of versions per day, highlights the most active editors, and shows a timeline of changes.
Progress0 / 5 steps
Sample Data
Version IDTimestampEditorChange Description
v12024-06-01 09:15AliceInitial wireframe created
v22024-06-01 14:30BobAdded color scheme
v32024-06-02 10:00AliceUpdated button styles
v42024-06-02 16:45CharlieFixed layout issues
v52024-06-03 11:20BobAdded icons
v62024-06-03 15:00AliceRefined typography
v72024-06-04 09:50CharlieImproved navigation flow
v82024-06-04 13:30BobUpdated footer design
1
Step 1: Extract the date from the Timestamp column to group versions by day.
Create a new column 'Date' by taking the date part of 'Timestamp' (e.g., 2024-06-01).
Expected Result
Dates like 2024-06-01, 2024-06-02, etc. for each version.
2
Step 2: Count the number of versions created each day.
Group data by 'Date' and count 'Version ID' entries per group.
Expected Result
2024-06-01: 2 versions, 2024-06-02: 2 versions, 2024-06-03: 2 versions, 2024-06-04: 2 versions.
3
Step 3: Identify the number of versions each editor has contributed.
Group data by 'Editor' and count 'Version ID' entries per editor.
Expected Result
Alice: 3 versions, Bob: 3 versions, Charlie: 2 versions.
4
Step 4: Create a timeline visualization showing versions over time with editor names.
Plot 'Timestamp' on the x-axis and 'Version ID' on the y-axis, color-coded by 'Editor'.
Expected Result
A timeline chart showing when each version was created and by whom.
5
Step 5: Build a summary dashboard with daily version counts, editor contributions, and the timeline chart.
Combine the grouped counts and timeline visualization into one dashboard.
Expected Result
Dashboard clearly showing version activity per day, top editors, and version timeline.
Final Result
09:15 v1 Alice
↓
10:00 v3 Alice
↓
11:20 v5 Bob
↓
09:50 v7 Charlie
✓Versions were evenly created over four days, with two versions each day.
✓Alice and Bob contributed equally with three versions each, while Charlie contributed two.
✓The timeline shows steady progress with multiple editors updating the design daily.
Bonus Challenge

Add a filter to the dashboard to view version history by a specific editor or date range.

Show Hint
Use slicers or dropdown filters to let users select an editor or date range and update the visuals accordingly.