how to not summarize column

[esuryahadi]

Hi, I have tabel like this.

after use visual area chart result like this

as shown, there is something wrong with the graph.
In April and June the values for each month should not be added up.
How to solve this problem.

Regard,

Eko

[Anonymous · Accepted solution]

Hi @esuryahadi ,

Since your x-axis is Month, the values will be automatically summarized based on Month:

If you want two values from the same month not to be aggregated, the only way to distinguish between them is to put a second field on the x-axis.
For example:
Here is my sample data:

When I put only months in the x-axis, Value is automatically summarized and there is no way to separate it:

When I put another ID field into the x-axis, because different IDs exist for the same month's value, it separates at that point:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Daniel29195]

hello  @esuryahadi 

right clikc on the column you dont want it to be summarized and click dont summarize .

let me know if you need any help . i will happy to assist you . 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Don't forget to hit that  thumbs up button 🫡👍

[esuryahadi]

Thank you.

But result no change.