column chart only permits count and count distinct, not actual value

[Anonymous]

I have:

and want to plot value vs date, but when I add value, only options are count and count distinct.

How can I get the actual values?

I want to see the columns growing as the date changes

[Anonymous]

Hi @Anonymous

The "Value" is defined as Char type column, hence you are seeing only count. Make the type as Number to see other aggregated functions like SUM etc.

Thanks
Raj

[Vvelarde · Accepted solution]

@Anonymous

Hi, Change data type from Text to Number and try again

Regards

Victor