# 15-Minute Dashboard Creation Checklist
## Before You Start
**Direct Link:** https://hypelive.sg.larksuite.com/base/C8kmbTsqoa6rBesTKRpl8nV8gHd
**What You Need:**
- Lark account with access to the base
- 15-20 minutes of focused time
- Desktop/laptop (mobile not recommended for creation)
---
## Step-by-Step Checklist
### Phase 1: Setup (2 minutes)
- [ ] Open the Lark Base link above
- [ ] Navigate to table: "TikTok L'AURA - Candle"
- [ ] Verify you can see 150 video records
- [ ] Click the view dropdown at top
- [ ] Click "+" to create new view
- [ ] Select "Dashboard" as view type
- [ ] Name it: "TikTok Analytics Dashboard"
- [ ] Click "Create"
### Phase 2: Add KPI Cards (3 minutes)
- [ ] Click "+ Add Chart" button
- [ ] Select "Metric" or "Number" card type
**Card 1: Total Views**
- [ ] Field: `Total video views`
- [ ] Aggregation: SUM
- [ ] Format: #,##0
- [ ] Position: Top left
**Card 2: Total Likes**
- [ ] Field: `Total number of likes the video received`
- [ ] Aggregation: SUM
- [ ] Format: #,##0
- [ ] Position: Next to Views
**Card 3: Total Comments**
- [ ] Field: `Total number of comments the video received`
- [ ] Aggregation: SUM
- [ ] Format: #,##0
- [ ] Position: Next to Likes
**Card 4: Total Shares**
- [ ] Field: `Total number of times the video was shared`
- [ ] Aggregation: SUM
- [ ] Format: #,##0
- [ ] Position: Next to Comments
**Card 5: Average Watch %**
- [ ] Field: `Percentage of video watched completely`
- [ ] Aggregation: AVERAGE
- [ ] Format: 0.00%
- [ ] Position: Next to Shares
### Phase 3: Add Trend Chart (3 minutes)
- [ ] Click "+ Add Chart"
- [ ] Select "Line Chart" or "Area Chart"
**Configuration:**
- [ ] X-Axis: `Date and time the video was published`
- [ ] Group by: Day or Week
- [ ] Y-Axis (Primary): `Total video views` (SUM)
- [ ] Y-Axis (Secondary): `Total number of likes the video received` (SUM)
- [ ] Enable dual Y-axis (if available)
- [ ] Title: "Views & Engagement Trends"
- [ ] Position: Below KPI cards, full width
### Phase 4: Add Top Videos Chart (2 minutes)
- [ ] Click "+ Add Chart"
- [ ] Select "Bar Chart" (horizontal)
**Configuration:**
- [ ] X-Axis: `Video description`
- [ ] Sort by: `Total video views` (Descending)
- [ ] Limit: 10 records
- [ ] Y-Axis: `Total video views` (SUM)
- [ ] Color by: `Percentage of video watched completely` (gradient)
- [ ] Title: "Top 10 Videos by Views"
- [ ] Position: Left half, below trend chart
### Phase 5: Add Duration Analysis (2 minutes)
- [ ] Click "+ Add Chart"
- [ ] Select "Scatter Plot" or "Bubble Chart"
**Configuration:**
- [ ] X-Axis: `Video duration in seconds, rounded to three decimal places`
- [ ] Y-Axis: `Percentage of video watched completely`
- [ ] Bubble Size: `Total video views`
- [ ] Title: "Watch Completion by Duration"
- [ ] Position: Right half, next to Top Videos
### Phase 6: Add Performance Table (3 minutes)
- [ ] Click "+ Add Chart"
- [ ] Select "Table" widget
**Configuration:**
- [ ] Columns to show:
- [ ] `Video description` (first 50 chars)
- [ ] `Date and time the video was published`
- [ ] `Total video views`
- [ ] `Total number of likes the video received`
- [ ] `Total number of comments the video received`
- [ ] `Percentage of video watched completely`
- [ ] Filter: Last 30 days (if available)
- [ ] Sort: `Date and time the video was published` (Descending)
- [ ] Limit: 20 rows
- [ ] Title: "Recent Video Performance"
- [ ] Position: Bottom, full width
### Phase 7: Final Touches (2 minutes)
- [ ] Add date range filter at top (if available)
- [ ] Adjust chart sizes for balance
- [ ] Verify all data is showing correctly
- [ ] Test clicking on charts (drill-down)
- [ ] Save dashboard
- [ ] Click "Share" to get shareable link
- [ ] Copy link for team access
---
## Optional Enhancements (10 more minutes)
### Add Performance Distribution Pie Chart
- [ ] Chart type: Pie or Donut
- [ ] Segments: Performance tiers (High/Medium/Low based on views)
- [ ] Value: COUNT of videos
- [ ] Position: Below table
### Add Engagement Breakdown
- [ ] Chart type: Stacked Bar
- [ ] Categories: Top 15 videos
- [ ] Metrics: Likes, Comments, Shares (stacked)
- [ ] Position: Next to pie chart
### Add Calculated Fields (in table first)
- [ ] Engagement Rate: `(Likes + Comments + Shares) / Views * 100`
- [ ] Watch Time per View: `Total Watch Time / Total Views`
- [ ] Virality Score: `(Shares / Views) * 100`
---
## Troubleshooting Quick Fixes
### Charts showing no data:
- [ ] Check if field names are exact (copy from FIELD_REFERENCE.md)
- [ ] Verify aggregation type (SUM for totals, AVG for rates)
- [ ] Remove any active filters
- [ ] Refresh the page
### Numbers look wrong:
- [ ] Check number formatting (add commas, decimals)
- [ ] Verify aggregation (SUM vs AVERAGE)
- [ ] Look for duplicate records
### Dashboard is slow:
- [ ] Limit charts to top 10-20 records
- [ ] Use date range filters
- [ ] Remove real-time auto-refresh
- [ ] Simplify calculated fields
### Can't create dashboard view:
- [ ] Ensure you have edit permissions on the base
- [ ] Try refreshing the page
- [ ] Check if "Dashboard" is available in your Lark plan
- [ ] Contact Lark support if issue persists
---
## Verification Checklist
Before considering the dashboard complete:
**Data Accuracy**
- [ ] Total views matches expected sum
- [ ] Date range shows all 150 videos
- [ ] Watch % is between 0-100%
- [ ] No null/missing values in key fields
**Visual Quality**
- [ ] Charts are properly sized
- [ ] Colors are consistent and meaningful
- [ ] Text is readable (not truncated badly)
- [ ] Spacing looks balanced
**Functionality**
- [ ] Filters work correctly
- [ ] Charts update when filtered
- [ ] Drill-down works (if enabled)
- [ ] Can export/share dashboard
**Performance**
- [ ] Dashboard loads in <5 seconds
- [ ] Charts render smoothly
- [ ] No lag when interacting
- [ ] Mobile view is acceptable
---
## Post-Creation Actions
### Immediate (Today)
- [ ] Share dashboard link with team
- [ ] Set permissions (view-only for most users)
- [ ] Pin dashboard to favorites
- [ ] Add to bookmarks
### This Week
- [ ] Gather feedback from 3-5 users
- [ ] Identify missing metrics
- [ ] Add any requested charts
- [ ] Document insights found
### This Month
- [ ] Set up automated reports (if available)
- [ ] Create alerts for key metrics
- [ ] Build comparison views (month-over-month)
- [ ] Train team on dashboard usage
---
## Success Criteria
Your dashboard is ready when:
- [ ] All 5 KPI cards show correct totals
- [ ] Trend chart displays at least 30 days of data
- [ ] Top videos chart ranks correctly by views
- [ ] Table shows most recent 20 videos
- [ ] Dashboard loads in under 5 seconds
- [ ] Team can access and understand it
- [ ] At least 3 actionable insights visible
---
## Time Estimates
| Phase | Time | Cumulative |
|-------|------|------------|
| Setup | 2 min | 2 min |
| KPI Cards | 3 min | 5 min |
| Trend Chart | 3 min | 8 min |
| Top Videos | 2 min | 10 min |
| Duration Analysis | 2 min | 12 min |
| Performance Table | 3 min | 15 min |
| Final Touches | 2 min | 17 min |
| **Total** | **17 min** | |
Optional enhancements add 10-15 minutes.
---
## Common Mistakes to Avoid
1. **Don't** use COUNT when you should use SUM
2. **Don't** forget to filter by date range
3. **Don't** show all 20 fields in charts (too cluttered)
4. **Don't** use pie charts for >5 categories
5. **Don't** forget to save your changes
6. **Don't** make dashboard public by accident
7. **Don't** use real-time refresh for historical data
8. **Don't** over-complicate with too many charts
---
## Quick Reference: Field Names
Copy these exact names when creating charts:
```
Total video views
Total number of likes the video received
Total number of comments the video received
Total number of times the video was shared
Video duration in seconds, rounded to three decimal places
Date and time the video was published
Percentage of video watched completely
Video description
```
---
## Next Steps After Completion
1. **Analyze the data:** What are the top 3 insights?
2. **Share findings:** Present to team/stakeholders
3. **Optimize content:** Use insights to improve strategy
4. **Monitor trends:** Check dashboard daily/weekly
5. **Iterate:** Add/remove charts based on usage
---
## Support Resources
- **Field Reference:** See `FIELD_REFERENCE.md` in this folder
- **Full Guide:** See `CREATE_DASHBOARD_NOW.md` in this folder
- **Visual Mockup:** See `DASHBOARD_MOCKUP.md` in this folder
- **Lark Help:** https://www.larksuite.com/help
- **API Docs:** https://open.larksuite.com/document/
---
**You're ready! Click the link and start building:**
https://hypelive.sg.larksuite.com/base/C8kmbTsqoa6rBesTKRpl8nV8gHd
Time to create: **15 minutes**
Time to value: **Immediate**
Good luck!
