- ID de exploración:
- 6a712342-5e53-4444-ba91-456497e24e92Finalizado
- URL enviada:
- https://openrefine.org/docs/manual/facets
- Informe finalizado:
Enlaces: 10 encontrados
Los enlaces salientes identificados en la página
| Enlace | Texto |
|---|---|
| https://github.com/OpenRefine/ | GitHub |
| https://w.wiki/3Em | 10 most populous cities from Wikidata |
| http://wiki.stat.ucla.edu/socr/index.php/SOCR_Data_Brain2BodyWeight | this data about the body weight of various mammals |
| https://en.wikipedia.org/wiki/List_of_Unicode_characters | Unicode decimal values |
| https://github.com/OpenRefine/openrefine.github.com/edit/master/docs/manual/facets.md | Edit this page |
| https://github.com/OpenRefine | GitHub |
| https://gitter.im/OpenRefine/OpenRefine | Gitter chat |
| https://twitter.com/openrefine | |
| https://fosstodon.org/@OpenRefine | Mastodon |
| http://creativecommons.org/licenses/by/4.0/ | Creative Commons Attribution 4.0 International License |
Variables JavaScript: 6 encontradas
Las variables JavaScript globales cargadas en el objeto de ventana de una página son variables declaradas fuera de las funciones y a las que se puede acceder desde cualquier lugar del código en el ámbito actual
| Nombre | Tipo |
|---|---|
| onbeforetoggle | object |
| documentPictureInPicture | object |
| onscrollend | object |
| webpackChunkOpenRefine_Documentation | object |
| docusaurus | object |
| docusaurusRoot | object |
Mensajes de registro de la consola: 0 encontrados
Mensajes registrados en la consola web
HTML
El cuerpo HTML sin procesar de la página
<!DOCTYPE html><html lang="en" dir="ltr" class="docs-wrapper plugin-docs plugin-id-default docs-version-current docs-doc-page docs-doc-id-manual/facets" data-has-hydrated="true" data-theme="light" data-rh="lang,dir,class,data-has-hydrated"><head>
<meta charset="UTF-8">
<meta name="generator" content="Docusaurus v3.3.2">
<title>Exploring facets | OpenRefine</title><meta data-rh="true" name="twitter:card" content="summary_large_image"><meta data-rh="true" property="og:url" content="https://openrefine.org/docs/manual/facets"><meta data-rh="true" property="og:locale" content="en"><meta data-rh="true" name="docusaurus_locale" content="en"><meta data-rh="true" name="docsearch:language" content="en"><meta data-rh="true" name="docusaurus_version" content="current"><meta data-rh="true" name="docusaurus_tag" content="docs-default-current"><meta data-rh="true" name="docsearch:version" content="current"><meta data-rh="true" name="docsearch:docusaurus_tag" content="docs-default-current"><meta data-rh="true" property="og:title" content="Exploring facets | OpenRefine"><meta data-rh="true" name="description" content="Overview"><meta data-rh="true" property="og:description" content="Overview"><link data-rh="true" rel="icon" href="/img/openrefine_logo.svg"><link data-rh="true" rel="canonical" href="https://openrefine.org/docs/manual/facets"><link data-rh="true" rel="alternate" href="https://openrefine.org/docs/manual/facets" hreflang="en"><link data-rh="true" rel="alternate" href="https://openrefine.org/docs/manual/facets" hreflang="x-default"><link data-rh="true" rel="preconnect" href="https://RXJKLJKJU2-dsn.algolia.net" crossorigin="anonymous"><link rel="alternate" type="application/rss+xml" href="/blog/rss.xml" title="OpenRefine RSS Feed">
<link rel="alternate" type="application/atom+xml" href="/blog/atom.xml" title="OpenRefine Atom Feed">
<link rel="search" type="application/opensearchdescription+xml" title="OpenRefine" href="/opensearch.xml">
<script src="/js/fix-location.js"></script><link rel="stylesheet" href="/assets/css/styles.37238636.css">
<script src="/assets/js/runtime~main.a27155b5.js" defer="defer"></script>
<script src="/assets/js/main.2873c74a.js" defer="defer"></script>
<meta name="viewport" content="width=device-width, initial-scale=1.0" data-rh="true"><link rel="prefetch" href="/assets/js/1df93b7f.ca81983c.js"><link rel="prefetch" href="/assets/js/a7456010.6e143478.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/a88b5783.6490ba69.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/d4d19352.a733f477.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/f85f2bd6.53584e69.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/bec1e1ca.2e06452c.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/4b21b167.86df667c.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/43e74644.02849070.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/5989e03e.1ecf48cc.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/5e95c892.1986c48e.js"><link rel="prefetch" href="/assets/js/aba21aa0.de85c49d.js"><link rel="prefetch" href="/assets/js/a7bd4aaa.9959944c.js"><link rel="prefetch" href="/assets/js/7c110bd0.ae638c52.js"><link rel="prefetch" href="/assets/js/a94703ab.52b993f0.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/c377a04b.58c560c7.js"><link rel="prefetch" href="/assets/js/17896441.9d82feeb.js"><link rel="prefetch" href="/assets/js/a8d4ce69.3be48cde.js"></head>
<body class="navigation-with-keyboard" data-rh="class" style="overflow: visible;">
<script>!function(){function t(t){document.documentElement.setAttribute("data-theme",t)}var e=function(){try{return new URLSearchParams(window.location.search).get("docusaurus-theme")}catch(t){}}()||function(){try{return localStorage.getItem("theme")}catch(t){}}();t(null!==e?e:"light")}(),function(){try{const c=new URLSearchParams(window.location.search).entries();for(var[t,e]of c)if(t.startsWith("docusaurus-data-")){var a=t.replace("docusaurus-data-","data-");document.documentElement.setAttribute(a,e)}}catch(t){}}()</script><div id="__docusaurus"><div role="region" aria-label="Skip to main content"><a class="skipToContent_PQXo" href="#__docusaurus_skipToContent_fallback">Skip to main content</a></div><nav aria-label="Main" class="navbar navbar--fixed-top"><div class="navbar__inner"><div class="navbar__items"><button aria-label="Toggle navigation bar" aria-expanded="false" class="navbar__toggle clean-btn" type="button"><svg width="30" height="30" viewBox="0 0 30 30" aria-hidden="true"><path stroke="currentColor" stroke-linecap="round" stroke-miterlimit="10" stroke-width="2" d="M4 7h22M4 15h22M4 23h22"></path></svg></button><a class="navbar__brand" href="/"><div class="navbar__logo"><img src="/img/openrefine_logo.svg" alt="OpenRefine diamond logo" class="themedComponent_C793 themedComponent--light_p_FH"></div><b class="navbar__title text--truncate">OpenRefine</b></a><a class="navbar__item navbar__link" href="/download">Download</a><a aria-current="page" class="navbar__item navbar__link navbar__link--active" href="/docs">Documentation</a><a class="navbar__item navbar__link" href="/community">Community</a><a class="navbar__item navbar__link" href="/blog">Blog</a></div><div class="navbar__items navbar__items--right"><a class="navbar__item navbar__link" href="/donate">Donate</a><a href="https://forum.openrefine.org/" target="_blank" rel="noopener noreferrer" class="navbar__item navbar__link">Forum</a><a href="https://github.com/OpenRefine/" target="_blank" rel="noopener noreferrer" class="navbar__item navbar__link">GitHub<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_SaMF"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a><div class="toggle_BWXw colorModeToggle_PJ6U"><button class="clean-btn toggleButton_cDH6" type="button" title="Switch between dark and light mode (currently light mode)" aria-label="Switch between dark and light mode (currently light mode)" aria-live="polite"><svg viewBox="0 0 24 24" width="24" height="24" class="lightToggleIcon_G7R4"><path fill="currentColor" d="M12,9c1.65,0,3,1.35,3,3s-1.35,3-3,3s-3-1.35-3-3S10.35,9,12,9 M12,7c-2.76,0-5,2.24-5,5s2.24,5,5,5s5-2.24,5-5 S14.76,7,12,7L12,7z M2,13l2,0c0.55,0,1-0.45,1-1s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S1.45,13,2,13z M20,13l2,0c0.55,0,1-0.45,1-1 s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S19.45,13,20,13z M11,2v2c0,0.55,0.45,1,1,1s1-0.45,1-1V2c0-0.55-0.45-1-1-1S11,1.45,11,2z M11,20v2c0,0.55,0.45,1,1,1s1-0.45,1-1v-2c0-0.55-0.45-1-1-1C11.45,19,11,19.45,11,20z M5.99,4.58c-0.39-0.39-1.03-0.39-1.41,0 c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0s0.39-1.03,0-1.41L5.99,4.58z M18.36,16.95 c-0.39-0.39-1.03-0.39-1.41,0c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0c0.39-0.39,0.39-1.03,0-1.41 L18.36,16.95z M19.42,5.99c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06c-0.39,0.39-0.39,1.03,0,1.41 s1.03,0.39,1.41,0L19.42,5.99z M7.05,18.36c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06 c-0.39,0.39-0.39,1.03,0,1.41s1.03,0.39,1.41,0L7.05,18.36z"></path></svg><svg viewBox="0 0 24 24" width="24" height="24" class="darkToggleIcon_VYnE"><path fill="currentColor" d="M9.37,5.51C9.19,6.15,9.1,6.82,9.1,7.5c0,4.08,3.32,7.4,7.4,7.4c0.68,0,1.35-0.09,1.99-0.27C17.45,17.19,14.93,19,12,19 c-3.86,0-7-3.14-7-7C5,9.07,6.81,6.55,9.37,5.51z M12,3c-4.97,0-9,4.03-9,9s4.03,9,9,9s9-4.03,9-9c0-0.46-0.04-0.92-0.1-1.36 c-0.98,1.37-2.58,2.26-4.4,2.26c-2.98,0-5.4-2.42-5.4-5.4c0-1.81,0.89-3.42,2.26-4.4C12.92,3.04,12.46,3,12,3L12,3z"></path></svg></button></div><div class="navbarSearchContainer_UScB"><button type="button" class="DocSearch DocSearch-Button" aria-label="Search"><span class="DocSearch-Button-Container"><svg width="20" height="20" class="DocSearch-Search-Icon" viewBox="0 0 20 20"><path d="M14.386 14.386l4.0877 4.0877-4.0877-4.0877c-2.9418 2.9419-7.7115 2.9419-10.6533 0-2.9419-2.9418-2.9419-7.7115 0-10.6533 2.9418-2.9419 7.7115-2.9419 10.6533 0 2.9419 2.9418 2.9419 7.7115 0 10.6533z" stroke="currentColor" fill="none" fill-rule="evenodd" stroke-linecap="round" stroke-linejoin="round"></path></svg><span class="DocSearch-Button-Placeholder">Search</span></span><span class="DocSearch-Button-Keys"><kbd class="DocSearch-Button-Key"><svg width="15" height="15" class="DocSearch-Control-Key-Icon"><path d="M4.505 4.496h2M5.505 5.496v5M8.216 4.496l.055 5.993M10 7.5c.333.333.5.667.5 1v2M12.326 4.5v5.996M8.384 4.496c1.674 0 2.116 0 2.116 1.5s-.442 1.5-2.116 1.5M3.205 9.303c-.09.448-.277 1.21-1.241 1.203C1 10.5.5 9.513.5 8V7c0-1.57.5-2.5 1.464-2.494.964.006 1.134.598 1.24 1.342M12.553 10.5h1.953" stroke-width="1.2" stroke="currentColor" fill="none" stroke-linecap="square"></path></svg></kbd><kbd class="DocSearch-Button-Key">K</kbd></span></button></div></div></div><div role="presentation" class="navbar-sidebar__backdrop"></div><div class="navbar-sidebar"><div class="navbar-sidebar__brand"><a class="navbar__brand" href="/"><div class="navbar__logo"><img src="/img/openrefine_logo.svg" alt="OpenRefine diamond logo" class="themedComponent_C793 themedComponent--light_p_FH"></div><b class="navbar__title text--truncate">OpenRefine</b></a><div class="toggle_BWXw margin-right--md"><button class="clean-btn toggleButton_cDH6" type="button" title="Switch between dark and light mode (currently light mode)" aria-label="Switch between dark and light mode (currently light mode)" aria-live="polite"><svg viewBox="0 0 24 24" width="24" height="24" class="lightToggleIcon_G7R4"><path fill="currentColor" d="M12,9c1.65,0,3,1.35,3,3s-1.35,3-3,3s-3-1.35-3-3S10.35,9,12,9 M12,7c-2.76,0-5,2.24-5,5s2.24,5,5,5s5-2.24,5-5 S14.76,7,12,7L12,7z M2,13l2,0c0.55,0,1-0.45,1-1s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S1.45,13,2,13z M20,13l2,0c0.55,0,1-0.45,1-1 s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S19.45,13,20,13z M11,2v2c0,0.55,0.45,1,1,1s1-0.45,1-1V2c0-0.55-0.45-1-1-1S11,1.45,11,2z M11,20v2c0,0.55,0.45,1,1,1s1-0.45,1-1v-2c0-0.55-0.45-1-1-1C11.45,19,11,19.45,11,20z M5.99,4.58c-0.39-0.39-1.03-0.39-1.41,0 c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0s0.39-1.03,0-1.41L5.99,4.58z M18.36,16.95 c-0.39-0.39-1.03-0.39-1.41,0c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0c0.39-0.39,0.39-1.03,0-1.41 L18.36,16.95z M19.42,5.99c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06c-0.39,0.39-0.39,1.03,0,1.41 s1.03,0.39,1.41,0L19.42,5.99z M7.05,18.36c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06 c-0.39,0.39-0.39,1.03,0,1.41s1.03,0.39,1.41,0L7.05,18.36z"></path></svg><svg viewBox="0 0 24 24" width="24" height="24" class="darkToggleIcon_VYnE"><path fill="currentColor" d="M9.37,5.51C9.19,6.15,9.1,6.82,9.1,7.5c0,4.08,3.32,7.4,7.4,7.4c0.68,0,1.35-0.09,1.99-0.27C17.45,17.19,14.93,19,12,19 c-3.86,0-7-3.14-7-7C5,9.07,6.81,6.55,9.37,5.51z M12,3c-4.97,0-9,4.03-9,9s4.03,9,9,9s9-4.03,9-9c0-0.46-0.04-0.92-0.1-1.36 c-0.98,1.37-2.58,2.26-4.4,2.26c-2.98,0-5.4-2.42-5.4-5.4c0-1.81,0.89-3.42,2.26-4.4C12.92,3.04,12.46,3,12,3L12,3z"></path></svg></button></div><button type="button" aria-label="Close navigation bar" class="clean-btn navbar-sidebar__close"><svg viewBox="0 0 15 15" width="21" height="21"><g stroke="var(--ifm-color-emphasis-600)" stroke-width="1.2"><path d="M.75.75l13.5 13.5M14.25.75L.75 14.25"></path></g></svg></button></div><div class="navbar-sidebar__items navbar-sidebar__items--show-secondary"><div class="navbar-sidebar__item menu"><ul class="menu__list"><li class="menu__list-item"><a class="menu__link" href="/download">Download</a></li><li class="menu__list-item"><a aria-current="page" class="menu__link menu__link--active" href="/docs">Documentation</a></li><li class="menu__list-item"><a class="menu__link" href="/community">Community</a></li><li class="menu__list-item"><a class="menu__link" href="/blog">Blog</a></li><li class="menu__list-item"><a class="menu__link" href="/donate">Donate</a></li><li class="menu__list-item"><a href="https://forum.openrefine.org/" target="_blank" rel="noopener noreferrer" class="menu__link">Forum</a></li><li class="menu__list-item"><a href="https://github.com/OpenRefine/" target="_blank" rel="noopener noreferrer" class="menu__link">GitHub<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_SaMF"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li></ul></div><div class="navbar-sidebar__item menu"><button type="button" class="clean-btn navbar-sidebar__back">← Back to main menu</button><ul class="theme-doc-sidebar-menu menu__list"><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class="menu__list-item-collapsible"><a href="#" class="menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" role="button" aria-expanded="true">User Manual</a></div><ul class="menu__list" style="display: block; overflow: visible; height: auto;"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs">Introduction</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/manual/installing">Installing</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/manual/running">Running</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/manual/starting">Starting a project</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item"><div class="menu__list-item-collapsible"><a href="#" class="menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" role="button" aria-expanded="true" tabindex="0">Exploring data</a></div><ul class="menu__list" style="display: block; overflow: visible; height: auto;"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/manual/exploring">Overview</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link menu__link--active" aria-current="page" tabindex="0" href="/docs/manual/facets">Facets</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/manual/sortview">Sort and view</a></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a href="#" class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" tabindex="0">Transforming data</a></div></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/manual/reconciling">Reconciling</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a href="#" class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" tabindex="0">Wikibase, Wikidata and Wikimedia Commons</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a href="#" class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" tabindex="0">Expressions</a></div></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/manual/exporting">Exporting</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/manual/troubleshooting">Troubleshooting</a></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a href="#" class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false">Contributing to OpenRefine</a></div></li></ul></div></div></div></nav><div id="__docusaurus_skipToContent_fallback" class="main-wrapper mainWrapper_Qxr5"><div class="docsWrapper_EgR_"><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_dgj1" type="button"></button><div class="docRoot_UI1O"><aside class="theme-doc-sidebar-container docSidebarContainer_ocMT"><div class="sidebarViewport_XfnG"></div></aside><main class="docMainContainer_paPW"><div class="container padding-top--md padding-bottom--lg"><div class="row"><div class="col docItemCol_bd2u"><div class="docItemContainer_q0M9"><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_v87d" aria-label="Breadcrumbs"><ul class="breadcrumbs" itemscope="" itemtype="https://schema.org/BreadcrumbList"><li class="breadcrumbs__item"><a aria-label="Home page" class="breadcrumbs__link" href="/"><svg viewBox="0 0 24 24" class="breadcrumbHomeIcon_oiB6"><path d="M10 19v-5h4v5c0 .55.45 1 1 1h3c.55 0 1-.45 1-1v-7h1.7c.46 0 .68-.57.33-.87L12.67 3.6c-.38-.34-.96-.34-1.34 0l-8.36 7.53c-.34.3-.13.87.33.87H5v7c0 .55.45 1 1 1h3c.55 0 1-.45 1-1z" fill="currentColor"></path></svg></a></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">User Manual</span><meta itemprop="position" content="1"></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">Exploring data</span><meta itemprop="position" content="2"></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item breadcrumbs__item--active"><span class="breadcrumbs__link" itemprop="name">Facets</span><meta itemprop="position" content="3"></li></ul></nav><div class="tocCollapsible_Dhhg theme-doc-toc-mobile tocMobile_btq4"><button type="button" class="clean-btn tocCollapsibleButton_axQu">On this page</button></div><div class="theme-doc-markdown markdown"><header><h1>Exploring facets</h1></header><h2 class="anchor anchorWithStickyNavbar_SRsa" id="overview">Overview<a href="#overview" class="hash-link" aria-label="Direct link to Overview" title="Direct link to Overview"></a></h2>
<p>Facets are one of OpenRefine’s strongest features - that’s where the diamond logo comes from!</p>
<p>Faceting allows you to look for patterns and trends. Facets are essentially aspects or angles of data variance in a given column. For example, if you had survey data where respondents indicated one of five responses from “Strongly agree” to “Strongly disagree,” those five responses make up a text facet, showing how many people selected each option.</p>
<p>Faceted browsing gives you a big-picture look at your data (do they agree or disagree?) and also allows you to filter down to a specific subset to explore it more (what do people who disagree say in other responses?).</p>
<p>Typically, you create a facet on a particular column. That facet selection appears on the left, in the <span class="tabLabels">Facet/Filter</span> tab, and you can click on a displayed facet to view all the records that match. You can also “exclude” the facet, to view every record that does <em>not</em> match, and you can select more than one facet by clicking “include.”</p>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="an-example">An example<a href="#an-example" class="hash-link" aria-label="Direct link to An example" title="Direct link to An example"></a></h3>
<p>You can learn about facets and filtering with the following example. You can copy the following table and paste it using the <span class="menuItems">Clipboard</span> method of starting a project if you would like to try it yourself. Check the "Attempt to parse cell text into numbers" option so that you can use numeric faceting.</p>
<p>We collected a list of the <a href="https://w.wiki/3Em" target="_blank" rel="noopener noreferrer">10 most populous cities from Wikidata</a>, using an example query of theirs. We removed the GPS coordinates and added the country.</p>
<table><thead><tr><th>cityLabel</th><th>population</th><th>countryLabel</th></tr></thead><tbody><tr><td>Shanghai</td><td>23390000</td><td>People's Republic of China</td></tr><tr><td>Beijing</td><td>21710000</td><td>People's Republic of China</td></tr><tr><td>Lagos</td><td>21324000</td><td>Nigeria</td></tr><tr><td>Dhaka</td><td>16800000</td><td>Bangladesh</td></tr><tr><td>Mumbai</td><td>15414288</td><td>India</td></tr><tr><td>Istanbul</td><td>14657434</td><td>Turkey</td></tr><tr><td>Tokyo</td><td>13942856</td><td>Japan</td></tr><tr><td>Tianjin</td><td>13245000</td><td>People's Republic of China</td></tr><tr><td>Guangzhou</td><td>13080500</td><td>People's Republic of China</td></tr><tr><td>São Paulo</td><td>12106920</td><td>Brazil</td></tr></tbody></table>
<p>If we want to see which countries have the most populous cities, we can create a text facet on the “countryLabel” column and OpenRefine will generate a list of all the different strings used in these cells.</p>
<p>We will see in the sidebar that the countries identified are displayed, along with the number of matches (the “count”). We can sort this list alphabetically or by the count. If you sort by count at the top of the facet window, you’ll learn which countries hold the most populous cities.</p>
<table><thead><tr><th>Facet</th><th>Count</th></tr></thead><tbody><tr><td>People's Republic of China</td><td>4</td></tr><tr><td>Bangladesh</td><td>1</td></tr><tr><td>Brazil</td><td>1</td></tr><tr><td>India</td><td>1</td></tr><tr><td>Japan</td><td>1</td></tr><tr><td>Nigeria</td><td>1</td></tr><tr><td>Turkey</td><td>1</td></tr></tbody></table>
<p>If we want to learn more about a particular country, we can click on its appearance in the facet sidebar. This narrows our dataset down temporarily to only rows matching that facet.</p>
<p>You’ll see the “10 rows” indicator change to “4 matching rows (10 total)” if you click on “People’s Republic of China”. In the data grid, you’ll see fewer rows: only the ones matching your current filter. Each row will maintain its original numbering, though - in this case, rows #1, 2, and 8.</p>
<p>If you want to go back to the original dataset, click <span class="buttonLabels">Reset All</span> or the small “exclude” text next to the facet. If you want to view the most populous cities in both China and India, click “include” next to each facet. Now you’ll see 5 rows - #1, 2, 5, 8, 9.</p>
<p>We can also explore our data using the population information. In this case, because population is a number, we can create a numeric facet. This will give us the ability to explore by range rather than by exact matching values.</p>
<p>With the numeric facet, we are given a scale from the smallest to the largest value in the column. We can drag the range minimum and maximum to narrow the results. In this case, if we narrow down to only cities with more than 20 million in population, we get 3 matching rows out of the original 10.</p>
<p>When you look back at the text facet display of country names, you should see a smaller list with a reduced count: OpenRefine is now displaying the facets of the 3 matching rows, not the total dataset of 10 rows.</p>
<p>We can combine these facets - say, by narrowing to only the Chinese cities with populations greater than 20 million - simply by clicking in both. You should see 2 matching rows for both these criteria.</p>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="things-to-know-about-facets">Things to know about facets<a href="#things-to-know-about-facets" class="hash-link" aria-label="Direct link to Things to know about facets" title="Direct link to Things to know about facets"></a></h3>
<p>When you have facets applied, you will see “matching rows” in the <a href="/docs/manual/running#project-grid-header">project grid header</a>. If you click <span class="menuItems">Export</span> and copy your data out of OpenRefine while facets are active, many of the exporting options will only export the matching rows, not all the rows in your project.</p>
<p>OpenRefine has several default facets, which you’ll learn about below. The most powerful facets are the ones designed by you - custom facets, written using <a href="/docs/manual/expressions">expressions</a> to transform the data behind the scenes and help you narrow down to precisely what you’re looking for.</p>
<p>Facets are not saved in the project along with the data. But you can save a link to the current state of the application. Find the <span class="menuItems"><a href="/docs/manual/running#the-project-bar">Permalink</a></span> next to the project’s name.</p>
<p>You can modify any facet expression by clicking the “change” button to the right of the column name in the facet sidebar.</p>
<p>Facet boxes that appear in the sidebar can be resized and rearranged. You can drag and drop the title bar of each box to reorder them, and drag on the bottom bar of text facet boxes.</p>
<div class="theme-admonition theme-admonition-info admonition_cqk1 alert alert--info"><div class="admonitionHeading_rLBX"><span class="admonitionIcon_Bs13"><svg viewBox="0 0 14 16"><path fill-rule="evenodd" d="M7 2.3c3.14 0 5.7 2.56 5.7 5.7s-2.56 5.7-5.7 5.7A5.71 5.71 0 0 1 1.3 8c0-3.14 2.56-5.7 5.7-5.7zM7 1C3.14 1 0 4.14 0 8s3.14 7 7 7 7-3.14 7-7-3.14-7-7-7zm1 3H6v5h2V4zm0 6H6v2h2v-2z"></path></svg></span>Operations that don't respect facets</div><div class="admonitionContent_JcxC"><p>Certain operations don't respect facet settings. If you perform any of the following operations while filtering your data with a facet, the operation will apply to all relevant data, columns, and/or rows in the table, not just those which you have filtered with the facet:</p><ul>
<li>Moving, Removing, Renaming, or Reordering a column</li>
<li>Splitting or Joining multi-valued cells</li>
<li>Reordering of rows</li>
<li>Transposition (columns to rows, rows to columns, and columnization by key/value columns)</li>
</ul></div></div>
<h2 class="anchor anchorWithStickyNavbar_SRsa" id="text-facet">Text facet<a href="#text-facet" class="hash-link" aria-label="Direct link to Text facet" title="Direct link to Text facet"></a></h2>
<p>A text facet can be generated on any column with the “text” data type. Select the column dropdown and go to <span class="menuItems">Facet</span> → <span class="menuItems">Text facet</span>. The created facet will be sorted alphabetically, and can be sorted by count.</p>
<p>A text facet is very simple: it takes the total contents of the cells of the column in question and matches them up. It does no guessing about typos or near-matches.</p>
<p>You can edit any entry that appears in the facet display, by hovering over the facet and clicking the “edit” button that appears. You can then type in a new value manually. This will mass-edit every identical cell in the column. This is a great way to fix typos, whitespace, and other issues that may be affecting the way facets appear. You can also automate the cleanup of facets by using <a href="/docs/manual/transforming#cluster-and-edit">clustering</a>: a “Cluster” button is displayed within the facet window. It may be most efficient to cluster cells to one value, and then mass-edit that value to your desired string within the clustering operation window.</p>
<p>Each text facet shows up to 2,000 choices by default. You can <a href="/docs/manual/running#preferences">increase this limit on the Preferences screen</a> if you need to, which may slow down your browser. If your applied facet has more choices than the current limit, you'll be offered the option to increase the limit, which will permanently edit that preference for you.</p>
<p>The choices and counts displayed in each facet can be copied as tab-separated values. To do so, click on the "X choices" link near the top left corner of the facet. This can be useful to generate small summary tables of your data.</p>
<p><img decoding="async" loading="lazy" alt="A column of years faceted as text and numbers, and with the count ready to be copied." src="/assets/images/yeardata-4f97bd8643e93cff5d7d704970a42448.png" class="img_Ihyu"></p>
<h2 class="anchor anchorWithStickyNavbar_SRsa" id="numeric-facet">Numeric facet<a href="#numeric-facet" class="hash-link" aria-label="Direct link to Numeric facet" title="Direct link to Numeric facet"></a></h2>
<p><img decoding="async" loading="lazy" alt="A screenshot of an example numeric facet." src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASwAAACgCAYAAAC2eFFiAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAA0+SURBVHhe7Z1PjxTHGYf5Tlx8QlYOiC/AwQeuIC0XtNqjD5G5RMgh4WStkCJLwZbYQzaYHBAJLLEUIVsgW3LkQ8DGIUFOHDlBCoJbKv32dPVUV7/Vf2a6e+fteX7SI3qqq6q7a6qfqR4Qc8IRQoiRICxCiJkgLEKImSAsQoiZtArr1RvnvvrGuU+/dO7eY+d+/wgAYBjEKeIWcYy4pi2Nwvr2+0WHf/qzc3/MOv0DwgKAARGniFvEMeIacU5TksKShkdfLDrTDgQAMCTiGnFOk7RUYcnSTGyHrABgSsQ54p7U46EqLHmelCWa1iEAwJiIe8RBWlRhyZdgrK4A4DgQ94iDtKjCkiXZGF+w/+7h/zqhtQWA7UDcIw7SogpL68TTNXE7EVHXIC0A0LKysH528O9ia5mwLG6HsACgD1pWEpaIyeMTl8XtbAvrmdt964Q7cWLPva/ub2Pd9rBV3P/BvfPeD+6mtm82vHSXWq5Ry1orLA2fuN3WCeuT6+7kuaPiNcKCHmyDsDpco5a1vsNKyUoSt9sqYYmsTmT1S2EBJJAbd/eJ+0nOC/eBL3vvRbYCKcqvvSzr3/zwu6JuUC71r2X143Lh8EVR/4W7nLW9dBiXR/VjKudSnJ/a9o277M83450P3yz7qNUP6jZIS4sRYR25syKAt/bc2VwcC87uh3W8VDyhXNra+/3X3Y1KX74PRVheSiWn3e4nYV2PtNGE1+V8r7vdc8s61esF+2SPRbvfucv3F69zGckNnUvMl0udUGT+Bo/K/XZYXulftp8shFXpx7kPrhXlxesKlXMpXmttRUqlvFLnHNSPyjW0TP5I+NNf/6sRSVJY5U3rb3YvCb8/JZiO7TsLq6hfrqCi9rUVVup82s43dX4wC1I3baVcViORMPxqxYskVT/qvyKXso8FlRVRSHyOqbbheYUrtqb62rUHaJn8S3dNUiGS9AoruGH397IbuhBQsX3y3WfLNpWylva1/W3C8vhyT7G/TVi9zzd1fDBN6qatlAcCym9+ZfWUqh/1r6+GWojPsa2t1C/E1HisuF8FLWutsOKEZXE7L6wu6SMsucFvvHs63648MnUUVjdBxK+L+nH7jsLqf74Ia56Ej2wZcnPLTZwSUHjzy3absJoeCctyqV+U5+0jYrEk2paPs0U9keNy5aUcK+5XQcta32E1JW43lrCOZYVVaau0Z4UFXclvaP+4pH3vEwuoqFt8yV6/+cP6GbnYFn1f8iusSrn01bJiisWSaCuSKsvDNmr94loapKWlt7DWQUTUhXrb4gbOWEgivoH9/oRgWttHr8sv1BP7C7l4IfkVU+14636HhbBgMCKRGUDLpMJaneUNvPxbM/+FtMff1J7w5u7Q3ktIOJfVqwiiLoz3g7+9k/LdXFrLPpf7pUwTTrfzRViwOsGKLCP5xfqGosWcsBY3cF/WbQ8AU6MFYQHARqIFYQHARqLFiLAAYNvQgrAAYCPRgrAAYCPRgrAAYCPRkhTW3/4JAHA8ICwAMAPCAgAzICwAMAPCAgAzICwAMAPCAgAzICwAMMMowlr+X04AAN3QXBIzmrC0cgAAjWMXVvhrOetACJl/EBYhxEwQFiHETBAWIcRMEBYhxEwQFiHETBAWIcRMEBYhxEwQFiHETBAWIcRMEBYhxEwQFiHETBAWIcRMEBYhxEwQFiHETBAWIcRMEBYhxEyORVjnz5+voUmoD4SQ+UZzhuYWz2DCkgNpkXJNRF0hhMwzTc7QHCMMIqzUgSWPHj1aS1qEkPmlizM01wwuLHkWDf9EWISQOF2cobkGYRFCJg/CIoSYCcIihJgJwiKEmAnCIoSYCcIihJgJwiKEmAnCIoSYCcIihJjJxggrDsIihMTp4gzNNYMIS5ADyIFi1pGVQAiZZ5qcoTlGGExYghwoRpNQHwgh843mDM0tnkGF5ZFnUU0+q0AImX/EGZpLYhAWIeTYg7AIIWaCsAghZoKwCCFmgrAIIWaCsAghZoKwCCFmgrAIIWaCsAghZoKwCCFmgrAIIWaCsAghZoKwCCFmMhthDcEvDl8WV0AI2cQgrICf/+Y/anlfrv32pVrelxv3XxUjSsjx5Fd3/6vOzb78MlsMaOV9OXZhAQD0QXNJzCjCAgAYA4QFAGZAWABgBoQFAGZAWABgBoQFAGZAWABgBoQFAGZAWIPzzF152/9juD13oNbxNNXt08+APLruTrUdL6/jzy3j7evuYbl/qGtatZ+5HAM0ENbAHOxkk2/nqLat0VS3Tz/DceQudLl5DveS5zPUNa3aT9O+mFX7adoXM1Q/sABhDYrc8KfdFT9OjauVprp9+hmGh1dP55/0p3b2Wo8lN9epq8+UfUNd06r9zOUYkAJhDUlt0kWTMqSpbp9+BuLh4dHisa71xpHHmJGvadV+5nKMsgxiENaQzGEy144dsziXU+V3L8F5DXVNq/Yzl2OUZRCDsIZkDpO5duyIfH94LnJuRf2hrmnVfuZyjLIMYhDWkEw+maXcr3S6EvarUDt2Gx3Pe4qxmcsxyjKIQViDEk262qQMaarbp5+B6X2s8FyHuqZV+5nLMSAFwhqYPn9V3VS3Tz+D0nbjyD9pCPdL/eDfYQ11Tav207QvZtV+mvbFDNUPLEBYgyOfnNnkUx6/ZFJW/zlAum7zvhFRhBWft/8nEP3Pe4qxmcsxQANhQTuZxC5UbsIRmMsxYFQQFrTy8Ore8ruWkZjLMWBcEBYAmAFhAYAZEBYAmAFhAYAZEBYAmAFhAYAZEBYAmAFhAYAZEBYAmAFhAYAZEBYAmAFhAYAZJhHWyZMne6P1Mwe0a21D6wfSaGPYhtbPpqGddxtaP5aZTFh9MseB9jAW4zPXMWbuIKzJYSzGZ65jzNzZIGE9f/7cnTlzxt25c2eWA+1h0o3PXMeYubMhwvKyunjxonv9+vUsB9rDpBufuY4xc2cDhBXLSlIb6Pz/GQ9+YaTp14eHRo4d/MjCuqw96Y5zLMZiI8fY/1/rCy4cBvtWOdcBrnHt68p/QCS8LnvzZjJhyaOeiEkE5aPJSpKcQOWviti9SdeedDMai7EYZIwrcpEfiyjG2LqwjP8yz2TCEiGJmLy0UrKSpCbQlR1/YwY3aWUixOV77kLxk+qnrh5l+/x28UME4SeOfyMr7fbcQdi/bPv6K/7KydqTrjgfdSyy/eEv2pTXKW12smvy556atKl64Rhs0Rgv5ZIJKzy/Yrvy60HhtbWMYd4u9R40sPZ1pYSVn1v8fgSvszrJeRXVq/U9MJMJSxJKKyUrSXICyZ/5gHcUVvipGH9CVtotfp4pX/aHdcNjh5+yWfmxTbrw/LWxKCdOtCqolCcmV6qeP2ZeviVj7IXj8eehXls0Vk1jmEmj+jNg3Vn7usIPD8Gff37O0ftRex1eU/A+h/UmYFJhSby0UrKSqBOoGNyDfGXRUVjhGxJvx29eRj6RKv0F9ePyFVl70gXnURuL6BO0Iojy3IP6Rb2SVL0u5dr2DMZ4URbdpH6fbJfX1mGs8nr+xu/P2tcVzY+S+Hrj153m1TRMLqwuaZxAsr2TPRKpN1PDxIq3+755cfmKjDoWPYUl+0uZSLtEvWr5lo1xQW0s5dpSq46ybX0MD7JV47GusPq8H/51p3k1DfaElbG40YKJEC67u95MYd18YiXehPJ1MCmlXN7EsF5HJhuLLjdR0Yfed3SzbfEYL8YyuH7ZF97Est021qlr7MHa1xWJpyS+Xu1167yahsmE1ZdKH+oALt/0cqWQfwGoDGZqO59oRVv/RmrHCtv6+uUb2A/tWtuo9KGdXzAW4ZejuRxqbVYQVvZ668a4PIcF9bGUG7fYX3zJXpexJqxsW8YkvP6OaOfdRqWP8L0oaP4AKV5ntM+raZhEWAAAQ4CwAMAMCAsAzICwAMAMhoT1o7v38b7b3y+4/TTa/9Td2r/rPquULfj6wU330YMfa+WmeXy3HItbj5X9sCZt880whueOGWGJdJaTZjGZloMtspI3QBHWk8/dR9m+eQlLrvemu/ck286vTxc1rE7zfLOM7bljaIVVZblqkskkg66tsGTfTXfr9sxWWDLRPv7cfZ2/XlxjPgHjejAYs1mlG587RoWlyale5ifZbCabR5b0wSPKZ7d5LBwXbb4ZxfjcMSisYElbKw8mVfBJgrBgdVLzzSgIa0LyZ+7U5KkKSyRVfmFaMBtp8Ug4DY3zzSg8Ek5EPnmaluXpZfvsVljhp37ruMBKzHZcbc8dM8KSpWvzimmbhJVh+K+mLdA+3wxjeO7YWWEBwNbTS1j3Mhv/9R96RwAAYyLuEQdpUYX16ZfOPf273hkAwJiIe8RBWlRhffWNc4//oncGADAm4h5xkBZVWK/eLJZkrLIAYErEOeIecZAWVViSb7937gGPhgAwEeIacY64J5WksCTSUGwnSzTpjC/iAWBIxCniFnGMuKZJVpJGYUlkaSbPk/IlmHQof90IADAE4hRxizgm9RgYplVYhBCyKUFYhBAzQViEEDNBWIQQM0FYhBAjce7/1oyafIzGAx4AAAAASUVORK5CYII=" class="img_Ihyu"></p>
<p>Whereas a text facet groups unique text values into groups, a numeric facet sorts numbers by their range - smallest to biggest. This displays visually as a histogram, and allows you to set a custom facet within that range. You can drag the minimum and maximum range markers to set a range. OpenRefine snaps to some basic equal-sized divisions - 19 in the example set above.</p>
<p>You will be offered the option to include blank, non-numeric, and error values in your numeric visualization; these will appear in the visual range as “0” values.</p>
<div class="theme-admonition theme-admonition-info admonition_cqk1 alert alert--info"><div class="admonitionHeading_rLBX"><span class="admonitionIcon_Bs13"><svg viewBox="0 0 14 16"><path fill-rule="evenodd" d="M7 2.3c3.14 0 5.7 2.56 5.7 5.7s-2.56 5.7-5.7 5.7A5.71 5.71 0 0 1 1.3 8c0-3.14 2.56-5.7 5.7-5.7zM7 1C3.14 1 0 4.14 0 8s3.14 7 7 7 7-3.14 7-7-3.14-7-7-7zm1 3H6v5h2V4zm0 6H6v2h2v-2z"></path></svg></span>Numbers as text</div><div class="admonitionContent_JcxC"><p>You can create a text facet on numeric data, which will treat each entry as a string. This can be useful if you wish, for example, to manually include facets instead of selecting a range, or sort by count, or copy that count.</p></div></div>
<div class="theme-admonition theme-admonition-info admonition_cqk1 alert alert--info"><div class="admonitionHeading_rLBX"><span class="admonitionIcon_Bs13"><svg viewBox="0 0 14 16"><path fill-rule="evenodd" d="M7 2.3c3.14 0 5.7 2.56 5.7 5.7s-2.56 5.7-5.7 5.7A5.71 5.71 0 0 1 1.3 8c0-3.14 2.56-5.7 5.7-5.7zM7 1C3.14 1 0 4.14 0 8s3.14 7 7 7 7-3.14 7-7-3.14-7-7-7zm1 3H6v5h2V4zm0 6H6v2h2v-2z"></path></svg></span>Faceting customization</div><div class="admonitionContent_JcxC"><p>As mentioned in the overview, facets can be modified or customized by GREL <a href="/docs/manual/expressions">expressions</a> in many ways. For example, to facet by clusters of <a href="/docs/manual/expressions#variables">row</a> numbers with <code>row.index/100</code> or better visualizing numbers greater than 1000 with <code>max(row.index, 1000)</code>.</p></div></div>
<h2 class="anchor anchorWithStickyNavbar_SRsa" id="timeline-facet">Timeline facet<a href="#timeline-facet" class="hash-link" aria-label="Direct link to Timeline facet" title="Direct link to Timeline facet"></a></h2>
<p><img decoding="async" loading="lazy" alt="A screenshot of an example timeline facet." src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASsAAACfCAYAAAChiP9jAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABBXSURBVHhe7Z29zx3FFYf9P7mhslAKi3+AgoKWD9Mg6y0pItxEBiEhCmS5QQog2Y0FpEAmxg4iskBGQSKiiAETEssJEREFwl02e3Zn9s7Mnpn9mt175/r5SY987+7M2Zk5Z3939oLue6pCCKEChFkhhIpQ0qx+eVhVX31bVZ98WVU3vqiqj+4AAORBPEW8RTxGvGZIUbP67kEb7M9/rao/1QH/iFkBQEbEU8RbxGPEa8RzUlLNSjrd/EsbSLsIAEBOxGvEc1KG1TMr2Y6Jy2FUALAl4jniPbFHwp5ZyfOjbMu0YAAAayLeIx6kqWdW8oUXuyoA2AfiPeJBmnpmJduwNb5M/8Pt/41C6wsAjwbiPeJBmnpmpQWwjFXYT0xorDAsANA0y6x+d/W/5tVO7rGwH2YFAFPQNNmsxJQsVuGxsN8ys7pZPXnqVHUq5OmbQTuAI+DjH6unXv6xuqKdOxp+rl4cmKOm2TsrDauwXxazcs3p/cvV6amGJX0wODh0HgWzGjFHTbO/s4oZlSjsl92sal59WnZYZ6vz77ttI8wxN4C1kZv2/N3qNw33qzftsZfv1zsPc/z1n7v2V9763rR1jkv71+v24XHh2n3T/n51oe774rXweNA+xBuLGZ/a92F1wY635qm3Hu5i9No7bROGpalYs/ro0knzOPjkJfPeGlKHNbJ71fnH3OMn1atuXMtjl6u33fgAq1I/Cp3/vrrwcfu+MSK5mRsDs8eljWti9uYOjtvX7nEvvry+25qVF6eq3nzdHDfvPbyxmPdaXzGkzrhiY3baB8c1NG36GPjb3/8niWiqWZ1+6Z7Sxry3BtTbWQXne+8BViZ2w3rHZRcSmIXdpVgTibUP4nvG0sVo8XZCLuEYY33dcbk7tVR7be4Omjb9gl0zKBfRPLOyxyO7qNCslL5vv3S2PjbysRJgKbEb1jvumE9z4yu7plj7IL6+CxogHONQX2lvTCl5rTCugqbZO6tQ7rGwnzWrMZpqVu1joGnTGZB9r5tVa0xt+5DusRJgVdzHtBq5seUGjpmPe+PL6yGzSj0GdselvTne9A8ITSXSt3uENe3EGHc7LuVaYVwFTbO/s0op7LeGWXlfsIffX9k+scdAdVcGsDHNzWwfkbTveULzMW3NF+r9G99tX9OYWhv7Rbuz8o5LrIGdUmgqkb5iUN1xt4/a3swlYViaJpnVEsSExtDvq5hVxHz6O6fgy/QuRmBm3eOjbQ9wTAQmVgCaNjOr+RhjCXHNq6bdaVlOqvPBd1C78/ZYGBejgmPC2YnVRL9EP1A0FWBWAPCooQmzAoCDQxNmBQAHhybMCgAODk2YFQAcHJowKwA4ODRhVgBwcGhSzeof/wYA2A+YFQAUAWYFAEWAWQFAEWBWAFAEmBUAFAFmBQBFgFkBQBFkN6vd70ABAIxD85KQVcxKOw4AoLFXs1pbb7xRVc88sy7Xr5uLIYRWFWa1EMwKoW2EWS0Es0JoG2FWC8GsENpGmNVCMCuEthFmtRDMCqFthFktBLNCaBthVgvBrBDaRpjVQjArhLYRZrUQzAqhbYRZLQSzQmgbYVYLwawQ2kaY1UIwK4S2EWa1EMwKoW2EWS0Es0JoG2FWC8GsENpGmNVCMCuEttHmZvVMfYeHrCXMCqHypXmG5i2WLGYlF9EUO75UmBVCZSvlGZrHCIvNKmVId+7cac5Lk9LArBBaR2M8Q/OarGZlv6+y/2JWCKFQYzxD8xrMKgJmhdA6wqwyg1khtI4wq8xgVgitI8wqM5gVQusIs8oMZoXQOsKsMoNZIbSOMKvMYFYIrSPMqjAuXGiWCKFFeuUVvb5y8umn5mKZhFkVBmaFcgizmmlWoTCrOJgVyqHSzSrUqmYlSHC5SAhGFQezQjlUolmJUp6heYyQxayE1phC/EnDDswK5VCpZiXSPEPzFks2s7LIs2d9TRgAs0I5VLJZWYlnaF4SglntCcwK5RBmhVmtDmaFcgizwqxWB7NCOYRZYVarg1mhHMKsMKvVwaxQDmFWmNXqYFYoh7Ywq7XBrA4czArlEGaFWa0OZoVyCLPCrFYHs0I5hFlhVquDWaEcwqwwq9XBrFAOYVaY1epgViiHMCvManUwK5RDmBVmtTrPP68fz8mDByZ56GiFWWFWq7OFWZXOc8/px2HHMazRXs0KAGAKmpeEZDcrAIA1wKwAoAgwKwAoAswKAIoAswKAIsCsAKAIMCsAKALMCgCKYHOzunrO/5/Bnr3mnL9zuTrTnTuprjr9kueunZjjlrPVxdh4U3EM7Rj1cyFq2xHX2HGvuvj4QNsm3rjx6G1HXCMkjNNb45Yzr93r983E7FoxqLmZUiuG5TluGRzP45er2+65Hok8evMamJM39hrvuu41RuY3V80NsKlZ3X7tbDN4W3Rt8uzCmsmdu7l73S1i6pyNO1x0Q3G6Y6MWONZ26Bo+zRo0bf3XvTajEn6zelYZ+5hr+OhxPJqbY8yY5jG/VpzzyhzG14oQizN0/ZBIHGMwrSEMx4nmsTELZ05DuZHzkRpo4toxhHFVctXcMJvvrDzcZBm3t07uFVXqXFcIieRYknHsoltS8RJtk9cIkTjOuaZvcF1Zo8fP9o8HtNepr3vuJGg74hoO8Tgu7fy9nc7ajK2VZB4n1ErWHOtxwn7DccbmMWgbIOZhx+6T7hcSr5UpYx3PXs3KTrYpelOM3Q3gvk+d6xWD0y5kMI4s6JiCTrRNXiOgl8SwWCR+fV5Jdlhwt6/ddD4NnbYD1xgdx6HJW3InkZ/RtZLMo5zb1YkXo0emHCfiNDsON9+LamVHmB8/xzIOvV8q50KumpvLHs3KFk47Ka8Y5bxJnCxO6pz3uj7XKwCHZJyunVbkMfptx13DMJBUidX0Gygij1yFE71mO2f1hlqN8bWy66PkcUKt7FiY446x45lXK7s2Q3Nq+51pxhK0lfHUJnfVzE8YledcNTfA3szKJsYuRqoAJhVH4tzsIo+ysJCTSa1fe98djBlPTa7CiV1zylgyMaVWdv1G5DGVm44VzarGxmr61zueaJwpeWzGE5l3E8ftJ3FM23AezfsZtTJlrBPYi1nZBHlJMQsVFkDzPnXO9reYc2rCR8VZZlaTxppIqtygXZ9euwS5CidyzSZ3yS9LJX57840nPrfJtWLbrGhWk3LcMX48apxJeZxiDk5bub73eN+OOT2vmlw1N8D2ZmUS0it4c9wWTlukziLGzrkxBLetvZYgSRgVJ16cXZwRbUeNNUxil2Q5bq4XMLlwotew5yNE2omJ2rmtjl33KbXStRtvDmqtdO0m5nhKnIB5teK2sUwxB6dtL2Y75s1qboCNzUomIQnTFtIksylM87pLduJcUDjtI0NsYVLXCNqMWlyt7Zhr7GjGa25G97XHlGQrbUddI0S9ZjufweLNwtxaCdq4c5hUKxYlzqjrhwyNx43p9tsRzWMTx4kruYuNZ6CtxLXr02sbI1fNDbCpWbWfHPXAA7rF6QpUCBcpfs6PO/SJkrqGoBVnjFjboWu4jGgbKYbdujmoJhO/xvQ4Q+ubh2W1Iui5mVYrQo4cC3qc5ka2cQYNL35Nf179a7g5TrXdjbPF/WDKVXNz2XhnBQAwD8wKAIoAswKAIsCsAKAIMCsAKALMCgCKALMCgCLArACgCDArACgCzAoAigCzAoAiwKwAoAgwKwAoAswKAIpgdbM6ffr0ZLQ4JaDNZQgtzjGjrcEQWpxDQxv3EFociLOJWU1RyUl8lOY6l2NdI3K/PphVRijYYY51jcj9+hyEWf3www/VE088UX344YdFJ5GCHeZY14jcr8/ezcoa1QsvvFD9+uuvRSeRgh3mWNeI3K/PXs0qNCqRl8Tmt513vwe942x18f363OBvVm/L4oJt5uv+Lrj8HnaG3zw/oHXMs0b+PLrfCZdzc+Yyt5/D4nmZPx6xI0Pej4xNzEoe78SUxJysNKMS9ZJokB+5V3+s/oBYXLD2Ruz+Ekgms3LY9zpmWSPPWJw/YlG6WWX4CzDHzCZmJWYkpmQNK2ZUol4SDb2bzBZY8+9J9az5ixxnXrvZ/XWOrr37qbViQSwuWDOni+esQflm5f5Vkm5u0udcPf+R89v3OuZaI8+s7HvnnLtW3VhjaxX2mzG3xfOKmZWXl5Pqavi+bhOti6BdL3ZhbGJWItewYkYl6iXRkLzJ3E/W8FPW/mv6yZ8TWuvv3i0uWHfMTeE6ZtXMzRZdsJvwjqcLc9/rmGWNrNlYQtPxxuqsSdNXWSvbvjYMb20msHhe7geBYMffjNnkIvrenZOSw+Zc+WxmViJrWDGjEvWSaEjeZG5iw9dhEdTMLcghFhesM/6rze7KMavgk7czC3fOIx4b972OOdeoPRbcoO64u7Eq53sfBNIubfQpFs8ryG9HON/w/ai6OA42Nasx6iXRsOgm04pgBRbPNRz/ufqRcKZZyfnOWJx++17HrGtk6K2FjDW22+j6BmZVH78ars0EFs8rtr7hfMP3o+riODh+s5J/u+2wFKhJpo2TkcVzdcdf0xqOc0NNuQFNjJB9r2PuNYo9znU3cGNcA2vVHXfWtYs/jsXzmmtW8n6wLo6DTcxqKlqc2TeZvG4Ktr/LyI02lyG8GGGByXvn5pE1sPPojMLrs6JZyesM66itwRBeDBmPHYOhvxZy09pxtl+o93cbmlnVr2WOXZvxaOMewovhrq2hP2blfc1wXRwHq5sVAEAOMCsAKALMCgCKALMCgCIozKy+qd67dL36zDn22QeXqkuXLP454etbV6p3bv3kve/af/BNd9yN894XfozN+eL64YzlQInl0T3v5j2W34PKu0DuoxRkVmJUkkTXkH6qbrx7pbpx123ncPfz6p26T1e08v7dz6uvm/PS1xSEFEhX8H1D3Ba5vplTM/59juVAieXRPe/mXfLrtTfrGztu42wOuU9RiFlJIUniAiNJJrQtvvc+cD5he0WuFeeezWrUGB9twl2TTz/v2u5a3seO2/ebQ+6TFLSzEgIjaT4Z6wIz22b3cSBWkK3BSft+IUjbvW+/vV1e+5jC44BPsya3bB5H5L23gzK7rthxE2tzyH2Sss1KuFsXpnktBdok1/mEGiparRj2WiQU7CCyJrs8OmsUy7vtYz6k3F1X7PheIPdJyjcrB/dTtS3AHfa4V4xBcVh67baER4FBwpt4KO9uXyFmAns3B3KfpGyzCsxGijUsNs94vJ1VW5zNuYP6RJM5miJtHln3+P3ZoTIiX7282/bumsaO7w1yn6L4nZUUaupT1CvaGrd9WPCpOJsiN5EZy14/6Q8Ydxc1Ne/umsaO7w1yH6UwswKAR5XRZnWjdvm//0sPAgCwJuI94kGaemb1yZdV9c0/9UAAAGsi3iMepKlnVl99W1Vf/E0PBACwJuI94kGaemb1y8N2G8buCgC2RDxHvEc8SFPPrETfPaiqWzwOAsBGiNeI54j3xKSalUg6icvJtkwC8aU7AOREPEW8RTxGvCZlVKKoWYlkOybPj/KFlwST/6QIAJAD8RTxFvGY2KOfq6RZIYTQoQizQggVIcwKIVSEMCuEUBHCrBBCRQizQggVoKr6P9sC9PSsJZ4oAAAAAElFTkSuQmCC" class="img_Ihyu"></p>
<p>Much like a numeric facet, a timeline facet will display as a small histogram with the values sorted: in this case, chronologically. A timeline facet only works on cells formatted as the <a href="/docs/manual/exploring#dates">“date” data type</a>.</p>
<p>The facet appears with a count of blank cells and those with errors, which can help you analyze whether your date cells are correctly converted.</p>
<h2 class="anchor anchorWithStickyNavbar_SRsa" id="scatterplot-facet">Scatterplot facet<a href="#scatterplot-facet" class="hash-link" aria-label="Direct link to Scatterplot facet" title="Direct link to Scatterplot facet"></a></h2>
<p>A scatterplot is a visual representation of two related sets of numeric data.</p>
<p>You have the option to generate linear scatterplots (where the X and Y axes show continuous increases) or logarithmic scatterplots (where the X and Y axes show exponential or scaled increases). You can also rotate the plot by 45 degrees in either direction, and you can choose the size of the dot indicating a datapoint. You can make these choices in both the preview and in the facet display.</p>
<p>A scatterplot facet can be generated on any column. You require two or more number columns to generate scatterplots. Selecting <span class="menuItems">Facet</span> → <span class="menuItems">Scatterplot facet</span> will create a preview of data plotted from every number-formatted column in your dataset, comparing every column against every other column. Each scatterplot will show in its own square, allowing you to choose which data comparison you would like to analyze further. You can control which columns are on the X and Y axes by rearranging the columns in your dataset.</p>
<p><img decoding="async" loading="lazy" alt="A simple scatterplot of two numeric values." src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASoAAADCCAYAAAD+Wo90AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABbMSURBVHhe7Z1rjBVlmsf5tJ/0AxqN0Ul2s2NG4xf1i9FNNLhxxOyumYnjikCMq0YYE9bLTFxnA3iZycCOyhrZQSU7XsjEQLRd5T4rIIotyEpza6Ghm8a+CXQ3ICI0dLf47PO8VXXOe+p9zq27Tt34/5Nf6FNv1VvVxfP++q3qPnUmEIIgSMoDUSEIkvpAVAiCpD4VRXV2hKi1k2jLHqKPWojWbQMAgGgQp2z5kh1z0HNNpZQVVfcRoo3biTZzR5/s1HcEAADjQdyyuZWltYOob8CXjxJVVAe+9iT1MQQFAIgBcY3IqosnSFocUZ0aIlrvb6h1CAAAjUCcs54vB88O+zKy4ohq1wGiz3gqpnUEAACNpJnd09bty8iKI6qNPP3CbAoAkAQfs3+ad/sysuKIStsYAADiYsN2X0ZW6hJVrYl6WwDA+UU4YxLVf7xz3P+qGHtZpW2rpXS7NnroJxNowk/m0+v+stdnXUsTJmjLrqWHmojm3c5tE6bQPL/Nxl7PWyb9B+u6+6rMWprExzFpodZmsXBK2eNpCE3z6cd8XD+e1VZ5mUo956D6uvNut891mNrOn/k/q/n/BGSDk/TbxQPK8iLh1C0qEVJAkPCyctvWkvB2YfF4r4XiIKgkJ5uwqEq3q09UXl+1CMgbkNUlERHjElU9VD5f7g8Frb2G8+cfe9UfCCA7bDhEd7/QYFFJbDHZBKm0bbWEt/MKOihUb9B7ogotu32tWb+S2CbxT/hg8AT9Bm0PNQUDbwpNkn/N8nIDqXSfhdf+oC095goidQQS6tdvD46zpsFak6j879Xv11luyafc+Suuq5wvM4sMlmnHbX+f7j5LJee2g5h5r5vunttJf/+rDpr5nvdavjYUhMOzpLn+MubuxSfN8mWLve2Ky4rrBetohDPme1TlJCWptm2lONvag8wfAJMWWoUeGoQlUvDX99qCwVn8KV8qkFC7NuAD/LaSARjs6/Yppq0osaCtuN8i/j6DdQvfn9XmD9CysgujHXcN50jbZ+XzV/l8lcomROj8VROT117D9w4ag4ipIKQBmvmrblrkt4mIjHC0WZIsm3uIlvmvF73giy6uGZUkNlFZP32LBWsVc8lAKx2E4cEdHjy6qILXodmNTWifHsH2QmiAqut72INQPx6mntmELwHvOErxJBL+vrzXJTIqkWPxe1GFUuZ8hc91CeHzYUsuJDyhYl+g8ciMKpj9iGT8GVIBXzoiomCZWd+eednL037pp21jI3G3DQaPf4nhD6KgeL3LkWCwRCCqghTKi8rrRxGPPwCdbfzl9uArUJhdKPsL+guoRVjKQNdEUNKvYPariarc+at8virJxT1/fl+8rbZd2fMN4sEWVWhGpeOvE5pRFYhDVGGxSMLLatlWQ6JtGxSqUBiA9iC2BrArqmLRhwfBWEXlzAgM/vo+JW3q+gHBfq/1haWtU+xblZ1NNVFV+r5UUZU7f2MXlXY+vPX5h5Hs0/r/LLaV6Qs0nhJRea/VWVJ4Ga9r36MSCpd+8rqCrMIZ84wqHHtZpW2rRdvWllKxuC0xWIOuRD7+dt4A9QdWFKJSZFAc1MFxFWci3nGUH2jeQAxtE96/Pbg1GQVUFZV+jrzzGjoHJecv+L6C72McoqpwjMX9FdcPJFY8NyDvhDPme1SVEvW2xSK2izUQT+lP5lL52BII/9aK8Qei10cdogq3BccXkooqBo3w9uHlAaH9hQd02TZnWfHc2cfpyic4dqHcb/3KnC/r2N3j1M5tcExhubnHBPJPOHWJChQxAqxp8HgDTZVK2imZbdUg3Dpwz185IXlSs38YgfwTDkQ1ZmocQGawZ/WyJZjlFIlOGMXzZ896w5eKtf9AAHkiHIgKAJA6woGoAACpIxyICgCQOsKBqAAAqSMciAoAkDrCgagAAKkjHFVUvf0AAJAMEBUAIPVAVACA1ANRAQBSD0QFAEg94xLVunXrAGgYWs2B85Nxi2oNN0bBtn+eQB/8dqbaBs4/XnnlFbXmwPkJl4STRES1+t3/oTWrPlHbwPkHRAVsuCScJCIqAGwgKmDDJeEEogKJA1EBGy4JJxAVSByICthwSTiBqEDiQFTAhkvCCUQFEgeiAjZcEk4gKpA4EBWw4ZJwAlGBxIGogA2XhBOICiQORAVsuCScQFQgcSAqYMMl4QSiAokDUQEbLgknEBVIHIgK2HBJOIGoQOJAVMCGS8IJRAUSB6ICNlwSTiAqkDgQFbDhknACUYHEgaiADZeEE4gKJE4aRXVssJ9Ge+fTaOcMGt3383iQffE+Bwf6af/+dtq1axdt27YtFmRfss+v+8+o5yNOuCScQFQgcdImKiOp9ul07vgKohFeEFd4X0MDG2jHjh10+PBhOn36NI2MjMSC7Kunp8fsO2lZcUk4gahA4qRNVKO98zxJJZD29nYjKU0mcSCykpmVdl7igkvCCUQFEid1ouLZFJ075Y+IeCMzmjNnzqgSiQOZWclloHZe4oJLwglElWJW/vnP1Dz1Alr55n+r7XkhdaLa93N/NFTLWjr+0gQ6ur6NaNcUGnzpWjpxyG8aY+R+kSaQAju304/+uIVe7lXaIkKOQTsvccEl4QSiSjGr3l9DK37zC1rZtFxtzwu5EFVEgaggKpBS8jajGlp/LQ2+PoWOvz6BlzGvz6chf4tqqU9Uh+nlt5r5tc97Hf56HfTLwrLt5utf7rT6qAJEBYBCLkUVXAYemk9HeZ3ju7wtqqUeUbVt2EI/eutLajNtnpxESOveY0EFy836EBUA4yafMyp/FtVAURkhFWZR3uzqpxsOh5YXBVbSTwUgKgAUIKpiRBJDQ0Pl2d5iRPVS1xC1ruMZ1R9b6C+mbT/NYCHN2D5Ef2mSGVUrtRbW95ar/SlAVAAoQFTF1COqoaE+esm6R3Xbuj5/PU9aZnlTS0FgTl9lgKgAUMiuqKJPVVHVQMlMq6uVboOoABg/EFUxIgn5g8/x0U4zgxmVmVW1K+uUB6ICQAGiKiYaUY0PiAoAhdSJqn1aYm+h2b59u7n8Onv2bCJ89913eAsNABqpE5W8KXlwqT8i4o28Kbm7u1uVSBzIvvGmZAAU0iYq7zEv0+jc0WXxP+Zl8CPzxuTe3l46deoUDQ8Px4LsS/aJx7wAUIa0iUrwHpw3j0YPPGzuWcWC7Iv3iQfn+TKyAlGBxEmjqEBycEk4gahA4kBUwIZLwglEBRIHogI2XBJOICqQOBAVsOGScAJRgcSBqIANl4QTiAokDkQFbLgknEBUIHEgKmDDJeEkEVGtfPKfaMWfFqlteWDlnHtp+X/NU9tAkbVrmmnFr/8BogIlcGk4SURUm6ZdRMuff1JtywPrH/xbWvHM/WobKLJ29Ub6hGsBogI2XBpOcOkHEgeiAjZcEk4gKpA4qRTVkbPUtq+ddkbwNhbpo/tACw33zKORzhn622fqQPoY7plP/f1HIj1G6Uu+b/V8xAiXhBOICiRO6kTFg1Uet9LX10fffvut8wTMejl94ivz6cvmY+KjeJMz93Gmf3Wkxyh9dHV1mT6TlhWXhBOICiRO2kQlMwsRgDagx8Jo7+89SUUYeRxMlMcYILIyMyvlvMQFl4QTiAokTtpEJbMKeeyJNpADTpw4oS7XkNlU1A/iq+UYwxw5ckRdbiMzK7kM1M5LXHBJOIGoQOKkTVRyz0YbxAEymOVJmPL1yZMnnfYwcl9Jy/79+/2vSjM6Okrff/+9/0pPtWMM8/7779M333yjtoWRvrXzEhdcEk4gKpA4WROVzdGjR9XlNuVEtWrVKv+r0siTNuWDQCulnmNcsmQJbdy4UW3TgKgAUEi7qI4fP16YQdWKLbByolq4cKH/Vf2pVVSzZ8+muXPn0unTp9V2DYgKAIW0i+rw4cP06aefmn/t5RoitIGBAXr33XcLy8qJ6tFHH6W9e/f6r0ojl37yiOByqUVUc+bMoaamJvr888/V+1nl5AVRAaCQhUu/rVu30osvvmieKV7uRrrMouQ3cYsXLy5ZXk5Ud911F7W2thqJhCP3qeQSsFyqierpp5+mBQsWmOPV7k1V+mUARAWAQhZEJTL58MMPaerUqbRlyxYaHBwstAWDvqenh2bNmlVYHlBOVI888gh1dHSYmU29qSSqZ555xlzy7d69W22vBkQFgEJWbqaLUN555x164IEH6LPPPqNjx46Z2Yr85q+zs5PuuecedbtyorrzzjvNhypU+w2flkqiuuOOO+ipp55S22oBogJAISuiCnj11Vdp8uTJ5s8LRF4iqWnTpqnrCuVEJUL54osv/Ff1pdIxyh9tyv2v5cuXq38+Ue1eG0QFgELWRCWsXLmSbrvtNnrssccqSkooJ6r777/f3Hw/d+6cuR9lXwL+8MMP/ld6qh2jfJDoc889R5s2bVLbKwFRAaCQRVHJTOXll1+mBx98UG23KSeqG264wQhP+5upKP7gs62tzVwCtrS01PVX7BAVAApZFFU9lBPV9ddfT7fccgvdd9999Pjjj9MTTzxhbsbLZZv81u61116jt99+mzZv3kzNzc3+Vl5qPUZ5q83zzz9vLge1dg2ICgCF81VU40k9xyg37D/44ANz87+WmRVEBYBC2kQ1ljf8VmK0fVrib0oW+cjfVGltNrl4U/LJP80AKUIb9FkkbaKSx5zUc6lUDfOYl8Gl/giLJvKYl3qPsRax5eIxLzI4tLY80N3WRT2796ptaQSiaiD+g/PkDzijeCid9+C8aXTu6LLoHpw3sCbSY5Q+pC/pM/MPzsuzqLr+8DM69uRfq21pBKJqMDxYZWYR1WN+vUcR/55GDjxs7lmNB+lDHmuMRxFrG+ddVLv20Fdbm9W2NAJRgbzCJeEEosooEBXIK1wSTiCqjAJRgbzCJeEEosooEBXIK1wSTiCqjAJRgbzCJeEEosooEBXIK1wSTiCqjAJRgbzCJeEEosooEBXIK1wSTiCqjAJRgbzCJeEEosooEBXIK1wSTiCqjAJRNZiI30LT3nGA+9sf6dtdBvr7aLhnPo10zlDfalMX3If01X+kXz8fMcIl4QSiyigQVQPx35QsH30VxRt+5QNMo+xP+jjSu5tG26fTueMrInujszzhQd48nbSsuCScQFQZBaJqHDJbEalokhgL8iEQUfYnmEfHiKQijshK3vCsnZe44JJwAlFlFIiqccjsJ8oH50XdnyCzqagfxmfCM6vRAw+r5yUuuCScQFQZBaJqHHIfSJPDWIm6P0HuKzUq0rd2XuKCS8IJRJVRIKrGAVFBVCAiIKrGkSdRyecD2tQSiApEBkTVOJIQlXz4qNzHCpDX2noB1UQl68gnOMsn0Mg9Mvlgh3379tGJEyeqCguiApEBUTWOWsQiH0Da0dFBe/bsof7+fnWdgFr627p1Ky1atIgWLFhgPs9P5CKfoqytK1QT1cGDB01f8pmB9957L02fPp3mzJljjmV0dNRfSw9EBSIDomoctYhFJDV58mS6+uqradmyZeo6AdX6kxmUSOrKK6+kiy++mK655hp68803K/7NVSVRyYxp586dRlKXX345TZw4kS699FLzEfRr166l4eFhf009EBWIjCRFtXrW39GK3/xCbRsLWRTV3r176aqrrqILLriAFi9erK4TUK0/mTnJ7Oeiiy4y/V122WXmnMhlmra+UE1UMiObOnWqkZT0eeGFF9LNN99sPkIeogKxkaSoVsydTh/Mf0xtGwtZFNXAwICZSYmkWltb1XUCaplRyeWezKSuuOIKuu6662jJkiXjmlHJPSm53LvkkkuMpERYt956K61evRqiAvGRpKiiJouiqoda+mtpaaE33njDnAuRlNwEF4Fp6wqVRCWRv4afPXu2udyTmdSkSZNo5syZ1NzcjHtUID4gqsaRhKjk8k9mUILcqB/vb/3kslH2K/ekVq1aZWZSIim58Y/f+oHYgKgaRxKiqpdqohIZycxpZGTEXOoJ8rqapCQQFYgMiKpx5EFU4wlEBSIDomoc2XhT8jS8KVndGKJKFRBV45DHvHR1damCGAtyYzvK/gTzmJfBpf6ojS54zAuIFIiqgfgPzuvp6an4JwK1Ejw4L6r+pI/+vlYzqzp3dFl0D87jvvDgPBApEFWDycyjiOfRCF+qyX2lccF9SF94FDGIFIgK5BUuCScQVUaBqEBe4ZJwAlFlFIgK5BUuCScQVUaBqEBe4ZJwAlFlFIgK5BUuCScQVUaBqEBe4ZJwAlFlFIgK5BUuCScQVUaBqEBe4ZJwAlFlFIgK5BUuCScQVUaBqEBe4ZJwAlFlFIgK5BUuCSeJiOrgW/9OX239XG0DtQFRgbzCJeEkEVGN/utf0cGl89U2UBsQFcgrXBJOcOmXUSAqkFe4JJxAVBkFogJ5hUvCCUSVUSAqkFe4JJxAVBkFogJ5hUvCCUSVUSAqkFe4JJxAVBkFogJ5hUvCCUSVUSAqkFe4JJxAVBkFogJ5hUvCCUSVUSAqkFe4JJxAVBkFogJ5hUvCCUSVUSAqkFe4JJxAVBkFogJ5hUvCCUSVUSAqkFe4JJxAVBkFogJ5hUvCCUSVUSAqkFe4JJxAVBkFogJ5hUvCCUSVUSAqkFe4JJxAVBkFogJ5hUvCCUSVUSAqkFe4JJzUJarvFv+L2pYH+npPU1/PSbUtjUBUIK9wSTipS1SnHr9EbcsDXX/4GR37t79R29IIRAXyCpeEk7pEdeKFyWpbHji4+WPq/N931LY0AlGBvMIl4QT3qDIKRAXyCpeEE4gqo0BU+WbT73bQxOk9apvOMXr2pm00tUlrK7J0+ja68XfH1La0wCXhBKLKKBBVvoGoSgNRZRSIKl5kgE+c6BEM9NJBb4miaQ9NvKmDni1ss4eWFvry1gv6CsRi+rqJ5ST9P7i70O7IqmzfIVFt6aAbgz78dYz8/GVplhWXhBOIKqNAVPFhBjjLYZO89gXgCUHksIOe3cJfs0AKg19kYsnASM4Xjvk66Mus521fspwpO6Mq27ctqh6aGl7H71u+TrOkBC4JJxBVRoGo4sITgD24Swa7iItldaM9azIysV4bucnr0KzH6rsoHK+tsqiq9F1YZq9TFCJEBWIDoooLTwDBJVMBSyLO4BeZWLOjoji8mU5RVMVtw31UFJXatyWqsMzMfiEqkAAQVVyEZ0EhRArTO3gd/xIwWGaLovA63Jf3um5RVesbMyqIKi1AVPFRco+q5P6PfO0LQWQQrGPkURSSyCGQjvm6ZD1dINXuUbl92xLEPSq1DcQPRBUvZrDz4C9e9rkzrYJcRCY37aGp3G7Wty/V/O2CvmzhlAjEF5Ijq7J9h47HzKKC/RRnV+YYeVmaZcUl4QSiyigQVYoxMrHlFCGN7DslcEk4gagyCkSVYiCqccEl4QSiyigQFcgrXBJOIKqMAlGBvMIl4QSiyigQFcgrXBJOIKqMAlGBvMIl4QSiyigQFcgrXBJOIKqMAlGBvMIl4QSiyigQFcgrXBJO6hZVmvj2P//RfODEyVfvU9vzjjboswhEBWy4JJw4otrQQtRzRNmYRSUFBUAjCNcbOD/pZvesZweF44hq0y6iA716JwAA0Eja2T3ioHAcUX15kOiLfXonAADQSLa2Ee3t9mVkxRHV0Flv6oVZFQAgTtp7PPecHfZlZMURleSrw0QbdxB1fq13CAAAUdLRR/TRdqIe/lqLKipJzwBvyLLaxpeBBw/pnQMAwHiQydD/8eWeTIwODfryUVJWVJIzI0StnUSb9xBtYNvJrw0BACAKNrJTPme3fPkV0fCoL50yqSgqBEGQNASiQhAk9YGoEARJeYj+H7dYvSq/LAWnAAAAAElFTkSuQmCC" class="img_Ihyu"></p>
<p>When you click on your desired square, that two-column comparison will appear in the facets sidebar. From here, you can drag your mouse to draw a rectangle inside the scatterplot, which will narrow down to just the rows matching the points plotted inside that rectangle (as shown by the rectangle inside the square in the image above). This rectangle can be resized by dragging any of the four edges. To draw a new rectangle, simply click and drag your mouse again. To add more scatterplots to the facet sidebar, re-run this process and select a different square.</p>
<p>If you have multiple facets applied, plotted points in your scatterplot displays will be greyed out if they are not part of the current matching data subset. If the rectangle you have drawn within a scatterplot display only includes grey dots, you will see no matching rows.</p>
<p>If you would like to export a scatterplot, OpenRefine will open a new tab with a generated PNG file that you can save.</p>
<h2 class="anchor anchorWithStickyNavbar_SRsa" id="custom-text-facet">Custom text facet<a href="#custom-text-facet" class="hash-link" aria-label="Direct link to Custom text facet" title="Direct link to Custom text facet"></a></h2>
<p>You may want to explore your textual data with modifications that aren't permanent. Creating custom text facets will load your column into memory, transform the data temporarily, and store those transformations inside the facet.</p>
<p>You can also use custom text facets to analyze numerical data, such as by analyzing a number as a string, or by creating a test that will return “true” and “false” as values.</p>
<p>Clicking on <span class="menuItems">Facet</span> → <span class="menuItems">Custom text facet…</span> will bring up an <a href="/docs/manual/expressions">expressions</a> window where you can enter in a GREL, Jython, or Clojure expression to modify how the facet works.</p>
<p>A custom text facet operates just like a <a href="#text-facet">text facet</a> by default. Unlike a text facet, however, you cannot click “edit” on the facets that appear in the sidebar and change the matching cells in your dataset - because what they display is modified, not the original entries.</p>
<p>For example, you may wish to analyze only the first word in a text field - perhaps the first name in a column of “[First Name] [Last Name]” entries. In this case, you can tell OpenRefine to facet only on the information that comes before the first space:</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">value.split(" ")[0]</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>In this case, <code>split()</code> is creating an array of text strings based on every space in the cells ["Firstname", "Lastname"]. Because arrays number their entries starting with 0, we want the first value, so we ask for <code>[0]</code>. (Assuming the first name is one word, not something like “Mary Anne.”) We can do the same splitting and ask for the last name with</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">value.split(" ")[1]</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>You may want to create a facet that references several columns. For example, let’s say you have two columns, “First Name” and “Last Name”, and you want out how many people have the same initial letter for both names (e.g., Marilyn Monroe, Steven Segal). To do so, create a custom text facet on either column and enter the expression</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">cells["First Name"].value[0] == cells["Last Name"].value[0]</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>That expression will look for the first letter (the character at index 0) of each entry and compare them. Then it will facet your rows into “true” and “false.”</p>
<p>You can learn more about text-modification functions on the <a href="/docs/manual/expressions">Expressions page</a>.</p>
<h2 class="anchor anchorWithStickyNavbar_SRsa" id="custom-numeric-facet">Custom numeric facet<a href="#custom-numeric-facet" class="hash-link" aria-label="Direct link to Custom numeric facet" title="Direct link to Custom numeric facet"></a></h2>
<p>You may want to explore your numerical data with modifications that aren't permanent. You can also use custom numeric facets to analyze textual data, such as by getting the length of text strings (with <code>value.length()</code>), or by analyzing it as though it were formatted as numbers (with <code>toNumber(value)</code>).</p>
<p>If you would like to build your own version of a numeric facet, you can use the <span class="menuItems">Custom Numeric Facet</span> option. Clicking on <span class="menuItems">Facet</span> → <span class="menuItems">Custom Numeric Facet…</span> will bring up an <a href="/docs/manual/expressions">expressions</a> window where you can enter in a GREL, Jython, or Clojure expression to modify how the facet works. A custom numeric facet operates just like a <a href="#numeric-facet">numeric facet</a> by default.</p>
<p>For example, you may wish to create a numeric facet that rounds your value to the nearest integer, enter</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">round(value)</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>If you have two columns of numbers and for each row you wish to create a numeric facet only on the larger of the two, enter</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">max(cells["Column1"].value, cells["Column2"].value)</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>If the numeric values in a column are drawn from a power law distribution, then it's better to group them by their logs:</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">value.log()</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>If the values are periodic you could take the modulus by the period to understand if there's a pattern:</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">mod(value, 7)</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>You can learn more about numeric-modification functions on the <a href="/docs/manual/expressions">Expressions page</a>.</p>
<h2 class="anchor anchorWithStickyNavbar_SRsa" id="customized-facets">Customized facets<a href="#customized-facets" class="hash-link" aria-label="Direct link to Customized facets" title="Direct link to Customized facets"></a></h2>
<p>Customized facets have been added to expand the number of default facets users can apply with a single click. They represent some common and useful functions you shouldn’t have to work out using an <a href="/docs/manual/expressions">expression</a>.</p>
<p>All facets that display in the <span class="tabLabels">Facet/Filter</span> tab can be edited by clicking on the “change” button to the right of the column title. This brings up the expressions window that will allow you to modify and preview the expression being used.</p>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="word-facet">Word facet<a href="#word-facet" class="hash-link" aria-label="Direct link to Word facet" title="Direct link to Word facet"></a></h3>
<p>A <span class="menuItems">Word facet</span> is a simple version of a text facet: it splits up the content of the cells based on spaces, and outputs each character string as a facet:</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">value.split(" ")</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>This can be useful for exploring the language used in a corpus, looking for common first and last names or titles, or seeing what’s in multi-valued cells you don’t wish to split up.</p>
<p>Word facet is case-sensitive and only splits by spaces, not by line breaks or other natural divisions.</p>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="duplicates-facet">Duplicates facet<a href="#duplicates-facet" class="hash-link" aria-label="Direct link to Duplicates facet" title="Direct link to Duplicates facet"></a></h3>
<p>A <span class="menuItems">Duplicates facet</span> will return only rows that have non-unique values in the column you’ve selected. It will create a facet of “true” and “false” values - true being cells that are not unique, and “false” being cells that are. The actual expression being used is</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">facetCount(value, 'value', '[Column]') > 1</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>Duplicates facets are case-sensitive and you may wish to filter out things like leading and trailing whitespace or other hard-to-see issues. You can modify the facet expression, for example, with:</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">facetCount(trim(toLowercase(value)), 'trim(toLowercase(value))', 'cityLabel') > 1</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" class="clean-btn" aria-label="Toggle word wrap" title="Toggle word wrap"><svg viewBox="0 0 24 24" class="wordWrapButtonIcon_YZ2e" aria-hidden="true"><path fill="currentColor" d="M4 19h6v-2H4v2zM20 5H4v2h16V5zm-3 6H4v2h13.25c1.1 0 2 .9 2 2s-.9 2-2 2H15v-2l-3 3l3 3v-2h2c2.21 0 4-1.79 4-4s-1.79-4-4-4z"></path></svg></button><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="numeric-log-facet">Numeric log facet<a href="#numeric-log-facet" class="hash-link" aria-label="Direct link to Numeric log facet" title="Direct link to Numeric log facet"></a></h3>
<p>Logarithmic scales reduce wide-ranging quantities to more compact and manageable ranges. A log transformation can be used to make highly skewed distributions less skewed. If your numerical data is unevenly distributed (say, lots of values in one range, and then a long tail extending off into different magnitudes), a <span class="menuItems">Numeric log facet</span> can represent that range better than a simple numeric facet. It will break these values down into more navigable segments than the buckets of a numeric facet. This facet can make patterns in your data more visible. OpenRefine uses a base-10 log, the “common logarithm.”</p>
<p>For example, we can look at <a href="http://wiki.stat.ucla.edu/socr/index.php/SOCR_Data_Brain2BodyWeight" target="_blank" rel="noopener noreferrer">this data about the body weight of various mammals</a>:</p>
<table><thead><tr><th>Species</th><th>BodyWeight (kg)</th></tr></thead><tbody><tr><td>Newborn_Human</td><td>3.2</td></tr><tr><td>Adult_Human</td><td>73</td></tr><tr><td>Pithecanthropus_Man</td><td>70</td></tr><tr><td>Squirrel</td><td>0.8</td></tr><tr><td>Hamster</td><td>0.15</td></tr><tr><td>Chimpanzee</td><td>50</td></tr><tr><td>Rabbit</td><td>1.4</td></tr><tr><td>Dog_(Beagle)</td><td>10</td></tr><tr><td>Cat</td><td>4.5</td></tr><tr><td>Rat</td><td>0.4</td></tr><tr><td>Sperm_Whale</td><td>35000</td></tr><tr><td>Turtle</td><td>3</td></tr><tr><td>Alligator</td><td>270</td></tr></tbody></table>
<p>Most values will be clustered in the 0-100 range, but 35,000 is many magnitudes above that. A numeric facet will create 36 equal buckets of 1,000 each - containing almost all the cells in the first bucket. A numeric log facet will instead display the data more evenly across the visual range.</p>
<p><img decoding="async" loading="lazy" alt="A screenshot of a numeric facet first and a numeric log facet second." src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASoAAAD4CAYAAABbu6u/AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABRTSURBVHhe7Z1Nix3HuYD1n7zRSogs5h9o4YW2EnglxCy1CNYmOEYXwQUjBoIh2lj3woBI7sI31iSCoMUdEYO9uXFsKSTCjgOJkihXuV+p9Ntd1af6rbc/6pzuPjWa54EHzfRHdZ2x61GdIzm54AAACodQAUDxECoAKB5CBQDFQ6gAoHgGQ/XqtXOffenc40+d++Spc/9+iog4j9IUaYs0RlozRG+ovvq6Gejnnzv3s2qwnxAqRJxRaYq0RRojrZHm9GGGSm44+UUziPUARMQ5ldZIc/pilYRKtmBSNyKFiGsqzZH2WG8Dk1DJ+0XZilkDISIuqbRHGqRJQiUfbrGbQsR9KO2RBmmSUMnWa4kPzn/05O+TtO5FxPOhtEcapElCZd0cnIq+TwI0FWKFiJqtQvW9B3/wX22Ij+n7CBUi5qjJDpUEKRjQx/R9u4XqxF25cMFdSDxwNx/G1+X4zN28KGMcuvfN88FwXfdZ71/1c7h45O6Hax8eubf0sV6nPj/ofwaTxu6zGePKvc3X24x3/9ZBxrwx20ffurff/dZ9ZJ17Y3zpboy8Rs3WOyrLgL5vllBdPUmPbb1gpociRKlZ4KJf8FcPu/ffk+/1PPtcIFQSyoFnN4EJwd0+VCHIb916Zp/H3TwPoZrwGjVbf0bVFylB3zd/qEJAtt1VZYTCB6hdmPVCrZ57z//qn9+EIA7anI6EJezmekPlX297/w6hSsbCrZUFe/ML953aF+6DcOzdF9WOwx+/+7K9/qMPn/tro+Ny/d3qen1cPH7hr3/hblf33jjWx9X12s5c/PzMe1+722G+lW9/+HozRnJ9dO1ArDRnNFTWQgvxCaoIhcVcj3UUhcqIlo9THR0dgfqcXNvMIQQsDaefY9Cca/TMeH4XD92Vzvnweg8211Q2URx53fHY7c+w+/NLdo2Dc9n1NwlsrN7+3Hzubj9qvq8jJAu5jlc4LtfEAQsLWx0PX8fHO+PL1180oeqM49wHd/1x/33Hzlz899a9EqM2Wn1zjq5Xxy01q771++4Pfz+o0BuqRCsKYTHpEHQX5mYhNuf1bqi7EP1Y8aL2C37zdfea5HnJ9yPzC28j9fl2Tj2vpxPzSL0rjO/395rnons3c1l693hO7FusneOy+1ChCLuTEJC+69X4nai0YzR2dkCxeo5998bzindoQ9dbrz1Ss+qH6VacYoVpO6rNLqJeLMlCVMeS8yoUnYWuFmplEy65trkvjFMv2Po6NUdjPt3PiNTzx+aXzGlo/nK+axqWMJ7fLcX3jc7Fugaz7VusneNReOpFb+yW+q5X49u7nxH1HMfulet9kAafpcc11Gy9o9LEx/R9IVRTmBaqymixmL/DD57Xiy/6PtlhxJFp5tKOUz9jc084Hp5n2VzTff74/BYKVWt4zpS5VBKqGYzfmlXKopbF2xeeeNHL12OhGnrr1x6X6/3x+n6lDkrPve3bVn+dRHGz0zKepcc11Gz9GdUQ+r6lQ2UunMHzfYvvwF25GqLkj4shRLfk1+hcfbz6/lZzb3vcmk9H9fzR+S0Vqup+/ezJP6uh14eTrBdyeFtkfa6jw+Ov9R+ep4s+vr6yDloz9o2wo+ocl7FGdkg6KD33Spza4/E95vX+tQzESpMVql2UAE0xvdcOVfdzpGjh1edHFrpfaJ3F144RXTd6LjxHNMbqC0v2/MbG8+d7QpWGpTue+bPsnYsVPixbFbAzoGa1UG2vXziG3YUSR0PcLKzasOsQO3/qt7mmWbD2TiGcs4OZHk/nHT9Lh6ayDUJlMj8VD+P+dh7xzi6Y7LjUePr84Fx02LBMox1YZe8H5oWqOQOhWs+w2Pe/UzBCtpN+vDZ0Oeq57DIW4jQ1hKo17IDmikOG7W4vPNvPpe+t3BY2b9cmvLbRuTTf8/kULqmGUInRW5197abC5z4b5w5mE5gpr29wLvXPau65IXbVECpELE4NoULE4tQQKkQsTg2hQsTi1Jih+s3vEBH3I6FCxOIlVIhYvIQKEYuXUCFi8RIqRCxeQoWIxUuoELF4Zw1V9z9aRUQc12qJdvZQWccRES33Fqr4/33GEgAgQKgAoHgIFQAUD6ECgOIhVABQPIQKAIqHUAFA8RAqACgeQgUAxUOoAKB4CBUAFA+hAoDiIVQAUDyECgCKh1ABQPEQKgAoHkIFAMWzaqiuXbuWaEVKBACwmmG1JbhzqOQBFnKcUAGAZqgZVmPEnULV90Dh9PTUjBUAnF+mNMNqzWyhkvea8a+ECgA0U5phtYZQAcBqECoAKB5CBQDFQ6gAoHgIFQAUD6ECgOIhVABQPIQKAIqHUAFA8ew9VBpCBQCaKc2wWrNTqEQZWB6gtSJFqABgqBlWY8SdQyXKA7RWpEQAAKsZVluCs4QqKO81rTjFAgAEpBlWS7SECgD2BqECgOIhVABQPIQKAIqHUAFA8RAqACgeQgUAxUOoAKB4CBUAFA+hAoDiIVQAUDyECgD2zsdP/2Z2IEioAGDvECoAKB5CBQDFU2yoEBFztFqinTVUiIhLSKgQsXgJFSIWL6FCxOIlVIhYvIQKEYuXUCFi8RIqRCxeQlW8z9x7l8Nfjjt0D8xrgkPX5owzg8eH/lnigXuv8+9QPJcL7tKdZ9E57bavKef1zjUOLiWhKtwH71QL5J2T5GvLoWtzxtnZ0yN3KY5THa3NIq+ff/nIPbGuVW77mobOaecaB5eTUBXtibseL+J6Uff9rj50bc44Sxg/X81l0G1fU87rnWscXFJCVbLJwlALJ3bo2pxxFvDJnQO1g5q42Ld9TTmvd65xcFEJVcme9QVXP7d6uxQ/S94GVtF6IPGqz11w14+je2K3fU05r3eucXBRCVXJvikLLv6Myn/I3n6AXn8/82t6U35u2EqoSnb1BSfHm13OdONx+4ye53dU9dvA2uZP1cxd1bavafWfGy4toSpatTCShRM7dG3OOEs4tPgHQrX1a8p5vXONg0tKqAo354/Hh67NGWdn47d6oizwaBclz+++9etf/Nu+pqFz2rnGweUkVMUrv6tXC8R4myULp/uXJfuvHT43v/Wf9PU+L/5LlN3d1Hyv6Wz+3NCWUGFZVruv652IIBIqLMwndw43nwkhegkVIhYvoULE4iVUiFi8k0L1yVPnfv2NPQAi4pJKe6RBmiRUjz917le/tQdBRFxSaY80SJOE6rMvnXv6S3sQRMQllfZIgzRJqF69brZe7KoQcU2lOdIeaZAmCZXw1dfO/ZS3gIi4ktIaaY60x8IMlSA3SN1kKyaD8AE7Is6pNEXaIo2R1vRFSugNlSBbMHm/KB9uyUDyx4aIiHMoTZG2SGOst3sxg6ECACgBQgUAxUOoAKB4CBUAFA+hAoDiIVQAUDyECgCKZzBU/D0qRFzKWf4eVfib6T//3LmfVYP9hFAh4oxKU6Qt0hhpTfbfTJcbTn7RDGI9ABFxTqU10py+WCWhki2Y1I1IIeKaSnOkPdbbwCRU8n5RtmLWQIiISyrtkQZpklDJh1vsphBxH0p7pEGaJFSy9Vrig/MfPfn7JK17EfF8KO2RBmmSUFk3B6ei75MATYVYIaJmq1B978Ef/Fcb4mP6PkKFiDlqskMlQQoG9DF9326hOnFXLlxwFxIP3M2H8XU5PnM3L8oYh+5983wwXNd91vtX/RwuHrn74dqHR+4tfazXqc8P+p/BpLH7bMa4cm/z9Tbj3b91kDFvzPbRt+7td791H1nn3hhfuhsjr1Gz9Y7KMqDvmyVUV0/SY1svmOmhCFFqFrjoF/zVw+799+R7Pc8+FwiVhHLg2U1gQnC3D1UI8lu3ntnncTfPQ6gmvEbN1p9R9UVK0PfNH6oQkG13VRmh8AFqF2a9UKvn3vO/+uc3IYiDNqcjYQm7ud5Q+dfb3r9DqJKxcGtlwd78wn2n9oX7IBx790W14/DH775sr//ow+f+2ui4XH+3ul4fF49f+OtfuNvVvTeO9XF1vbYzFz8/897X7naYb+XbH77ejJFcH107ECvNGQ2VtdBCfIIqQmEx12MdRaEyouXjVEdHR6A+J9c2cwgBS8Pp5xg05xo9M57fxUN3pXM+vN6DzTWVTRRHXnc8dvsz7P78kl3j4Fx2/U0CG6u3Pzefu9uPmu/rCMlCruMVjss1ccDCwlbHw9fx8c748vUXTag64zj3wV1/3H/fsTMX/711r8SojVbfnKPr1XFLzapv/b77w98PKvSGKtGKQlhMOgTdhblZiM15vRvqLkQ/Vryo/YLffN29Jnle8v3I/MLbSH2+nVPP6+nEPFLvCuP7/b3muejezVyW3j2eE/sWa+e47D5UKMLuJASk73o1ficq7RiNnR1QrJ5j373xvOId2tD11muP1Kz6YboVp1hh2o5qs4uoF0uyENWx5LwKRWehq4Va2YRLrm3uC+PUC7a+Ts3RmE/3MyL1/LH5JXMamr+c75qGJYznd0vxfaNzsa7BbPsWa+d4FJ560Ru7pb7r1fj27mdEPcexe+V6H6TBZ+lxDTVb76g08TF9XwjVFKaFqjJaLObv8IPn9eKLvk92GHFkmrm049TP2NwTjofnWTbXdJ8/Pr+FQtUanjNlLpWEagbjt2aVsqhl8faFJ1708vVYqIbe+rXH5Xp/vL5fqYPSc2/7ttVfJ1Hc7LSMZ+lxDTVbf0Y1hL5v6VCZC2fwfN/iO3BXroYo+eNiCNEt+TU6Vx+vvr/V3Nset+bTUT1/dH5Lhaq6Xz978s9q6PXhJOuFHN4WWZ/r6PD4a/2H5+mij6+vrIPWjH0j7Kg6x2WskR2SDkrPvRKn9nh8j3m9fy0DsdJkhWoXJUBTTO+1Q9X9HClaePX5kYXuF1pn8bVjRNeNngvPEY2x+sKSPb+x8fz5nlClYemOZ/4se+dihQ/LVgXsDKhZLVTb6xeOYXehxNEQNwurNuw6xM6f+m2uaRasvVMI5+xgpsfTecfP0qGpbINQmcxPxcO4v51HvLMLJjsuNZ4+PzgXHTYs02gHVtn7gXmhas5AqNYzLPb97xSMkO2kH68NXY56LruMhThNDaFqDTugueKQYbvbC8/2c+l7K7eFzdu1Ca9tdC7N93w+hUuqIVRi9FZnX7up8LnPxrmD2QRmyusbnEv9s5p7bohdNYQKEYtTQ6gQsTg1hAoRi1NDqBCxODVmqH7zO0TE/UioELF4CRUiFi+hQsTiJVSIWLyEChGLl1AhYvESKkQs3llD1f2PVhERx7Vaop09VNZxRETLvYXK+j952IVv/vj/7p+OX/rv8vj8+f+6e//2Z//dOP/xn//jfvDxX/x32/Hx07+5ez/+s/uXx3/1R1IePvmv2l24/+iVe/zZf/vv9ov885F/Thbf/9c/1r56Pf1/I39Xvvr6/9w/P/yT/w5KJPw7QagqCNU6ECrIhVBFEKp1IFSQC6GKIFTrQKggF0IVQajWgVBBLoQqglCtA6GCXAhVBKFaB0IFuRCqCEK1DoQKciFUEYRqHQgV5EKoIgjVOhAqyIVQRRCqdSBUkAuhiiBU60CoIBdCFUGo1oFQQS6EKoJQrQOhglwIVQShWgdCBbkQqghCtQ6ECnIhVBGEah0IFeSyl1Bdu3YtcS4IlQ2h6odQlY/VDKstwZ1DJQ+w6DueC6GyIVT9EKqyGWqG1Rhxp1ANxej09HSWWBEqG0LVD6EqlynNsFozW6jkvWb8K6EiVAKhgpgpzbBaQ6giCNV2ECqYCqEyIFTrQKhgKoTKgFCtA6GCqRAqA0K1DoQKpkKoDAjVOhAqmAqhMiBU60CoYCqEyoBQrQOhgqkQKgNCtQ6ECqZCqAwI1ToQKpjK3kOlIVSESiBUEDOlGVZrdgqVKAPLA7RzREogVDaEqh9CVTZDzbAaI+4cKlEeoJ0LQmVDqPohVOVjNcNqS3CWUAXlvSb/w3mEKoZQgUX4d0KaYbVES6giCNV2ECrIhVBFEKp1IFSQC6GKIFTrQKggF0IVQajWgVBBLoQqglCtA6GCXAhVBKFaB0IFuRCqCEK1DoQKciFUEYRqHQgV5EKoIgjVOhAqyIVQRRCqdSBUkAuhiiBU60CoIBdCFUGo1oFQQS6EKoJQrQOhglwIVQShWgdCBbkQqghCtQ6ECnLZe6gQEXO0WqKdNVSIiEtIqBCxeAkVIhYvoULE4iVUiFi8hAoRi5dQIWLxEipELF5CdW585t67HP6S3aF7YF7jPT1yl9q/kHfg3ov/+R8f+uPGuSWt55Qz78rLR+7JlHNYvITqnPjgnWpxvnOSfJ164q5XC/n6cfP9kzsH1cL2gagXexSnOloj8ZjJes5jz5L59L2uoXNYvITqXCjxiQIztDtJzql7Ow6dm1GJzOWD/jl7JWaX7jzLPoflS6jOg1nxad4ihh1VEwn7bVK921r8LZTMp5r7UFxr5bqh17RCUHExCdV5MCtUYvR5lhWiejw5v/zilxjWO6HRUDWv6VL7OVw8t6FzeBYkVOfBrFDJuc3bpM5nVNrFP6Oq5hJCORaq+ryOk79+6ByeCQnVG2gTF797kA+Qc0KVHTXrnBwPu5eppuGQz5Xat6BjoUrcZt5YqoTqXKgW5tCinyVUcyhjW0GL4jXovuaNS0iozonxX0mIv05tPp8y3/rpt3oStbX+PtLYjmpobvucN84ioTo3xjuU7oJP/ui+jkK4trvz6LytHArH3Bqh0vMemtve5o2zSKgQsXgJFSIWL6FCxOIlVIhYvIQKEYt3Uqg+eercr7+xB0BEXFJpjzRIk4Tq8afO/eq39iCIiEsq7ZEGaZJQffalc09/aQ+CiLik0h5pkCYJ1avXzdaLXRUirqk0R9ojDdIkoRK++tq5n/IWEBFXUlojzZH2WJihEuQGqZtsxWQQPmBHxDmVpkhbpDHSmr5ICb2hEmQLJu8X5cMtGUj+2BARcQ6lKdIWaYz1di9mMFQAACVAqACgeAgVABQPoQKAwnHuHyHxnSX9iHGBAAAAAElFTkSuQmCC" class="img_Ihyu"></p>
<p>A 1-bounded numeric log facet can be used if you'd like to exclude all the values below 1 (including zero and negative numbers).</p>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="text-length-facet">Text-length facet<a href="#text-length-facet" class="hash-link" aria-label="Direct link to Text-length facet" title="Direct link to Text-length facet"></a></h3>
<p>The <span class="menuItems">Text-length facet</span> returns a numerical value for each cell and plots it on a numeric facet chart. The expression used is</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">value.length()</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>This can be useful to, for example, look for values that did not successfully split on an earlier split operation, or to validate that data is a certain expected length (such as whether a date in YYYY/MM/DD is eight to ten characters).</p>
<p>You can also employ a <span class="menuItems">Log of text-length facet</span> that allows you to navigate more easily a wide range of string lengths. This can be useful in the case of web-scraping, where lots of textual data is loaded into single cells and needs to be parsed out.</p>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="unicode-character-code-facet">Unicode character-code facet<a href="#unicode-character-code-facet" class="hash-link" aria-label="Direct link to Unicode character-code facet" title="Direct link to Unicode character-code facet"></a></h3>
<p><img decoding="async" loading="lazy" alt="A screenshot of the Unicode facet." src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASkAAAB7CAYAAAAoqHbKAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAArhSURBVHhe7ZxPixzHHYb3O/nikzA57DfQwQddZfBJLAvxwYdgYVCMUVAQGKEITGwSvBA2WUIuib2JIOgiEYNyimPLIRFOHDAmGEQuqcyvu2umuvqt7vnf1VPPCw/eqa6qrpruera6V/jIEUJIxkFShJCsg6QIIVmnV1LfvXDu6efOPfzUuY+fOPfbxwAA28GcYm4xx5hrUklK6ouv6k7++Gfn/jDr6HdICgC2iDnF3GKOMdeYc1SkpKzy5Z/qDlTnAADbxFxjzlGi6kjKtl1mNQQFAPvEnGPuiR/9OpKy50PbfqlOAAB2ibnHHBSmIyl7kcUuCgDGwNxjDgrTkZRtt3bxkvzXj/63FKotAJSBucccFKYjKdXQs2zidiafZYOoACDMWpK6dfZN89MiYVncDkkBwCqEWVlSJiOPT1wWt9tMUpfu6tGRO7p2GZQ9cycvz8qOTt27rbopVq2/Crvsu5n7y/fdh/L4IZPr3Hd5vWd88rV79a2v3Ufq2MHwrbsxMMcwa++kFD5xOyS1Lhku1Iv77qXWtdgVSEoePwSWmGOYtd9JpQRliduNL6ldUpCkTFCda7ErCpCULdaTz9z3Kp6793zZW89nO42m/M638/ofvf9lUzcot/p3ZvXjcuP8eVP/ubs5a3vjPC6P6se0xtKMT7Z94W768c549f0Xiz469YO6PaIKcyCSWtzQJ9esvObqvVT9GX7BeWT/nuiGDNtem52zc9M24/EMLbTkWPy8jlvHF/MSbY+O3cmFPx63b8bY20Ycr8aT+k765qrOH/WT/G58W3VNxfW8dxocFyS/Y2PP17ti9shz8qW7+Un9uRKQLeJKXL7c6oTy8os6Kvc/h+Wt/u3nz2pJtfpx7r07TXnzuUVrLM1n1dZENBdWasxB/ahcEWavj3s/+ODfvVg2ktR8sS1u8PpmSdT3fTY3+EtvPgv68nUTbX3f8xs4cbzzOWaZsaTmFbVNHVfiGmqjxuPnOtS25/wfvnlc9WcyCX+u+wuJ2/rrUH+O275biSycZ0jPnObn2df1bkgt1Fa57ToiSfhdiZdHqn7Uf0so8z5qWjufkHiMqbbhuMKdWV99NfeAMHt9ca7EFGLZdCdV3xjx8ehz32/d1g0syjrHdd9h+3pBJRZQ31gG5+Xx5Z7U97JEm77xxJIanGv3/F4u7eupEGMPx9YaS988Z/TNScyhVdY5vuH19qQWaqs8kE614MUuKVU/6l/vegaIxzjU1uo3Muo9V9yvIMzaO6k4YVnczktqmexDUvFv4RB5LLgRu8d134qlzzdnaF7N8Rn1IvGfU9/LcJve8USSGp6rOr+fQ1w3RrRtCSH4LppxhaII6ZuTPLbD670gfBybYQvaFm5KOuGCt5+HJNX3uDcvt/pNedU+IpZJou38UbWpZ0Jc7LDEueJ+BWHWfifVl7jdViQlb/TUYoyPR5+bm1DeROI3Y6usc1z3nVowHfrGMjSvTtu4fnqhJ9v0jWeJnVQbcf6Qpr3eVS0x9urzsbt6zUTRs3Ppm5OaQ1jWOb7h9Q6pFrF/FFLvcWLpNHWbF+XdBR/Wn1HJrO77ht9Jtcqtr4GdUSyTRFsT07w8bCPrN3PpEVWYlSS1CSafZVBt6/cNwU0WL5bODT0gqcTCrG+05tiKbZPHO+1jlhhLqi9/7s7OJjWWNdqo8Sz9vXfP37qWvTugpq2vK7/HRZ3WHDtE41Bzmve76+s9BpG8JkCYvUlqU/zNPaf123foRhE3jhed7M/X90Q3XNh2mb/2DN2wybEML4D293LqTirppN8JDbeZ0fPdLNpG55gjvofW+aPvNhrbgkVb/RfbGj8eLbqAnK73Xgh2XjOSL8czJcxkJAWg8JKSj3IwWcIgKZgwfgeTw84FtkkYJAXTZP5uiF3UIRIGSQFAdoRBUgCQHWGQFABkRxgkBQDZEUZK6u//AgAYByQFAFmDpAAga5AUAGQNkgKArEFSAJA1SAoAsgZJAUDWFCOpxf/bJ2/U2AFKpihJqfKcQFIAXbYqqYuLi2wxAeQeG6Maex8//dmv3Pdvna3MGz/U5UM8+OCXchwAq6IcokBSGQVJQUkohyiQVEZBUlASyiEKJJVRkBSUhHKIAkllFCQFJaEcokBSGQVJQUkohyiQVEZBUlASyiEKJJVRkBSUhHKIAkllFCQFJaEcokBSGQVJQUkohyiQVEZBUlASyiEKJJVRkBSUhHKIAkllFCQFJaEcokBSGQVJQUkohyiQVEZBUlASyiEKJJVRkBSUhHKIAkllFCQFJaEcojh4SV2/fr1DblFjVHNRICmYKsohioOWlC12lVT5GOkbo5pTDJKCqaIcojhYSfWJ6PHjx1mIapkxqrmFICmYKsohiiIk5d9H+f/mKKnUGNXcQpAUTBXlEAWSGjFICkpGOUSBpEYMkoKSUQ5RIKkRg6SgZJRDFEhqxCApKBnlEAWSGjFICkpGOUSBpEbMMmNUotgGSArGRjlEgaRGDJKCklEOUSCpEYOkoGSUQxRIasQgKSgZ5RBFEZKKk6Ok4iApOHSUQxQHKynDFrkt9pgcBOXTN0YliW2BpGBslEMUBy0pwxZ7TG5RY1SC2CZICsZGOURx8JLy+Hc9OcfGqMSwC5AUjI1yiAJJZRQkBSWhHKJAUhkFSUFJKIcokFRGQVJQEsohCiSVUZAUlIRyiAJJZRQkBSWhHKJAUhkFSUFJKIcokFRGQVJQEsohCiQ1kIdP/+tunX2zF5AUlIRyiAJJDQRJbc7bP/6FvCZQNsohCiQ1ECS1OUgKFMohCiQ1ECS1OUgKFMohiqIkde83/5FyyAUkBSWhHKJAUhmBpKAklEMUW5WUukGXQU1g2yCpNkgKxkY5RIGkMgJJwRS5+5Nzed2HUA5R5CGpBw92jglgCqjvZxe8Icp2xds/2s81hnG4e/fn8roPoRyi2KqkAAC2DZICgKxBUgCQNUgKALIGSQFA1iApAMgaJAUAWYOkACBrkNTkeebeeWXxj0Gv3H6WOHbqzlrtYvrqrtLPFnh8311p5nP0yn33qHV8onOCtUFSE+fs9dki8wu5WtzH7p3mmlXHXr/s/Kzoq7tKP5tz6V6bicPL9tHt47XH0ld3lX5gXJDUpLEFvZBS77FKYKkdQ1/dVfrZAp3+w/NPdE6wEUhqyvQtrt7FHtFXd5V+tsG2xpLTnGAjkNSUOT+tHvXO7JGoerdy5F47b45NdkFb/4t5VI97/vNk5wSbgKSmjEkqeH9Tf15jIea2oKtz1tK9cvuyesGNpMoFSU2ZZie1+OtX/RercRa0lddiWZ6w3xTrjGXGVuYEOYCkpkxnsQWSihdep25IX91V+tkBa48l4znBSiCpiWN/Pm8/7i0W2yp/Zu+ru0o/m9MWyCZj6au7Sj8wLkhq8oT/KHHxwrnGFrw/1t4p2MJs/8PPdN3+YzugeddW0fnHnBOdE6wNkgKArEFSAJA1SAoAsgZJAUDWICkAyJpBSX38xLm//VM3BgDYJeYec1CYjqQefurcX/+hOwAA2CXmHnNQmI6knn7u3JO/6A4AAHaJucccFKYjqe9e1NstdlMAsE/MOeYec1CYjqQsX3zl3O957AOAPWGuMeeYe+JISVmsslnNtl/WAS/TAWCbmFPMLeYYc40SlCUpKYttu+z50F5kWSf2p0EAgG1gTjG3mGPiR7wwvZIihJCxg6QIIVkHSRFCsg6SIoRkHOf+D4GqmIuhchCYAAAAAElFTkSuQmCC" class="img_Ihyu"></p>
<p>The Unicode facet identifies and returns <a href="https://en.wikipedia.org/wiki/List_of_Unicode_characters" target="_blank" rel="noopener noreferrer">Unicode decimal values</a>. It generates a list of the Unicode numerical values of each character used in each text cell, which allows you to narrow down and search for special characters, punctuation, and other data formatting issues.</p>
<p>This facet creates a numerical chart, which offers you the ability to narrow down to a range of numbers. For example, lowercase characters are numbers 97-122, uppercase characters are numbers 65-90, and numerical digits are numbers 48-57.</p>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="facet-by-error">Facet by error<a href="#facet-by-error" class="hash-link" aria-label="Direct link to Facet by error" title="Direct link to Facet by error"></a></h3>
<p>An error is a data type created by OpenRefine in the process of transforming data. For example, say you had converted a column to the number data type. If one cell had text characters in it, OpenRefine could either output the original text string unchanged or output an error. If you allow errors to be created, you can facet by them later to search for them and fix them.</p>
<p><img decoding="async" loading="lazy" alt="A view of the expressions window with an error converting a string to a number." src="/assets/images/error-5c7e8312a70c68a3eac86531e0f6e012.png" class="img_Ihyu"></p>
<p>To store errors in cells, ensure that you have <span class="fieldLabels">store error</span> selected for the “On error” option in the expressions window.</p>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="facet-by-null-empty-or-blank">Facet by null, empty, or blank<a href="#facet-by-null-empty-or-blank" class="hash-link" aria-label="Direct link to Facet by null, empty, or blank" title="Direct link to Facet by null, empty, or blank"></a></h3>
<p>Any column can be faceted for <a href="#cell-data-types">null and/or empty cells</a>. These can help you find cells where you want to manually enter content.</p>
<p>“Blank” means both null values and empty values. All three facets will generate “true” and “false” facets, “true” being blank.</p>
<p>An empty cell is a cell that is set to contain a string, but doesn’t have any characters in it (a zero-length string). This can be left over from an operation that removed characters, or from manually editing a cell and deleting its contents.</p>
<h3 class="anchor anchorWithStickyNavbar_SRsa" id="facet-by-star-or-flag">Facet by star or flag<a href="#facet-by-star-or-flag" class="hash-link" aria-label="Direct link to Facet by star or flag" title="Direct link to Facet by star or flag"></a></h3>
<p>Stars and flags offer you the opportunity to mark specific rows for yourself for later focus. Stars and flags persist through closing and opening your project, and thus can provide a different function than using a permalink to persist your facets. Stars and flags can be used in any way you want, although they are designed to help you flag errors and star rows of particular importance.</p>
<p>You can manually star or flag rows simply by clicking on the icons to the left of each row.</p>
<p>You can also apply stars or flags to all matching rows by using the <span class="menuItems">All</span> dropdown menu (on the first column) and selecting <span class="menuItems">Edit rows</span> → <span class="menuItems">Star rows</span> or <span class="menuItems">Flag rows</span>. This will create “true” and “false” facets in the <span class="tabLabels">Facet/Filter</span>. These operations will modify all matching rows in your current subset. You can unstar or unflag them as well.</p>
<p>You may wish to create a custom subset of your data through a series of separate faceting activities (rather than successively narrowing down with multiple facets applied). For example, you may wish to:</p>
<ul>
<li>apply a facet</li>
<li>star all the matching rows</li>
<li>remove that facet</li>
<li>apply another, unrelated facet</li>
<li>star all the new matching rows (which will not modify already-starred rows)</li>
<li>remove that facet</li>
<li>and then work with all of the cumulative starred rows.</li>
</ul>
<p>You can also create a text facet on any column with the expression <code>row.starred</code> or <code>row.flagged</code>.</p>
<h2 class="anchor anchorWithStickyNavbar_SRsa" id="text-filter">Text filter<a href="#text-filter" class="hash-link" aria-label="Direct link to Text filter" title="Direct link to Text filter"></a></h2>
<p>Filters allow you to narrow down your data based on whether a given column includes a text string.</p>
<p>When you choose <span class="menuItems">Text filter</span> a box appears in the <span class="tabLabels">Facet/Filter</span> tab that allows you to enter in text. Matching rows will narrow dynamically with every character you enter. You can set the search to be case-sensitive or not, and you can use this box to enter in a regular expression.</p>
<p>For example, you can enter in “side” as a text filter, and it will return all cells in that column containing “side,” “sideways,” “offside,” etc.</p>
<p>The text filter field supports <a href="/docs/manual/expressions#regular-expressions">regular expressions</a>. For example, you can employ a regular expression to view all properly-formatted emails:</p>
<div class="codeBlockContainer_IkL4 theme-code-block" style="--prism-color: #bfc7d5; --prism-background-color: #292d3e;"><div class="codeBlockContent_IvUM"><pre tabindex="0" class="prism-code language-text codeBlock_yBG_ thin-scrollbar" style="color: rgb(191, 199, 213); background-color: rgb(41, 45, 62);"><code class="codeBlockLines_LHw_"><span class="token-line" style="color: rgb(191, 199, 213);"><span class="token plain">([a-zA-Z0-9_\-\.\+]+)@([a-zA-Z0-9\-\.]+)\.([a-zA-Z0-9\-]{2,15})</span><br></span></code></pre><div class="buttonGroup_IffG"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_Rkib" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_jMgp"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_MDiI"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div>
<p>You can press “invert” on this facet to then see blank cells or invalid email addresses.</p>
<p>This filter works differently than facets because it is always active as long as it appears in the sidebar. If you “reset” it, you will delete all the text or expression you have entered.</p>
<p>You can apply multiple text filters in succession, which will successively narrow your data subset. This can be useful if you apply multiple inverted filters, such as to filter out all rows that respond “yes” or “maybe” and only look at the remaining responses.</p></div><footer class="theme-doc-footer docusaurus-mt-lg"><div class="row margin-top--sm theme-doc-footer-edit-meta-row"><div class="col"><a href="https://github.com/OpenRefine/openrefine.github.com/edit/master/docs/manual/facets.md" target="_blank" rel="noopener noreferrer" class="theme-edit-this-page"><svg fill="currentColor" height="20" width="20" viewBox="0 0 40 40" class="iconEdit_BeQX" aria-hidden="true"><g><path d="m34.5 11.7l-3 3.1-6.3-6.3 3.1-3q0.5-0.5 1.2-0.5t1.1 0.5l3.9 3.9q0.5 0.4 0.5 1.1t-0.5 1.2z m-29.5 17.1l18.4-18.5 6.3 6.3-18.4 18.4h-6.3v-6.2z"></path></g></svg>Edit this page</a></div><div class="col lastUpdated_MInM"><span class="theme-last-updated">Last updated<!-- --> on <b><time datetime="2024-04-29T21:25:00.000Z" itemprop="dateModified">Apr 29, 2024</time></b> by <b>WR Smiley</b></span></div></div></footer></article><nav class="pagination-nav docusaurus-mt-lg" aria-label="Docs pages"><a class="pagination-nav__link pagination-nav__link--prev" href="/docs/manual/exploring"><div class="pagination-nav__sublabel">Previous</div><div class="pagination-nav__label">Overview</div></a><a class="pagination-nav__link pagination-nav__link--next" href="/docs/manual/sortview"><div class="pagination-nav__sublabel">Next</div><div class="pagination-nav__label">Sort and view</div></a></nav></div></div></div></div></main></div></div></div><footer class="footer footer--dark"><div class="container container-fluid"><div class="row footer__links"><div class="col footer__col"><div class="footer__title">Get OpenRefine</div><ul class="footer__items clean-list"><li class="footer__item"><a class="footer__link-item" href="/download">Download</a></li><li class="footer__item"><a class="footer__link-item" href="/whats_new">What's new</a></li><li class="footer__item"><a class="footer__link-item" href="/extensions">Extensions</a></li><li class="footer__item"><a class="footer__link-item" href="/distributions">Other distributions</a></li><li class="footer__item"><a class="footer__link-item" href="/ecosystem">Ecosystem</a></li></ul></div><div class="col footer__col"><div class="footer__title">Documentation</div><ul class="footer__items clean-list"><li class="footer__item"><a class="footer__link-item" href="/docs">User manual</a></li><li class="footer__item"><a class="footer__link-item" href="/external_resources">Training and Courses</a></li><li class="footer__item"><a class="footer__link-item" href="/docs/technical-reference/contributing">Contributing</a></li><li class="footer__item"><a class="footer__link-item" href="/privacy">Privacy notice</a></li></ul></div><div class="col footer__col"><div class="footer__title">About OpenRefine</div><ul class="footer__items clean-list"><li class="footer__item"><a class="footer__link-item" href="/openrefine_history">Project history</a></li><li class="footer__item"><a class="footer__link-item" href="/community">Project Roles and Governance</a></li><li class="footer__item"><a class="footer__link-item" href="/usage">Who uses OpenRefine</a></li><li class="footer__item"><a class="footer__link-item" href="/funding">Grants & funding</a></li></ul></div><div class="col footer__col"><div class="footer__title">Social</div><ul class="footer__items clean-list"><li class="footer__item"><a href="https://github.com/OpenRefine" target="_blank" rel="noopener noreferrer" class="footer__link-item">GitHub<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_SaMF"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://forum.openrefine.org/" target="_blank" rel="noopener noreferrer" class="footer__link-item">Forum<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_SaMF"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://gitter.im/OpenRefine/OpenRefine" target="_blank" rel="noopener noreferrer" class="footer__link-item">Gitter chat<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_SaMF"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://twitter.com/openrefine" target="_blank" rel="noopener noreferrer" class="footer__link-item">Twitter<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_SaMF"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item">
<a rel="me" class="footer__link-item" target="_blank" href="https://fosstodon.org/@OpenRefine">Mastodon<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_node_modules-@docusaurus-theme-classic-lib-theme-Icon-ExternalLink-styles-module"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a>
</li></ul></div></div><div class="footer__bottom text--center"><div class="margin-bottom--sm"><a href="https://openrefine.org" rel="noopener noreferrer" class="footerLogoLink_uy_9"><img src="/img/openrefine_logo.svg" alt="OpenRefine diamond logo" class="footer__logo themedComponent_C793 themedComponent--light_p_FH" height="150"></a></div><div class="footer__copyright"><a rel="license" href="http://creativecommons.org/licenses/by/4.0/"><img alt="Creative Commons License" style="border-width:0" src="https://i.creativecommons.org/l/by/4.0/80x15.png"></a><br>OpenRefine's website and documentation is licensed under a <a rel="license" href="http://creativecommons.org/licenses/by/4.0/">Creative Commons Attribution 4.0 International License</a>.</div></div></div></footer></div>
</body></html>