Issue: Plotly Line Chart Shows Chaotic Lines Despite Correct Data Aggregation


Hi everyone,

I’m trying to create a line chart using Plotly to show the median value (mac_median) over time for different categories (category). The data is grouped by element, category, and year, and I have ensured that the data is properly aggregated. However, the resulting chart shows many chaotic lines, even though for each category and year, there should only be a single value.

Here is the key part of my code:

Hi @yanlei
:wave: Welcome to the community.

can you share your code again, please.