Forum Discussion
Plot Line Chart (Industrial Logging) without Aggregation
- 2 years ago
The Y-axis in a line chart functions as a value axis, inherently performing aggregation, much like a pivot table in Excel.
However, it's essential to note that the aggregation always occurs at the level of each point-to-point interval on the X-axis. For example, if you have data recorded every second with the date and time on the X-axis categorized accordingly, the chosen aggregation method—whether it's sum, average, minimum, or maximum—will consistently display a single value for each interval . This is because the aggregation is accurately filtered to the specific point, resulting in the same value for that particular interval . The X-axis of the graph should be "categorical"
I put on the attached picture graph and table with "don't summarize", you can see that the values are equal:
The issue with the instruments in your case is that you can't show the same time stamp for every occurrence,
X-Axis cannot have duplicates, so you need to filter the graph by instrument or work with a hierarchy
or from instrument to logs and then it would look like this (my country is your instrument) :or from instrument to timestamp and it would look like this:
the file with the hierarchies is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Use Deployment pipelines - https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipelines