Is there a way to remove the "Aggregate" prefix on fields?

Hi Renato,

Thanks for reaching out. It is possible to configure the default aggregation at the View level. If you go to edit your View > Prepare > Field Settings > Format, you'll see Default Aggregation, and one of these options is N/A:

But this will make it so when you drag in the field the aggregation isn't applied, and when you change it, it does still append 'Sum' to the field name.

In this case, as well as for fields already added to pre-existing reports, you would have to manually remove this by clicking the arrow next to your field name and going to Format > Edit > change Display name:

For existing fields, like above, you may have to say, add a space, then save, then remove space and save again, but it is technically possible to do manually this way.

That said, this does require a considerable amount of manual work, so I think this would be a valid idea for enhancement. Please let me know if you'd like me to change this to an Idea ticket and submit an enhancement request for this.

Regards,

Mike

Hi Mike,

I hope all is well with you!

Thanks a lot for your help in this case. I would appretiate if you could submit this as an engancement request. I hope they can do this in a very soon update.

Thanks one more time.

Hi Renato,

Thanks Renato! I'm well, hope all's well with you too!

I've gone ahead and submitted an enhancement request for this.

Any potential updates regarding this will be posted here.

Regards,

Mike

I second this enhancement.

I recommend that there be a toggle placed immediately under the "Default Aggregation" option that allows the aggregation prefix label to be turned off.

It would also be useful is there was an option to set a custom aggregation prefix label. For example, an organisation may want the sum of "Item Revenue" field to be displayed as "Total Item Revenue" rather than Yellowfin's current default of "Sum Item Revenue"