Forum Discussion

esuryahadi's avatar
esuryahadi
Icon for Helper I rankHelper I
2 years ago
Solved

how 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...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.