Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
When we sort chronologically - it starts with January - DecemberHow can we sort so that the first row is always the current month, like in this screenshot: Sort starts on July (article written on 7/15/2021) We can sort on a table calculation (which we will hide from the visualization so it doesn’t get plotted) If the month column’s value > current month (ex. Row 2, August > July evaluates to true)we'd take the month_num and subtract the current month value (8 - 7)If not, we would add them (ex. Row 9, March > July evaluates to false, we’ll take 3 + 7)The table calc syntax looks something like this:if( ${orders.order_month_num} >= extract_months(now()), ${orders.order_month_num} - extract_months(now()), ${orders.order_month_num} + extract_months(now()) )
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
