Forum Discussion

jeoosma's avatar
jeoosma
Icon for Helper II rankHelper II
9 years ago
Solved

Bar chart

Hi. In the chart the value on the bar in the count of element while I want to see the sum of value of column. How can I change the value? Thank you.    
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    jeoosma,

     

    Generally, in a bar chart.

    • For integer data type value, the default aggregate function is sum. 
    • For string data type value, the default aggregate function is count. 

    So in your scenario, please check CdeAufragK[ValoreVendita] data type. Please refer to the scrresnhot to see how to check your column's data type.

     

    Regards,

    Charlie Liao

     

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

jeoosma,

 

Generally, in a bar chart.

  • For integer data type value, the default aggregate function is sum. 
  • For string data type value, the default aggregate function is count. 

So in your scenario, please check CdeAufragK[ValoreVendita] data type. Please refer to the scrresnhot to see how to check your column's data type.

 

Regards,

Charlie Liao