In a Looker table calculation custom expression you can compute the max or min value of a date time object using an expression like this:
max(
(100 * 100 * 100 * 100 * 100 * extract_years(${table.created_at})) +
(100 * 100 * 100 * 100 * extract_months(${table.created_at})) +
(100 * 100 * 100 * extract_days(${table.created_at})) +
(100 * 100 * extract_hours(${table.created_at})) +
(100 * extract_minutes(${table.created_at})) +
(extract_seconds(${table.created_at}))
To delegate effectively to a new team, you have to explain the following:
As the team grows and they learn how to do the work, it become sufficient and appropriate to explain only the first three bullet points. As the team further progresses, you can communicate the first 2 bullet points and the team will figure out what to do and how to do it. Finally, with high performing teams/individuals, you can provide context and the goal, and the team defines the rest.
| # Example Jira GraphQL API to fetch a Cloud ID, query for issues with JQL, and get issues with links, i.e. child issues | |
| # | |
| # Run this in https://developer.atlassian.com/platform/atlassian-graphql-api/graphql/explorer/ | |
| # | |
| # In the GraphQL explorer UI, at the bottom, add these Request Headers: | |
| # { | |
| # "X-ExperimentalApi" : "JiraIssueSearch" | |
| # } | |
| # | |
| query fetchCloudId { |
| // Given an element, select a range of text given a start and end character position offset relative | |
| // to the element's innerText, not counting any HTML markup in the element. | |
| // Partial credit: https://stackoverflow.com/questions/16662393/insert-html-into-text-node-with-javascript | |
| function injectMarkerIntoTextNode(node, startIndex) { | |
| // startIndex is beginning location of the text to inject a span | |
| let parentNode = node.parentNode; | |
| var s = node.nodeValue; | |
| var beforePart = s.substring(0, startIndex); |
I wanted to set the default title of new notes created via Cmd+N to be formatted like "2023-05-18 New", "2023-05-18 New 2", ...
I also wanted all new notes created via Cmd+N to go in the new folder.
Create a folder called e.g. new
In "Files & Links" settings, set "Folder to create new notes in" to new
Create a folder called e.g. templates and add a file called e.g. Default with this content:
| // Adds a "Page Results" button to a Blazer query and buttons to export (copy or download) results as JSON or CSV. | |
| // | |
| // To use this, open a Blazer query on the "Edit" page, open Chrome Dev Tools, paste all this code and hit Enter. | |
| // | |
| // When paging, the Blazer query must contain an expression like this that can be used to cursor through results: | |
| // | |
| // WHERE product.order_id >= 0 ORDER BY product.order_id LIMIT 100 | |
| // or: | |
| // WHERE agreements.id >= '00000000-0000-0000-0000-000000000000' ORDER BY agreements.id LIMIT 100 | |
| // |
Growth versus Productivity
When you're growing, you're not producing as much. When you're producing a lot, you're probably not learning as much. Invest in growth to expand the breadth and depth of what you can produce.
I'm an engineering manager. For engineers, context switching to check Slack is extremely expensive. I aim to minimize that expense!
I have very low expectations for quick response times on Slack. On the contrary, it puts my mind at ease when folks don't always respond immediately on Slack. Take time to craft a meaningful response. Stay focused on your own tasks or meetings, and respond only after you have a moment.
Slack is an asynchronous medium. I generally expect folks will respond to Slack messages at some point during the day, when they can.
99.999% of my Slack messages are not urgent, even when I use @ mentions.
We filled out character sheets at Elastic as a team building exercise. I wrote this in 2022. I figured I'd work in the open and share it with the world.
Richard Kuzsma. Last name is pronounced "Kooz-mah".