# Sentiment Analytics Dashboard - Manual Creation Guide
**Target Base**: https://hypelive.sg.larksuite.com/base/IZ3cbKvLsakfGZsZgjvl38ifgwg
**Table**: Social Daily Sentiment (`tblkVYEcPh410eFw`)
**Date Created**: 2025-12-09
---
## Why Manual Creation?
The Lark/Feishu API **does not support programmatic dashboard creation**. The available view types via API are:
- `grid` - Table view
- `kanban` - Kanban board
- `gallery` - Gallery view
- `gantt` - Gantt chart
- `form` - Form view
**Dashboard views must be created through the Lark UI.**
---
## Data Overview
Your table contains **100+ records** of social media sentiment data with:
| Field | Type | Sample Values |
|-------|------|---------------|
| Social-tracking-id | Text | tiktok_1765242162163_ef4y5o1zx |
| Date | DateTime | Timestamps in milliseconds |
| Sentiment | Select | Positive, Neutral, Negative |
| Platform | Select | tiktok, facebook |
| Post Likes Count | Number | 6, 51, 117, 1857 |
| Post Shares Count | Number | 0, various |
| Theme Category | Multi-select | App Functionality, Verification/Identity, etc. |
| Sentiment Confidence | Number | 0.72 - 0.98 |
---
## Step-by-Step Dashboard Creation
### Step 1: Open Your Base
1. Go to: https://hypelive.sg.larksuite.com/base/IZ3cbKvLsakfGZsZgjvl38ifgwg
2. Click on the **"Social Daily Sentiment"** table
### Step 2: Create Dashboard View
1. Click the **"+"** button next to view tabs
2. Select **"Dashboard"** from the view type options
3. Name it: `Sentiment Analytics Dashboard`
### Step 3: Add KPI Cards
Add these 4 metric cards at the top:
#### Card 1: Total Comments
- **Type**: Number/Count
- **Field**: Social-tracking-id
- **Aggregation**: COUNT
- **Title**: "Total Comments"
#### Card 2: Total Likes
- **Type**: Number/Sum
- **Field**: Post Likes Count
- **Aggregation**: SUM
- **Title**: "Total Likes"
#### Card 3: Total Shares
- **Type**: Number/Sum
- **Field**: Post Shares Count
- **Aggregation**: SUM
- **Title**: "Total Shares"
#### Card 4: Avg Confidence
- **Type**: Number/Average
- **Field**: Sentiment Confidence
- **Aggregation**: AVG
- **Decimal Places**: 2
- **Title**: "Avg Confidence"
### Step 4: Add Charts
#### Chart 1: Sentiment Distribution (Pie Chart)
- **Chart Type**: Pie
- **Group By**: Sentiment
- **Value**: COUNT of records
- **Title**: "Sentiment Distribution"
- **Colors**:
- Positive: #52c41a (Green)
- Neutral: #faad14 (Yellow)
- Negative: #ff4d4f (Red)
#### Chart 2: Comments by Platform (Bar Chart)
- **Chart Type**: Bar
- **X-Axis**: Platform
- **Y-Axis**: COUNT of Social-tracking-id
- **Title**: "Comments by Platform"
- **Colors**: #3370FF (Lark Blue)
#### Chart 3: Comments Over Time (Line Chart)
- **Chart Type**: Line
- **X-Axis**: Date (grouped by day/week)
- **Y-Axis**: COUNT of Social-tracking-id
- **Title**: "Comments Over Time"
- **Color**: #3370FF (Lark Blue)
#### Chart 4: Theme Categories (Bar Chart)
- **Chart Type**: Horizontal Bar
- **X-Axis**: Theme Category
- **Y-Axis**: COUNT of Social-tracking-id
- **Title**: "Comments by Theme"
- **Color**: #FF3B69 (TikTok Pink)
### Step 5: Add Data Table
- **Type**: Table/Grid view
- **Columns to show**:
- Date
- Platform
- Sentiment
- Post Likes Count
- Theme Category
- Sentiment Confidence
- **Sort**: Date (Descending - newest first)
- **Title**: "Recent Comments"
---
## Recommended Layout
```
┌─────────────────────────────────────────────────────────────────┐
│ Total Comments │ Total Likes │ Total Shares │ Avg Conf │
│ 100+ │ 5,000+ │ 50+ │ 0.82 │
├─────────────────────────────────┬───────────────────────────────┤
│ Sentiment Distribution │ Comments by Platform │
│ [PIE CHART] │ [BAR CHART] │
│ ● Positive: 45% │ TikTok ████████ 85 │
│ ● Neutral: 40% │ Facebook ███ 15 │
│ ● Negative: 15% │ │
├─────────────────────────────────┴───────────────────────────────┤
│ Comments Over Time │
│ [LINE CHART] │
│ Dec 2025 ─────────────────────────────────────> │
├─────────────────────────────────────────────────────────────────┤
│ Comments by Theme │
│ [HORIZONTAL BAR CHART] │
│ App Functionality ████████████ 25 │
│ Support/Positive ██████████ 20 │
│ Verification/Identity ████████ 18 │
│ Service Suspension ██████ 12 │
├─────────────────────────────────────────────────────────────────┤
│ Recent Comments (Table) │
│ Date │ Platform │ Sentiment │ Likes │ Theme │
│ 2025-12-09 │ tiktok │ Positive │ 51 │ App Func... │
│ 2025-12-08 │ tiktok │ Neutral │ 47 │ Claiming WLD │
│ ... │ ... │ ... │ ... │ ... │
└─────────────────────────────────────────────────────────────────┘
```
---
## Color Scheme Reference
| Color Name | Hex Code | Usage |
|------------|----------|-------|
| Lark Blue | #3370FF | Primary charts, bars |
| TikTok Pink | #FF3B69 | Secondary accent |
| Success Green | #52c41a | Positive sentiment |
| Warning Yellow | #faad14 | Neutral sentiment |
| Error Red | #ff4d4f | Negative sentiment |
---
## Alternative: Use VChart Demo
If you want a quick visualization without manual setup, use the VChart demo:
```bash
cd /Users/mdch/hype-dash
npm run approach-c:demo
```
This opens a standalone HTML page with all 4 chart types pre-configured.
---
## Summary
| Method | Time Required | Skill Level |
|--------|---------------|-------------|
| Manual UI Dashboard | 10-15 minutes | Beginner |
| VChart Demo | 2 minutes | None (just open browser) |
| aPaaS Visual Editor | 30 minutes | Intermediate |
**Recommendation**: Create the dashboard manually in Lark UI for the best native experience. The VChart demo is great for quick data exploration.
---
*Generated by lark-dashboard-sdk on 2025-12-09*
