4 Replies Latest reply on Jan 18, 2017 10:30 AM by karina

    Line Charting

    gartmorris

      I have a table with the following fields: Date, Type, Amount

      I want to create a line graph that will have a separate line for each type showing the amount over time. I have the date on the x axis but I am not sure how to set the y axis to give a separate line for each type.  The graph is in a separate table and I have the data table related (X).  New to graphing.

       

      Thanks

        • 1. Re: Line Charting
          user19752

          How many types do you have?

          You need adding Y-series for every type (line on chart), so corresponding data looks like

                    type1     type2     type3...

          date1

          date2

          ...

          • 2. Re: Line Charting
            gartmorris

            Here is the table

            table.jpeg

            I want one line to represent D and each amount on the particular date with the other line as F. 

            I have messed with ExecuteSQL but cannot seem to get it right.  It seems like it would be fairly simple but I am stumped.

            • 3. Re: Line Charting
              philmodjunk

              Option 1

               

              Define calculation fields in this table such as:

               

              If ( category = D ; amount )

               

              For each category.

              Refer to the calculation fields as your Y-Series

               

              Option 2

               

              Or use the "Delimited Data" option and use ExecuteSQL to produce each of your X and Y - Series. This avoids the need to create calculation fields, but requires using SQL...

              • 4. Re: Line Charting
                karina

                Hi,

                I made a sample with a DashBoard layout.

                It's another way to do this and does not require SQL ( this way you need to create extra fields and relationships).

                 

                Greetz,

                Karina

                1 of 1 people found this helpful