Google charts issue showing only 1 option

Question

I am able to see only one option ['Pend'] but ['Attend'] option is not showing from the chart, what is the issue from my code:

google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['Pend', 'Attended'], <?php while($row = mysqli_fetch_array($result)) { echo "['".$row['Pend']."', '".$row['Attended']."'],"; } ?> ]); }

WhiteHat · Accepted Answer · 2019-12-25 15:57:51Z

1

the second value in the array should be a number, not a string.
remove the single quotes...

change...

echo "['".$row['Pend']."', '".$row['Attended']."'],";

to...

echo "['".$row['Pend']."', ".$row['Attended']."],";

answered Dec 25, 2019 at 15:57

WhiteHat

61.3k7 gold badges54 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

asley Over a year ago

not working still, this is my query

SELECT SUM(CASE WHEN PointsArchieved=0 AND Extrapoints=0 AND Finalpoint=0 THEN 1 ELSE 0 END) AS Pend, SUM(CASE WHEN PointsArchieved=0 AND Extrapoints=0 AND Finalpoint=0 THEN 0 ELSE 1 END) AS Attended FROM performance WHERE DATE(AssignDate) = CURDATE()

WhiteHat Over a year ago

are you still having issues with this question? what type of chart are you trying to draw?

Collectives™ on Stack Overflow

Google charts issue showing only 1 option

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related