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.