The cost pivot table in Fracttal One allows you not only to analyze the economic data of your maintenance activities but also to visualize them through different types of interactive charts and tables.
Each view offers a different way to interpret the information depending on the analysis objective.
How to Access the Graph Views
In the main menu, go to Business Intelligence.
Select Economic Analysis.
Click on the Cost Pivot Table tab.
At the top left, open the visualization dropdown menu.
Here you can choose from several types of views to represent your data.
Available View Types
1. Table
Displays data in a tabular format.
Ideal for detailed reviews and audits where exact values of each field are required (for example, Total Cost, Unit Cost, Asset, OT Id).
Recommended for:
Accounting control.
Exporting data to Excel.
Comparative analysis by cost center.
2. Table Row Heatmap
Applies a heatmap over the table, highlighting the highest or lowest values with colors.
Allows quick detection of deviations or spending concentrations.
Recommended for:
Identifying assets or cost centers with higher costs.
Analyzing visual trends without using complex charts.
3. Multiple Pie Chart
Shows the proportion of costs or quantities by category (for example, task type, asset, or cost center).
The Multiple Pie Chart format allows comparing several categories in the same space.
Recommended for:
Comparing cost distribution by task type.
Seeing which area or asset concentrates the most spending.
4. Column Chart
Represents data in vertical bars.
Each column can show the total or average cost of each selected category.
Recommended for:
Comparing costs between assets or task types.
Showing expense evolution by month or year.
5. Stacked Bar Chart
Stacks values of different categories in the same bar, showing their proportion within the total.
Recommended for:
Analyzing the composition of total cost (for example, labor, spare parts, and external services).
Comparing several cost centers or assets.
6. Line Chart
Displays data as a continuous line over time.
It is ideal for analyzing the evolution of costs or monthly trends.
Recommended for:
Evaluating the behavior of preventive vs corrective costs throughout the year.
Detecting progressive increases or decreases.
7. Dot Chart
Represents values with individual dots, allowing visualization of dispersion or concentration of data.
Each dot can represent an asset, OT, or task type.
Recommended for:
Comparing the performance of different assets.
Identifying outliers (for example, costs outside the normal range).
8. Area Chart
Similar to the line chart but with the area under the line filled with color, which highlights the total accumulated volume.
Allows visualization of trends and the magnitude of costs over a period.
Recommended for:
Analyzing the accumulated evolution of costs.
Comparing spending growth between categories or periods.
Recommendations for Using the Views
Switch between different chart types to gain complementary perspectives.
Use the side filters (Cost Center, Resource Type, Asset Classification) to focus on relevant data.
Practical Example
If you want to visualize the average total cost by task type:
Select Multiple Pie Chart or Column Chart.
In Measure, use Average → Total Cost.
Group by Task Type and Month.
The result will show how the average maintenance cost varies according to the task type over time.