📊 Visualizing your Data#
Now that you know how to execute a query in DataDistillr, let's create a visualization. In the query editor, enter the following query:
This query is an aggregate query and will count the number of records by country name. This pattern of aggregation is useful for summarizing data.
Did You Notice the Asterisk?
One powerful feature of DataDistillr is that it can query directories of files as if they were one big file. The query
above is actually executing over any files in the directory with the naming pattern
Next, click on the Visualize button at the top of the screen to visualize the data.
Next, you will see the visualization screen with options on the left as shown. For a more complete view of DataDistillr's visualization capabilities, see the Visualization section of the documentation.
Fill in the left columns with the following options to generate the chart above:
- For Graph Type, select Bar
- Click the edit icon in Transform and set the Limit to 10
- Double-click Untitled to rename the graph and press Save
- For the X-Axis, select
- For the Y-Axis, select
You can export your data visualization as a jpeg or png by hovering over Download in the top bar.
Congratulations! Now you are ready to publish your data.