ClicData for Advanced users

Explore the debtors dashboard to analyze invoice amounts and counts by country and category, review days outstanding, export data to Excel, and use filters for country and invoice category.

Connect data, create a view, transform columns to calculate days from invoice date to payment date, normalize amount paid, classify as small/medium/large with case, use iif to compute outstanding amounts.

Add a scatter chart to the dashboard with days paid on the y-axis and invoice amount on the x-axis, using category invoice amount and applying country and invoice category filters.

Duplicate and customize a dashboard chart, switch days paid to an average line, apply style, and create a drill-down table with country, invoice amount, and outstanding filters, export to Excel.

Explore the revenue dashboard, review widgets for total revenue, invoice count, and average order size, and analyze gross margin, cost of goods, and filters by date, country, and product category.

Combine Canada and Mexico with Fusion to create a dashboard, set types, replace empty Amount Paid with zero, and add cost of goods percentage and gross margin using Excel formula.

Create a revenue dashboard with a date range picker and filters for country and product category, using formulas to display average order amount, gross margin, and cost of goods percentage.

Explore how to add charts to the revenue dashboard, including stacked column and area charts, with monthly and yearly views, cumulative sums, tooltips, legends, and reset filters.

Learn to enhance dashboard clarity for colorblind users by testing with real users, using light and dark color schemes, varied line thickness and styles, markers, borders, and accessible text.

Explore how to use a LinkedIn dashboard built from company page data to analyze posts, clicks, likes, comments, and impressions, measure engagement, and interact with bubble charts and date filters.

Learn to build a LinkedIn dashboard with number indicators, bubble charts, and funnels, using LinkedIn company data, date range pickers, and filters to track impressions and engagements.

Explore a Facebook dashboard that presents posts, clicks, likes, and comments for a period, and switch between metrics while viewing fans by gender and age with monthly new-fan trends.

Learn how to build your own Facebook dashboard by configuring three data sets, widgets, and charts with dynamic buttons and calculated columns.

Develop advanced dashboards by combining bar and line charts, scatter and area charts, add number indicators with icons, and export data to Excel.

Explore mobile dashboards that stay interactive with filters, period zoom, and toggle views between quantity and revenue, featuring LinkedIn, revenue, Facebook, and YouTube dashboards.

Explore data flow transformations in the new ClicData feature, including merging datasets, selecting and aliasing columns, calculating profit percentage and sales price per product, and producing output tables for dashboards.