AnsweredAssumed Answered

Charting Data: Counting text fields with the same name

Question asked by bradduncan on May 4, 2017
Latest reply on May 4, 2017 by philmodjunk

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!

Outcomes