The basic concept in analytics is the query.
A query is a means of selecting the necessary information from a database using a special language.
PayСore.io Analytics uses SQL (Structured Query Language) for creating queries.
To create query you need:
- Basic SQL knowledges
- General understanding of database structure
- Folowing the Query creating workflow
Query creating workflow¶
- Press Create button on toolbar
- Choose "Query"
- Select Datasource
- Write query text
- Save to confirm creation
To facilitate writing a query, use the list of tables and their fields in the left menu.
You can add field to the query by clicking on the
Execute query after creation to make sure that it works correctly!
By default, your query results (data) will appear in a simple table. Visualizations are much better to help you digest complex information, so let’s visualize your data.
After you make sure that the query is working properly, returning the result you want, you may Add new visualization or Edit Existing one.
After first executing system will automaticaly create Table visualization.
Visualization creating workflow¶
- To crate another visualization press
Suitable select of visualization type depends on the business needs and analysis purpose.
For example: To compare several indicators of the similar types, the most appropriate are
Set up visualization parameters
There are a lot of different parameters for different types of visualization.
After saving - tab with name of your visualization will appear next to the "Table" tab.
And you will be able to add it to the Dashboard