Nov 12, 2021 11:50 AM
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?
Nov 18, 2021 10:03 AM
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.
Nov 18, 2021 11:39 PM
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.
Nov 19, 2021 07:51 AM
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:
Nov 19, 2021 10:03 AM
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.
Nov 22, 2021 06:30 AM
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?
Nov 22, 2021 08:30 AM
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.
Nov 22, 2021 02:16 PM