# Looker Liquid style

**URL:** https://community.omni.co/t/looker-liquid-style/164
**Category:** Modeling
**Tags:** calcs
**Created:** [October 18, 2024, 8:19am UTC](https://community.omni.co/t/looker-liquid-style/164 "2024-10-18T08:19:11Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Ben](https://avatars.discourse-cdn.com/v4/letter/b/df788c/32.png) [@Ben](https://community.omni.co/u/Ben)
#### Post date: [October 18, 2024, 8:19am UTC](https://community.omni.co/t/looker-liquid-style/164/1 "2024-10-18T08:19:11Z")

</div>

Hi  
How do I solve the problem in Omni that a measure is dependent on the dimensions selected?

So as an example:

The customer has selected the delivery month in his analysis.  
Then the correct math is: Value / number of hours remaining in the displayed month

The customer has selected quarter, then Value / number of hours remaining in the displayed quarter.

The customer has selected year, then Value / Number of hours remaining in the displayed year.

In Looker, I can use liquid in\_query to dynamically rewrite the SQL accordingly.  
How do I do that in Omni?

Thanks  
Ben

---

<div class="post-metadata">

### Author: ![Ben](https://avatars.discourse-cdn.com/v4/letter/b/df788c/32.png) [@Ben](https://community.omni.co/u/Ben)
#### Post date: [October 26, 2024, 5:59pm UTC](https://community.omni.co/t/looker-liquid-style/164/2 "2024-10-26T17:59:19Z")

</div>

I am frankly a little surprised.  
I wouldn’t have thought that in such a young community there wouldn’t be anyone who is familiar with the topic.  
Or that at least a product manager would jump in and answer the question…  
actually a shame…

---

<div class="post-metadata">

### Author: ![liam](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/liam/32/178_2.png) [@liam](https://community.omni.co/u/liam)
#### Post date: [October 31, 2024, 11:59am UTC](https://community.omni.co/t/looker-liquid-style/164/3 "2024-10-31T11:59:30Z")

</div>

Hey Ben - apologies for this slipping through the cracks. We have Slack channels with our customers that we actively support on these kind of questions, but we need to set up better alerting for us to see when questions come up here.

Omni also supports `in_query`. The syntax is slightly different - it would look like:

```auto
  case when {{ my_first_field.in_query }} then a/b
          when {{ my_other_field.in_query} then a/c
  end

```

Let us know if that’s what you were looking for