sorting by percentage

i have a table insight that summarizes the total sales by store formatted as percentage.  i would like to sort the table by the total percentage descending.  How do i do this ?

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Dustin Basil , can you help?

    Reply Like
    • Hi amy yoste , which version of Incorta are you using and is it a flat table? If you are using v4.3.x and it is a flat table, you have the option to add the following setting to the engine.properties file:

      engine.allow_formula_sorting_in_flat_table = true

      This parameter is false by default due to its performance implications. Ideally the calculation would be persisted as a formula column in the physical schema for best performance. 



      Reply Like
    • Dustin Basil  we are on version 4.2.4.  Also this is an aggregated table insight with the scale set to percentage rather than a schema.  

      Reply Like
    • amy yoste Please open a ticket with Support as they can manage linking your issue to a specific enhancement request. https://support.incorta.com/hc/en-us/articles/360000840152-How-to-Submit-a-Ticket

      Reply Like
Like Follow
  • 2 wk agoLast active
  • 4Replies
  • 27Views
  • 2 Following


Welcome to Incorta's user community! Whether you are already an Incorta customer, or interested in becoming one, this is your place to come together and discuss the software, register for webinars, learn about events, learn about new product releases and get support from the community. 

Looking for Product Documentation?