7-3: Creating Dashboards โ
Now that you can filter and save views, let's take it to the next level! Dashboards let you see the big picture at a glanceโtrack key metrics, spot trends, and share progress with your team.
Think of dashboards as your mission control center. Instead of clicking through different tables and views, you get all your important numbers in one place, updating in real-time.
๐ก What You'll Learn
By the end of this section, you'll be able to:
- โ Create your own dashboard in minutes
- โ Add different types of widgets (numbers, charts, lists)
- โ Arrange widgets to tell your data story
- โ Share dashboards with your team
7-3.1: Why Dashboards? โ
Let's say you're managing customer support. Right now, you might check:
- Your Support Tickets table โ filter for "Open" โ count rows
- Click around โ filter for "Closed" โ check yesterday vs. today
- Switch tables โ check team assignments
That's a lot of clicking! ๐
With a dashboard, you see everything at once:
- 23 Open Tickets (big number, can't miss it!)
- Chart showing tickets closed per day (trending up? ๐)
- List of recent tickets (what came in just now?)
All updating automatically as new tickets arrive. That's the power of dashboards!
๐ก ๐ก Real-World Example
Before dashboards: Sarah checks 5 different tables each morning, taking 15 minutes to understand what happened overnight.
After dashboards: Sarah opens one dashboard, sees everything in 30 seconds, and knows exactly what needs attention.
7-3.2: Creating Your First Dashboard โ
Let's create a Customer Support dashboard together!
Step 1: Access Dashboards
From your table view, look for the Dashboards button in the top navigation. Click it!
Taible Toolbar:
Step 2: Create a New Dashboard
Click the "Create Dashboard" button. You'll see a simple form:
Create Dashboard
Fill in:
- Dashboard Name: "Customer Support Overview"
- Description: "Track open tickets, response times, and team performance"
Click "Create Dashboard" and you're in! ๐
๐ก ๐ You Just Created a Dashboard!
Right now it's emptyโbut that's perfect! You're about to add your first widget and watch your data come to life.
7-3.3: Adding Your First Widget (Number Card) โ
Dashboards are made of widgetsโlittle blocks that show different types of information. Let's add your first one!
Step 1: Click "+ Add Widget"
You'll see a menu of widget types. Each one shows data in a different way:
Add Widget
Choose a widget type to add to your dashboard
For now, choose "Stat Card" (the one that shows a big number).
Step 2: Configure the Widget
Tell the widget what to show:
Configure Stat Card Widget
Filter (optional)
Here's what each setting means:
- Widget Title: What should the number represent? ("Open Tickets")
- Data Source: Which table has the data? ("Support Tickets")
- Calculation Type: Count the rows
- Filter: Only count rows where Status = "Open"
Click "Save Widget" and boom! ๐ฅ
๐ก ๐ก Think of It Like This
A Stat Card is like asking your data a question:
- Question: "How many open tickets do we have?"
- Answer: A big, bold 23 right on your dashboard
The number updates automatically as tickets open and close!
7-3.4: Adding a Chart Widget โ
Numbers are great, but charts show trends over time. Let's add a chart to see if you're closing tickets faster or slower than usual.
Step 1: Click "+ Add Widget" Again
This time, choose "Chart".
Step 2: Configure the Chart
Configure Chart Widget
Set up:
- Widget Title: "Tickets Closed Per Day"
- Data Source: "Support Tickets"
- Chart Type: Line Chart
- Date Column: "Closed At"
- Time Range: Last 30 days
Click "Save Widget" and watch your chart appear!
Tickets Closed Per Day
Showing data from last 30 days
What you're seeing:
- Each point = number of tickets closed that day
- Line going up = you're closing more tickets! ๐
- Line going down = might need help! ๐
๐ก Pro Tip: Spotting Trends
Look for patterns:
- Sudden spike? Maybe you launched a new product
- Dip on weekends? Totally normal if you don't work weekends
- Steady climb? Your team is getting more efficient! ๐
Charts turn numbers into stories.
7-3.5: Adding a List Widget โ
Sometimes you need details, not just numbers. List widgets show you the actual rows from your table.
Step 1: Add a List Widget
Click "+ Add Widget" โ Choose "List"
Configure it:
- Widget Title: "Recent Tickets"
- Data Source: "Support Tickets"
- Sort by: Created At (newest first)
- Show: 10 rows
- Columns to display: Subject, Status, Priority
Step 2: See Your Recent Tickets
The list updates in real-time! Every time a new ticket arrives, it pops up at the top.
๐ก ๐ก When to Use List Widgets
Lists are perfect for:
- โ "What just happened?" (recent activity)
- โ "What needs attention?" (high priority items)
- โ "Who's working on what?" (assignments)
They're like a live feed of your data!
7-3.6: Your Complete Dashboard โ
Now let's see all three widgets together:
Customer Support Overview
Track open tickets, response times, and team performance
Open Tickets
23
Tickets Closed Per Day
Recent Tickets
Look at that! In one screen, you can see:
- Big number (23 open tickets) โ Quick status check
- Chart (trend over time) โ Are we improving?
- List (recent activity) โ What's happening right now?
This is actionable dataโyou can make decisions at a glance!
๐ก ๐ You Just Built a Dashboard!
From scratch to a complete dashboard in minutes! And the best part? It updates automaticallyโno manual reports, no copying numbers into spreadsheets.
7-3.7: Arranging Widgets โ
Don't like the layout? You can rearrange widgets by dragging them around!
How it works:
- Hover over a widget โ You'll see a handle (โฎโฎ) at the top
- Click and drag โ Move the widget to a new spot
- Resize โ Drag the corners to make widgets bigger or smaller
Tips for great layouts:
- Put your most important number at the top-left (that's where eyes go first!)
- Charts work better when they're wider (more room for the timeline)
- Lists work better when they're taller (show more rows)
๐ก ๐ก Design Tip
Think about the story you want to tell:
- Top: "Here's the situation" (status numbers)
- Middle: "Here's the trend" (charts)
- Bottom: "Here's what to do" (lists of items needing action)
Your dashboard should answer questions in order!
7-3.8: Sharing Your Dashboard โ
Your dashboard looks great! Now share it with your team.
Click the "Share" button at the top right:
Share Dashboard
Give your team access to this dashboard
Anyone with this link can view the dashboard
Other Options
You can:
1. Share a Link
- Anyone with the link can view the dashboard
- Copy the link and send it via email, Slack, anywhere!
- Updates in real-time (when they look, they see current data)
2. Email Reports
- Send a snapshot of the dashboard
- Schedule daily/weekly reports
- Great for executives who want summaries
3. Export as PDF
- Download a static copy
- Perfect for presentations or printing
๐ก Permission Note
Viewers see the dashboard but can't edit it. Only you (the creator) can add or remove widgets. This keeps your carefully designed layout safe!
7-3.9: Common Dashboard Patterns โ
Here are some dashboards people love to create:
Sales Dashboard:
- Stat Card: "Deals Closed This Month"
- Chart: "Revenue Over Time"
- List: "Hot Leads (Score > 80)"
Operations Dashboard:
- Stat Card: "Orders Pending Shipment"
- Chart: "Fulfillment Time Trend"
- List: "Urgent Orders"
Marketing Dashboard:
- Stat Card: "Leads This Week"
- Chart: "Lead Source Performance"
- List: "Recent Campaign Sign-ups"
Support Dashboard:
- Stat Card: "Average Response Time"
- Chart: "Ticket Volume by Day"
- List: "Escalated Issues"
๐ก ๐ก Start Simple, Add More Later
Your first dashboard doesn't need 20 widgets! Start with 2-3 key metrics that you check every day. Add more as you figure out what you need.
A simple dashboard you actually use beats a complex one you ignore.
7-3.10: Widget Best Practices โ
Stat Cards: Use for single, important numbers
- โ "23 Open Tickets"
- โ "$127,450 Revenue"
- โ Don't use for lists of things
Charts: Use for trends over time
- โ "Tickets Closed Per Day"
- โ "Revenue Growth"
- โ Don't use if you only care about "right now"
Lists: Use for items needing action
- โ "High Priority Tickets"
- โ "New Leads Today"
- โ Don't show 100+ rows (use filters!)
Tables: Use for detailed comparisons
- โ "Sales by Product"
- โ "Performance by Team Member"
- โ Don't use if a chart would be clearer
7-3.11: Keeping Dashboards Fast โ
Dashboards update automatically, but here are tips to keep them snappy:
Do:
- โ Filter to relevant data ("Last 30 days" instead of "All time")
- โ Limit list widgets to 10-20 rows
- โ Use 3-6 widgets per dashboard (not 50!)
Don't:
- โ Show "All rows" in huge tables
- โ Add 20 widgets just because you can
- โ Nest complex calculations in widgets
๐ก Performance Tip
If your dashboard feels slow, try:
- Reduce the time range (30 days โ 7 days)
- Add more specific filters
- Split into multiple dashboards by topic
Focused dashboards load faster and are easier to understand!
7-3.12: Updating Dashboards โ
Need to change a widget? Easy!
Edit a Widget:
- Click the โฎ menu on any widget
- Choose "Edit"
- Update the configuration
- Save!
Remove a Widget:
- Click the โฎ menu
- Choose "Delete"
- Confirm (it's gone, but you can always add it back)
Change Dashboard Info:
- Click "Settings" at the top
- Update name or description
- Save
What You've Learned โ
You now know how to create powerful dashboards! ๐
You learned:
- โ Why dashboards save time and improve decisions
- โ How to create a dashboard from scratch
- โ Adding Stat Cards (big numbers)
- โ Adding Charts (trends over time)
- โ Adding Lists (recent activity)
- โ Arranging widgets for maximum impact
- โ Sharing dashboards with your team
Next: Ready for real-world examples? In Part 8, we'll build complete automation systems from start to finishโcombining everything you've learned into powerful workflows!
๐ก ๐ You're a Dashboard Pro!
From raw data to beautiful visualizations in minutes. You can now turn any table into a dashboard that tells a story, tracks progress, and helps your team make better decisions.
That's the power of Uniki! ๐
Previous: 7-2 Saving Favorite ViewsNext: 8-1 Customer Support Chatbot