Hmm could you provide an example of this? May I know what issues you faced using a formula field to format the data and using said formula field in the chart?
Hmm could you provide an example of this? May I know what issues you faced using a formula field to format the data and using said formula field in the chart?
It's not the formula field that I'm having an issue with.
There is a field where values follow this pattern: <role> <space> <seniority level>. Since interfaces consume data from a base using this pattern, the charts may appear cluttered and visually unappealing.
I want to reformat the data before the interface picks it up—for example, by removing the <seniority level>.
The only solution I’ve found is to create another base.
After conducting some research, I discovered that customization within the interface does not exist.
It's not the formula field that I'm having an issue with.
There is a field where values follow this pattern: <role> <space> <seniority level>. Since interfaces consume data from a base using this pattern, the charts may appear cluttered and visually unappealing.
I want to reformat the data before the interface picks it up—for example, by removing the <seniority level>.
The only solution I’ve found is to create another base.
After conducting some research, I discovered that customization within the interface does not exist.
Hmm, yeah I was thinking you could format the data with a formula field, and so with reference to your example you could remove the seniority level like so:

I don't think I understand what you're trying to do though. Any chance you could provide some screenshots?