cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahuh02 Regular Visitor
Regular Visitor

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

I have:

 

Capture.PNGCapture1.PNG

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

@ahuh02

 

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

 

Regards

 

Victor




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




2 REPLIES 2
Super User
Super User

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

@ahuh02

 

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

 

Regards

 

Victor




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Highlighted
Super User
Super User

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

Hi @ahuh02

 

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