1 Reply Latest reply on May 4, 2017 6:12 AM by philmodjunk

    Charting Data: Counting text fields with the same name

    bradduncan

      Hey everyone!

       

      It's Thursday, so one more day to the weekend    At the moment I'm working on creating a chart to count text fields.

       

      Example

      Apple

      Pear

      Apple

      Orange

      Banana

       

      On the bar chart, I'm looking at getting the data to reflect the count of the occurrences of the text. Apple = 2 so "Apple" would be in the X Axis and the Y axis would show the amount of apples. I know this is simple stuff, but at the moment I'm getting some pretty crazy outputs!!!

       

      Currently using FMPA 15 and FM Cloud.

      Screen Shot 2017-05-04 at 13.34.54.png

       

      Any help would be most appreciated! I hope you're having an awesome and productive day!