Hi there,
I'm using an ARI Data Table module (1.13.14) set to ARI GChart, pie chart. I ran into a case where one of the chart values was 9 (0.1%) and instead of displaying the correct label it ended up as "Other" with color gray. I simplified everything, tested it and found out if a value ends up being 0.1% the label will be changed to "Other" with color gray. Make that value bigger than 0.1% (even just 0.2%) and it works fine.
My test table has 4 colums: ID = varchar(10), and A,B,C,D which are all decimal(12,2)
Table values are LABEL,47.80,47.90,4.20,1 (one single data row)
Module graphic colors are set to A(blue), B(red), C(green), D(black)
If I do the following query -
SELECT A AS "A", B AS "B", C AS "C", D AS "D" FROM test
there's no "A" on the chart and the colors are all shifted - B(blue), C(red), C(green)
I tried all kinds of things until I added column ID to the query, even though why would I need a column that's not even on the chart?
With this query -
SELECT ID AS "ID", A AS "A", B AS "B", C AS "C", D AS "D" FROM test
everything works fine
Now, change the value for D to 0.1 and "D"(black) becomes "Other"(gray). Have I found a bug? Do I get a cookie?
Updated to 1.13.15, repeated everything and problem persists.
Screenshots here
imgur.com/a/0RZZJ