Forum Discussion
Helper Ihow to not summarize column
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
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.
3 Replies
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
Community Champion
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.
