There seems to be a difference in the values โโdisplayed in the chart and the values โโin the source table.
Take a look on the pics below..... see in column F5 the value is 0.14% for PLAN.
The detail view is correct but on the chart view got wrong value.
Is there anyone who can help ?
Is it possibly due to rounding differences? Do you have the decimal digits in the PLAN column set to 6? Or could you try wrapping the values in the spreadsheet with the ROUND() function?
Not sure if that'll fix anything, but a rounding error is all I can think of
Do you have the decimal digits in the PLAN column set to 6?
- No, just using default setting
could you try wrapping the values in the spreadsheet with the ROUND() function?
- I have tried it but the result is still the same
I made this easily, using the initial settings and only using 1 table without formulas on spreadsheets and appsheets.I don't understand why the data could be different like that. At first I thought it was because there was an adjustment in the graph, but after trying using pie the results were still the same.
If you set this to a set amount of digits, say 2 or 3, do you still get this long 0.1399999999999999 value? Or do you get something else?
@RMS wrote:Do you have the decimal digits in the PLAN column set to 6?
- No, just using default setting
Iset to 2....
This is the result :
Hmmm.. last thing I would try is looking at your view settings, and maybe try Value or Percentage instead of whatever is currently selected as the label type. If that doesn't work, report a bug.
As u wish ....
This is for the pie style :
And this is for the curve col series style (no option for label type) :
Sorry I am out of ideas. Seems like a rounding issue in the spreadsheet data, but it ROUND() isn't working, then beats me.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |