How do I turn off section totals for a field?

David Gallagher shared this idea 1 year ago
Idea Logged

I am creating a report with fields that are being read as 'Metrics' because they are numeric; I have section headers on the report and I need subtotals, but I only want subtotals for a few of the 'Metric' columns. I have set the 'Totals' property for these fields to 'None', but there is still an entry for these fields in the subtotal line. How do I stop this behavior?

Comments (7)

photo
0

Hi David,

Thank you for reaching out. As per your video, you are clicking Aggregation > None, rather than Totals > None:

07f1e9eb8694ab95dc03a8a558401488

ea87b7c8b887ee3aeb83c0ba60ff210e

Let me know if this helps.

Regards,

Mike

photo
0

Hi Mike – attached a revised video to show the behavior when using the Totals field. I don’t want to show anything at all in that subtotals line.

From: Mike Sheehan <support@yellowfin.bi>

Sent: Thursday, March 22, 2018 7:00 PM

To: David Gallagher <dgallagher@cleverdevices.com>

Subject: Re: How do I turn off section totals for a field? [#8054]

photo
0

Hi David,

I believe what you are referring to here is this part:

369696f665e8fa734929ecbf367f01bb

This is a Section total. If you head to (what looks like) Equipment > Format > Summary > turn Section Total off:

ea3edf124e9fc3acedaee58c6ef7ff9c

That should get rid of that line from the bottom of the report. Please let me know if you have further questions.

Regards,

Mike

photo
0

Hi Mike - I want the Section Total, I just want to choose which columns show up on it. At the moment it looks like anything defined as a ‘Metric’ is in there. I had to change ‘Meter 1 Reading’ to a ‘Dimension’ to stop it from showing up, I’m hoping there’s a way to avoid doing that for the other columns. I would expect setting ‘Totals’ to None would do so.

Thanks,

Dave

From: Mike Sheehan <support@yellowfin.bi>

Sent: Friday, March 23, 2018 10:48 AM

To: David Gallagher <dgallagher@cleverdevices.com>

Subject: Re: How do I turn off section totals for a field? [#8054]

photo
0

Hi David,

I see what you're asking for here now. This isn't currently possible in Yellowfin. What I can do is submit an enhancement request to allow the ability to display section totals per field. Would you like me to go ahead and put forth this enhancement request?

Regards,

Mike

photo
0

Yes, please.

Thanks,

Dave

From: Mike Sheehan <support@yellowfin.bi>

Sent: Friday, March 23, 2018 2:03 PM

To: David Gallagher <dgallagher@cleverdevices.com>

Subject: Re: How do I turn off section totals for a field? [#8054]

photo
1

Hi David,

Sounds good. I've gone ahead and logged this as an enhancement request in our internal tracking system. Any potential updates regarding this matter will be posted here.

Regards,

Mike