Sort on percent

I have two columns in an answer - User and Percent. I am trying to force a descending sort on the 'percent' column. I am using the TS: BI Server worksheet to create usage statistics.

I am using this percent formula to display the percentage: concat(to_string(round(count ( user action ) / group_count( month (timestamp))*100,0.01)),'%')

I suspect that ThoughtSpot is holding onto the 'month' context as each 'count(user action)' is within the context of a month timestamp.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 1 mth agoLast active
  • 16Views
  • 1 Following