Last tested: Dec 19, 2019
In Table Next, you can freely drag columns around in the visualization.
In Table Legacy, the order of the visualization is dependent on the order of the columns in the data table. You can drag the columns to change the order of the series. However, you can't drag between different types of columns.
It's true that you can't drag columns between different types of columns. There are 4 main types of columns:
You can freely drag columns that are the same type between other columns of the same type.
Thus, a workaround for reorganizing any column is to make all desired fields into "green measures"!
${measure}
This content is subject to limited support.
So, to display a calculated number on a dashboard you need to first convert every other column into a green measure? Because the “single number” visualization only takes the first column.
This is a lot of time for something simple. Maybe the single number visualization could have an option for which column it is visualizing.
Hey @felixhelix !
For the use case of displaying one particular number for a single number visualization, I recommend using the “hide from visualization” option instead. You can hide every other field except for the one you want to show.
This is still cumbersome if there are a lot of fields, but definitely easier than creating a green measure for each measure.
Hey @felixhelix !
For the use case of displaying one particular number for a single number visualization, I recommend using the “hide from visualization” option instead. You can hide every other field except for the one you want to show.
This is still cumbersome if there are a lot of fields, but definitely easier than creating a green measure for each measure.
That’s a good tip thank you!
@sam8 : Thanks for the tip. Any help on below would be highly appreciated 🙂
How would we apply sorting in a drill window in a dashboard? Below window appears when user clicks on a single value Total visual
Below is a sample drill window. How would we apply sorting on Year, Quarter dimensions? Is there a way to add it in LookML. Tried order_by_field it doesn't seem to work.
Also, in the drill window - is it possible to add a percentage column which should be based on the total/year and not the complete total?
Lastly, is there a way to add sorting for the filters on dashboard? I have a calendar quarter filter with values like 2018Q1,2018Q2,2018Q3,2018Q4,2019Q1 so on. Its sorted in ascending order by default. I would like to change it to descending. Is it possible?