Skip to Main Content
Feature Request FR-1859
Product Area Application Builder
Status CLOSED

11 Voters

The "Maximum" function within the Interactive Report Pivot Menu should apply to TEXT Columns as well

sorin.apalaghie Internal · Aug 27 2021

Idea Summary
The Maximum Function within the Interactive Pivot Report option should apply to Varchar Columns as well. Currently it only supports number columns. 

Use Case
Suppose you have a list of people,language skills and language ratings  as shown in the image below. I'd like to be able to pivot the data using the Interactive Report Pivot Data functionality to display ratings per Employee and Language Skill as shown in the second table of the image below. This is currently not possible unless the Rating Column is of numeric type. 

This request is likely a duplicate of FR-2532.

Comments

Comments

  • mark stewart OP 3.8 years ago

    And how about DATE columns?  I've wanted to add that to several IR reports.  And SQL functions min and max both work for DATE columns.  The IR Aggregate pop-up won't list DATE columns.