Re: Drawing Bar Graphs OR Pie Charts using Fusion Tables Data. HOW?

[Ghica]

Sauro,
Did you do the pizza party tutorial, to learn how to work with Fusion tables? http://explore.appinventor.mit.edu/ai2/pizzaparty#
And, your setup with buttons seems like a good idea. You can set the height of a button by using the set Button height block.
You may need to do some calculations to make the height fit on your screen.
Cheers, Ghica.

[SteveJG]

Here are several ways to plot graphs using any data using App Inventor  ... https://groups.google.com/forum/#!searchin/mitappinventortest/graph%7Csort:date/mitappinventortest/mTwR-bAJ_jc/ACbJ06y6CAAJ  

To get the data needed for the bar graph or pie chart from the FusionTable, follow Ghica's advice.  The simplest way to capture a data set is to do the fusion table query and convert the data to a list or a csv file so the raw data can be plotted using the methods described in the above link.

Regards,

Steve

[Ghica]

As opposed to global variables, the values of a TinyDB can be used in other screens. There is only one TinyDB in an app, therefore if you save something in one screen using a specific tag (for example tag1) then, if you retrieve that tag in the same or another screen, you will get your saved value back.

You would use a Fusion table if you want to share data between users using the same app.Actually, I never did the pizza party tutorial myself. Maybe I should. But as far as I know, the way to store or retrieve something from a Fusion table is to use SQL and that I know well enough. So, you should be able to retrieve from a Fusion table what you need.
Maybe you can explain what your Fusion table looks like and what data you would like to get out of it. Certainly one of the wizards here will be able to help you. Besides, there are quite a few examples on the forum.
Cheers, Ghica.

[SteveJG]

Fusion Tables:   you extract data using SQL statements: https://puravidaapps.com/fusionDB.php     and   https://puravidaapps.com/fusionerror.php  

in your case Sauroo, you will extract values to construct a graph.  

The TinyDB can be used in multiple screens.  You put a TinyDB object in each of the screens where it is used.  Each instance of the TinyDB can access the Tags .

You want to retrieve specific data from the FT and ' information about how to get a special part of the data in Fusion Tables".   What have you tried?   You need to learn how to use the SQL statements described above.

May you have a capture of the blocks and hopefully an explanation.  That is impossible Sauroo; you did not provide an example of what your Fusion Table architecture looks like and tell us specifically what you want to retrieve.  In order to make bar graphs you need to retrieve   the value for the height of each 'bar'.  You need to look at each of the possible bar graph/ pie graph examples in the provided links and learn how to plot a data set ....    5,722,  33, 44 for example so that when you learn to extract the data you are saving from the Fusion Table you can use it.