Make Pie chart use google sheet data import with chartmaker extension

When I run it, it will display runtime error and said "RuntimeError. Irritants: (Cannot find the component: Web1 Problem with application)"

Your items and values are lists from a local variable, which is why you have red crosses against them.
Set these to global variables and try

Sry i dont know what you mean :sweat_smile:

Are you trying this on iOS companion ?

Like this

Screenshot 2021-09-05 at 8.20.04 PM
It appears this error message

Please show your blocks and your responseContent

You appear to be missing &range= ...

image

Still cannot will appear same error message. Actually i just want to show one column result only like this!

I need to change the whole code?

  1. Please stop deleting your images, it will make the topic hard to follow

  2. please show the raw response content being returned

or

  1. Share your aia project here for testing

OK, try this

[aia withrdrawn at request of OP]

You had an error in your SpreadsheetID

Items and values where round the wrong way (just how I did it as I could not see the data)

You should see a pie chart now....

image

There is nothing in this topic that cannot be found easily elsewhere, no real point in deleting the topic. Your issues were about typos, correct syntax and positioning. However, I have withdrawn the revised aia project I posted, and edited on of your images to remove the spreadsheetID.

Can i make the if else statement in the bottom values ?

Please show your blocks, and give a description of what you are trying to achieve...
(there was no if statement in the blocks I provided?)

But you cannot show that in a pie chart, unless you give each item a value of 1 and show the labels (for which you would need a different extension:

or do it yourself with html and a google chart

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.