Overview
When the data in a table does not directly meet the analysis requirements and requires processing, you can create indicators. Indicators serve as a quantitative statistical method for analyzing transactions from multiple perspectives. They are typically derived from metrics (such as sales revenue, number of users, etc.) and dimensions (such as time, region, etc.). For example, sales revenue is a metric, while monthly sales revenue is an indicator based on the time dimension. There are mainly three types of indicators:
- Atomic indicators are the smallest possible indicators that can be used to measure transaction attributes, such as the total amount.
- A derivative indicator is an indicator that is created from a single basic indicator and is typically used to extend indicators over time, such as for month-on-month comparisons or accumulated sales amounts. These metrics are indicators for conducting more complex data analysis.
- A composite indicator is an indicator that is calculated using one or more basic indicators. For example, the average unit price can be calculated by dividing the total amount by the number of sales. These indicators are useful for conducting complex data analysis.
Notes and Constraints
- You have the permission to edit required datasets.
- You can only create indicators for projects that are connected to any of the following data sources: GaussDB(DWS), ClickHouse, GaussDB, MySQL, PostgreSQL, and Doris.
For MySQL, only version 8.0 or later is supported.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot