idea Re: Non Aggregated Measure in Pivot or Chart in Suggest an Idea

Non Aggregated Measure in Pivot or Chart

tschullo — Wed, 25 Nov 2020 08:56:29 GMT

When adding a measure to a pivot or data chart, you can search for the field you want, but when you select it you are forced to pick an aggregation function to go with it, i.e. SUM, COUNT, AVG, MAX, MIN. Many times the measure is text and I just want to enter it alone without aggregation for various reasons including not wanting to have a search icon like dimensions because it's not a field users would search in. Do all measures really have to be measurable?

I would like the drop down option allow me to select the field as is without aggregation instead of having to either type it in manually and click enter, or select sum and then go edit sum out.

Re: Non Aggregated Measure in Pivot or Chart

tschullo — Thu, 25 Jun 2020 20:43:11 GMT

Henric Cronström call these "Naked References" and discourages the use of them. Behind the scenes they get wrapped in an Only() statement. but given the fact that they are possible, why make it so difficult?

Re: Non Aggregated Measure in Pivot or Chart

John_Teichman — Fri, 26 Jun 2020 05:17:04 GMT

Hello @tschullo,

Thanks for your post. Please use one, and only one, label when submitting an idea. Refer to the submission guidelines for more details.

Re: Non Aggregated Measure in Pivot or Chart - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Mon, 09 Nov 2020 13:18:57 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,
Patric

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Tue, 05 Sep 2023 13:07:20 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Non Aggregated Measure in Pivot or Chart - Status changed to: Closed - Archived

Ideation — Tue, 05 Sep 2023 13:07:22 GMT