- create_filter_insight
- create_graph_insight
- create_plot_insight
- filter_rows
- segment_rows
- cluster_network
- cluster_subnetwork
Text and categorical queries
In categorical or text columns you can search for specific words (tokens) or categories. You can combine searches using boolean logic (i.e. string together multiple conditions using the AND/OR keywords). Select rows where the “department” column contains “engineering”:Numerical and date queries
You can compare the values in numeric and date columns against constants to test for equality or against a desired range (mininum and/or maximum). For queries in date columns you can use dates expressed in the ISO format 8061 standard (e.g. “2019-01-01”).Column statistics in filter conditions
In addition to using constants and ranges, you may also compare date and numeric values against certain column statistics. Specifically, all the following statistics are supported:- MIN: minimum value
- MAX: maximum value
- MEAN: the average
- P25: or Q1, 25% of data lies below this point
- MEDIAN: that is, P50 or Q2. This is the median of the data and 50% of it lies below this point
- P75: or Q3, 75% of data lies below this point