# Uncategorized **URL:** https://community.exploratory.io/c/uncategorized/1.md [Latest](https://community.exploratory.io/latest.md) · [Categories](https://community.exploratory.io/categories.md) --- ## [Welcome to Exploratory Community](https://community.exploratory.io/t/welcome-to-exploratory-community/8)
**Author:** [@system](https://community.exploratory.io/u/system)\ **Replies:** 0\ **Last updated:** [July 21, 2016, 5:57pm UTC](https://community.exploratory.io/t/welcome-to-exploratory-community/8 "2016-07-21T17:57:07Z")
Welcome to Exploratory Community! Feel free to ask questions, share your works, or suggest ideas! Other helpful resources: Tutorials FAQ Exploratory Desktop Troubleshooting Guide New Features Twitter - @ExploratoryDat… --- ## [Windows: How can I switch back to Insert mode when the calculation editor has entered Overwrite mode?](https://community.exploratory.io/t/windows-how-can-i-switch-back-to-insert-mode-when-the-calculation-editor-has-entered-overwrite-mode/4267)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [June 24, 2026, 3:08am UTC](https://community.exploratory.io/t/windows-how-can-i-switch-back-to-insert-mode-when-the-calculation-editor-has-entered-overwrite-mode/4267 "2026-06-24T03:08:25Z")
If existing characters get replaced as you type in the Create Calculation dialog, the editor has switched into “Overwrite mode.” You can return to the normal “Insert mode” by pressing the Insert key on your keyboard. Th… --- ## [Two Cases That Cause the "could not find function" Error and How to Fix Them](https://community.exploratory.io/t/two-cases-that-cause-the-could-not-find-function-error-and-how-to-fix-them/4261)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [June 12, 2026, 1:20pm UTC](https://community.exploratory.io/t/two-cases-that-cause-the-could-not-find-function-error-and-how-to-fix-them/4261 "2026-06-12T13:20:37Z")
When you use an R function in Exploratory, you may see an error message like the following: could not find function "xxxxx" This error means that “a function with the specified name could not be found.” If you get thi… --- ## [Released Exploratory Desktop v15.5!](https://community.exploratory.io/t/released-exploratory-desktop-v15-5/4256)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [June 8, 2026, 4:09am UTC](https://community.exploratory.io/t/released-exploratory-desktop-v15-5/4256 "2026-06-08T04:09:08Z")
On June 7, 2026, we released Exploratory Desktop v15.5! In this release, we’ve significantly enhanced the Analytics features, including adding CatBoost to the machine learning models, the Silhouette method for K-Means c… --- ## [When running an R script, the error "could not find function '%\>%\<-'" occurs](https://community.exploratory.io/t/when-running-an-r-script-the-error-could-not-find-function-occurs/4253)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [June 4, 2026, 11:53pm UTC](https://community.exploratory.io/t/when-running-an-r-script-the-error-could-not-find-function-occurs/4253 "2026-06-04T23:53:39Z")
When you write a script that includes variable assignment with \<- inside a Custom R Command, the following error may occur: Error in %\>% var\_name \<- "..." : could not find function "%\>%\<-" A Custom R Command is treated… --- ## [Released Exploratory Desktop v15!🔥](https://community.exploratory.io/t/released-exploratory-desktop-v15/4237)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [May 14, 2026, 8:44am UTC](https://community.exploratory.io/t/released-exploratory-desktop-v15/4237 "2026-05-14T08:44:37Z")
We released Exploratory Desktop v15.0 on May 13, 2026​:fire: This release introduces a variety of new features, including the “Step Diagram” that visualizes the flow of data wrangling, “AI Auto-Fix” that diagnoses error… --- ## [How can I add predictions to the data frame used to build a model created in the Analytics View](https://community.exploratory.io/t/how-can-i-add-predictions-to-the-data-frame-used-to-build-a-model-created-in-the-analytics-view/4222)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [April 28, 2026, 5:56am UTC](https://community.exploratory.io/t/how-can-i-add-predictions-to-the-data-frame-used-to-build-a-model-created-in-the-analytics-view/4222 "2026-04-28T05:56:50Z")
In Exploratory, you can generate numeric or logical predictions using statistical or machine learning models in the Analytics View. Additionally, in the “Predictions for Training Data” section of a completed analysis… --- ## [How can I access the Project List (Management) screen?](https://community.exploratory.io/t/how-can-i-access-the-project-list-management-screen/4177)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [February 9, 2026, 11:54pm UTC](https://community.exploratory.io/t/how-can-i-access-the-project-list-management-screen/4177 "2026-02-09T23:54:53Z")
The “Project Management screen” is the Project List screen that appears when you first launch Exploratory Desktop. On this screen, you can see a list of your projects and create a new one using the green “Create New” … --- ## [On the user management screen of the Hosted or On-Premise Server, what do the grayed-out users represent?](https://community.exploratory.io/t/on-the-user-management-screen-of-the-hosted-or-on-premise-server-what-do-the-grayed-out-users-represent/4171)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [February 5, 2026, 12:12am UTC](https://community.exploratory.io/t/on-the-user-management-screen-of-the-hosted-or-on-premise-server-what-do-the-grayed-out-users-represent/4171 "2026-02-05T00:12:55Z")
In the user management screen of the Hosted Server or On-Premise Server, you may see certain users displayed as grayed out. Grayed-out users are accounts that are currently in an "Awaiting Acceptance. Specifically, t… --- ## [When trying to sign up, "There was a problem processing your request" is displayed and sign-up cannot be completed](https://community.exploratory.io/t/when-trying-to-sign-up-there-was-a-problem-processing-your-request-is-displayed-and-sign-up-cannot-be-completed/4166)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [February 3, 2026, 11:59pm UTC](https://community.exploratory.io/t/when-trying-to-sign-up-there-was-a-problem-processing-your-request-is-displayed-and-sign-up-cannot-be-completed/4166 "2026-02-03T23:59:35Z")
Issue When signing up to create an Exploratory account, “There was a problem processing your request” may be displayed, and the sign-up process may not be completed. Cause It is assumed that the cause is your firewall b… --- ## [Released Exploratory Server v14.1!](https://community.exploratory.io/t/released-exploratory-server-v14-1/4157)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [February 2, 2026, 12:18am UTC](https://community.exploratory.io/t/released-exploratory-server-v14-1/4157 "2026-02-02T00:18:01Z")
We have released Exploratory Server v14.1 on 1/31/2026! :fire: This is a release for customers using Exploratory Hosted Server or On-premise Server. Release Notes - Link Please see below for the new features and bug … --- ## [How can I standardize Inconsistent text values](https://community.exploratory.io/t/how-can-i-standardize-inconsistent-text-values/4142)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [January 19, 2026, 1:36am UTC](https://community.exploratory.io/t/how-can-i-standardize-inconsistent-text-values/4142 "2026-01-19T01:36:24Z")
If you want to standardize inconsistent values using the UI, you can use the “Replace Values” menu. For more details on how to replace values, please refer to the link below: Additionally, you can efficiently fix valu… --- ## [When logged into an Exploratory Server (Hosted or On-premise), attempting to access OAuth data sources such as Google Analytics from the desktop results in the following error: "Access blocked: Authorization Error 400: invalid\_request"](https://community.exploratory.io/t/when-logged-into-an-exploratory-server-hosted-or-on-premise-attempting-to-access-oauth-data-sources-such-as-google-analytics-from-the-desktop-results-in-the-following-error-access-blocked-authorization-error-400-invalid-request/4137)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [January 15, 2026, 12:10am UTC](https://community.exploratory.io/t/when-logged-into-an-exploratory-server-hosted-or-on-premise-attempting-to-access-oauth-data-sources-such-as-google-analytics-from-the-desktop-results-in-the-following-error-access-blocked-authorization-error-400-invalid-request/4137 "2026-01-15T00:10:44Z")
Problem When logged into an Exploratory Server (Hosted or On-premise), attempting to access OAuth data sources such as Google Analytics from the desktop results in the following error: “Access blocked: Authorization Err… --- ## [Released Exploratory Desktop v14.2!](https://community.exploratory.io/t/released-exploratory-desktop-v14-2/4128)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [December 15, 2025, 6:16am UTC](https://community.exploratory.io/t/released-exploratory-desktop-v14-2/4128 "2025-12-15T06:16:46Z")
We released Exploratory Desktop v14.2 on December 14, 2025! This release includes feature enhancements such as “Reorder chart reference lines with drag & drop” and “Dynamic image display using parameters in dashboard te… --- ## [Connecting to Oracle Database through ODBC from Mac](https://community.exploratory.io/t/connecting-to-oracle-database-through-odbc-from-mac/4127)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [December 14, 2025, 10:26pm UTC](https://community.exploratory.io/t/connecting-to-oracle-database-through-odbc-from-mac/4127 "2025-12-14T22:26:17Z")
See the notes below for information on how to set up a connection to an Oracle Database using Oracle Instant Client and ODBC on a Mac. --- ## [Error "In argument:model = purrr::map(...)" occurs when performing time series clustering](https://community.exploratory.io/t/error-in-argument-model-purrr-map-occurs-when-performing-time-series-clustering/4114)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [December 2, 2025, 2:20pm UTC](https://community.exploratory.io/t/error-in-argument-model-purrr-map-occurs-when-performing-time-series-clustering/4114 "2025-12-02T14:20:04Z")
When performing time series clustering, if missing values occur in many groups, an error “In argument:model = purrr::map(…)” may occur. By specifying “1” for “Ratio of missing values is equal to or greater than this … --- ## [Exporting Data as CSV to a Specific Folder as a Step](https://community.exploratory.io/t/exporting-data-as-csv-to-a-specific-folder-as-a-step/4084)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [November 6, 2025, 2:36pm UTC](https://community.exploratory.io/t/exporting-data-as-csv-to-a-specific-folder-as-a-step/4084 "2025-11-06T14:36:25Z")
When you want to constantly export your data to a specific folder as a CSV file based on steps processed in Exploratory, there are times when you want to create an export operation as a step. In that case, select “R Comm… --- ## [Filtering While Retaining Missing Values](https://community.exploratory.io/t/filtering-while-retaining-missing-values/4104)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [November 25, 2025, 5:10am UTC](https://community.exploratory.io/t/filtering-while-retaining-missing-values/4104 "2025-11-25T05:10:52Z")
For example, suppose you use a filter to narrow down data targeting a column that contains missing values. In this case, the filter normally works after excluding missing values. Here, we’ll introduce a method to… --- ## [How to Display Only the Top 10 Items in a Chart](https://community.exploratory.io/t/how-to-display-only-the-top-10-items-in-a-chart/4098)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [November 20, 2025, 11:27pm UTC](https://community.exploratory.io/t/how-to-display-only-the-top-10-items-in-a-chart/4098 "2025-11-20T23:27:23Z")
If you want to display only the top 10 items as bars in a bar chart, you can use the “Limit” feature to achieve this. For more details, please refer to the note linked below. --- ## [Extract a String from a Specified Range](https://community.exploratory.io/t/extract-a-string-from-a-specified-range/4097)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [November 20, 2025, 4:36am UTC](https://community.exploratory.io/t/extract-a-string-from-a-specified-range/4097 "2025-11-20T04:36:49Z")
When you import multiple CSV files, an “id” column is added. If you want to extract specific characters from a designated range, such as the “month” portion, you can do so. In this case, select “Extract” under “Work … --- ## [How to convert a column that records values only when an event occurs into a logical type](https://community.exploratory.io/t/how-to-convert-a-column-that-records-values-only-when-an-event-occurs-into-a-logical-type/4094)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [November 19, 2025, 4:37am UTC](https://community.exploratory.io/t/how-to-convert-a-column-that-records-values-only-when-an-event-occurs-into-a-logical-type/4094 "2025-11-19T04:37:58Z")
When working with event-based datasets, it’s common to encounter columns that record a value only when a specific event occurs — for example, a “1” indicating that the event happened — while leaving all other cases as mi… --- ## [How to Display the Minimum and Maximum Values on a Line Chart](https://community.exploratory.io/t/how-to-display-the-minimum-and-maximum-values-on-a-line-chart/4075)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [October 30, 2025, 11:07pm UTC](https://community.exploratory.io/t/how-to-display-the-minimum-and-maximum-values-on-a-line-chart/4075 "2025-10-30T23:07:48Z")
For example, suppose you have a line chart showing the trend of a time series metric like the one below. If you want to display the minimum and maximum values on such a chart, click the chart settings icon to open th… --- ## [Setting Stop Words and Compound Words](https://community.exploratory.io/t/setting-stop-words-and-compound-words/4061)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [October 21, 2025, 11:29pm UTC](https://community.exploratory.io/t/setting-stop-words-and-compound-words/4061 "2025-10-21T23:29:55Z")
When executing “Word Count” or topic models in the Analytics view, you can register and use dictionaries for “stop words” (common words that don’t characterize individual sentences) and “compound words” (words that shoul… --- ## [Adding Currency Symbols to the Y-Axis in Bar or Line Charts](https://community.exploratory.io/t/adding-currency-symbols-to-the-y-axis-in-bar-or-line-charts/4058)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [October 21, 2025, 12:20am UTC](https://community.exploratory.io/t/adding-currency-symbols-to-the-y-axis-in-bar-or-line-charts/4058 "2025-10-21T00:20:50Z")
When you want to add currency symbols to the Y-axis in charts with X and Y axes, such as bar or line charts, you can do so by selecting “Currency” in the Format option from the Y-axis settings. This allows you to dis… --- ## [Is it possible to allow CSV downloads of chart data while disabling "Show Detail" and "Interactive Chart" for content published on the server?](https://community.exploratory.io/t/is-it-possible-to-allow-csv-downloads-of-chart-data-while-disabling-show-detail-and-interactive-chart-for-content-published-on-the-server/4049)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [October 9, 2025, 11:54pm UTC](https://community.exploratory.io/t/is-it-possible-to-allow-csv-downloads-of-chart-data-while-disabling-show-detail-and-interactive-chart-for-content-published-on-the-server/4049 "2025-10-09T23:54:04Z")
Yes, it is possible. Access the published content and click on the settings button (the “…” in the upper right corner of the screen), then select “Setting.” A setting dialog will appear, where you can disable “Show … --- ## [Fly Smarter with Flighys](https://community.exploratory.io/t/fly-smarter-with-flighys/4021)
**Author:** [@sam\_morgan](https://community.exploratory.io/u/sam_morgan)\ **Replies:** 0\ **Last updated:** [September 3, 2025, 4:58pm UTC](https://community.exploratory.io/t/fly-smarter-with-flighys/4021 "2025-09-03T16:58:30Z")
Flighys offers fast, easy, and reliable flight booking for domestic and international travel. You can compare fares, check schedules, and find the best deals in real-time. The platform provides updates on flight availabi… --- ## [I want to fill missing values with a specified value](https://community.exploratory.io/t/i-want-to-fill-missing-values-with-a-specified-value/3970)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [July 18, 2025, 9:33am UTC](https://community.exploratory.io/t/i-want-to-fill-missing-values-with-a-specified-value/3970 "2025-07-18T09:33:23Z")
I want to fill missing values with a specified value. If you want to fill missing values with a specified value, please refer to the following note for detailed instructions: --- ## [When you want to apply a created chart entirely to different data](https://community.exploratory.io/t/when-you-want-to-apply-a-created-chart-entirely-to-different-data/3945)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [June 18, 2025, 11:55pm UTC](https://community.exploratory.io/t/when-you-want-to-apply-a-created-chart-entirely-to-different-data/3945 "2025-06-18T23:55:54Z")
When you want to apply a created chart entirely to different data, you can do this by duplicating the data frame and then changing the data source of the duplicated data frame. Data frame duplication can be performed fr… --- ## [Change the size of an R‐script–generated chart embedded in a note](https://community.exploratory.io/t/change-the-size-of-an-r-script-generated-chart-embedded-in-a-note/3926)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [May 27, 2025, 11:49pm UTC](https://community.exploratory.io/t/change-the-size-of-an-r-script-generated-chart-embedded-in-a-note/3926 "2025-05-27T23:49:35Z")
You can use R scripts to add charts to a note that aren’t supported by Exploratory’s default features. To enlarge a chart created with an R script, simply click on the chart to bring up the size popup, and adjust it the… --- ## [What Types of Data Sources Support the Scheduling Feature?](https://community.exploratory.io/t/what-types-of-data-sources-support-the-scheduling-feature/3919)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [May 23, 2025, 4:29am UTC](https://community.exploratory.io/t/what-types-of-data-sources-support-the-scheduling-feature/3919 "2025-05-23T04:29:08Z")
For content published on the Exploratory Shared Server, if the data is located in a place accessible by the server, you can set up a schedule on the server to automate updates. The following types of data sources suppor… [Next page](https://community.exploratory.io/c/uncategorized/1.md?page=1)