2 Replies Latest reply on Nov 13, 2012 12:09 AM by MilutinPetrovic

    IWP and Charts



      IWP and Charts



           I have a problem with Pie Chart in IWP.

           I have created a Pie Chart made out of Value List field (checkbox set) by adding a trailing group, and counting the responses. I have ten records, and when I look in to a Pie chart it looks like in the Test 1 section, but, once I go to IWP, it looks like section Test 2! Also, once I perform any kind of fine, the chart looks like the Test 2 section even in FileMaker Pro. 

           What am I doing wrong?


           More important, can someone give me any advice on how to create pie charts, visible in the IWP, for value lists, both as radio button and checkbox set (single and multiple selections). Any tutorials on creating charts in FM?





        • 1. Re: IWP and Charts

               Your piechart is based on yoru current found set and sort order. When you perform a find, you will pull up different records and your chart will reflect the data in your new found set. And performing a find produces an unsorted found set so you then have to sort your records to regroup them as needed for your pie chart.

               In IWP, presumably, you need to make sure that you also have the correct found set and sort order there. If you are relying on a script trigger to produce the correct found set and/or sort order, they can't be directly "tripped" by a user interacting with a web browser so that may explain the difference.

               I can't tell from your post what a value list has to do with this piechart. Perhaps each 'wedge' of the chart represents a different value in your value list?

          • 2. Re: IWP and Charts


                 I figured out the sorted part late last night, I have to test placing the button to transfer me to the "chart layout" which have embedded sort step in it, and then another one when You go back to original layout, for the unsort part.