Create Dashboards from JSON Files

Overview Video

Load Template

To use a JSON file as a source for a visualization you need a valid JSON file in your file manager, in this guide, we will follow the example in the Visualization from JSON File template.

First, go to the Template section in Instadeq by searching it and selecting it in the search box in the navigation bar or by opening the menu in the navigation bar.

A list of templates will be displayed each with a + button on the right side.

Select the + button on the right of Visualization from JSON File, the message Imported should appear below it after some seconds.

Open Visualization

Go to the Home section by selecting the home icon on the navigation bar.

In the Visualizations section there should be an entry titled File: JSON Example, select it to open it.

Note

If the entry is not displayed in the first 3 entries use the search box below the entries on the bottom right or the pagination controls on the bottom left of the Visualizations section to locate it.

Download JSON File

Once opened you should see two panels, the one on the left focused on the Data section should contain instructions to download a file called sales.json, click on the link and download it, if it opens instead of downloading it, right-click it and select Save Link As.

Open the folder containing the file.

Drag the file and drop it in the Data section, the area should highlight to indicate you can drop it there.

Once dropped you should see its content represented like a spreadsheet.

Configure Aggregation

Double click the 0 path item left to the green j on the Data section to open actions associated with it.

Select the red button to remove the first item in the list since it contains the column titles.

Now that all the items in the list contain only numbers we can calculate aggregations on them, start by dragging the 3 path item (the one left of "Mastercard") from the Data section to the Key target area in the Summary section.

Drag the 2 path item (the one left of 1200) from the Data section to the Field target area in the Summary section.

This will configure an aggregation that will calculate multiple statistics on the third item in the first list item in v by the second item from the first list item in v.

Since we want to calculate The statistics for every item in the list v we need to tell Intadeq that by dragging the iterator i next to the path item v to the Summary configuration, by adding i to the paths we indicat that the statistics should be calculated for each item in the list and not just the first one.

Since both paths share the iterator i they will be calculated together for each value of i.

Update Aggregation

To calculate the aggregations you can either click the refresh button at the top of the Data section to reprocess recent data or you can drop the JSON File again.

After doing any of those actions a table should appear at the bottom of the Summary section with the current aggregation results.

Configure Chart

Now that we have data being calculated we can proceed to select a visualization for it.

Open the Chart section on the right panel, select the chart selector and pick a visualization, for example, Bar Chart, the visualization should appear below the selector.

Customize the visualization or explore alternatives.

Update Chart

Now every time you have an updated JSON file you can update the visualization by dropping the updated file into the visualization's Data section.

If you have configured an Instadeq Events source, you can save each upload so it can be visualized live by any dashboard that contains that visualization.