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

Renato Marcello dos Reis shared this idea 50 days ago
Idea Logged

When we're creating reports, if we add a field who has some "aggregation" method, Yellowfin insert a prefix in the field name. For example, let's assume we have a numeric field named "Profit" responsible to show the sum values of an enterprise. When it is added to a report creation, Yellowfin rename the field to "Sum Profit".


Is there a way to change this behaviour?

Comments (4)

photo
1

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:

/7854bdef38c07dee2519fdb4df4ac46d

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:

/cef5018ac65cee8c0e825d8b2bbda106

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

photo
1

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.

photo
1

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

photo
1

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"

photo
1

Hi Steve,

Thanks for your input. That's where I was thinking it should go too. I've added the second part to the task though for further consideration. Any updates on this will be posted here.

Regards,

Mike

photo