I have an item in my database called Leads that have a Text field with different ratings in it. I have the info in the chart menu setup like this:
Chart Type: Pie
Type of data: Lead
Data source: Search for Leads
Now the issue I’m having is the Value Expression field. The expression keeps building and building (no matter what expression I add, the text is always red). From what I can tell this is supposed to be a number field for the Type of Data… Is this correct? If so, how would I display something like "There are 3 leads with ‘High’ rating, 5 with ‘Medium’’, ect.
Any help would be appreciated!