1 Reply Latest reply on Oct 1, 2014 10:21 AM by philmodjunk

    Scatter Chart Help

    sccardais

      Title

      Scatter Chart Help

      Post

       

      I want a scatter chart to analyze cancelations. My table contains a field, Status, that identifies all former customers who have cancelled. Another field c_Date Till Cancel calculates the number of days between their start date and the date they cancelled.

      I want to visualize this in a scatter chart (bubble chart OK too.) The Y axis would be the number of days till cancellation starting with 1 day and max value of the longest number of days before cancellation.

      The x axis is the Org's that cancelled. Our data shows that approximately 1,600 orgs have cancelled since we started so my scatter chart should show 1,600 data points. Alternately, a bubble chart would be fine, too.

      I'm not having any luck generating this chart. I'm sure it's because I'm using the wrong values for one of my axis. I've tried placing my chart in various "parts" (Body, Sub Summary, etc.).  My data source is current found set. I've tried both Summarized groups and Individual record data when sorted on the Data Source tab. All I get is a straight line of dots representing the total number of records in my found set.

      What values should I be plotting to get this chart?

        • 1. Re: Scatter Chart Help
          philmodjunk

          According to FileMaker Help on scatter/bubble charts, the X-Axis field has to be a number field so I don't think using the Orgs for the x-Axis will work here. Theses charts compare values in two number series and I only see one, the number of days til cancellation in what you describe...

          Wouldn't it make more sense to set up a line or bar chart where each bar/line point represents the number of orgs that canceled in a particular value range? (y orgs cancelled in the 1 - 5 day range, y orgs cancelled in the 6 - 10 day range...)