Forum Discussion

michael19960621's avatar
michael19960621
New Member
2 years ago
Solved

Plot Line Chart (Industrial Logging) without Aggregation

Hi everyone, sorry for the dumb question, I currently have a database with industrial loggings of each instruments in 24 hourss. I have timestamps, ~about 41 instruments, and their values (logging cy...
  • Ritaf1983's avatar
    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