0

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. 

      Thanks,

      Dustin

      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
  • Status Answered
  • 6 mths agoLast active
  • 4Replies
  • 50Views
  • 2 Following