5 Replies Latest reply on Nov 23, 2015 1:20 PM by coherentkris

    Lists?

    weedonpaul

      I have a list that I'm trying to put in a graph, but it seams to be putting them all together as one item.

       

      Asia

      N.America

      S.America

      W.Europe

       

      One Bar with the title "Asia N.America S.America W.Europe"

       

      I have a hunch that the dots are confusing it but wanted to get a second opinion before I start writing scripts to replace stuff.

        • 1. Re: Lists?
          coherentkris

          I would grab the FileMaker training series and work through the section on charting before i wrote one character of code that changed data.

          You could also post the file so we can try to fix and reccomend solutions

          • 2. Re: Lists?
            weedonpaul

            This generates a list of regions that coverage has come from

             

            ExecuteSQL (

             

            "SELECT region

            FROM coverage_For_Report

            WHERE \"_kf_clients_id\"= ? AND publication_date >= ? AND publication_date <= ? AND region IS NOT NULL

            GROUP BY region"

             

            ;"";"";Coverage_Report::g_kf_clients_id; Coverage_Report::g_start_date; Coverage_Report::g_end_date)

             

            and this generates the quantity of coverage for each region

             

            ExecuteSQL (

             

            "SELECT COUNT(region)

            FROM coverage_For_Report

            WHERE \"_kf_clients_id\"= ? AND publication_date >= ? AND publication_date <= ? AND region IS NOT NULL

            GROUP BY region "

            ;"";"";Coverage_Report::g_kf_clients_id; Coverage_Report::g_start_date; Coverage_Report::g_end_date)

             

            the fields have an accurate list and count, so I'm assuming this part is ok, but the graph looks like

             

            RadicalMovesPR__n323_fmphost_com_.jpg

            • 3. Re: Lists?
              coherentkris

              In the data source for the chart how are things set up?

              Should be Current Record ( delimited data ).
              Also does Coverage_Report::g_kf_clients_id contain a list of client id's? If yes then WHERE \"_kf_clients_id\"= ? may be looking for a single client ID not a list of them.

               

              Maybe post the file?

              • 4. Re: Lists?
                weedonpaul

                the delaminated data part was it. I had related records doh!

                 

                It's been a long day

                 

                thanks

                • 5. Re: Lists?
                  coherentkris

                  Had still have plenty of those moments myself. Glad i could help