5 Replies Latest reply on Jul 11, 2013 8:53 AM by philmodjunk

    Graph

    Dees

      Title

      Graph

      Post

           I have a column graph that in theory should display the sales total made by each employee for the week. The x- axis is Employee Name and Y Axis is sale Amount.. The graph is the first screen that loads up once filemaker pro is started( the idea is to keep the employees motivated).

            

           The graph right now work nothing like what it should in theory. I wrote a script that find records within a week - however the graph does not load the correct info.

            

           Any idea  / example how I can achieve this.

            

           Thanks

            

        • 1. Re: Graph
          philmodjunk

               We'd need to know:

               What version of FIleMaker, 11 or 12?

               How your tables/relationships that contain this data are set up.

               All the options you have currently specified for your chart--not just what you've selected for the X-axis.

          • 2. Re: Graph
            Dees

                 Filemaker pro 12. I have attached the screen shot image.

                  

            • 3. Re: Graph
              philmodjunk

                   You didn't indicate how your tables/relationships are set up. Your screen shot identifies two tables. How are they related to each other?

                   Is your layout for the chart based on employee or BV_CustomerPayment?

              • 4. Re: Graph
                Dees

                     its based on employee

                                
                               Preferences
                §
                1
                2
                3
                4
                5
                6
                7
                8
                9
                0
                -
                =
                Backspace
                                     
                Tab
                q
                w
                e
                r
                t
                y
                u
                i
                o
                p
                [
                ]
                                          
                Return
                                          
                                     
                capslock
                a
                s
                d
                f
                g
                h
                j
                k
                l
                ;
                '
                \
                                     
                shift
                `
                z
                x
                c
                v
                b
                n
                m
                ,
                .
                /
                shift
                                     
                                          
                                         English
                                               
                                               
                alt
                alt
                                     
                                
                               Preferences

                      

                • 5. Re: Graph
                  philmodjunk

                       Presumably, it's based on BV_Employee. (The details are critical.)

                       And what is the relationship between BV_Employee and BV_CustomerPayment ?

                       Is BV_CustomerPayment::Amount a number, calculation or summary field?

                       I would guess that you have this relationship:

                       BV_Employee::__pkEmployeeID = BV_CustomerPayment::_fkEmployeeID

                       For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained

                       I would also guess that Amount is either a number or a calculation with a Number result. If so, then you can define a calculation for your Y-Axis data series as: Sum ( BV_CustomerPayment ).

                       However, the resulting chart will chart the total payments linked to each employee over all the records in BV_CustomerPayment. To see this same chart for selected sets of records in BV_CustomerPayment, I recommend that you use a layout based on BV_CustomerPayment and a Summary field that computes the total of Amount as the Y-Axis. You will also then need to sort your records by EmployeeID to group them properly and specify the Data source options for summary values from "grouped data when sorted".

                       With that approach, you can get charts of payment data over any date range you want by performing a find for those records and then sorting them as needed to get the proper groups of records for each employee.