Hi I'm using Apex 23.1 and I have the following question regarding faceted search page:
It seems that by default, when creating a facet, for example customer or product, Apex will show you the customers or product along with a count, so again if i have, let us say ten customer it will show those ten customers along with the current count given the conditions set in all the facets available on the page. This is ok, but seems we are talking about sum sales here, how can I use those sum sales instead of counts? This is particularly important when you select the show chart option associated with the facet, you want to see the sales figures in the graph instead of the counts.
I see there is a list of values section and you can use a query here and I'm aware it might not be practical.
Any help or feedback will be greatly appreciated!