Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
I am not too sure, but from the sound of your error it is not due to your date dimension .. it is more due to the fact that your are trying to include more than 1 dimension in your query. Looker forecasting only allows for 1 single dimension, here is a quote from the Looker docs:Include exactly one dimension, which must be a timeframe dimension, with dimension fill enabled. Sort your results by this timeframe dimension in descending order.If this is at all helpful, please feel free to reference the blog post I wrote on Looker forecasting here
Hello rrli, If the use case is you simply want 1 date filter modifying different date fields for different tiles .. have you tried modifying the “Tiles To Update” section of the Edit Filter section? You can create a generic filter field, or even repurpose an existing date field .. and just have Looker point that date filter to different fields for different tiles. This would be the simplest way to accomplish this. If you require multiple fields being filtered on the same tile with only 1 filter we can look into solving that with Parameters or Templated Filters. Let me know if this solves your issue.. if not im happy to discuss further.
Hello Pa1! I believe creating a separate dimension of type date_quarter is exactly what you are looking for. Something like the following: dimension: date_qtr { type: date_quarter sql: ${date_raw} ;; }This will return values in your desired output!
Hello JC, If I understand correctly, I believe this should provide the solution you are looking for. We can create hidden yesno dimensions that will filter on our selected dates which will allow us to create filtered measures where we are filtering for only our selected date by setting these yesno dimensions = “Yes”. Hope this helps! If not let me know and we can keep tackling. I believe this should be exactly or very close to the solution you are looking for! filter: selected_date { type: date_time } filter: selected_date_2 { type: date_time } dimension: hidden_selected_date { hidden: yes type: yesno sql: {% condition selected_date %} ${date} {% endcondition %} ;; } dimension: hidden_selected_date_2 { hidden: yes type: yesno sql: {% condition selected_date_2 %} ${date} {% endcondition %} ;; } measure: calculate_on_date_1 { type: number sql: safe_divide(${some_number}, ${another_number}) ;; filters: [hidden_selected_date: "Yes"] } measure: c
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.
