Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

chart of faceted search based on aggregate function not the rows

wucisDec 6 2023

The chart accompanying a faceted search displays normally the amount of rows.
Is it possible, that the chart is based on the sum of a column ( or more columns ).
It is assumed, that the respective columns are numbers.

Example:
Based on the emp table, when selecting in a faceted search from the Job, Salesman(4) and Manager(3),
the chart displays 2 bars, first the Salesman with value 4 and Manager with value 3.
I would like to have the chart displaying first Manager with value 8275 ( the sum of their sal ) and second
the Salesman with value 5600.
An extended version could sum up more than 1 column, here e.g. the columns sal and comm so the value
of the Salesman would be respectively 7800 ( sum of their sal and comm ).

Comments
Post Details
Added on Dec 6 2023
0 comments
348 views