This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,I’m able to apply conditional format for empty values but I could not
able to apply the conditional format for NULL values. Can you please
help me out on how to implement this.Question: NULL values should be
appeared in red color for Zip column?Be<!-- --><!-- -->...
Hi,I wanted to import all the dashboard names and dashboard folder name
and Dashboard URL into a spreadsheet. Can you please suggest how can we
do that.Format:Dashboard Folder name Dashboard Name Dashboard URL
Developer Name
I want to write a dimension with adding text values and date with
MM/DD/YYYY formateg: Result for: 2022/11/05 dimension: resultfor { type:
string sql: 'Result For : ' || ${admin_dt_date} ;; html:{<!-- -->{
rendered_value | date: "%m/%d/%Y" }};; }Result is sh...
I want to write a dimension with adding text values and date with
MM/DD/YYYY formateg: Result for: 2022/11/05 dimension: resultfor { type:
string sql: 'Result For : ' || ${admin_dt_date} ;; html:{<!-- -->{
rendered_value | date: "%m/%d/%Y" }};; }Result is sh...
Hi mr_joel, I noticed your discussion about the issue you're facing, and
I'm experiencing something similar. Have you found any solutions or
workarounds yet?
Thank you all for answering my questions/doubts.conditional format is
not allowed for NULL (∅) and special characters in LOOKML. We need to
convert them into text or empty.Note: empty and null (∅) is different
valuesBelow syntax is working fine. dime<!-- --><!-- -->...
We can use sorting the values in lookml. You can refer the below
syntax.Add order_field_by : sortable ( at the existing
dimension)dimension: sortable { type: number sql: case when
TRIM(${grade_level}) = 'K' then 0 when TRIM(${grade_level})= '1' then ...
Hi Krishna and other folks,If you look at the snapshot on the above.
There was a dimension column name "City" in this we have "_ _" (special
character) values available.I want to put the conditional format for
these values (Null, _ _) using html,I wa<!-- --><!-- -->...
