{"version":1,"pages":[{"id":"GRxG9OBvFilKUgPJNQWK","title":"Welcome to Cascade","pathname":"/cascade","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Introduction"}]},{"id":"6KrgJCyQdz81ZzHZ0FWF","title":"Workspaces","pathname":"/cascade/introduction/workspaces","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Introduction"}]},{"id":"A6xiLkaU0umpihwdZB2X","title":"Build Your First Workflow","pathname":"/cascade/getting-started/build-your-first-workflow","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Getting Started"}]},{"id":"oMnfQ8rYgZOzDm5hh5kn","title":"Build Your First Data App","pathname":"/cascade/getting-started/data-apps-101","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Getting Started"}]},{"id":"9RIFNiFGVx4Tvew3UUXj","title":"Overview","pathname":"/cascade/workflows/overview","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Workflows"}]},{"id":"iUckUmKNebrSC2Sj7kyP","title":"Navigating the Canvas","pathname":"/cascade/workflows/overview/navigating-the-canvas","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Workflows"},{"label":"Overview"}]},{"id":"bW9vjXZOBl2nL32v7ROC","title":"Setting Up","pathname":"/cascade/workflows/overview/setting-up","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Workflows"},{"label":"Overview"}]},{"id":"cm0gfGn2RwKXW6bIVarT","title":"Drag and Drop","pathname":"/cascade/workflows/overview/drag-and-drop","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Workflows"},{"label":"Overview"}]},{"id":"Zz6Me3RXkWrnF1cP2exX","title":"Tools","pathname":"/cascade/workflows/overview/tools","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Workflows"},{"label":"Overview"}]},{"id":"ygRqoqbaVxjnmTdldHXP","title":"Dynamic Workflows","pathname":"/cascade/workflows/dynamic-workflows","siteSpaceId":"sitesp_oHs1L","description":"Isolate and reuse workflow logic with Dynamic Workflows","breadcrumbs":[{"label":"Workflows"}]},{"id":"17jpFkS2hA87OuPhI1JQ","title":"Global Variables","pathname":"/cascade/workflows/global-variables","siteSpaceId":"sitesp_oHs1L","description":"A global value set at a workflow level","breadcrumbs":[{"label":"Workflows"}]},{"id":"FQFBQsy58zqyy7r4ezSN","title":"Data Locker","pathname":"/cascade/workflows/data-locker","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Workflows"}]},{"id":"oG0L23fHIJmMzE84LAHb","title":"Scheduling","pathname":"/cascade/workflows/scheduling","siteSpaceId":"sitesp_oHs1L","description":"Set up schedules to automate workflow runs","breadcrumbs":[{"label":"Workflows"}]},{"id":"hQylatX40Jh9zje3p3gn","title":"Webhooks","pathname":"/cascade/workflows/webhooks","siteSpaceId":"sitesp_oHs1L","description":"Set up webhooks to automate workflow runs","breadcrumbs":[{"label":"Workflows"}]},{"id":"hjj5WgPnuXwjXu3qdKGW","title":"Run Logs","pathname":"/cascade/workflows/run-logs","siteSpaceId":"sitesp_oHs1L","description":"Track your workflow runs and run details","breadcrumbs":[{"label":"Workflows"}]},{"id":"WRZTdsstey5uJpRxnOJE","title":"Workflow Deployment","pathname":"/cascade/workflows/workflow-deployment","siteSpaceId":"sitesp_oHs1L","description":"Edit your operationalized workflows by switching from Live to Draft mode","breadcrumbs":[{"label":"Workflows"}]},{"id":"MBo2UXKg2btHwKjYuxUF","title":"Connecting Cascade to your database","pathname":"/cascade/integrations/connecting-cascade-to-your-database","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"oLeJZ5y4VU5QRds07IUI","title":"Amazon S3","pathname":"/cascade/integrations/amazon_s3","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"LbERliG4tjC77t3E0jgM","title":"Azure Blob Storage","pathname":"/cascade/integrations/azure_blob","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"RrPeppzWcOksyW3KlCoN","title":"BigQuery","pathname":"/cascade/integrations/bigquery","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"-MY7tlTOERLcOoj5bwAK","title":"Google Sheets","pathname":"/cascade/integrations/gsheets","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"-MY7tgNz9xgs3jf5v5ZT","title":"MySQL","pathname":"/cascade/integrations/mysql","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"-MYkshYPOjw_J7EMrBvq","title":"Postgres","pathname":"/cascade/integrations/postgres","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"B6eAREIkOR8xo8hy83gQ","title":"Redshift","pathname":"/cascade/integrations/redshift","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"-MY7tcL1QHS3B9O6PPVR","title":"SQL Server","pathname":"/cascade/integrations/sqlserver","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"-MY7tiZu2sdKd9CecNI0","title":"Snowflake","pathname":"/cascade/integrations/snowflake","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"kIsdfZtgQTar8XC4mau1","title":"Tableau Server","pathname":"/cascade/integrations/tableau","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"-MY7Z86iCa2GPikZvG0P","title":"Import","pathname":"/cascade/tools/import","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"}]},{"id":"-MY7uSdg9eeysX85Escb","title":"Import File","pathname":"/cascade/tools/import/import_file","siteSpaceId":"sitesp_oHs1L","description":"Upload a file, or import a file from a URL","breadcrumbs":[{"label":"Tools"},{"label":"Import"}]},{"id":"-MYR3L49CNgVDs0dePk1","title":"Import from Data Locker","pathname":"/cascade/tools/import/import_workspace","siteSpaceId":"sitesp_oHs1L","description":"Import a table, chart or model from your Data Locker","breadcrumbs":[{"label":"Tools"},{"label":"Import"}]},{"id":"IPahNkJsAN58wnvCEHXk","title":"Import from API","pathname":"/cascade/tools/import/import_api","siteSpaceId":"sitesp_oHs1L","description":"Import data from an external service.","breadcrumbs":[{"label":"Tools"},{"label":"Import"}]},{"id":"-Mkim_g0mqBj685nUAkU","title":"Import Sample Data","pathname":"/cascade/tools/import/import_sample","siteSpaceId":"sitesp_oHs1L","description":"Import a sample dataset","breadcrumbs":[{"label":"Tools"},{"label":"Import"}]},{"id":"-MY7tJfSxvxApRAplwfV","title":"New Table","pathname":"/cascade/tools/import/newtable","siteSpaceId":"sitesp_oHs1L","description":"Create a new table from scratch","breadcrumbs":[{"label":"Tools"},{"label":"Import"}]},{"id":"-MYR3TTZR70uwWRJ8fIy","title":"Clean","pathname":"/cascade/tools/cleaning","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"}]},{"id":"WLMaoqf1ZZHiEV1jcIny","title":"Validate Schema","pathname":"/cascade/tools/cleaning/validateschema","siteSpaceId":"sitesp_oHs1L","description":"Validate that a table contains specific columns.","breadcrumbs":[{"label":"Tools"},{"label":"Clean"}]},{"id":"-MYR43cW3b1-7XM_2Tsx","title":"Find/Replace","pathname":"/cascade/tools/cleaning/findreplace","siteSpaceId":"sitesp_oHs1L","description":"Replace values in a column with other values","breadcrumbs":[{"label":"Tools"},{"label":"Clean"}]},{"id":"-MZTqksUFweYYByhYOtZ","title":"Text to Columns","pathname":"/cascade/tools/cleaning/text2columns","siteSpaceId":"sitesp_oHs1L","description":"Split one column into many based on text content","breadcrumbs":[{"label":"Tools"},{"label":"Clean"}]},{"id":"-MlS0G2bXFdJRs78s81N","title":"Flatten Json","pathname":"/cascade/tools/cleaning/flattenjson","siteSpaceId":"sitesp_oHs1L","description":"Flatten JSON allows you to flatten json strings in selected columns from a table.","breadcrumbs":[{"label":"Tools"},{"label":"Clean"}]},{"id":"-MlS0Oq0-TkdSREqZsQD","title":"Sample","pathname":"/cascade/tools/cleaning/sample","siteSpaceId":"sitesp_oHs1L","description":"Sample pulls a portion of data from a tool based on rules.","breadcrumbs":[{"label":"Tools"},{"label":"Clean"}]},{"id":"4GJC4eWJ6FQ9iZGUSWPM","title":"Standardize","pathname":"/cascade/tools/cleaning/standardize","siteSpaceId":"sitesp_oHs1L","description":"Standardize data to a specified output format","breadcrumbs":[{"label":"Tools"},{"label":"Clean"}]},{"id":"GiPXkdLbewbF4tH2rUeA","title":"Validate","pathname":"/cascade/tools/cleaning/validation","siteSpaceId":"sitesp_oHs1L","description":"Validate your data meets expectations","breadcrumbs":[{"label":"Tools"},{"label":"Clean"}]},{"id":"-MYR3VitlsJbn1zYwOsd","title":"Transform","pathname":"/cascade/tools/transform","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"}]},{"id":"-MYR3klipPHFAYQUwSqu","title":"Edit Columns","pathname":"/cascade/tools/transform/editcolumns","siteSpaceId":"sitesp_oHs1L","description":"Add new expression-based columns, rename and retype columns","breadcrumbs":[{"label":"Tools"},{"label":"Transform"}]},{"id":"8PNZLCuuj2ctTKvYJFSf","title":"Select Columns","pathname":"/cascade/tools/transform/selectcolumns","siteSpaceId":"sitesp_oHs1L","description":"Select Columns allows you to keep or drop selected columns from a table.","breadcrumbs":[{"label":"Tools"},{"label":"Transform"}]},{"id":"-MYR3o1w3rCmzihDSyfB","title":"Filter","pathname":"/cascade/tools/transform/filter","siteSpaceId":"sitesp_oHs1L","description":"Select records from a table based on row criteria","breadcrumbs":[{"label":"Tools"},{"label":"Transform"}]},{"id":"-MYR3pcRcp0yR2ZBkvJD","title":"Sort","pathname":"/cascade/tools/transform/sort","siteSpaceId":"sitesp_oHs1L","description":"Reorder a table based on row values","breadcrumbs":[{"label":"Tools"},{"label":"Transform"}]},{"id":"-MYR3r3o9e06fuhOlQaL","title":"Pivot","pathname":"/cascade/tools/transform/pivot","siteSpaceId":"sitesp_oHs1L","description":"Aggregate the values in a table","breadcrumbs":[{"label":"Tools"},{"label":"Transform"}]},{"id":"-MYR3sw6TBaebRV7_dYh","title":"Unpivot","pathname":"/cascade/tools/transform/unpivot","siteSpaceId":"sitesp_oHs1L","description":"Convert column values into rows","breadcrumbs":[{"label":"Tools"},{"label":"Transform"}]},{"id":"-MYR8MgL8H84VFsIAh6d","title":"Deduplicate","pathname":"/cascade/tools/transform/dedupe","siteSpaceId":"sitesp_oHs1L","description":"Remove duplicate values in a column","breadcrumbs":[{"label":"Tools"},{"label":"Transform"}]},{"id":"-MYR50rfoELemkc0yEnU","title":"Merge","pathname":"/cascade/tools/combine","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"}]},{"id":"-MYR5DXVgXDD3zLfPJm2","title":"Append","pathname":"/cascade/tools/combine/append","siteSpaceId":"sitesp_oHs1L","description":"Stack tables with similar columns on top of each other","breadcrumbs":[{"label":"Tools"},{"label":"Merge"}]},{"id":"-MYR53LZav2IXstYpCav","title":"Join","pathname":"/cascade/tools/combine/join","siteSpaceId":"sitesp_oHs1L","description":"Combine two tables based on common field","breadcrumbs":[{"label":"Tools"},{"label":"Merge"}]},{"id":"QAEVSsqHuRBL5SC4ZaPP","title":"Multi Join","pathname":"/cascade/tools/combine/multijoin","siteSpaceId":"sitesp_oHs1L","description":"Combine two or more tables based on common field","breadcrumbs":[{"label":"Tools"},{"label":"Merge"}]},{"id":"-MlRnmfVOQg5TE4BjQ-S","title":"Fuzzy Join","pathname":"/cascade/tools/combine/fuzzyjoin","siteSpaceId":"sitesp_oHs1L","description":"Fuzzy Join combines two datasets into a single table, based on a similar shared column.","breadcrumbs":[{"label":"Tools"},{"label":"Merge"}]},{"id":"-MYR7McOuTV89-y0micw","title":"Predictive Modeling","pathname":"/cascade/tools/data_science","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"}]},{"id":"-MYR7WAMwB_XVmWkmXk4","title":"Build Model","pathname":"/cascade/tools/data_science/buildmodel","siteSpaceId":"sitesp_oHs1L","description":"Train a predictive model based on training data","breadcrumbs":[{"label":"Tools"},{"label":"Predictive Modeling"}]},{"id":"-MYR7YIc87s2w7PvolbS","title":"Apply Model","pathname":"/cascade/tools/data_science/applymodel","siteSpaceId":"sitesp_oHs1L","description":"Apply a predictive model to test data","breadcrumbs":[{"label":"Tools"},{"label":"Predictive Modeling"}]},{"id":"-MYR7SOO4GCX71dS88ZN","title":"Correlate","pathname":"/cascade/tools/data_science/varimportance","siteSpaceId":"sitesp_oHs1L","description":"Determine relationships between numeric columns","breadcrumbs":[{"label":"Tools"},{"label":"Predictive Modeling"}]},{"id":"NzCZAGcXuqTrutnsi9BE","title":"ARIMA Forecast","pathname":"/cascade/tools/data_science/arimaforecast","siteSpaceId":"sitesp_oHs1L","description":"Time-series forecasting","breadcrumbs":[{"label":"Tools"},{"label":"Predictive Modeling"}]},{"id":"IiojjBVemFhf6syR4OqH","title":"Flow","pathname":"/cascade/tools/flow","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"}]},{"id":"jVETTNTKGkZAls8BmsMi","title":"Conditional","pathname":"/cascade/tools/flow/conditional","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Flow"}]},{"id":"9QylnDQfKWXnSHvQDWoW","title":"Code","pathname":"/cascade/tools/code","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"}]},{"id":"-MYR7U_6WYLcE45W-KbK","title":"Python","pathname":"/cascade/tools/code/pythoncode","siteSpaceId":"sitesp_oHs1L","description":"Insert custom Python code","breadcrumbs":[{"label":"Tools"},{"label":"Code"}]},{"id":"fHWAobev9TQWumWc4lGn","title":"SQL","pathname":"/cascade/tools/code/sql","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Code"}]},{"id":"-MYR7OftMMdLPqnlRYDe","title":"Visualize","pathname":"/cascade/tools/visualize","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"}]},{"id":"y6hDjrs6oDyQhvAvURRy","title":"Chart","pathname":"/cascade/tools/visualize/chart","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"}]},{"id":"lBtskDYVHavJQgkOFLxH","title":"Bar","pathname":"/cascade/tools/visualize/chart/bar","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"},{"label":"Chart"}]},{"id":"8TssAPx2DSHDxAKFDLgh","title":"Line","pathname":"/cascade/tools/visualize/chart/line","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"},{"label":"Chart"}]},{"id":"97d4IbUHfklSXSTXpV7U","title":"Combo","pathname":"/cascade/tools/visualize/chart/combo","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"},{"label":"Chart"}]},{"id":"GW7ps7c4hN6rWTx1th6p","title":"Scatter","pathname":"/cascade/tools/visualize/chart/scatter","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"},{"label":"Chart"}]},{"id":"jUT2Cw3sBEvPJRfU0LDy","title":"Histogram","pathname":"/cascade/tools/visualize/chart/histogram","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"},{"label":"Chart"}]},{"id":"GdWysA3n9EiIIumUsaUW","title":"Box","pathname":"/cascade/tools/visualize/chart/box","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"},{"label":"Chart"}]},{"id":"izgEG7kgTHzeBF04lxGX","title":"Pie","pathname":"/cascade/tools/visualize/chart/pie","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"},{"label":"Chart"}]},{"id":"G6tZQ2tHvkjC1wABJjwp","title":"Area","pathname":"/cascade/tools/visualize/chart/area","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"},{"label":"Chart"}]},{"id":"2WthYbhY1TX6vuS1bNeH","title":"Funnel","pathname":"/cascade/tools/visualize/chart/funnel","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"},{"label":"Visualize"},{"label":"Chart"}]},{"id":"-MYR7QmVlR9yjaoIG-RZ","title":"Publish","pathname":"/cascade/tools/publish","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Tools"}]},{"id":"-MYR7gd6RJ3W_-qGGute","title":"Publish to Data Locker","pathname":"/cascade/tools/publish/publish","siteSpaceId":"sitesp_oHs1L","description":"Publish an output to your Data Locker","breadcrumbs":[{"label":"Tools"},{"label":"Publish"}]},{"id":"YsosuRlgwViw0t3xj0m5","title":"Publish via Email","pathname":"/cascade/tools/publish/publish_email","siteSpaceId":"sitesp_oHs1L","description":"Publish via Email sends tables (CSV, XLSX, HYPER) or charts (PNG) to email recipients of your choice.","breadcrumbs":[{"label":"Tools"},{"label":"Publish"}]},{"id":"-MlRiKCSxVYVMNn1E0_K","title":"Publish to URL","pathname":"/cascade/tools/publish/publish_url","siteSpaceId":"sitesp_oHs1L","description":"Publish to URL sends a table as a CSV to a hosted destination.","breadcrumbs":[{"label":"Tools"},{"label":"Publish"}]},{"id":"lQTiipuqGDxcTgjnjAkZ","title":"Embed","pathname":"/cascade/tools/publish/embed","siteSpaceId":"sitesp_oHs1L","description":"Embed exposes the interactive content of any table or chart to a third party product via a URL.","breadcrumbs":[{"label":"Tools"},{"label":"Publish"}]},{"id":"T7YUwNyLTHw1N4kPKW5S","title":"Functions","pathname":"/cascade/functions-and-expressions/functions","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"}]},{"id":"-MYRIYamxUhNj9NZPOSq","title":"Aggregate Functions","pathname":"/cascade/functions-and-expressions/functions/aggregate","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"}]},{"id":"-MYRjkEyvdY23HhOIWSP","title":"AVERAGE","pathname":"/cascade/functions-and-expressions/functions/aggregate/average","siteSpaceId":"sitesp_oHs1L","description":"Averages a list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"lOZweH5oDSbHXMN8KElF","title":"CORR","pathname":"/cascade/functions-and-expressions/functions/aggregate/corr","siteSpaceId":"sitesp_oHs1L","description":"Calculates a correlation coefficient","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYUzogAwY0KXagHb1Sp","title":"COUNT","pathname":"/cascade/functions-and-expressions/functions/aggregate/count","siteSpaceId":"sitesp_oHs1L","description":"Returns the count of all non-null values in a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MggPc7xqj1G1H2gLB6x","title":"COUNTD","pathname":"/cascade/functions-and-expressions/functions/aggregate/countd","siteSpaceId":"sitesp_oHs1L","description":"Returns count of distinct values within a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYWjbLWVTjnmR9NdI8L","title":"COUNTBY","pathname":"/cascade/functions-and-expressions/functions/aggregate/countby","siteSpaceId":"sitesp_oHs1L","description":"Counts the number of values within a column, partitioned by the unique values of a separate column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYWujA0jSFJeBGQhO6_","title":"COUNTIF","pathname":"/cascade/functions-and-expressions/functions/aggregate/countif","siteSpaceId":"sitesp_oHs1L","description":"Counts values based on a condition","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYXhbC4txpTIhQilIoE","title":"COUNTIFS","pathname":"/cascade/functions-and-expressions/functions/aggregate/countifs","siteSpaceId":"sitesp_oHs1L","description":"Counts values based on multiple conditions","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"TDEtvC7ZXhxRlbtdfR3v","title":"COVAR","pathname":"/cascade/functions-and-expressions/functions/aggregate/covar","siteSpaceId":"sitesp_oHs1L","description":"Calculates covariance","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"1g3LWku41sBFJNXFlJSH","title":"COVARP","pathname":"/cascade/functions-and-expressions/functions/aggregate/covarp","siteSpaceId":"sitesp_oHs1L","description":"Calculates population covariance","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"Ie7fpOxUCLsvc6dgms9F","title":"COVARS","pathname":"/cascade/functions-and-expressions/functions/aggregate/covars","siteSpaceId":"sitesp_oHs1L","description":"Calculates sample covariance","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYXnFrtMpVC_qd_fYX1","title":"MAX","pathname":"/cascade/functions-and-expressions/functions/aggregate/max","siteSpaceId":"sitesp_oHs1L","description":"Finds maximum value in a list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYXtemOnn-Ef7A3Jvgf","title":"MEDIAN","pathname":"/cascade/functions-and-expressions/functions/aggregate/median","siteSpaceId":"sitesp_oHs1L","description":"Finds median value of a list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYXv9P8jVHIq2hUSaeu","title":"MIN","pathname":"/cascade/functions-and-expressions/functions/aggregate/min","siteSpaceId":"sitesp_oHs1L","description":"Finds minimum value in a list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-Mfcbmziww8fWRTN1VlR","title":"MAXBY","pathname":"/cascade/functions-and-expressions/functions/aggregate/maxby","siteSpaceId":"sitesp_oHs1L","description":"Finds the maximum of a list of numbers, partitioned by the unique values of a separate column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MfcTl3BZpR6_JHcNA94","title":"MINBY","pathname":"/cascade/functions-and-expressions/functions/aggregate/minby","siteSpaceId":"sitesp_oHs1L","description":"Finds the minimum of a list of numbers, partitioned by the unique values of a separate column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYYF-bRQqihEYevJhFt","title":"PERCENTILE","pathname":"/cascade/functions-and-expressions/functions/aggregate/percentile","siteSpaceId":"sitesp_oHs1L","description":"Computes nth percentile of a list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MgfcTZbb2Q9wlj0UzTA","title":"STDEV","pathname":"/cascade/functions-and-expressions/functions/aggregate/stdev","siteSpaceId":"sitesp_oHs1L","description":"Returns the standard deviation of a list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"ppYKph0g4Q8ui7SeoWPi","title":"STDEVP","pathname":"/cascade/functions-and-expressions/functions/aggregate/stdevp","siteSpaceId":"sitesp_oHs1L","description":"Returns the standard deviation of a list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"Y59vXCxpUHfSKp1P9why","title":"STDEVS","pathname":"/cascade/functions-and-expressions/functions/aggregate/stdevs","siteSpaceId":"sitesp_oHs1L","description":"Returns the sample standard deviation of a list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYYGdPhlJaShvf7JtoK","title":"SUM","pathname":"/cascade/functions-and-expressions/functions/aggregate/sum","siteSpaceId":"sitesp_oHs1L","description":"Sums a list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MYYHEF7Qq1yRrrvDHoB","title":"SUMBY","pathname":"/cascade/functions-and-expressions/functions/aggregate/sumby","siteSpaceId":"sitesp_oHs1L","description":"Sums a list of numbers, partitioned by the unique values of a separate column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"-MggFtWx86NdYc07ner0","title":"SUMIF","pathname":"/cascade/functions-and-expressions/functions/aggregate/sumif","siteSpaceId":"sitesp_oHs1L","description":"Sums values within a column if specified criteria is met","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"2CwaNZwSkC2WCJi4hWUQ","title":"VAR","pathname":"/cascade/functions-and-expressions/functions/aggregate/var","siteSpaceId":"sitesp_oHs1L","description":"Calculates variance","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"shSkpME2QQTHOslE7IjI","title":"VARP","pathname":"/cascade/functions-and-expressions/functions/aggregate/varp","siteSpaceId":"sitesp_oHs1L","description":"Calculates a population variance","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"050R7ubyGPINR2rP1Fb6","title":"VARS","pathname":"/cascade/functions-and-expressions/functions/aggregate/vars","siteSpaceId":"sitesp_oHs1L","description":"Calculates a sample variance","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"WhVc1KnFBdZVmHTV5DSu","title":"RUNNINGTOTALBY","pathname":"/cascade/functions-and-expressions/functions/aggregate/runningtotalby","siteSpaceId":"sitesp_oHs1L","description":"Calculates a running total when grouped by a partition column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"}]},{"id":"PxShOBTTgGM4JPWfrDlW","title":"SIGN","pathname":"/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sign","siteSpaceId":"sitesp_oHs1L","description":"Determines the sign of a number","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"},{"label":"RUNNINGTOTALBY"}]},{"id":"-MeVIrELkqePW3Sd_qLj","title":"SIN","pathname":"/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sin","siteSpaceId":"sitesp_oHs1L","description":"Calculates the sine of an angle","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"},{"label":"RUNNINGTOTALBY"}]},{"id":"-MjUS5FU4hn6C6mgBVOf","title":"SQRT","pathname":"/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sqrt","siteSpaceId":"sitesp_oHs1L","description":"Takes the square root of a given number","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"},{"label":"RUNNINGTOTALBY"}]},{"id":"cmQ1bgtEUze6uMJA6IsX","title":"SQUARE","pathname":"/cascade/functions-and-expressions/functions/aggregate/runningtotalby/square","siteSpaceId":"sitesp_oHs1L","description":"Squares a given number","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"},{"label":"RUNNINGTOTALBY"}]},{"id":"-MeVJlDMAlbSoed2i6hb","title":"TAN","pathname":"/cascade/functions-and-expressions/functions/aggregate/runningtotalby/tan","siteSpaceId":"sitesp_oHs1L","description":"Calculates the tangent of an angle","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"},{"label":"RUNNINGTOTALBY"}]},{"id":"vRWyG3HutWmQWd5YTYXp","title":"ZN","pathname":"/cascade/functions-and-expressions/functions/aggregate/runningtotalby/zn","siteSpaceId":"sitesp_oHs1L","description":"Fill all null values with 0","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Aggregate Functions"},{"label":"RUNNINGTOTALBY"}]},{"id":"-MYRIsAHt26YjMHBS-y-","title":"Conversion Functions","pathname":"/cascade/functions-and-expressions/functions/conversion","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"}]},{"id":"tfLKq52n8BZ7MhCohu3F","title":"TIMESTAMPTODATE","pathname":"/cascade/functions-and-expressions/functions/conversion/timestamptodate","siteSpaceId":"sitesp_oHs1L","description":"Converts a timestamp into a date/time value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Conversion Functions"}]},{"id":"-MYYKhMNtaXsOcTVgT2G","title":"TODATE","pathname":"/cascade/functions-and-expressions/functions/conversion/todate","siteSpaceId":"sitesp_oHs1L","description":"Converts text into a date/time value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Conversion Functions"}]},{"id":"-MkrvwJr7TmvcoKVcbOF","title":"TODECIMAL","pathname":"/cascade/functions-and-expressions/functions/conversion/todecimal","siteSpaceId":"sitesp_oHs1L","description":"Converts text into a decimal number","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Conversion Functions"}]},{"id":"-MYYN5NgQuOsLdiDAyCH","title":"TOINT","pathname":"/cascade/functions-and-expressions/functions/conversion/toint","siteSpaceId":"sitesp_oHs1L","description":"Converts text into an integer","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Conversion Functions"}]},{"id":"-MYRIkgvWpK19bZfkBAZ","title":"Date/Time Functions","pathname":"/cascade/functions-and-expressions/functions/date-time","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"}]},{"id":"-MgR-sujQvcN6YfYp8ql","title":"DATEADD","pathname":"/cascade/functions-and-expressions/functions/date-time/dateadd","siteSpaceId":"sitesp_oHs1L","description":"Adds or subtracts a specific number of time steps from a date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MYYQQjXBOFErhzvMcWg","title":"DATEDIF","pathname":"/cascade/functions-and-expressions/functions/date-time/datedif","siteSpaceId":"sitesp_oHs1L","description":"Calculates the number of time steps between two dates","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"ijskfLpK2wt93X8Zslvt","title":"DATENAME","pathname":"/cascade/functions-and-expressions/functions/date-time/datename","siteSpaceId":"sitesp_oHs1L","description":"Returns text corresponding to the specified part of a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MkrxdHnq4ANPB6cuADi","title":"DATENORMALIZE","pathname":"/cascade/functions-and-expressions/functions/date-time/datenormalize","siteSpaceId":"sitesp_oHs1L","description":"Converts times to midnight","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"ImffMKvr4u6iSGvG8Y0Q","title":"DATEPART","pathname":"/cascade/functions-and-expressions/functions/date-time/datepart","siteSpaceId":"sitesp_oHs1L","description":"Returns the specified part of a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"27SQKfmak31RtrhQi1TX","title":"DATETRUNC","pathname":"/cascade/functions-and-expressions/functions/date-time/datetrunc","siteSpaceId":"sitesp_oHs1L","description":"Truncates a date to the beginning of the specified period","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MYYOyOxsaqiA4vECS58","title":"DAY","pathname":"/cascade/functions-and-expressions/functions/date-time/day","siteSpaceId":"sitesp_oHs1L","description":"Calculates the day of the month for a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MYlLPX26OKiA0KOUpdl","title":"DAYS","pathname":"/cascade/functions-and-expressions/functions/date-time/days","siteSpaceId":"sitesp_oHs1L","description":"Calculates the number of days between two dates","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MYYPy1am0Tnp1adeut9","title":"HOUR","pathname":"/cascade/functions-and-expressions/functions/date-time/hour","siteSpaceId":"sitesp_oHs1L","description":"Calculates the hour corresponding to a date/time value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"9d532lEQcwMUPiFCUfGd","title":"ISDATE","pathname":"/cascade/functions-and-expressions/functions/date-time/isdate","siteSpaceId":"sitesp_oHs1L","description":"Determines if a given date is a valid date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"CgePzudYRPAuBpsMOpmP","title":"ISOWEEKDAY","pathname":"/cascade/functions-and-expressions/functions/date-time/isoweekday","siteSpaceId":"sitesp_oHs1L","description":"Returns the ISO8601 weekday of a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"ZzEpLe6sbyF2TCNAfkYx","title":"ISOWEEK","pathname":"/cascade/functions-and-expressions/functions/date-time/isoweek","siteSpaceId":"sitesp_oHs1L","description":"Returns the ISO8601 week of a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"NuMX1Vdv8HqpzdmTiXmT","title":"ISOQUARTER","pathname":"/cascade/functions-and-expressions/functions/date-time/isoquarter","siteSpaceId":"sitesp_oHs1L","description":"Returns the ISO8601 quarter of a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"sFNOhE1wS2kCb7nNqYua","title":"ISOYEAR","pathname":"/cascade/functions-and-expressions/functions/date-time/isoyear","siteSpaceId":"sitesp_oHs1L","description":"Returns the ISO8601 year of a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"GIbFdUbB0keBB6ukPRnc","title":"MAKEDATE","pathname":"/cascade/functions-and-expressions/functions/date-time/makedate","siteSpaceId":"sitesp_oHs1L","description":"Create a date/time value from a given year, month, and day","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"4Fuzu8M2W1jPVWcMLI3S","title":"MAKEDATETIME","pathname":"/cascade/functions-and-expressions/functions/date-time/makedatetime","siteSpaceId":"sitesp_oHs1L","description":"Create a date/time value from a given date and time","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"5ywQUMtBmbMCTmA3xZbx","title":"MINUTE","pathname":"/cascade/functions-and-expressions/functions/date-time/minute","siteSpaceId":"sitesp_oHs1L","description":"Calculates the minute corresponding to a date/time value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MYYRgl_SVZ5jXILW5XA","title":"MONTH","pathname":"/cascade/functions-and-expressions/functions/date-time/month","siteSpaceId":"sitesp_oHs1L","description":"Calculates the month for a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"n7mEN9MlfX7pfuNcCodj","title":"NOW","pathname":"/cascade/functions-and-expressions/functions/date-time/now","siteSpaceId":"sitesp_oHs1L","description":"Returns current timestamp on local system","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"ZW4GSKaEmHzuTMC5jlcG","title":"QUARTER","pathname":"/cascade/functions-and-expressions/functions/date-time/quarter","siteSpaceId":"sitesp_oHs1L","description":"Returns the quarter of a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"jAisxMTq569lDWGncrBx","title":"SECOND","pathname":"/cascade/functions-and-expressions/functions/date-time/second","siteSpaceId":"sitesp_oHs1L","description":"Calculates the second corresponding to a date/time value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MYYRwxA7iOvvwWyofH2","title":"TODAY","pathname":"/cascade/functions-and-expressions/functions/date-time/today","siteSpaceId":"sitesp_oHs1L","description":"Returns the current date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"xHORALPUGLVENMCnwmE4","title":"WEEK","pathname":"/cascade/functions-and-expressions/functions/date-time/week","siteSpaceId":"sitesp_oHs1L","description":"Calculates the week for a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MgR4TVTYJiakLZI35OS","title":"WEEKDAY","pathname":"/cascade/functions-and-expressions/functions/date-time/weekday","siteSpaceId":"sitesp_oHs1L","description":"Converts a date into an integer corresponding to a day of the week","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MYYTFrXSeI4cAb8VMNy","title":"YEAR","pathname":"/cascade/functions-and-expressions/functions/date-time/year","siteSpaceId":"sitesp_oHs1L","description":"Calculates the year for a given date","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Date/Time Functions"}]},{"id":"-MYRITmuFyKY5nZOM8fA","title":"Logical Functions","pathname":"/cascade/functions-and-expressions/functions/logical","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"}]},{"id":"-MYYTyfEzfIcMSx0Vb7p","title":"AND","pathname":"/cascade/functions-and-expressions/functions/logical/and","siteSpaceId":"sitesp_oHs1L","description":"Returns true if all items are true, otherwise returns false","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"CdaISDBO4aLpr3uQKm2z","title":"BETWEEN","pathname":"/cascade/functions-and-expressions/functions/logical/between","siteSpaceId":"sitesp_oHs1L","description":"Determines if given value is between two boundary values","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"twaWJVWpakCsryFsM3TI","title":"CASE","pathname":"/cascade/functions-and-expressions/functions/logical/case","siteSpaceId":"sitesp_oHs1L","description":"Returns specified values when condition is met","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-MYYUlQLXv6LRUltUCvg","title":"CHOOSE","pathname":"/cascade/functions-and-expressions/functions/logical/choose","siteSpaceId":"sitesp_oHs1L","description":"Finds the value located at a specified index","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"EeIWHDCg7jhx9HZ2NIw6","title":"CONTAINSWITHIN","pathname":"/cascade/functions-and-expressions/functions/logical/containswithin","siteSpaceId":"sitesp_oHs1L","description":"Returns true if the given value exists within a column or list of values.","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-MYYVdWp5hn-zzPxldsW","title":"IF","pathname":"/cascade/functions-and-expressions/functions/logical/if","siteSpaceId":"sitesp_oHs1L","description":"Tests whether expression is true or false and returns desired values accordingly","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"eEAIud4Fi4Sdv6MRB4iZ","title":"IFS","pathname":"/cascade/functions-and-expressions/functions/logical/ifs","siteSpaceId":"sitesp_oHs1L","description":"Implements multiple if-then statements simultaneously","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"nbq82rUO4BBP0tWnkR42","title":"IIF","pathname":"/cascade/functions-and-expressions/functions/logical/iif","siteSpaceId":"sitesp_oHs1L","description":"An if-then statement with capability of returning a third, unique value if condition is null","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-MknCkG5GzFWDJUF98P0","title":"IN","pathname":"/cascade/functions-and-expressions/functions/logical/in","siteSpaceId":"sitesp_oHs1L","description":"Returns true if the given value exists within a column or list of values.","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"N4GnjYa0Q1OpkrIkGx7J","title":"IFNULL","pathname":"/cascade/functions-and-expressions/functions/logical/ifnull","siteSpaceId":"sitesp_oHs1L","description":"Returns values dependent on if input values are null or not","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"3HgUkUIVhPDbEcv1k7T5","title":"ISBOOLEAN","pathname":"/cascade/functions-and-expressions/functions/logical/isboolean","siteSpaceId":"sitesp_oHs1L","description":"Determine if given values are boolean","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"iuv8ZPI9JaEYrlLzoS7d","title":"ISDECIMAL","pathname":"/cascade/functions-and-expressions/functions/logical/isdecimal","siteSpaceId":"sitesp_oHs1L","description":"Determine if given values are decimals","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"JfTfZ5tE7n2zhAo9xJP8","title":"ISDURATION","pathname":"/cascade/functions-and-expressions/functions/logical/isduration","siteSpaceId":"sitesp_oHs1L","description":"Determine if given values are durations","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"JfjFerjtbkF5k3LzzRVU","title":"ISINTEGER","pathname":"/cascade/functions-and-expressions/functions/logical/isinteger","siteSpaceId":"sitesp_oHs1L","description":"Determine if given values are integers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-MYYX6Wm4hzIuIl0L3dq","title":"ISNULL","pathname":"/cascade/functions-and-expressions/functions/logical/isnull","siteSpaceId":"sitesp_oHs1L","description":"Returns true for null values and false otherwise","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"iZfV58A3zQFUY7M0G52E","title":"ISNUMBER","pathname":"/cascade/functions-and-expressions/functions/logical/isnumber","siteSpaceId":"sitesp_oHs1L","description":"Determine if given values are numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"pVPJoxQVQ0f7NAQxqpHi","title":"ISSTRING","pathname":"/cascade/functions-and-expressions/functions/logical/isstring","siteSpaceId":"sitesp_oHs1L","description":"Determine if given values are strings","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"97mMlwh9wGVprfChquFj","title":"ISUNIQUE","pathname":"/cascade/functions-and-expressions/functions/logical/isunique","siteSpaceId":"sitesp_oHs1L","description":"Determines if the values in a column are unique","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-MYY_dTaysiWc7pjHJ3B","title":"NOT","pathname":"/cascade/functions-and-expressions/functions/logical/not","siteSpaceId":"sitesp_oHs1L","description":"Returns true when a condition is false and false otherwise","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-MgNEPMWiGUCCfaUxD_y","title":"NULL","pathname":"/cascade/functions-and-expressions/functions/logical/null","siteSpaceId":"sitesp_oHs1L","description":"Returns null value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-MY_pyx0PFxI4Vcfv8K_","title":"OR","pathname":"/cascade/functions-and-expressions/functions/logical/or","siteSpaceId":"sitesp_oHs1L","description":"Returns true if any of multiple conditions are true, otherwise returns false","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-MY_r4IhZPXfH7VHQnIl","title":"SWITCH","pathname":"/cascade/functions-and-expressions/functions/logical/switch","siteSpaceId":"sitesp_oHs1L","description":"Switches values with new values if original value matches key","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"ZEOTLFCidsRrb8LSUxh4","title":"ALL","pathname":"/cascade/functions-and-expressions/functions/logical/all","siteSpaceId":"sitesp_oHs1L","description":"Determine if all elements of a column are true","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-Ma0pTljoQzRBVtZUGnH","title":"TOSTRING","pathname":"/cascade/functions-and-expressions/functions/logical/all/tostring","siteSpaceId":"sitesp_oHs1L","description":"Convert a value into a string","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"},{"label":"ALL"}]},{"id":"XcbpJGnfivEuCgjterOR","title":"ANY","pathname":"/cascade/functions-and-expressions/functions/logical/any","siteSpaceId":"sitesp_oHs1L","description":"Determine if any elements of a column are true","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Logical Functions"}]},{"id":"-MXdVJ_Z4Ri20cJ76jTL","title":"Math Functions","pathname":"/cascade/functions-and-expressions/functions/math","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"}]},{"id":"-MY_w3-7Tt_A7q49fiu8","title":"ABS","pathname":"/cascade/functions-and-expressions/functions/math/abs","siteSpaceId":"sitesp_oHs1L","description":"Calculates the absolute value of a number","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Me_dtlX7XAg018BsnR9","title":"ACOS","pathname":"/cascade/functions-and-expressions/functions/math/acos","siteSpaceId":"sitesp_oHs1L","description":"Calculates the arc cosine of a number","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Me_mdSdKQmzjzfupvUO","title":"ASIN","pathname":"/cascade/functions-and-expressions/functions/math/asin","siteSpaceId":"sitesp_oHs1L","description":"Calculates the arc sine of a number","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Me_r9QZBSBDuWEty0Xn","title":"ATAN","pathname":"/cascade/functions-and-expressions/functions/math/atan","siteSpaceId":"sitesp_oHs1L","description":"Calculates the arc tangent of a number","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Mea1pK8Uoco9IkOEsQW","title":"ATAN2","pathname":"/cascade/functions-and-expressions/functions/math/atan2","siteSpaceId":"sitesp_oHs1L","description":"Calculates the arc tangent of an ordered pair","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MfOnheY8L7gQih1PPKT","title":"CEILING","pathname":"/cascade/functions-and-expressions/functions/math/ceiling","siteSpaceId":"sitesp_oHs1L","description":"Rounds a given number up","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MctpuAv9D3F5ys8eA82","title":"COS","pathname":"/cascade/functions-and-expressions/functions/math/cos","siteSpaceId":"sitesp_oHs1L","description":"Calculates the cosine of an angle","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MihJPwjU-wsUt-tczYP","title":"COT","pathname":"/cascade/functions-and-expressions/functions/math/cot","siteSpaceId":"sitesp_oHs1L","description":"Calculates the cotangent of an angle","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MezMbdPZCir1JEOK-SA","title":"COSEC","pathname":"/cascade/functions-and-expressions/functions/math/cosec","siteSpaceId":"sitesp_oHs1L","description":"Calculates the cosecant of an angle","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Mk2GKzx6WbD7aab_oSv","title":"DEGREES","pathname":"/cascade/functions-and-expressions/functions/math/degrees","siteSpaceId":"sitesp_oHs1L","description":"Converts radians to degrees.","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"Bgt77ETkhnduCey56iws","title":"DIV","pathname":"/cascade/functions-and-expressions/functions/math/div","siteSpaceId":"sitesp_oHs1L","description":"Returns the integer portion of a division operation","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MYa08Q3lACv7mPxZcn7","title":"EVEN","pathname":"/cascade/functions-and-expressions/functions/math/even","siteSpaceId":"sitesp_oHs1L","description":"Rounds a number up to the nearest even integer","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Mk2OvRNWSlBTAwACsE8","title":"EXPONENTIAL","pathname":"/cascade/functions-and-expressions/functions/math/exponential","siteSpaceId":"sitesp_oHs1L","description":"Exponential function","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"NyYmkOcg5czZ87PZTD51","title":"FILLINFINITY","pathname":"/cascade/functions-and-expressions/functions/math/fillinfinity","siteSpaceId":"sitesp_oHs1L","description":"Replace infinity values within input value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MfOmiMaVQPTuvTXXY5b","title":"FLOOR","pathname":"/cascade/functions-and-expressions/functions/math/floor","siteSpaceId":"sitesp_oHs1L","description":"Rounds a given number down","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MjtL98IpDZqjYX9bYxl","title":"HAVERSINE","pathname":"/cascade/functions-and-expressions/functions/math/haversine","siteSpaceId":"sitesp_oHs1L","description":"Calculates Haversine distance between coordinates","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Mk2YGSYwJXQ3oESR3Xv","title":"LOG","pathname":"/cascade/functions-and-expressions/functions/math/log","siteSpaceId":"sitesp_oHs1L","description":"Logarithm function","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Mk2YAqTbmfMAFIF2-qo","title":"LN","pathname":"/cascade/functions-and-expressions/functions/math/ln","siteSpaceId":"sitesp_oHs1L","description":"Natural logarithm function","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MYa1xO7DGyImk7_fAp3","title":"ODD","pathname":"/cascade/functions-and-expressions/functions/math/odd","siteSpaceId":"sitesp_oHs1L","description":"Rounds a number up to the nearest odd integer","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"nH3QiRguhPQsi7I43pJ7","title":"MODULO","pathname":"/cascade/functions-and-expressions/functions/math/modulo","siteSpaceId":"sitesp_oHs1L","description":"Calculates the remainder of a division operation","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"lr8cOaIrGo9MOYaifOsn","title":"PERCENTILEOFVALUE","pathname":"/cascade/functions-and-expressions/functions/math/percentileofvalue","siteSpaceId":"sitesp_oHs1L","description":"Calculate percentiles based on data","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"z5ezxQ3gxDmpg39Qmi85","title":"PERCENTILEVALUE","pathname":"/cascade/functions-and-expressions/functions/math/percentilevalue","siteSpaceId":"sitesp_oHs1L","description":"Calculate value(s) from specified percentiles","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MYa39IrHWuRPw8L4DKi","title":"PI","pathname":"/cascade/functions-and-expressions/functions/math/pi","siteSpaceId":"sitesp_oHs1L","description":"Returns the PI value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Mk2P1g3svNgYYdCDUax","title":"POWER","pathname":"/cascade/functions-and-expressions/functions/math/power","siteSpaceId":"sitesp_oHs1L","description":"Raises a number to a specified exponent","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-Mk2GR-rhr0DKCDgmxt0","title":"RADIANS","pathname":"/cascade/functions-and-expressions/functions/math/radians","siteSpaceId":"sitesp_oHs1L","description":"Converts degrees to radians.","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MY_yHUGl-biBxrDFtHU","title":"RANDOM","pathname":"/cascade/functions-and-expressions/functions/math/random","siteSpaceId":"sitesp_oHs1L","description":"Returns a random value between 0 and 1","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MYa-G8F0tMDsxfVR5ZR","title":"ROUND","pathname":"/cascade/functions-and-expressions/functions/math/round","siteSpaceId":"sitesp_oHs1L","description":"Rounds a number or list of numbers","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MezOKWe5jagGfKE2fkX","title":"SEC","pathname":"/cascade/functions-and-expressions/functions/math/sec","siteSpaceId":"sitesp_oHs1L","description":"Calculates the secant of an angle","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Math Functions"}]},{"id":"-MXdXlugbj-7WkzrretU","title":"Table Functions","pathname":"/cascade/functions-and-expressions/functions/table","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"}]},{"id":"-McFlNL4wWQIg4jJGTvn","title":"ENCODE","pathname":"/cascade/functions-and-expressions/functions/table/encode","siteSpaceId":"sitesp_oHs1L","description":"Returns integers for each unique string value in a referenced column.","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MXdXoed2W0aB1nAjRyQ","title":"INDEX","pathname":"/cascade/functions-and-expressions/functions/table/index","siteSpaceId":"sitesp_oHs1L","description":"Returns the value at a given index inside a column.","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-M_sCB1QWRpbX0Vq3p3H","title":"INDEXBY","pathname":"/cascade/functions-and-expressions/functions/table/indexby","siteSpaceId":"sitesp_oHs1L","description":"Returns a value of a specific index within a column, partitioned by the unique values of a separate column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MhkFufHhbph2StiQxxR","title":"FILLNULL","pathname":"/cascade/functions-and-expressions/functions/table/fillnull","siteSpaceId":"sitesp_oHs1L","description":"Fills null values with specified replacement value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYlK0nakZNWHJj2sML4","title":"FIRSTBY","pathname":"/cascade/functions-and-expressions/functions/table/firstby","siteSpaceId":"sitesp_oHs1L","description":"Finds the first element within a column, partitioned by the unique values of a separate column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"j6jV0PADW6ArF4GDMHIW","title":"GENERATEUNIQUEID","pathname":"/cascade/functions-and-expressions/functions/table/generateuniqueid","siteSpaceId":"sitesp_oHs1L","description":"Generates Unique IDs","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"HrKSKLBXa9pBGSUA2VbS","title":"LASTBY","pathname":"/cascade/functions-and-expressions/functions/table/lastby","siteSpaceId":"sitesp_oHs1L","description":"Finds the last element within a column, partitioned by the unique values of a separate column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"GsrsQgsZqb3ND9N0Lte9","title":"LOOKUP","pathname":"/cascade/functions-and-expressions/functions/table/lookup","siteSpaceId":"sitesp_oHs1L","description":"Returns a row offset a given number of rows from the current row","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MgDZAYTCe0DE0sW3PCK","title":"MATCH","pathname":"/cascade/functions-and-expressions/functions/table/match","siteSpaceId":"sitesp_oHs1L","description":"Returns the index of a matched value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYaudl-HfeTfHPYCxCy","title":"NTH","pathname":"/cascade/functions-and-expressions/functions/table/nth","siteSpaceId":"sitesp_oHs1L","description":"Returns the nth element of a given column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYasHMtpKtzfk4xPzpS","title":"OFFSET","pathname":"/cascade/functions-and-expressions/functions/table/offset","siteSpaceId":"sitesp_oHs1L","description":"Offsets values within a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYatYHSC85YTMPhCaFq","title":"OFFSETBY","pathname":"/cascade/functions-and-expressions/functions/table/offsetby","siteSpaceId":"sitesp_oHs1L","description":"Offsets values within a column, partitioned by the unique values of a separate column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"UJrjFXzIpLS7WOECrs4V","title":"PREVIOUSVALUE","pathname":"/cascade/functions-and-expressions/functions/table/previousvalue","siteSpaceId":"sitesp_oHs1L","description":"Calculate a function's result based on the previous row's values","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYawMTIv0REuvlMW_Dl","title":"RANK","pathname":"/cascade/functions-and-expressions/functions/table/rank","siteSpaceId":"sitesp_oHs1L","description":"Returns the rank of each element in a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYax5OgkH2W_NBH059O","title":"RANKBY","pathname":"/cascade/functions-and-expressions/functions/table/rankby","siteSpaceId":"sitesp_oHs1L","description":"Ranks values within a column, partitioned by the unique values of a separate column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"03Dov3OYJqdnyRzRvOuZ","title":"RECORDID","pathname":"/cascade/functions-and-expressions/functions/table/recordid","siteSpaceId":"sitesp_oHs1L","description":"Generates IDs for each row in a table","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYaxcnVVH9kykQrF9er","title":"ROLLINGAVERAGE","pathname":"/cascade/functions-and-expressions/functions/table/rollingaverage","siteSpaceId":"sitesp_oHs1L","description":"Calculates the rolling averages of a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-Ma0g7EX5Wh_lJPAQkTC","title":"ROW","pathname":"/cascade/functions-and-expressions/functions/table/row","siteSpaceId":"sitesp_oHs1L","description":"Returns the current row number","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYazHPIxhwl2PGzeSRM","title":"RUNNINGAVERAGE","pathname":"/cascade/functions-and-expressions/functions/table/runningaverage","siteSpaceId":"sitesp_oHs1L","description":"Calculates the running average of a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"gL0IXPbbK8dtAyS8cfSN","title":"RUNNINGMAX","pathname":"/cascade/functions-and-expressions/functions/table/runningmax","siteSpaceId":"sitesp_oHs1L","description":"Calculates the running maximum of a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"5qs7ftEw9XhiScIXPfkq","title":"RUNNINGMIN","pathname":"/cascade/functions-and-expressions/functions/table/runningmin","siteSpaceId":"sitesp_oHs1L","description":"Calculates the running minimum of a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"Fuv5W7ScoHFZBUyMkkee","title":"RUNNINGSTDEV","pathname":"/cascade/functions-and-expressions/functions/table/runningstdev","siteSpaceId":"sitesp_oHs1L","description":"Calculates the running standard deviation of a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYb-NPMZzx58wmV-gG7","title":"RUNNINGTOTAL","pathname":"/cascade/functions-and-expressions/functions/table/runningtotal","siteSpaceId":"sitesp_oHs1L","description":"Calculates the running total of a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"c585MxkXDyFNPljVNV1Z","title":"WINDOWAVERAGE","pathname":"/cascade/functions-and-expressions/functions/table/windowaverage","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window average","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"O7oFPYcWrxXsX6cUjhHH","title":"WINDOWMAX","pathname":"/cascade/functions-and-expressions/functions/table/windowmax","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window maximum","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"JgqN0flK0itoCKYiCXP4","title":"WINDOWMIN","pathname":"/cascade/functions-and-expressions/functions/table/windowmin","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window minimum","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"Fl1BiVRFnXRe0Vs6wnrA","title":"WINDOWCOUNT","pathname":"/cascade/functions-and-expressions/functions/table/windowcount","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window count","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"0uPfsePzo7u80rA8bF14","title":"WINDOWSUM","pathname":"/cascade/functions-and-expressions/functions/table/windowsum","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window sum","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"PA7IwLDfCHE9b5quYC6l","title":"SEQUENCE","pathname":"/cascade/functions-and-expressions/functions/table/sequence","siteSpaceId":"sitesp_oHs1L","description":"Create a sequence of numeric values","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"SyxI7A6yiAsjrg9jFovq","title":"WINDOWMEDIAN","pathname":"/cascade/functions-and-expressions/functions/table/windowmedian","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window median","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"XOSqf0uQzwXei4fIbFBO","title":"WINDOWSTDEV","pathname":"/cascade/functions-and-expressions/functions/table/windowstdev","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window population standard deviation","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"vKRWoeibqFH02TKhmh40","title":"WINDOWSTDEVP","pathname":"/cascade/functions-and-expressions/functions/table/windowstdevp","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window population standard deviation","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"OJPpGlfii8sZEYfMKDZ2","title":"WINDOWSTDEVS","pathname":"/cascade/functions-and-expressions/functions/table/windowstdevs","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window sample standard deviation","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"pSfeG2XG9PdVfgCw5t7p","title":"WINDOWVAR","pathname":"/cascade/functions-and-expressions/functions/table/windowvar","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window average","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"gZvpOIVrdTf0tx66INar","title":"WINDOWVARP","pathname":"/cascade/functions-and-expressions/functions/table/windowvarp","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window average","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"0nbM483939E3SFOIxyNO","title":"WINDOWVARS","pathname":"/cascade/functions-and-expressions/functions/table/windowvars","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window sample variance","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"3nE47JXBRRmal7o1Wgmn","title":"WINDOWCORR","pathname":"/cascade/functions-and-expressions/functions/table/windowcorr","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window average","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"Kcm6EACTwDIi2Csz7e7B","title":"WINDOWCOVAR","pathname":"/cascade/functions-and-expressions/functions/table/windowcovar","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window population covariance","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"6GbGs5pCvQOdTfjtp6hG","title":"WINDOWCOVARP","pathname":"/cascade/functions-and-expressions/functions/table/windowcovarp","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window average","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"kiyoJeKFhic3AseglgsP","title":"WINDOWCOVARS","pathname":"/cascade/functions-and-expressions/functions/table/windowcovars","siteSpaceId":"sitesp_oHs1L","description":"Calculates rolling or static window sample covariance","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYb-rSLAGjICXnlE1AW","title":"SMOOTHEDAVERAGE","pathname":"/cascade/functions-and-expressions/functions/table/smoothedaverage","siteSpaceId":"sitesp_oHs1L","description":"Calculates the smoothed averages of a column","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Table Functions"}]},{"id":"-MYRIWT63tIfkDq-_jKI","title":"Text Functions","pathname":"/cascade/functions-and-expressions/functions/text","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"}]},{"id":"RgiBuZfW0208qj2TNoB2","title":"ASCII","pathname":"/cascade/functions-and-expressions/functions/text/ascii","siteSpaceId":"sitesp_oHs1L","description":"Returns the ASCII code for a given character","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"KcKKS4CJrz36B85bedp3","title":"CHAR","pathname":"/cascade/functions-and-expressions/functions/text/char","siteSpaceId":"sitesp_oHs1L","description":"Returns the character for a given ASCII code","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-MYb31ceHPnbBBsj1akg","title":"CONCAT","pathname":"/cascade/functions-and-expressions/functions/text/concat","siteSpaceId":"sitesp_oHs1L","description":"Concatenates all inputs into a string","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-MYb2kmLcvARizsIaAq4","title":"CONTAINS","pathname":"/cascade/functions-and-expressions/functions/text/contains","siteSpaceId":"sitesp_oHs1L","description":"Checks if a given column contains specified text","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"5cdp1inldJndI9ED3md3","title":"ENDSWITH","pathname":"/cascade/functions-and-expressions/functions/text/endswith","siteSpaceId":"sitesp_oHs1L","description":"Determines whether a given string ends with a specified substring","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-MfnCy-N2uaZ60DjItfV","title":"FIND","pathname":"/cascade/functions-and-expressions/functions/text/find","siteSpaceId":"sitesp_oHs1L","description":"Finds the index of a substring within a string","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"aXPCXzD4V1JleEuMU2u0","title":"FINDNTH","pathname":"/cascade/functions-and-expressions/functions/text/findnth","siteSpaceId":"sitesp_oHs1L","description":"Returns the nth occurrence of a substring within a string","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"7bs8BMPhP8YJ3Rc82oYE","title":"ISEMPTY","pathname":"/cascade/functions-and-expressions/functions/text/isempty","siteSpaceId":"sitesp_oHs1L","description":"Determines if value(s) are empty strings","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-Mh_MZSKLWHHXqOAOmXX","title":"JSONPARSE","pathname":"/cascade/functions-and-expressions/functions/text/jsonparse","siteSpaceId":"sitesp_oHs1L","description":"Extracts a single field from a json","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-MYb3GnxHjHyi9w26r7G","title":"LEFT","pathname":"/cascade/functions-and-expressions/functions/text/left","siteSpaceId":"sitesp_oHs1L","description":"Returns a certain numbers of characters within a string, counting from the left","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-MgD9eYryVPI4BiU13Uf","title":"LENGTH","pathname":"/cascade/functions-and-expressions/functions/text/length","siteSpaceId":"sitesp_oHs1L","description":"Returns the number of characters within a given text","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-Ma0sPESUWOpxqPauGLf","title":"LOWER","pathname":"/cascade/functions-and-expressions/functions/text/lower","siteSpaceId":"sitesp_oHs1L","description":"Returns a string, converted to lowercase","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"6lUspqnDmqOCv8xOiIfh","title":"LTRIM","pathname":"/cascade/functions-and-expressions/functions/text/ltrim","siteSpaceId":"sitesp_oHs1L","description":"Removes leading whitespace","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"508knAp9kZXLEZIwI8WP","title":"MID","pathname":"/cascade/functions-and-expressions/functions/text/mid","siteSpaceId":"sitesp_oHs1L","description":"Returns a portion of input text beginning at specified location","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"ZKMKiDJs1sNcFaZT3cXX","title":"PROPER","pathname":"/cascade/functions-and-expressions/functions/text/proper","siteSpaceId":"sitesp_oHs1L","description":"Convert text strings to proper case","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-MYb3VHV-f7WKnmksQl-","title":"RIGHT","pathname":"/cascade/functions-and-expressions/functions/text/right","siteSpaceId":"sitesp_oHs1L","description":"Returns a certain numbers of characters within a string, counting from the right","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"pPi8Q9l0JcxvWUMTiJyN","title":"RTRIM","pathname":"/cascade/functions-and-expressions/functions/text/rtrim","siteSpaceId":"sitesp_oHs1L","description":"Removes trailing whitespace","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"JGPWiQcqhIntAeTmI0m1","title":"SPACE","pathname":"/cascade/functions-and-expressions/functions/text/space","siteSpaceId":"sitesp_oHs1L","description":"Produces desired number of spaces","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-M_xMHY9ArQd7pXvvDWx","title":"SPLIT","pathname":"/cascade/functions-and-expressions/functions/text/split","siteSpaceId":"sitesp_oHs1L","description":"Split a string based on a given delimiter","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"Xjj8XV4uKJmDtXr8gUvK","title":"STARTSWITH","pathname":"/cascade/functions-and-expressions/functions/text/startswith","siteSpaceId":"sitesp_oHs1L","description":"Determines whether a given string begins with a specified substring","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-Ma0mwUdA6H61_wW23AD","title":"TRIM","pathname":"/cascade/functions-and-expressions/functions/text/trim","siteSpaceId":"sitesp_oHs1L","description":"Removes leading, trailing and repeated whitespace from a text string","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-MYb3m6RVhYzH1o99AJG","title":"SUBSTITUTE","pathname":"/cascade/functions-and-expressions/functions/text/substitute","siteSpaceId":"sitesp_oHs1L","description":"Substitutes all instances of one value with another value","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"-MgDDt_hZJROn4zuvuVW","title":"UPPER","pathname":"/cascade/functions-and-expressions/functions/text/upper","siteSpaceId":"sitesp_oHs1L","description":"Returns a string, converted to uppercase","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Functions"},{"label":"Text Functions"}]},{"id":"KMguTGuf33aDDc51Nd4N","title":"Building Expressions","pathname":"/cascade/functions-and-expressions/building-expressions","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"}]},{"id":"-MYlGJ2a9tv0UQaJ9B3g","title":"Expression Operators","pathname":"/cascade/functions-and-expressions/building-expressions/expression-operators","siteSpaceId":"sitesp_oHs1L","description":"","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Building Expressions"}]},{"id":"-MZZK1Idwyz8yf9PMhvo","title":"Guide to Window Functions","pathname":"/cascade/functions-and-expressions/building-expressions/guide-to-window-functions","siteSpaceId":"sitesp_oHs1L","description":"Window functions partition a table before they run, making them very useful when working with large datasets","breadcrumbs":[{"label":"Functions & Expressions"},{"label":"Building Expressions"}]},{"id":"vw8beGsooWaXb7GrdE2c","title":"Cascade FAQs","pathname":"/cascade/cascade-faqs","siteSpaceId":"sitesp_oHs1L","description":"This section contains a library of tutorials and how-to guides, organized into different categories to make it easier for users to find what they need."},{"id":"kZx3VjJAVulkQKWprSEs","title":"Best Practices","pathname":"/cascade/cascade-faqs/best-practices","siteSpaceId":"sitesp_oHs1L","description":"Review best practices to build efficient and well organized workflows","breadcrumbs":[{"label":"Cascade FAQs"}]},{"id":"t730AG1yt0JIHX1kKQ41","title":"How to add a total row to a table","pathname":"/cascade/cascade-faqs/best-practices/how-to-add-a-total-row-to-a-table","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Learn our easiest way to append a Total Row to your table","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Best Practices"}]},{"id":"jZwce4ClUaHQuNfK4fiG","title":"How to leave comments on a workflow","pathname":"/cascade/cascade-faqs/best-practices/how-to-leave-comments-on-a-workflow","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Cascade allows for annotation and customization","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Best Practices"}]},{"id":"OjPuQW1FZnsfwVAAbUYf","title":"How to add new columns in the Edit Columns tool","pathname":"/cascade/cascade-faqs/best-practices/how-to-add-new-columns-in-the-edit-columns-tool","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Adding columns to your data in Cascade","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Best Practices"}]},{"id":"WfyIaZ1ZPITMmAYBBlPi","title":"Setting up a New Table tool","pathname":"/cascade/cascade-faqs/best-practices/setting-up-a-new-table-tool","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Storing data in workflow with New Table tool","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Best Practices"}]},{"id":"t8m43RySMuRTJAmnkTjn","title":"How to rename a tool","pathname":"/cascade/cascade-faqs/best-practices/how-to-rename-a-tool","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Renaming tools is an effective way to make your workflow more organized and comprehensible","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Best Practices"}]},{"id":"wULlcbaLb72Zyk25oxjm","title":"Knowledge Based","pathname":"/cascade/cascade-faqs/knowledge-based","siteSpaceId":"sitesp_oHs1L","description":"Important things to remember when starting out with Cascade","breadcrumbs":[{"label":"Cascade FAQs"}]},{"id":"lCXJxSIjHKJb0gLYKiXE","title":"How to change Data Types in Cascade","pathname":"/cascade/cascade-faqs/knowledge-based/how-to-change-data-types-in-cascade","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Easily change data types in Cascade","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Knowledge Based"}]},{"id":"qXmCbebLDCZbi2pHmRHE","title":"How to remove columns from a table in Cascade","pathname":"/cascade/cascade-faqs/knowledge-based/how-to-remove-columns-from-a-table-in-cascade","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Use the Select Columns tool to remove columns from a table in Cascade","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Knowledge Based"}]},{"id":"kC6H9QPLqn5tlk2Bh97m","title":"How to rename columns in Cascade","pathname":"/cascade/cascade-faqs/knowledge-based/how-to-rename-columns-in-cascade","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Make data more comprehendible with the Edit Columns tool","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Knowledge Based"}]},{"id":"skX9QoSAm5SzA7U542O9","title":"Understanding the Join options in the Cascade Join tool","pathname":"/cascade/cascade-faqs/knowledge-based/understanding-the-join-options-in-the-cascade-join-tool","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Exploring different types of joins in Cascade","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Knowledge Based"}]},{"id":"J9yEgOJcpzDgCpaZJSRu","title":"How to connect tools to each other","pathname":"/cascade/cascade-faqs/knowledge-based/how-to-connect-tools-to-each-other","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Connecting tools in Cascade","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Knowledge Based"}]},{"id":"Xqky4nmpNWYSsm4dgKqO","title":"Import","pathname":"/cascade/cascade-faqs/import","siteSpaceId":"sitesp_oHs1L","description":"Additional resources for Importing data into Cascade","breadcrumbs":[{"label":"Cascade FAQs"}]},{"id":"atHs9vVHDEtM5HVjS3vq","title":"How to Import an Excel File into Cascade","pathname":"/cascade/cascade-faqs/import/how-to-import-an-excel-file-into-cascade","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Learn how to upload an Excel file into Cascade","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Import"}]},{"id":"NQmLgj3sHg5rU7FbfCiH","title":"How to Import a CSV File into Cascade","pathname":"/cascade/cascade-faqs/import/how-to-import-a-csv-file-into-cascade","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Learn how to upload a CSV File into Cascade","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Import"}]},{"id":"cjrUGKf75jKPjpa0h0dy","title":"How to import a CSV file into the Data Locker","pathname":"/cascade/cascade-faqs/import/how-to-import-a-csv-file-into-the-data-locker","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Learn how to import a CSV File into the Data Locker","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Import"}]},{"id":"4CZDFUFrrOi5hcDXUBni","title":"Functions and Expressions","pathname":"/cascade/cascade-faqs/functions-and-expressions","siteSpaceId":"sitesp_oHs1L","description":"More on functions and expressions using Expression Editors in Cascade","breadcrumbs":[{"label":"Cascade FAQs"}]},{"id":"ceLLUYVrHzV8TVeSAXow","title":"How to write an IN() statement with multiple variables","pathname":"/cascade/cascade-faqs/functions-and-expressions/how-to-write-an-in-statement-with-multiple-variables","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Using the IN() function to with multiple variables","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Functions and Expressions"}]},{"id":"SP8luJHzMUFCcJyp9TUT","title":"How to Remove null Records with a Filter tool","pathname":"/cascade/cascade-faqs/functions-and-expressions/how-to-remove-null-records-with-a-filter-tool","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Remove null records with a Filter tool","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Functions and Expressions"}]},{"id":"eTMwxQD3PjlVJIheaGRi","title":"How to write an IF Statement in Cascade","pathname":"/cascade/cascade-faqs/functions-and-expressions/how-to-write-an-if-statement-in-cascade","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Writing IF statements in Cascade made easy","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Functions and Expressions"}]},{"id":"bmh6aieXCwKSIiJL0OKD","title":"How to replace null values with 0","pathname":"/cascade/cascade-faqs/functions-and-expressions/how-to-replace-null-values-with-0","siteSpaceId":"sitesp_oHs1L","emoji":"1f4ac","description":"Use an IF statement or Find Replace tool to replace null values","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Functions and Expressions"}]},{"id":"rXkAknYsQH2TLLZNM8dX","title":"Troubleshooting","pathname":"/cascade/cascade-faqs/troubleshooting","siteSpaceId":"sitesp_oHs1L","description":"See if it's happened before","breadcrumbs":[{"label":"Cascade FAQs"}]},{"id":"eYtFLt13IDBpjZMx2agh","title":"What does it mean if my workflow won’t load?","pathname":"/cascade/cascade-faqs/troubleshooting/what-does-it-mean-if-my-workflow-wont-load","siteSpaceId":"sitesp_oHs1L","emoji":"26a0","description":"It happens sometimes, but nothing to fear","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Troubleshooting"}]},{"id":"qu0RApoeC2TULF9pWn7G","title":"Why can’t I connect my tool to other tools?","pathname":"/cascade/cascade-faqs/troubleshooting/why-cant-i-connect-my-tool-to-other-tools","siteSpaceId":"sitesp_oHs1L","emoji":"26a0","description":"Can’t connect a tool","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Troubleshooting"}]},{"id":"gzDuq1wGVVmDs1NmZYQT","title":"Why are there duplicate records after my Join tool?","pathname":"/cascade/cascade-faqs/troubleshooting/why-are-there-duplicate-records-after-my-join-tool","siteSpaceId":"sitesp_oHs1L","emoji":"26a0","description":"Using a Join tool in your Cascade workflows can sometimes give rise to duplicate records","breadcrumbs":[{"label":"Cascade FAQs"},{"label":"Troubleshooting"}]},{"id":"TQAXN3PAJokEYYy9OdjL","title":"Change Log","pathname":"/cascade/change-log","siteSpaceId":"sitesp_oHs1L","description":"Hey ma, we shipped code, here's what changed"}]}