my query results have some null values. i got an error about "All series on a given axis must be of the same data type". any idea how i can fix this? i tried setting interpolateNulls, it didn't seem to help.
Felix, Thanks for the suggestion. I have a set of data like this: | Date | Low | Med | High | Overall | | 12/10 | 0.81 | 0.75 | 1.00 | 0.85 | | 12/11 | 1.00 | 1.00 | 1.00 | 1.00 | | 12/14 | 1.00 | NULL | NULL | 1.00 | | 12/15 | 1.00 | 1.00 | 1.00 | 1.00 | I'm looking to do a line graph so that the null values are simply omitted in the graph. Using a WHERE clause would eliminate a row with nulls altogether. I don't want NULL represented as zero (0) either as that would not be an accurate representation in the graph.
Hi Tim! The issue is actually in PocketQuery: as soon as a value of a column for the line chart is not a number (in this case null is not a number), the type for the whole column will become string. In that case, Google Charts won't work with the input submitted by PocketQuery. I added this as a bug in PocketQuery and I will target it with the next release.
This is really strange. It works perfectly for me. Maybe you can think about what's different for you. I'm using PocketQuery 2.1-m6. I'm using the sample MySQL "World" database ( as dump file).
This is my statement:
SELECT Name, LifeExpectancy FROM Country WHERE Continent = 'Oceania'
This is my template:
<script> PocketQuery.chart('LineChart'); </script>
Now, most countries in Oceania have a number in the column LifeExpectancy. But some of them have NULL. For the ones with NULL, there is a gap in my chart:
Maybe you can find out what's wrong with this?
Regards, Felix (Scandio)
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs