LinkedIn
Twitter
Can I set colors (or apply other custom formatting) in my bar chart based on a measure’s value?
Here is a simple example generated in Excel. There is a red reference line at 130. All the measure values greater than it are dark green and the bars below it are a lighter green.
I like how I can use the “html” parameter to apply conditional formatting to measures. But can I do the same for these measures in the visualization?
Thanks!
You could potentially use the pattern below, if you don’t have too many buckets.
Imagine I’m looking at user count per state and I want to break out states with 300+ users. Select the dimension & measure and run the query.
Now, create two (or more) table calculations:
if(${users.count} >= 300, ${users.count}, null)
and:
if(${users.count} < 300, ${users.count}, null)
Hide the original measure, and go into viz settings and stack them. This will remove the extra whitespace between the two table calc series. Add a trend line if you like.
The end result should look like this:
Hey @jkassof ,
We could do what Brecht has suggested using measures instead of tablecalcs- then we can define drills in those measures.
We’ll want to create two measures with CASE WHENs in the sql parameter, like so:
measure: count_g_500 {
type: number
sql: CASE WHEN ${count} > 500 THEN ${count} ELSE NULL END;;
drill_fields:
}
measure: count_l_500 {
type: number
sql: CASE WHEN ${count} <= 500 THEN ${count} ELSE NULL END ;;
drill_fields:
}
Here’s an example of what this looks like in the explore:
This approach will preserve drilling into the vis!
Cheers,
Adina
Hi @adina_katz,
This is a good idea however I have always had issues with drilling into measures that use CASE WHEN. I usually have to revert to this:
If a measure is being drilled into and outputting incorrect information, this could be due to a CASE WHEN statement in your measure. Let’s say we want a measure that counts how many companies have exactly 13 employees. We could create a measure that includes a CASE WHEN statement in the sql parameter. For example,New LookML
measure: count_employees_thirteen { type: count_distinct sql: CASE WHEN ${number_of_employees} = 13 THEN ${company_id} ELSE NULL END ;; drill_fields: [comp…
Can you confirm that drilling on this works because it is a number possible instead of an aggregation?
Thank you,
Drew
