Hey community! I have what I believe should be a simple formula, but I feel like I'm running up against a limitation.
As an example, I have two custom fields:
- Expected ROI (currency type)
- Geo (drop down, single select)
My goal is to SUM Expected ROI and then use the "break by" or categories on a bar chart to show the breakdown of Expected ROI by Geo.
Expected ROI sums fine. However, when I add the custom field "Geo" or even the text values from the Geo field in the "break by" area, the chart returns no data.
Is it not possible to take a sum and then break it up by another custom field?