Skip to main content

Problem with sales bar chart in interfaces


Forum|alt.badge.img+2

Hi all, not sure if I’m doing something wrong here or if it’s a bug…

I have a base table with a list of sales orders and I’m trying to create a chart in my interface summing up all sales in monthly buckets.

Initially creating the chart defaults to counting records and I get a bar chart as you would expect. BUT when I switch to SUM by the field containing my sales values I get a blank graph.

Do my settings look right? Am I doing something right or could this be a bug?

7 replies

Forum|alt.badge.img+6

I think I have the same problem. I am trying to create a bar chart of clients by revenue sum, and I cannot get it to generate - I get the “internal error, try refreshing” message in place of the chart, but no matter how many times I refresh it won’t load. The minute I change it to a pie chart, it’s fine.


Forum|alt.badge.img+2

Hi @Nicole_Hawkesford,

Strangely, I have another base I have generated a view for which has currency values I have successfully bar charted. I’ll try to do some comparison and see why one might be working and another not. Could be me doing something wrong at this rate.


Forum|alt.badge.img+15
  • Inspiring
  • 69 replies
  • November 19, 2021

Yep I’ve got this issue too - if you change the currency to $ it should resolve it. Also mentioned here: [Bug] Field summary in charts does not work with currency columns when using a symbol other than $
I guess it’s time to move State side :slightly_smiling_face:


Forum|alt.badge.img+2
Joe_Hewes wrote:

Yep I’ve got this issue too - if you change the currency to $ it should resolve it. Also mentioned here: [Bug] Field summary in charts does not work with currency columns when using a symbol other than $
I guess it’s time to move State side :slightly_smiling_face:


Hey @Joe_Hewes ,

This worked for me. This would be why my other interface which has values in $ was working but my UK business in £ was not.

Thanks for the work around.


Forum|alt.badge.img+6

No, I think mine is a different root cause, because my revenue field is not formatted as currency or with any currency symbol. It’s actually a computed formula field, maybe that’s contributing somehow?


Forum|alt.badge.img+2
Nicole_Hawkesf1 wrote:

No, I think mine is a different root cause, because my revenue field is not formatted as currency or with any currency symbol. It’s actually a computed formula field, maybe that’s contributing somehow?


Hi @Nicole_Hawkesford ,

It does sound different. Incidentally, my was a calculated field (formula) with currency formatting.

Pretty sure this doesn’t help but I thought I’d clarify.


Forum|alt.badge.img+15
  • Inspiring
  • 69 replies
  • November 22, 2021

Might want to start your own thread @Nicole_Hawkesford


Reply