1. Create a New Dataset 📊
First, you need to bring your data into the platform.
- Navigate to Data Settings on the left-hand menu and select Datasets.
- Click the purple + Add Dataset button at the top right.
- In the “Select Source” pop-up, choose the data source you want to connect to (e.g., Sample ConnectWise Connection).
- A new screen will appear. Use the Filter… bar on the right to search for the specific data you need. In the video, “ticket” is searched, and Tickets is selected.
- The system will load a preview. You can now add or remove columns. Use the Filter… bar on the left to find specific columns, like “Priority name” or “Owner name,” and check the box next to them to add them to your dataset.
- Once you’re happy with your columns, click Save & Close.
2. Create a Modified Dataset ✨
Modified datasets let you clean up or change your original data without altering the source.
- In the main menu, go to Modified Datasets (located under Datasets).
- Click + Add Modified Dataset.
- Select the dataset you just created (e.g., “Tickets”).
- You are now in the Modified Dataset Editor. On the left is a list of “Transform” tools. Let’s apply two common ones:
- Order Data: Select Order from the “Organize & Structure” list. Click the pencil icon ✏️ to edit, select + Add Column, choose a column to sort by (like “Last Updated”), and save. This will sort your data based on that column.
- Remove Duplicates: Select Drop Duplicates. Click the pencil icon ✏️, set the rule to Keep the First Row, and choose to check for duplicates in a Specific Column (like “Ticket #”). This cleans up redundant entries.
- Give your new modified dataset a name in the Modified Dataset Label field on the right (e.g., “Order Date”).
- Click Save & Close.
3. Build Your Dashboard 📈
Now for the fun part—visualizing your data!
- Click Dashboards at the top of the left-hand menu.
- Select + New Dashboard.
- Give your dashboard a title at the top left, like “Tickets”.
- Click the + Widget button.
- In the “Select Chart Type” window, choose the visualization you want. For this example, select Number.
- You’re now in the Widget Editor. Under the Data tab:
- In the Setup section, click the dropdown and select the modified dataset you created (“Order Date”).
- Give your widget a title, such as “Tickets open”.
- Click the Customization tab to change the widget’s appearance.
- To add color-coding, toggle on Thresholds.
- Set rules to change the widget’s color based on its value. For example:
- Green if the value is < 5.
- Yellow if the value is between 5 and 100.
- Red if the value is > 100.
- Click Save & Close to place the widget on your dashboard. You can now resize and move it as needed.
- Finally, click the main Save button at the top to save your new dashboard.
You’ve successfully created your first dataset, modified it, and built a dashboard to display it! 🎉