Hi Friends, very confused by the behavior of the c...
# gooddata-cloudd
Daniel Muise
09/16/2024, 10:30 PMHi Friends, very confused by the behavior of the combo chart. Reordering "METRICS (AS LINES)" results in different aggregation values. I don't see why this should happen. the only difference in the 2 screenshots shown is the ordering (see on the left)
m
Michael Ullock
09/16/2024, 11:27 PMHi Daniel, I was trying to replicate this issue in my own workspace, but I was unable to reproduce this behaviour. In the config settings of your report, can you please turn on the “Data Labels” so we can see difference in the numbers in the before and after and provide the screenshots once again please?
Michael Ullock
09/16/2024, 11:28 PMCan you please also check the “Scale” settings in the report Y Axis and try and set them to a min / max value and see if the issue still persists?
d
Daniel Muise
09/16/2024, 11:29 PMAgain, the only difference between these 2 charts is the literal ordering of "metrics"
m
Michael Ullock
09/17/2024, 12:01 AMDoes this issue still occur when you change the report type? For example, if you change the report to a Table report and re-arrange the metrics?
Michael Ullock
09/17/2024, 12:12 AMIf you also see this in a Table report, I think I know what is going on there - the order of metrics in a report can affect the results when certain metrics are dependent on other metrics or when different aggregation functions are used. Metrics that rely on previous calculations can produce different outcomes if their order changes. Also, the way data is aggregated, filtered, or grouped by attributes can influence how the metrics are computed, altering the results based on the context provided by their sequence. This interplay of dependencies and context-sensitive calculations is why the metric order can sometimes change report values.
👀 1