Create a Query

There are several ways to create queries. Explore the different available methods, and you can refer to the Discovery documentation for guidance.

In this case, we will create a query visually, without needing to know SQL.

Go to the home screen of Discovery and select "datastore_psql".

You should see the table you created in the data workflow. For example, in my case, it is cat_clientes_riesgo_jmruiz.

If you open it, you can view the data and create a distribution based on the "Riesgo" column by clicking on it.

This will generate a visual result:

Save this query within the collection you created and select "Yes" when asked if you want to add it to the dashboard. Then, add it to the dashboard you previously created.

Save the dashboard and complete it with additional graphs that you find useful to display the results.