3 Replies Latest reply on Dec 23, 2009 2:19 PM by user9755

    Charting question

    donjuancarlos_1

      Title

      Charting question

      Post

      I've been trying my hand at charting data in Filemaker using Google Charts.

       

      My question is, how do you get Filemaker summary data into a format that can be used in a charting add-in? For example, I have a summary report showing month and Sales for the month like this:

       

      Jan 09    4,550,351

      Feb 09    2,854,654

      ...and so forth. 

       

      Google charts just grabs the totals for the period I am specifying rather than the individual months.

       

      It seems that all this chart stuff wants to grab data out of a portal.  If that is so, what's the best way to move summary report data into a portal?

        • 1. Re: Charting question
          davidanders
            

          http://www.google.com/search?q=charting+in+filemaker

          If this is too simple, apologies. 

          • 2. Re: Charting question
            donjuancarlos_1
               OK, let me re-word my issue:  How do you get your summary data into a format all these add-on charts use?  Because they don't seem to like summary data--they want raw data.
            • 3. Re: Charting question
              user9755
                

              If I understand you're problem correctly, essentially what you're going to need to do is build your own summary data using a script.

               

              1. Get you found set

              2. Sort it by date

              3. Loop through your data and build a series of variables

                      For example

                          Case (

                          Month ( Date ) = 1 ; $JanuaryTotal + Total

                          Month ( Date ) = 2 ; $FebruaryTotal + Total

                          ...

                          Month ( Date ) = 12 ; $DecemberTotal = Total

                          

              4. Send your data to Google

               

              Obviously this is much simplified; you'll need to consider that your found set might span more than a year, might not begin in January, might spread over a December 31 / January 1 period, etc.  If I'm on the right track, though, let me know and I can help you out more.