set_visual_sort
Set an existing visual's sort order by a field, ascending or descending, so top performers lead and blank rows fall to the bottom.
Instructions
Set the SORT ORDER of an EXISTING visual (table/matrix/chart): order its query by a field, asc or desc. kind=column|measure. Use descending=true to sort a ranking by sales/value so the top performers lead and blank-rank/zero rows fall to the bottom (the fix for 'blanks at the top'). The field should be one already shown in the visual.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | No | column|measure | measure |
| field | Yes | field (column or measure) to sort by | |
| table | Yes | table that owns the sort field | |
| pageName | Yes | ||
| descending | No | true = descending (largest first), false = ascending | |
| visualName | Yes | ||
| reportSessionId | Yes |