📊 Visualizing your Data#
Now that you know how to execute a query in DataDistillr, we are going to 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 extremely useful for summarizing data.
Did You Notice the Star?
Did you notice the asterisk in the file path? One very 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, we are going to visualize this data. 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 below:
For Graph Type, select Bar. For Limit, enter 10. Double click on the Series, enter the name of your data, and Press Save. Next, for the X-Axis, select
Country, and for the Y-Axis, select
Customer_Count. You should now have a visualization that looks something like the chart below:
Congrats! You've created your first visualization using DataDistillr! For a more complete view of DataDistillr's visualization capabilities, please refer to the Visualization section of the documentation.
Now, let's move on to publishing your data!