How to remove the "count of" from the values field on an area chart?

[Anonymous]

I'm having troubles making this area chart because it keeps counting or suming the values of my chart 

I have changed the summarization to "don't summarize" but it keeps counting the data

I would like to know how to remove the "count of" and just add the value to my area chart

Here's how the table looks like i don't know if i have to do something to remove that "count of"

[jdbuchanan71 · Accepted solution]

Then change your value column to be formatted as a percentage.

And change your value to be calculated as a SUM

You will also want to change your Y-axis range to be from 0 to 1

[jdbuchanan71 · Accepted solution]

Is your attribute column set to data type date?

[Anonymous]

God! I totally forgot about that, Thank you! it is working as expected now

[jdbuchanan71]

The amounts used in the values section of a chart must come from a calculation of some kind.  If you are wanting to show the total rather than the count change it to SUM in the in the dropdown instead of count or write a measure to sum your field.  If you change it to SUM and have the date on the axis it will show the value.

[Anonymous]

I need the data to look like this

[jdbuchanan71 · Accepted solution]

Then change your value column to be formatted as a percentage.

And change your value to be calculated as a SUM

You will also want to change your Y-axis range to be from 0 to 1

[Anonymous]

It worked but now theres another problem

It is sorted by value but i want it to be sorted by date from august 2022 to july 2023

[jdbuchanan71]

Change the sort setting on the chart.

[Anonymous]

I tried that but it gets sorted by month

looks like it ignores the year

[truptis]

Hi @Anonymous  ,
Try this:
Click on this arrow(highlighted in the image)  and you will see Don't summarize option. Select that it will solve the issue.

Please mark this as a solution if it works for you. Thank you.

Regards,
TruptiS

[Anonymous]

Also i'm using an area chart not a table

[Anonymous]

I've done it but in my version it is located here

but when i click on the arrow it shows this

forcing me to select one of the above eventough i don't need any of them

[jdbuchanan71]

If you are using a matrix you would have to move the column from the values to the rows

[Anonymous]

like this?