# Workbooks **URL:** https://community.omni.co/c/workbooks/7.md?page=1 [Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md) **Page:** 2 --- ## [How do I include a comma in my filter value? (e.g. "San Francisco, CA")](https://community.omni.co/t/how-do-i-include-a-comma-in-my-filter-value-e-g-san-francisco-ca/79)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 30, 2024, 7:48pm UTC](https://community.omni.co/t/how-do-i-include-a-comma-in-my-filter-value-e-g-san-francisco-ca/79 "2024-05-30T19:48:03Z")
By default, Omni will delimit filter entries using commas — so typing San Francisco, CA will split into San Francisco and CA. To explicitly include a comma in a filter, you can “escape” the comma with a \\, e.g. you woul… --- ## [Grouped Running Totals](https://community.omni.co/t/grouped-running-totals/63)
**Author:** [@colin](https://community.omni.co/u/colin)\ **Replies:** 0\ **Last updated:** [May 15, 2024, 5:22pm UTC](https://community.omni.co/t/grouped-running-totals/63 "2024-05-15T17:22:39Z")
Running totals are one of the most common reporting use cases, but can be tricky when exploring across multiple dimensions. This article presents a quick pattern for running totals inside sub-groups, with and without pi… --- ## [How can I unnest my JSON data?](https://community.omni.co/t/how-can-i-unnest-my-json-data/51)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [May 2, 2024, 11:25pm UTC](https://community.omni.co/t/how-can-i-unnest-my-json-data/51 "2024-05-02T23:25:54Z")
When you want to unnest JSON data in Omni, you can scroll to the far right of the cell you want to unnest and click the three dots. You’ll see an option there to “Create Fields From Json” Once you click that, you’ll … --- ## [How can I add a filter on just one column / measure? (filtered measure)](https://community.omni.co/t/how-can-i-add-a-filter-on-just-one-column-measure-filtered-measure/31)
**Author:** [@anika](https://community.omni.co/u/anika)\ **Replies:** 0\ **Last updated:** [April 5, 2024, 10:05pm UTC](https://community.omni.co/t/how-can-i-add-a-filter-on-just-one-column-measure-filtered-measure/31 "2024-04-05T22:05:04Z")
To apply a filter to one but not all measures in a given query, you can use a filtered measure. There are two easy ways to create a filtered measure from the UI: Create a query with the measure you’d like to filter, … --- ## [How do I see the raw SQL that Omni is running in my database?](https://community.omni.co/t/how-do-i-see-the-raw-sql-that-omni-is-running-in-my-database/41)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 18, 2024, 9:27pm UTC](https://community.omni.co/t/how-do-i-see-the-raw-sql-that-omni-is-running-in-my-database/41 "2024-04-18T21:27:06Z")
At its core, Omni is writing SQL down to your database and returning the results. If you’re ever curious to see the SQL, want to reuse it in other ways, or run the SQL directly in your database to check results, you can … --- ## [How does the 50K limit on rows work?](https://community.omni.co/t/how-does-the-50k-limit-on-rows-work/28)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 2, 2024, 5:41pm UTC](https://community.omni.co/t/how-does-the-50k-limit-on-rows-work/28 "2024-04-02T17:41:37Z")
Omni currently has a 50k row limit, meaning we can display up to 50,000 rows in your workbook. Result sets and tables can be paginated to flip through all possible results. By default, Omni only displays the first 1,000 … [Previous page](https://community.omni.co/c/workbooks/7.md)