Data Analytics: List and Dashboard

On our first approach to the topic of Data Analytics (blog post here), we’ve shown how to make use of advanced queries and their usefulness in web application development.

Today we’re going to go a step further, and show you how to make use of those queries to output the desired information on a dashboard of your web application. To do this, we’ll explain the concept behind Lists, Dashboards, and show a quick step-by-step guide demonstrating the basic steps needed to go from query creation, to dashboard placement.

Lists

Regardless of their complexity or size, queries serve as a tool for manipulating and selecting data, and one way to show that information on our platform is using lists. A list is, in its essence, a visual output of a query.

Example (list):

The previous list is an output of this query:

Keep in mind that the output list of a query can also be customized. You can choose to add or remove columns, show/hide specific information according to the logged user, etc. We’ll explore this topic in depth in future posts.

Dashboards

In order for a list, or any other element for that matter, to show up in your web application, it needs to be placed in a dashboard. You can think of dashboards as a web page. The base web page in which you will place any and all data output elements as you wish. You can create dashboards freely, and use them to output the information you wish (see documentation). The most common dashboard in all our web applications is the Home Dashboard. As the name implies, it’s the first dashboard you see when visiting your web application. Its homepage, if you will.

Home Dashboard example:

In the dashboard illustrated by the previous image, we have a total of 6 web components (more info here), and 2 lists.

For the purpose of this demonstration, we’ll share a step-by-step guide with the basic steps needed to create a query, create its list, and add it to our home dashboard. We’ll be using the same demo environment we’ve used in our “Advanced Analytics” post, and the goal of our query is to list the most popular products, and the total number of times they were purchased.

 

Step-by-Step

1 – Create (or edit) your query

 

2 – Create (or edit) its output list

 

3 – Add list to dashboard:

3.1 – Select Dashboard (Home)

3.2 – Select “Add List” to add it to the selected Dashboard

3.3 – Build and check Dashboard for “Quantity by Product” list:

 

And that’s it! You’ve just added a new list to your web application.

If you want to try our platform, and see this example in action, feel free to send us an email (click here) and we’ll provide you with a free demo.

We hope you’ve enjoyed this quick demonstration about lists and dashboards. If you had any doubts regarding the subjects we covered in this blog posts, feel free to read our previous ones, so that you can fully understand the steps behind this example.

Don’t forget to follow us on LinkedIn and Twitter, and subscribe to our newsletter so you don’t miss any of our future updates.