Defining Calculated Columns

Explore the dynamic capabilities of calculated columns and measures in Infoveave. Create customized data insights by applying specific formulas, enhancing data analysis. Similarly, explore the calculated measures functionality by aggregating data across multiple rows. These features empower users to tailor their analyses, enrich datasets, and make more informed decisions.

Calculated Columns

In Infoveave, a calculated column is a dynamically generated column in a dataset that derives its values through a predefined formula or expression. Instead of containing static data, a calculated column’s values are computed based on the values of other columns in the same dataset. This allows to perform custom calculations, transformations, and aggregations on data.

Importance and Necessity

• Customized Data Analysis: Utilizing calculated columns, you can tailor your analysis based on specific requirements, such as deriving profitability ratios or performance indicators.
• Enhanced Decision-Making: By adding calculated columns, you can generate metrics like total cost, profit percentages, or other key indicators relevant to their business goals, aiding in better decision-making.
• Data Enrichment: Calculated columns enrich your dataset by providing additional insights. For instance, you can calculate total prices, facilitating a deeper understanding of your sales data.
• Consistency in Analysis: Infoveave ensures consistency by applying standardized formulas across the dataset, maintaining accuracy and reliability in your analytical processes.
• Reduced Manual Effort: With calculated columns, manual efforts for repetitive calculations are reduced, saving time and minimizing the risk of errors in the analysis.

How to Add a Calculated Column in Infoveave

Let’s take the provided dataset as an example and say we want to calculate the profit percentage for each order. Here are the steps:

1. Select Datasources and choose your dataset (in this case, “Sales Data”).

2. Click on the Edit Datasource button on the selected Datasource.

   • You will be now redirected to the Datasource Designer.

3. Click on Add Calculated Column on the data table to configure.

4. In the Add Calculated Column modal configure the column as below.

   • Column Name: “Profit Percentage”
   • Type: Decimal
   • Formula: (@Profit/@Total Cost (Manufacturing))*100

5. Click Validate to check the formula and Preview to see how the calculated column will look with existing data.
6. Once validated and previewed, click Add Column to include the calculated column in your dataset.

Now, you have a new calculated column, Profit Percentage, providing insights into the profitability of each order.

Please remember to reupload the data batch to preview data in the calculated column.

Conclusion

In conclusion, through the calculated column feature Infoveave significantly enhance the data analysis process. With tailored formulas and expressions, you can create custom columns, supporting advanced analytic. Calculated columns support enriched analyses, improved decision-making, and consistent application of standardized formulas. Moreover, this feature contributes to reduced manual efforts, saving time and ensuring accuracy in analytical processes.