Build a dashboard using the Infinity data source

The instructions in this milestone are based on the publicly available Traffic density JSON file, which has the following structure.

JSON Copy

{
  "channel": {
    "id": 38629,
    "name": "Traffic Monitor",
    "field1": "Density of Westbound Cars",
    "field2": "Density of Eastbound Cars"
  },
  "feeds": [
    {
      "created_at": "2025-04-02T17:44:34Z",
      "entry_id": 18679825,
      "field1": "7.000000",
      "field2": "7.000000"
    }
  ]
}

In this section, you create a dashboard, query your JSON endpoint with the Infinity data source, and save the result as a table panel.

To build a dashboard with the Infinity data source, complete the following steps:

1. From the navigation menu, click Dashboards.

2. Click New and select New dashboard.

3. Add a panel and open the panel editor: click the Panel placeholder, then click Edit visualization.

4. Pop this guide out into a floating panel so the data source list and save dialog don’t cover it.

5. In the query section at the bottom of the screen, open the Data source dropdown and search for Infinity.

6. From the filtered list, select the Infinity data source you created earlier. Choose the one that matches the name you set.

7. In the URL field, enter the URL of the JSON data you want to visualize.

   For example: https://thingspeak.com/channels/38629/feed.json

8. In the Parser dropdown, select Frontend.

   The default parser is JSONata. Selecting Frontend lets you use plain field names in the Rows/Root and column selectors in the next steps.

9. Expand Parsing options & Result fields.

10. In the Rows/Root field, enter feeds.

    This tells the Infinity data source which section of the JSON contains the records you want to visualize. The feeds field reference works whether you selected the Frontend parser or kept the default JSONata parser.

11. Click Add Columns and add a column for each field:

    • Selector created_at / Title Created at / Format as Time
    • Selector field1 / Title Density of Westbound Cars / Format as Number
    • Selector field2 / Title Density of Eastbound Cars / Format as Number

12. In the right pane, click All visualizations, search for Table, and select it from the results.

13. Click Back to dashboard in the top-left of the panel editor.

14. In the toolbar, click Save dashboard.

15. Enter a title for your dashboard.

16. Click Save.

You built and saved a dashboard that visualizes your JSON data with the Infinity data source.

The dashboard is now available for others to see.

More to explore (optional)

At this point in your journey, you can explore the following paths:

• Modify dashboard settings
• Manage dashboards
• Filtering data / Using template variables in Query