3/30/2026
3/23/2026
3/17/2026
Released on 03/05/2026
hms() function instead of as_hms() when converting time-stamped strings, leading to errors that require manual "Auto Fix" to resolve.circlize package in an R code block can cause the R process to hang or crash, leading to "There is another R process running" errors in the Note.Released on 01/18/2026.
AI: AI Function: Improved stability when handling row count discrepancies between AI function results and actual data.
AI: AI Function: Improved handling of column names containing Japanese characters and numbers.
Data Source: Import & Merge: Added support for the "Not Contain", "Not Start With", and "Not End With" operators.
Data Wrangling: Filter: Added an option to retain missing values.
Data Wrangling: Added support for one-hot encoding using 'Long to Wide' menu.
Chart: Added an option to keep a consistent X-axis range (e.g. 1/1–12/31) across repeated year charts regardless of the actual data range.
Chart: Added support for specifying the number of decimal places in reference lines.
Chart: Filter: Added support for reordering filter conditions using drag-and-drop.
Chart: Chart property dialog is now draggable.
Chart: Map: Increased the number of columns that can be selected by label.
Chart: Automatically adjusts label positions to avoid overlapping characters when using Show Value.
Chart: Error Bar: Added an option to avoid value overlap with chart elements.
Analytics: Automatically excludes infinite values in Random Forest and XGBoost to prevent execution errors.
Dashboard: Added support for exporting multiple dashboard pages to a single PDF.
Note: Added support for exporting notes to PDF.
Data Wrangling: Long to Wide: Converting to wide format failed if the value contained an empty string.
Data Wrangling: TF-IDF: document_id values were incorrect when calculating TF-IDF.
Chart: Window Calculation: When "Remove Missing Values" was enabled, values from other columns were also removed unintentionally.
Chart: Bar: When using Repeat By with cumulative percentage, the Y2 axis range could exceed 100%.
Chart: Pivot Table: Fixed performance degradation introduced since v14.
Chart: Radar: When categorizing values by color, selecting "same color as chart" reversed the colors.
Analytics: Word Count: Changed the default value of "Count combinations" to "Within document".
Analytics: ARIMA: Fixed a "subscript out of bounds" error.
Analytics: ARIMA: Fixed a "Null model was selected" error.
Dashboard: Configured parameter values were not displayed.
Dashboard: Parameter values specified in the URL were not reflected in dashboard results.
Dashboard: Parameter values set via URL were not updated if execution history existed on Exploratory Server.
Note: Charts and images could be split incorrectly by page breaks when exporting notes to PDF.
General: The arrow icon direction was incorrect after restoring a window from the maximized state.
Released on 12/22/2025.
Chart: Pivot / Summarize Table: Now you can export tables as image files.
Note: Now you can set square sizes for charts and analytics.
General: Fixed an issue where Exploratory failed to launch on Windows after a Windows update.
Chart: Scatter: Fixed an issue where the trend line position was incorrect for the second Y-axis column when the data partially overlapped.
Released on 12/14/2025.
Chart: Reference Line: Added support for drag-and-drop to reorder the reference lines.
Chart: Reference Line: Added support for roll functions other than mean.
Dashboard: Text Panel: Added support for using parameters for dynamic URL-based image display.
Dashboard: Added support for bold font for chart titles in dashboards.
Data Source: Google Cloud Storage: When there were many files in a bucket, it failed to list them in the UI with an http_400 error and files could not be imported.
Chart: The order of charts changed under certain conditions.
Chart: Line: When displaying all values on the same X-axis in hover mode, if there was a missing value, the next value was displayed incorrectly.
Project: Collaboration: If you exited the app without closing the project, the green editing light remained on.
Project: Opening a project failed with the error "invalid multibyte character in parser (C:\Program Files\Exploratory\lib\library.r:4591:61" after upgrading to Exploratory 14.1.
Released on 12/7/2025.
AI: AI Function: An error occurred when executing data that contained line breaks.
AI: AI Summary didn't work on the Academic plan if it hit the quota.
AI: Ask AI: The spin icon kept rotating.
Chart: Bar: Reference Line: The X-Axis reference line didn't go through from the bottom to the top when using Repeat By, multiple Y-Axis columns, and Y-Axis sync disabled.
Chart: Change the name of the reference line button.
Chart: Chart wasn't refreshed automatically after the AI function process was completed.
Released on 11/23/2025.
We've published a blog post to introduce these new features, please take a look for more details.
Data Source: Google Sheets: Now you can override column data types during import.
Data Wrangling: Added the copy text feature in the hover popup.
Chart: Added the copy text feature in the hover popup in the Table/Pivot Table.
Chart: Supported date formats where there are no zeros in the tens place, such as 8/1.
Chart: Added button style menu for Filter and Reference Line.
Chart: Number: Difference / Ratio: Now you can change the display name for sub-metric.
Chart: Number: Now you can change or flip text color for sub-metric.
Chart: Pivot Table / Summarize Table: Added window calculation support for Total and Subtotal.
Chart: Pivot: Show detail: Now you can show only the rows whose logical values are TRUE when 'Number of TRUE' is selected.
Chart: Reference Line: Cumulative Sum/Cumulative Sum Ratio: Y2 axis option is now available in all chart types.
Chart: Reference Line: Added grouping option support for Cumulative Sum/Cumulative Sum Ratio and Moving Average reference line types.
Analytics: t-Test: Changed the menu name for assuming equal variances.
Dashboard: The map zoom level is now maintained when removing filter selection.
Data Source: Database: Windows: The SQL being written disappeared when maximizing the window.
Data Source: The file selection button did not show up after clicking the Import button.
Data Source: Google Analytics: "Cannot read properties of undefined (reading 'some')" error occurred.
Data Source: Import: The Cancel button in the import dialog was unresponsive after clicking the Cancel button of the SQL Query.
Data Wrangling: Replace Values with Conditions: Existing condition settings showed as "Creating...".
Data Wrangling: Filter: The "Specify multiple values" option under "Starts with this character" did not work.
Data Wrangling: The Data Re-import Dialog did not remember the previous selection.
Data Wrangling: After deleting a data frame, the data frame sometimes remained.
Data Wrangling: On the Data Re-import Dialog, data frames referenced from a branch data frame were not listed.
Data Wrangling: Filter: The condition expression became empty when specifying multiple values under "Starts with this character".
Data Wrangling: When importing an EDF file, an unnecessary "imp" suffix was set to the data frame name.
Chart: Charts should always be pinned.
Chart: Pivot Table / Summarize Table: If you applied the "% of" Window calculation and added additional totals, it did not work properly.
Chart: Pivot Table: Color Format: Custom calculated values used an incorrect color palette.
Chart: Pivot Table: An error occurred when using Limit Value.
Chart: Pivot Table: When a value was cut off, information was sometimes displayed in a popup and sometimes not.
Chart: Pivot Table: When multiple values were selected, "Show subtotal only" or "Show total only" for the last value did not work properly.
Chart: Reference Line: Calculation for Cumulative Sum/Cumulative Sum Ratio and Moving Average was incorrect on Scatter and Bubble charts.
Chart: Reference Line: An error occurred when adding Moving Avg on Y, Specific Value on X and Specific Value on Y.
Chart: Reference Line: The second reference line label was not displayed in the legend even when "Show in Legend" was checked.
Chart: Reference Line: The Y-axis scale became incorrect when using a reference line with logical type data showing true ratio.
Chart: Reference Line: Y2 axis title and label overlapped and the label was truncated when a cumulative total percentage reference line was set.
Chart: Scatter plot: Reference lines were not displayed when a date column was assigned to the X axis.
Chart: Scatter: Show detail data was not displayed when Y-axis format was set to percentage.
Chart: Sorting did not work on the Boxplot with Color if you assigned the same column to X and Color.
Chart: Table: Summarize Table: Pivot Table: User palette returned grey color palette.
Analytics: Changed the number of decimal places displayed for P-values in Guided Analytics.
Analytics: Decision Tree: The node with a value 0.5 did not show the gray background.
Analytics: If a parameter was changed in the analytics view, the process did not finish and the busy indicator kept showing.
Analytics: Legend got garbled when selecting a target column whose value included Japanese in Decision Tree.
Analytics: Supervised Learning Models: When a date column was used as predictor, Day of the month was incorrectly treated as Category.
Analytics: t-Test (Aggregated Data): Data Distribution tab loading did not finish.
Analytics: Word Count: When changing settings for the co-occurrence network size, results from a different data frame were displayed.
Note: Full-size image display position was incorrect.
Note: When importing EDF to a project that had duplicated data frames, not all charts were imported.
Note: When importing an EDF file, an unnecessary '_1' was added.
Dashboard: The whole page refreshed even if "Apply for All Pages" was unchecked and the parameter was updated on a page.
Dashboard: When a dashboard was published without execution, the thumbnail showed the previous execution's last viewed page instead of the current page.
Dashboard: When a duplicated dashboard was published without execution, the first page's first object became the thumbnail.
Publish: When publishing data, an error "paste(csv_content...) result would exceed 2GB" occurred.
Project: An error occurred when duplicating a project with invalid dataframe metadata.
Project: Project window did not close with a single click.
Released on 10/15/2025.
Released on 10/14/2025.
AI: AI Prompt failed to return results when using "Calculate NPS" as the prompt text.
Data Source: Oracle: Selecting Oracle as a data source displayed a blank screen.
Data Wrangling: The "startsWith is not a function" error occurred when deleting data frames created from merged Data Files.
Released on 08/15/2025.
Released on 08/14/2025.
Chart: Pivot/Summarize Table: Now you can override the default total aggregation function.
Chart: Pivot/Summarize Table: Now you can decide to show/hide total at each column level.
Dashboard: Chart rendering performance improvement. Now chart queries do not block the chart rendering.
Data Source: Close button did not respond after canceling an import in an R script data source on Windows.
Data Wrangling: "Data Re-import all" did not work when the targets were branches and/or branch of branches.
Data Wrangling: AI Prompt: Socket closed when the data frame had a group by column and contained many groups, causing sample data size to exceed limits.
Data Wrangling: Filter: An error occurred when specifying a parameter for "The last day of N months from today" in the filter.
Data Wrangling: Updated text/label for "1st/last day of N Month Ago" options for better clarity.
Chart: Bar: Y1 and Y2 axis scales did not sync at zero when setting the axis range to Y2 axis.
Chart: Heatmap: Color palette was not applied correctly for values of 0 if you set a custom color on the same chart before.
Chart: Line: Legend color appeared inverted from the configured color setting if you set the "Bottom to Top" direction in the Color dialog on the same chart before.
Chart: If you used the "Line + Circle" marker type and clicked the chart figure to show the detail, circle markers disappeared.
Analytics: Time Series Clustering errored with "model = purrr::map(...)".
Dashboard: After copying a dashboard from one project to another, it added '_1' to the copied dashboard name.
Dashboard: Switching to column layout showed a blank screen right after creating a new dashboard.
Released on 7/29/2025.
Released on 7/28/2025.
Data Source: When you have multiple data sources for your data frame now you can select which data sources you want to re-import from.
Data Source: Now you can drag and drop '.xlsm' files for import.
Data Wrangling: Filter: Now you can filter by first and last day of the month ago.
Chart: Supported parameters in custom calculations.
Chart: Now it includes Grand total values when exporting data for Summarize Table and Pivot Table.
Note: Supported the Save button on the Note Editor.
Note/Dashboard: You can now configure the End of Line character when exporting chart data to CSV in System Settings dialog.
Security: Supported 2FA/MFA authentication.
Data Source: S3: Fixed an error "Error in z[["Owner"]][["ID"]] : subscript out of bounds" when importing data.
Data Source: MongoDB: Column data types were different from Desktop after scheduled data refreshed on server.
Data Wrangling: Summary / Table View: Could not clear text when the "Is In" operation is selected for POSIXct type on row filters.
Chart: Date range parameters did not work after switching to use a specific date instead of a parameter.
Analytics: Linear Regression failed with extract_from_date function error when the predictor column data type was changed from Date to Numeric.
Analytics: Word Count: Example sentences were either repeated or missing in AI Summary dialog.
Analytics: Word Count: Downloaded chart images showed wrong charts.
Note: Colored text was automatically recognized as hyperlink under certain conditions.
Dashboard: Error in gsub("EXP__NA", """", csv_content) : input string 1 is invalid" was shown when exporting chart data to CSV.
Dashboard: Parameter: Server error occurred in the browser when the 'Save Selected Value' was unchecked.
Publish: The original URL was not preserved when publishing a dashboard failed with 'Storage Quota Exceeded' error.
Released on 7/8/2025.
Chart: Map: UK country map was missing some areas.
Chart: Map: World map was missing some countries such as Vatican City, Antigua and Barbuda, etc.
Chart: Map: Longitude range of the Pacific-centered world map was too wide.
Project: Project failed to open with the error "Error in loadNamespace(x): there is no package called 'pacman'".
Released on 07/05/2025.
Data Source: Google Sheets: Now you can automatically detect data types during import, just like with CSV files.
Chart: Number: Now you can append custom text after the value in Number charts.
Note: Now you can export notes in Markdown format.
AI: Prompt: R Script was not correctly restored when reopening an existing AI Prompt step.
Data Source: BigQuery: Text in the connection settings dialog overlapped with the title.
Data Wrangling: Error handling needs to be improved if the referenced connection is incorrect or not found when publishing or exporting a step.
Summary View/Table View: Displaying all columns did not work properly when there were more than 1,000 columns.
Chart: CSV download option was not available in the published chart.
Analytics: There was an extra space to the left of the X-axis when the confidence intervals option was checked in the Survival Curve.
Note: Blank window showed up when opening notes created with older versions of Exploratory Desktop.
Dashboard: Fixed an issue where the dashboard thumbnail still contained a hover popup.
General: The user dropdown shows quota information when connected to a hosted or on-premise server.
General: Project window turned blank when resized or maximized on Windows.
Released on 06/28/2025.
Data Source: Google Analytics: It should show a user-friendly message when re-importing obsolete v3 GA data sources.
Data Wrangling: It should show a user-friendly message when selecting non-EDF files.
Chart: Pie/Doughnut Chart: Opacity setting didn't work if you picked a custom color with an opacity.
Analytics: Analytics Guide view scrolled back to the top when moving between windows.
Analytics: Statistical Models: Multicollinearity charts did not display groups with perfect collinearity when using Repeat by.
Analytics: Word Count: Co-occurrence chart didn't appear in published Word Count analytics.
Note: R Script: Zoom level of the ggplot2-based chart were different between web and desktop previews.
Dashboard: "Failed to update variables while generating Dashboard" error occurred when running a dashboard.
Dashboard: Clicking the Run button or changing the parameter took very long time if a dashboard contained many charts.
Parameter: Changed the "Cache Values" label to "Get Values Dynamically" and set default to off for improved clarity in the Parameter Setting dialog.
History: "Restore from history failed with unrecognized input" error occurred when restoring a history.
Released on 06/12/2025.
Summary View: The step export menu style was broken.
Analytics: Word Count: Moved network chart-related properties to the Analytics-level setting for consistency.
Analytics: Word Count: Fixed an inconsistency where the AI Summary results did not match the groups shown in the Network Chart.
Parameter: Numeric text input parameters defaulted to 0 when left blank.
History: Fixed an issue where using the mouse wheel caused unexpected scrolling behavior.
Released on 06/11/2025.
Chart: Table: Now it supports the "Apply All Columns" option in the color formatting.
Analytics: Enhanced user interface with improved navigation and visual design.
Analytics: Chart: Now you can see the list of available charts/analytics from the "Show Chart/Analytics List" button in the Analytics and Chart tab area.
AI Prompt: It didn't create a step after clicking the "Save As Step" button when opened via Cmd + L shortcut.
AI Prompt: Resolved an issue where AI Prompt would fail when processing sample data containing a high number of columns.
AI Prompt: The "AI Wrangling" button style was not displayed correctly when grouping columns were present.
Data Source: CSV / Text Input: Separator fallback is now supported at the R function level so that it works on the Scheduler.
Data Source: CSV Import: Auto-detection of the separator did not work when the file contained only one column.
Data Wrangling: Error dialog should not appear if the error originates from a wrangling step.
Chart: "Cannot read properties of null (reading 'getRName')" error showed up when deleting a data frame.
Chart: R-based charts now support automatic configuration to make output responsive to the view area.
Analytics: Analytics type now appears in the hover popup for analytics.
Analytics: Renamed "Predictor Variables" to "Explanatory Variables" for consistency.
Analytics: The "Data Type" column for Training/Test was missing in GLM analytics even when Test Mode was enabled.
Analytics: Data rows that are not statistically significant should be in gray color in the Coefficient tables in Statistical Prediction Models.
Analytics: One-way ANOVA should use the oneway.test() function for improved statistical accuracy.
Note / Dashboard: Publishing failed with "EPERM: Operation Not Permitted" error in some cases.
Note: Fixed an issue where the note reverted to a previous state unexpectedly.
Parameter: Executing a slider parameter with the default value did not return the correct result.
Parameter: After resetting the parameter value to the default, the number slider value jumped to the maximum.
Publish: Publishing a Dashboard or Note failed with a network error if you had a lot of case-when conditions in the step.
System Setting: Fixed terminology inconsistency for "Repository" in Japanese UI.
General: The quota information should be refreshed when opening the user info dropdown on the Project List page.
General: The quota information should display the next quota reset date in the user info dropdown on the Project List page.
Released on 04/28/2025.
AI Prompt: Now you can preview the output of the suggested R script by clicking the "Preview" button at the R code block.
AI Prompt: Now you can select a part of the generated R script and preview the result.
AI Prompt: When you see an error by running the generated R script in AI Prompt dialog, you can click on 'Auto Fix' button to have AI automatically fix the R script in the Preview pane.
AI Prompt: Now you can see the history of the past prompts that match what you type in.
AI Prompt: Now you can use "@" sign for the data frame name suggestion in addition to the "$" sign.
Data Wrangling: Export: Now you can enhance CSV export options, including Encoding (BOM) and Line Endings Code (LF/CRLF).
Chart: Pivot Table: Now you can control the alignment of the column title text from the Column Property dialog.
Chart: Pivot Table: Now you can show the vertical grid lines between column categories from the Chart Property dialog.
Dashboard: Now you can replace the existing chart with a new chart by clicking the "Choose a different chart" button.
AI Prompt: Added support for auto-scrolling to the bottom of content while streaming results from AI.
AI Prompt: After you changed your email address on Exploratory Server, AI Prompt does not work on Exploratory Desktop.
AI Prompt: Automatically prefix function names with the corresponding package name when the package was not loaded by default.
AI Prompt: Improved error handling for cases where the server becomes unresponsive during a request, such as a 529 Overloaded Error.
AI: Ask AI: It should open the chat window inside Exploratory Desktop app instead of opening an external web browser.
Table View: Column summary panel didn't close if you moved to the other wrangling step.
Data Wrangling: Character columns could not be selected in the Chi-square Test dialog.
Data Wrangling: Export: Leading zeros were lost when exporting data to Google Sheets.
Chart: Boxplot: "Show Unused Levels" setting on the X-axis didn't work properly.
Analytics: The result of 'Paired t-Test' was not matching with the result of R.
Dashboard: LaTeX formatting was not working in the text editor.
Dashboard: On Windows, publishing failed with "EPERM: Operation Not Permitted, Open" error.
Note: Repeatedly copying and pasting Math blocks, R blocks, and images within the same note caused instability when pressing the Enter key.
General: Mac: Full-screen mode was canceled when switching to another screen.
General: The 'purrr' package should be loaded by default when you open a project.
Released on 4/9/2025.
AI Prompt: The AI Prompt step menu appeared even when the system was offline.
AI Prompt: The AI Prompt dialog was dragged outside the visible window.
AI Prompt: Pressing the Escape key inside the R Script editor incorrectly closed the AI Prompt dialog.
AI Prompt: Newly typed column names in the R Script editor were not being highlighted.
AI Prompt: Column name suggestions didn't work correctly after typing a function name in the R Script editor.
AI Prompt: The tooltip background for error steps were white instead of the intended black.
Data Source: Prevented drag-and-drop file import when the AI Prompt dialog was open.
Data Source: MS SQL Server: Implemented a retry mechanism for handling "Communication link failure" errors.
Data Wrangling: Create Calculation with Conditions: Improved the condition panel scrollbar for smoother and more reliable scrolling.
Data Wrangling: It should checks the data frame metadata and shows a warning with details if there's any inconsistency that might cause a data frame to be missing when you duplicate a project.
Chart: Chart was refreshed when you updated the condition for the conditional aggregation such as "Sum If" even though the auto-run option was turned off.
Chart: Pivot Table: If you sorted the column in the descending order, the subtotal order didn't match.
General: Windows: Exploratory window unexpectedly shifted position when using external displays.
Released on 03/27/2025.
Released on 03/26/2025.
AI: Now you can ask AI for data wrangling questions.
Chart: Pivot Table: Summarize Table: If you turn on the "Show Popup on Hover" option in the chart property dialog, now you can hover the total cell to see the aggregation function used for the total calculation.
Chart: Pivot Table: Summarize Table: Now you can show "0" values as empty values by turning on the "Show Zero as NA" option in the chart property dialog.
Project: Now you can search comments of data frames, branches, notes, and dashboards.
Data Source: Excel: The sheet name was not refreshed when re-importing data or pressing the refresh button in the import dialog.
Data Source: SQL Editor: Unnecessary function suggestion was showing up.
Data Source: SQL: It should show a "Rerun" message when an R conflict occurred.
Data Source: Teradata: Database connection failed with external pointer is invalid error.
Data Wrangling: column name highlighting did not work for names containing special characters.
Data Wrangling: Column suggestion is not displayed inside parentheses when creating calculation.
Data Wrangling: Now you can either ask the error to the Intercom AI or copy the error text when you get a step error message at the top of the window.
Data Wrangling: Refreshing a data frame that references a local file failed after importing a project.
Data Wrangling: Summarize: The function box next to the Number Of Rows was disabled by default
Data Wrangling: The Delete Confirmation dialog was not centered in the window.
Chart: If you created categories on numeric values and assigned custom bucket labels with only numbers like "1, 2, 3, 4...", the chart showed incorrect number of buckets.
Chart: Line: If you apply the "Percentage" formatting on the X axis, it should multiply the values by 100 automatically.
Chart: Scatter (With Aggregation): If you assigned a column to "Color by", it didn't draw a reference line fully from the left edge to the right edge.
Chart: Scatter (With Aggregation): If you assigned a column to "Color by", the labels for the reference line showed up in multiple places.
Chart: Scatter (With Aggregation): If you assigned a column to "Color by", you couldn't change the the color of the diagonal reference line.
Chart: The "Cumulative Sum Ratio" Window Calculation should show up in the menu list.
Analytics: Prophet – The 'Run' button was cut off when multiple external predictor variables were specified.
Note: Deleting text directly below a math block would select the math box instead of deleting the text.
Note: Note window was not correctly listed under the window menu.
Note: Reduced the delay between clicking the Publish button and the Publish Dialog opening.
Dashboard: Clicking a URL link in the text panel did not open the link in the web browser but displayed it within Exploratory Desktop Window.
Dashboard: If you publish a dashboard, it should use the dashboard thumbnail instead of the 1st chart thumbnail for the publish notification email.
Dashboard: If you ran Parameter with the "Apply for All Pages" option and moved to another page, the busy icon kept spinning.
Dashboard: If you ran Parameter, the contents of the whole app shifted upward.
Dashboard: If you ran Parameter, the scroll bars appeared and disappeared repeatedly on each dashboard panel.
Dashboard: Long page title was not properly truncated in the preview.
Dashboard: Parameters – "Failed to generate Dashboard while updating catalog" error occurred when executing parameters.
Dashboard: Note: Report menu icon did not appear when hovering over it.
Parameter: Data was re-fetched unnecessarily when updating parameters in an SQL query.
Project: Importing a specific remote project displayed an incorrect import dialog that prevented the import process.
Project: Resetting R packages failed when an active project was open.
Project: Windows: Publishing a project failed with zip error: Error Code 15.
General: The error message improvement when requesting a License Key fails.
General: The Cmd + Backtick shortcut key interfered with other applications.
General: If you clicked the "Ask AI" button in the error dialog, it sent the "[Object object]" as an error message to the Intercom AI chat.
General: The delete confirmation dialog was cut off when many items were listed in the catalog.
General: The link to show/hide the error details in the error dialog did not work.
Released on 02/18/2025.
Released on 02/16/2025.
Data Wrangling: Selecting a data frame in a low-resolution Windows environment caused the right side of the UI to appear blank.
Publish: After publish a dashboard to a server, CSV exports from dashboard charts displayed inconsistent values.
Released on 02/14/2025.
Chart: Scatter (With Aggregation): Fixed an issue where colors could not be updated when using the "Manual" color bucket.
Dashboard: After updating the data source and running the dashboard, it didn't update charts on other pages.
Dashboard: When you open and run a dashboard, it failed if the underlying charts are not opened before.
Dashboard: Re-importing data from a database multiple times would cause the number of connections to increase unexpectedly.
Parameter: The spinning icon would persist when a cascading parameter referenced itself as the source for its list of values.
Publish: When offline, canceling publishing takes a long time to process, and after cancellation, it incorrectly displays a "complete" status.
Released on 01/25/2025.
Data Source: Snowflake: Data sources created in Exploratory Desktop versions prior to 9.8 could not be published to Exploratory Server after upgrading Exploratory Desktop to versions newer than 9.8.
Data Source: Excel: Override column data types didn't work when importing and merging multiple sheets from an Excel file.
Data Wrangling: Filter: Using the "Equal To" operator with a multi-select parameter caused an "Error in coercion to logical(1)".
Chart: Pivot Table: Reordering columns via drag-and-drop did not work immediately after dragging and dropping a data frame.
Chart: Summarize Table: Selecting the "Total & Subtotal" option in the Total settings prevented the Show Detail dialog from appearing when clicking a row header cell at the bottom.
Chart: The reference line color setting did not work when a column was assigned to Color, and the "Specific Value" reference line type was selected.
Note: Deleting text below an added image resulted in an unpredictable deletion mode.
Note: Improved responsiveness of the publish button to better indicate activity, especially on low-spec machines.
Note: Copy and Paste text values inside a table did not work.
Note: Publishing to Exploratory Server or exporting to an EDF file failed if the note or dashboard did not contain any charts.
Note: Inserting a chart to a 2-Column Layout didn't insert it to correct position.
Note: Updated spacing for bullet lists for better readability.
Note: Hitting the delete key on a row formatted as H1 now properly removes the H1 formatting.
Project: Project information did not display on the project page when a project was published for the first time using the Public edition.
Released on 01/09/2025.
Data Wrangling: Data frames could not be dragged and dropped into folders.
Note: On Windows, Note window could not be resized.
Note: Pressing the Enter key after typing a backtick in a code block resulted in an undeletable symbol being displayed.
Dashboard: Importing an EDF containing data frames with conflicting names caused the header row to display a "chart not found" error.
Publish: Publishing to the Data Catalog failed if the data size exceeded 2GB.
Released on 12/30/2024.
Now you can create new or edit Notes and Charts, which have already been published, in web browsers.
Now you can copy and paste the following objects across multiple project windows.
Also, now you can copy and paste charts across multiple data frames within a same project.
We added 'Run' button to Chart View so that you can decide whether you want the chart to automatically update as you change the column configuration or to hold the update until you click the Run button.
Chart: Added sub-menu for Reference Line, Trend Line so make it easier to access typical line types.
Chart: Supported additional trend line types - Exponential, Logarithmic, Power and Polynomial
Chart: Support showing values on the reference lines even when there are both X-Axis and Y-Axis lines.
Note: You can now expand images with full screen size inside Notes.
Note: We have added two columns layout component. You can use it to show two charts side by side.
Note: Support copying markdown text from outside the Note editor and pasting it while preserving the format.
Note: Support 'Paste without Formatting' with Command + Shift + V.
Note: We have assigned new short cut keys for Header text format as follows.
Data Wrangling: Now you can see the Data Wrangling Step's comments even when the steps are disabled.
Released on 8/29/2024.
Data Wrangling: Added an option to select whether to remove double quotes when exporting to CSV.
Data Wrangling: Added support for two types of comments - Author and Viewer.
Data Wrangling: Added support for using the Note Editor to enter comments.
Chart: Added support for date format settings when assigning a Date column to Repeat By.
Chart: Enhanced Number Chart to support displaying values from the previous period in sub-metrics.
Note: Now you can copy the URL for an H1/H2 header of the document by hovering the header text and clicking the link icon on a published note.
Dashboard: Added an option to set the top margin for Text Panels.
Dashboard: Added support for titles in Text Panels, similar to Chart Panels.
Dashboard: Now you can create a link to open another page from the Link dialog.
Dashboard/Note: Now it shows Author Comments when the logged-in user is the author of the insight.
Parameter: Added an option to set NULL in date-picker and slider parameters to return all values.
Parameter: Added support for inputting NA as a text input value.
Data Source: After importing a project from another user, “Run with Data Import” for the dashboard failed to reimport a parquet data frame on some occasions.
Data Wrangling: Create Calculation: When converting Japanese characters, the symbol "⍰" unexpectedly appears at the beginning of the resulting string.
Data Wrangling: Typing Japanese text may result in characters being repeated unexpectedly.
Data Wrangling: Data Source Reimport failed with TypeError: Cannot read properties of undefined (reading 'multivalued').
Data Wrangling: Long to Wide did not work when assigning an hms data type column to a value column.
Data Wrangling: Unit was ignored when converting hms data to numeric data type.
Chart: A "0%" difference from the previous period was displayed as "In,fin,ity%".
Chart: Boxplot: Even if you checked the "Include outliers" checkbox, the appropriate maximum value was not displayed.
Chart: Number Chart showed unnecessary space below even when there was no sub-metric.
Chart: Pivot Table / Summarize Table: The "% of" Window Calculation should be applied to the totals.
Chart: The time portion disappeared when changing the format of POSIXct type in Number charts.
Chart: When changing the marker to 'Line + Circle' it added unnecessary space at the right and the left sides.
Analytics: Linear Regression / Logistic Regression: In the Effects tab, it should show "< 0.0001" if the P-value is less than 0.0001.
Analytics: Survival Curve: Percentage values should show up in the Survival Table chart instead of ratio values.
Analytics: Survival Curve: Summary tab should show the "Rows" and "Rows *(TRUE)" information even if you don't set a column to Color.
Note: The 'plot' function in R Script Block didn't work inside the Note Editor.
Note: Adding a Code Block deleted images before the Code Block.
Note: Clicking the 'Number of Rows' dropdown caused the settings dialog to disappear.
Note: Could not reopen the same note immediately after closing it.
Note: Moving the cursor upwards did not select the image.
Note: Selecting text with Shift + Down only selected the image.
Note: When you published your note with the previous versions of Exploratory Desktop, if you didn't turn on the 'Data' and 'EDF' options, the 'Show Detail' option didn't show up on the published view even if you republished it with the latest version.
Note: Dashboard: If you added a waterfall or visNetwork chart in an R code chunk and clicked the preview tab, it spawned a new preview window. It should show the preview under the preview tab.
Dashboard: Optimized R Script output size to better fit the available section.
Project: Sorting data frames by name didn't work as expected if a data frame name contained "0." at the beginning.
Project: Opening a project showed the “EMFILE: too many open files, open” error once in a while.
Project: The editing green lamp remained on even after leaving a team-published project.
Released on 7/26/2024.
Data Source: SQL Connection: Added syntax validation for the Additional Parameter field.
Data Wrangling: Create Calculation with Condition: Unchecking the selected column did not clear the column from the selected columns.
Data Wrangling: Create Calculation with Condition: Duplicating a token to create a separate step resulted in unnecessary columns being added.
Chart: Limit for Date/POSIXct columns did not work as expected when Window Calculations were used.
Dashboard: It should not re-run the Dashboard when clicking the Publish or Published button when there was no change made to the Dashboard.
Publish: The Data option is now always enabled and has been removed from the Publish Dialog.
Released on 7/20/2024.
Data Source: SQL: An error occurred if an SQL preview was being executed when a notification for database import completion appeared and the OK button was clicked.
Data Wrangling: Filter: When filtering a POSIXct column with a time zone other than UTC, filtering by 'Date' did not yield the correct dates.
Data Wrangling: The "Import All the Related Source Data" option should not be displayed when selecting a step that precedes a merge data frame step.
Note: Pressing the Enter key in the image caption area did not add a new line.
Note: The content became blank if the data frame used for charts in the note were deleted.
Dashboard: Cascading parameters did not work when the parameter was set to use "Select All" for empty values.
Dashboard: The "Fit to screen" option did not work when previewing or publishing the dashboard.
Installation: On Windows, Exploratory Desktop failed to detect R installations located in the \AppData\Local\Programs\R folder within the user's home directory.
Release on 7/15/2024.
Data Wrangling: Wide to Long: Added support for automatic data type detection for Key columns.
Data Wrangling: Create Calculation with Condition: Added support for automatic data type detection for 'Return Values'.
Chart: Limit: Now you can limit the data by the relative dates in all chart types.
Parameter: Now you can change the order of parameters in the Data Import dialog.
Data Source: SQL import job failed when Exploratory Desktop was running in offline mode.
Data Source: Unable to click on source step token after canceling during data import.
Data Source: when a project was associated with custom R packages that were missing, the import SQL job failed.
Data Wrangling: Create Calculation with Condition: Custom conditions using 'OR' operators were not functioning as expected.
Data Wrangling: Create Calculation with Condition: The default column selection disappeared when there were no rows from the previous step.
Data Wrangling: In the Mutate dialog, the function help content for the highlight function was not displayed correctly when scrolling.
Data Wrangling: The Re-import option was not appearing under certain conditions.
Chart: Pivot: Summarize Table: Show detail returned no rows if you applied the date formatting on the Row or Column.
Chart: Scatter: The text order on the Y-axis became incorrect if you assigned the same character column for the X and Y axes and assigned columns for Color and Repeat By.
Chart: The order of the legend items was different between Mac and Windows if you had Japanese characters in the legend item names.
Analytics: Prophet: The Effects tab became blank if you assigned external predictors and used the multiplicative seasonality mode.
Note: The R code block preview output did not update dynamically when parameters were changed.
Note: When creating a visNetwork chart using an R code chunk and previewing it, the chart appeared wider than expected.
Note: When inserting a link to text, closing the URL Link dialog didn't save the URL.
Dashboard: Chart Picker: The Data Frame List incorrectly displayed disabled data frames after opening the merge or join steps.
Dashboard: Clicking the Apply button three times caused the text inside a text widget to disappear.
Dashboard: Exporting a dashboard to HTML caused the UI to break
Dashboard: The Math Block option was not supported in Text Widgets.
Dashboard: The visNetwork chart created in the R Script disappeared if you switched the dashboard tabs in the preview mode.
Dashboard: When re-importing data from an SQL data source, the confirmation dialog should not appear if the user is still opening the dashboard.”
Publish: Added a 'Retry' link for failed published jobs.
Publish: Dashboard: Selecting 'Data Re-Import' from the Run dropdown caused the dashboard to fetch data twice when publishing.
Parameter: The 'Allow No Selection (Return All Values)' option didn't return all values when the associated data frame was updated.
Project: Attempting to open a project often resulted in an error message: 'Failed to open the project because it couldn’t start an Rserve process.'.
Released on 6/19/2024.
Parameter: Added support for resetting parameter values to their default settings.
Data Source: Google BigQuery: Import result messed up during multiple Imports via Google Cloud Storage.
Data Source: After re-importing data, reopening the project displays the previous 'Last Imported Date' instead of the updated one.
Summary View: Quick Filters were not applied to exported data.
Data Wrangling: Long to Wide: Aggregate functions for numeric columns were incorrectly listed when a character column was assigned as the value.
Data Wrangling: Step Cut and Paste failed with the 'Cannot read properties of undefined' error.
Data Wrangling: Text Wrangling: The label for tokens always displayed the first token's label when multiple tokens were present in a step.
Data Wrangling: An incorrect 'circular relationship error' occurred when a join column name matched the name of another data frame.
Chart: Color: Logical condition on Date column didn't work as expected.
Dashboard: Always show a green comment icon if a chart has comments.
Dashboard: The output of R code chunks and inline R code did not update when parameters were changed.
Parameter: Resolved various parameter-related errors that appeared after importing an EDF file.
Parameter: TRUE/FALSE values were incorrectly auto-populated for 'List of value' options when selecting the 'List' style for a character list of value parameter.
Project: The project header displayed an incorrect name during the initial loading phase.
Released on 6/5/2024.
Release on 6/3/2024.
Data Source: Switching between connections didn't update the schema and tables correctly.
Data Wrangling: The Last Imported date information in the data import step was updated even when just running a step that is not the data import step.
Chart: Number: When there is no value to compare against, now we display '-' instead of leaving the field blank.
Chart: Number: The height of the number was incorrect when there was no data after applying the parameter setting.
Chart: Pivot: Summarize Table: Now we support "Calculate As Absolute Values" option for "Difference"/"% Difference" Window Calculation.
Chart: Pivot: Summarize Table: When you have two columns assigned to Row and set the "Hide" option for the first column, removing the first column pass the Hide setting to the second column.
Parameter: The column assignment for a parameter became invalid after deleting a referenced step. Now we automatically assign the previous step to make the parameter valid.
Project: Projects could not be closed if they had previously failed to publish and had pending changes.
Released on 5/29/2024.
Chart: XmR Chart: Now you can show the "Control Limits" range for Line, Bar, Scatter, Bubble, and Error Bar charts.
Chart: Number: Now you can show a sub-metric value underneath the main metric value when using the Difference feature.
Chart: Now you can choose the "Period Ago" reference line type if you assign a Date/POSIXct column to X-Axis.
Chart: Now you can set the base data range for the reference line calculation and the trend line data.
Chart: Added 'Quick Filter' operator for the Limit Values at X-Axis.
Chart: Now you can change the sort order for the Repeat By.
Note: Added 'Text Search' and 'Replace Text' feature for Note Editor.
Data Source: CSV Import: Supported the "Treat All Columns as Text (Force)" Option.
Data Wrangling: Added 'Quick Filter' operator to make it easier to filter time series data.
Data Wrangling: Added the 'Latest N Years/Months/Weeks/Days' options for the 'Relative Date' operator for the Filter.
Table View: Now you can set the custom decimal and thousand separators for numeric data shown inside the Table View.
Chart: Reference Line: Now you can set the text position (left or right) for the reference line labels on the plot.
Chart: Binning: Now you can use the Manual bucketing option for a Date or POSIXct column at Color.
Chart: Color: Now you can choose an aggregation function for sorting Color/Legend items by values.
Chart: Added 'Latest N Years/Months/Weeks/Days' options for the 'Relative Date' operator for the Limit Values at X-Axis.
Chart: Pivot: Summarize Table: Now you can show the column names in multiple lines with the 'Text Wrap' option.
Chart: Pivot: Summarize Table: Table: Now you can show the full column names with the "Fit to Header Text" option.
Chart: Pivot: Summarize Table: Now you can change the text alignment for the Row values.
Chart: Pivot Table: Now you can sort the values for the Column.
Analytics: Factor Analysis: Now you can enable the text wrap to see the full column names on the Weights tab.
Dashboard: Updated the Run button as a dropdown button so that you can choose either Run or Run with Data Import.
Dashboard: Added support for showing the comment for Number charts that are included inside a Dashboard.
Note: Added the display size options for the R Script block.
Note: Support the chart size with normal width and full height.
Note: You can now search for and replace text within a note.
Parameter: Now it supports the quote option so that you can make column names as parameter values inside calculations.
Project: Now it supports numeric sorting for data frame names inside the project.
Project: Now you can invite academic plan users to your team shared projects.
Data Source: BigQuery: When importing data that contains character columns, the data type of the column changed from character to numeric on some occasions.
Data Source: Excel: It mistakenly selected all the columns even though these columns were not presented in the preview table.
Data Source: Excel: It opened a wrong dialog for multiple Excel sheets when clicking a source step.
Data Source: Google Analytics: When opening the import dialog, It did not restore the previously selected profile.
Data Source: Re-Importing SQL data showed an infinite spin when the associated password is empty.
Data Source: SQL: After canceling a data import job, it showed ERROR CODE 127.
Data Wrangling: Window Calculation: If there was an NA at the beginning of the data we the cumulative calculation returned all NA values.
Data Wrangling: Could not combine multiple Create Calculation With Condition steps into a single step.
Data Wrangling: Exporting step data to Google Sheets with the 'Override Existing' option failed with error code 127.
Data Wrangling: Join: After creating a right join step, the target data frame key columns in the Join Dialog became disabled if the target data frame was a branch of a branch.
Data Wrangling: Join: When the target data frame was "Grouped by", you could not get rid of the group columns from the target column selections.
Data Wrangling: When copying a data frame, it sometimes failed to copy the underlying chart.
Data Wrangling: Work with Text Data: If the new value is missing, it should show the new value as
Chart: Bar chart failed to render due to the “idx must contain one integer for each level of f” error if you assigned a column that had many unique values to X-Axis.
Chart: Heatmap: The default decimal formatting didn't apply for values on the plot area if you turned on and off the thousand separator setting.
Chart: Number: If you closed the Difference/Ratio dialog by hitting the Close button, moved to another chart tab, and came back to the original chart, then the value became "0".
Chart: Pivot Table: If you enabled the text wrap, the column width got wider.
Chart: Pivot Table: The cell width got wider even if you set an explicit cell width in the Formatting dialog if you assigned multiple columns to Value and a column to Column.
Chart: Pivot: Summarize Table: Table: Now you can customize the text for "Inf".
Chart: Reference Line: The line didn't go through from the left to the right if you assigned a column to "Color By" and chose the "All" for Group By setting.
Chart: Reference Line: You should be able to enter date values for the constant value even if the column at X-Axis is POSIXct.
Chart: Table: The text sort order was inconsistent between the Table and Pivot if the data contained full-width alphabet characters.
Chart: The Missing Value Handling menu should show up even if you assign multiple columns to the Y-axis.
Chart: You should be able to change the color for each column at Y-Axis if you have multiple columns assigned to Y-Axis.
Chart: Table: Table should show the number of rows all the time.
Dashboard: After changing the parameter type from Single Select LOV to Multiple Select LOV, opening a dashboard raised TypeError: e.value.map is not a function error.
Dashboard: After moving the last chart from one row to another row by drag and drop, the empty row was removed from the page.
Dashboard: Showing the detail data failed with the "error code 3" error on the published dashboard if the chart used in the dashboard was not pinned to the step.
Dashboard: When publishing a dashboard whose data source is Google Drive, it showed a connection not found error.
Dashboard: Running a dashboard with parameters referring to a data frame resulted in an "object not found" error.
Dashboard/Note: Changed the default sort type to Date instead of Name.
Note: After inserting a URL that contains a hyphen (-), it was mistakenly escaped.
Note: Deleting an inline code block was difficult if there was a space at the end.
Note: Importing notes created with Exploratory Desktop V9 sometimes resulted in charts being incorrectly placed within bullet lists, causing them to display improperly.
Note: LaTeX: Added the link for the LaTeX cheat sheet.
Note: Note content got cleared for some occasions.
Note: Resolved an issue where deleting an inline code block at the beginning of a sentence was difficult after its contents were cleared.
Note: Retain the original scroll position when pressing the refresh button.
Note: The cursor could not be placed before a character immediately following an inline code block.
Note: The mouse cursor could not be placed immediately after inline math syntax.
Note: When trying to cut and paste an image in a note, it did not work unless you explicitly clicked the circle icon to select the image before cutting it.
Note: The size popup didn't go away even if you unselected a map chart on a note.
Note: The size popup didn't show up if you selected a map chart using the cursor key.
Parameter: It should show an instant popup for a long parameter name.
Parameter: The Data Frame List of Value should show an instant popup for a long data frame name.
Parameter: After deleting a step referenced from a parameter, selecting the step that uses the parameter showed the object not found error.
Project: The current editing user popup shouldn't show the users who don't have the privilege to republish the project.
Project: When multiple projects were opened, the projects froze when you tried to close them.
Project: You could not close a Project after publishing the project.
Project: Restoring with history failed with "does not match index" error.
General: The chat button did not go away even if you clicked the close button.
General: Signing out and then signing in with a different account still used the previous account's information for publishing insights.
Installation: The rename dialog now consistently displays IDs for Project, Data Frame, and other elements, enhancing the diagnostic experience.
Release on 3/24/2024.
Note: Changing the parameter value on one note inadvertently triggered an update to the parameter value on a separate note, despite the 'Save Selected Value' checkbox being selected.
Project: Spin Icon closed prematurely prior to the completion of project loading.
Release on 3/21/2024.
Chart: Support choosing the base axis (Y1 or Y2) for the zero line sync.
Note: Supports option to display borders for charts embedded in notes.
Parameter: Now it supports overwriting labels for a List of Values with '(None)' and '(All)' options.
Chart: Bar: NA didn't show up as a category if you assigned a Date column including NA values to Color.
Chart: Color dialog didn't remember the Color Direction setting when reopening the Color dialog.
Chart: Reference line length should be the same as the group's data range if you choose "Color" for the Group By setting.
Chart: Map: Legend becomes weird if you apply the percentage number formatting.
Dashboard: Attempting to add a link within a text unexpectedly closed the Text Edit dialog.
Dashboard: After changing parameter values, it did not update the charts on the Dashboard.
Dashboard: Running preview failed with the error code 127 if you had a chart with a range parameter on the dashboard.
Dashboard: Text editing was unavailable for dashboards created with versions before v9 if they contained HTML tags.
Dashboard: Text Widget: When you run the Dashboard, the color setting for text does not work and it becomes a link.
Dashboard: Pressing the Tab key inadvertently triggered the display of the parameter pane.
Dashboard: When the parameter is applied to all pages, some charts in inactive pages are not updated.
Data Source: Importing a CSV file resulted in an error message displaying 'could not find function "silver".
Data Source: Database / R Script: Users were unable to select items from a multi-select List of Values (LOV) on the Import dialog.
Note: Chart: Values shown on top of a bar chart are cut off on Windows.
Note: Selecting the 'Body' option from the Heading toolbar dropdown menu did not clear the Bold, Italic, Strikethrough, Color, and Inline Code formatting.
Note: Data Reimport: Previously, users had to click 'Re-import Data then Refresh' twice to see the updated data reflected.
Note: Even after enabling the LaTeX format option, the math syntax was not working.
Note: Header items should have indentation depending on the level.
Note: Inserting an HTML does not work on the Preview and Publish.
Note: The link to the Header didn't work when there were special characters in the header text.
Note: Math output (font etc) should be consistent between Editor and Preview.
Note: Math syntax doesn't work on the HTML preview.
Note: Note: One cannot delete a table by simply pressing the delete key after selecting it.
Note: Previewing R script failed if you had a comment line at the bottom of the script.
Note: R code output should be consistent between Editor and Preview.
Note: R/HTML/Math Code Block selection update.
Note: Now it supports math y = ax + b as the inline math syntax that eliminates the dependency on the $ signs.
Note: Table: Could not enter a new line feed in a cell text.
Note: When adding a comment to an existing chart, it is not displayed in the editor.
Note: When publishing a note, an image caption was left-aligned where it should be center-aligned.
Note: When copying and pasting note content between projects, the content was transformed into markdown text rather than retaining its original format.
Parameter: After hiding parameters on a Note, the parameters reappeared upon refreshing the note.
Project: After reopening the project, the previously selected Report Sort Type option was not restored.
Publish: Dashboard: Note: Support an option to enable chart data downloads, but not for EDF file.
Released on 3/5/2024.
Data Source: Snowflake: Now it supports secret key file authentication on Exploratory Server.
Chart: Table: Now you can show image URLs as images in table cells by the "Treat as Image" option in the Format Configuration dialog.
Note: Added "Edit" buttons for the charts inside Note so that you can click them to open the charts directly under the Chart view.
Note: Added HTML code block component so that you can embed HTML code inside Notes.
Note: Added Web Page component so that you can embed Web pages in a note.
Note: Supported 'Header' link inside Note so that you can create text links that would navigate to headers (H1, H2) in the same note.
Note: Now you can see a thumbnail of each note by hovering over the note name in the left-hand side pane.
Note/Dashboard: Now you can sort the data frame list by Name or Updated Date.
Data Source: Mac: Sometimes a password on a Data Connection was cleared and you had to reenter the password for the Data Connection.
Chart: The "Always Include 0 in Y Axis" property didn't work properly if you had a Reference Line on X-axis.
Chart: Pivot Table: If you exported the Show Detail data with more than 100 columns, it exported only up to 100 columns.
Note: Changing the image size moved the image to an incorrect position for small images.
Note: Existing note didn't open if "<" and ">" signs were used in the code block.
Note: Clicking the Refresh button multiple times caused another R running error.
Note: When opening an existing note, an empty line at the bottom was removed where it should be kept.
Note: When copying text containing multiple levels of bullet points and pasting them into a note, only the text from the first level was captured.
Note: When copying and pasting note content within Exploratory Desktop, users experienced an issue where the second copy of the same content was pasted as markdown text instead of retaining the original content format.
Dashboard: Scheduling a dashboard failed if you had a chart and one of the data sources is the local Parquet file.
Dashboard: Clicking on a chart inside a published dashboard at the server caused an error if the chart didn't pin a step.
Dashboard: If you republished a Dashboard after running it, it showed another R running error for some occasions.
Dashboard: Dashboard Filter didn't work if you clicked one of the bars on a Horizontal Bar chart with no column assigned to the X-axis.
Parameter: If you changed the data frame selection for one parameter, the other parameter's data frame selection was also changed.
Project: When you opened a project, it showed an empty screen sometimes.
Project: After closing a project while the data import dialog was opened when you opened the project, the data import dialog was partially displayed.
Project: When the spin was shown on the Project List, it didn't cover the whole window.
Released on 2/22/2024.
Data Source: Amazon Aurora: Accessing Amazon Aurora failed due to obsoleted bundled SSL certificate file.
Data Wrangling: The 'Remove duplicated rows' command did not work if you selected a column whose name starts with "_".
Chart: Assigning a color to the Y-Axis Column did not work if the Repeat By was used.
Chart: If you set "0.1" to the Each Step Length property, it immediately turned to "0.00001" in the chart property dialog.
Chart: If you assigned multiple columns at Y-Axis and assigned colors on those columns, the color configuration didn't follow the column order change by the drag-and-drop.
Note: Could not open a Note if it included HTML tags such as style, image, and script.
Note: Refreshing a note did not refresh a chart on the note if the note contained both updated charts and not-updated charts.
Note: Chart default height should be taller if the chart has the Repeat By and the "Full" height size option.
Note: When applying color to multiple bullet points simultaneously, it inserted a weird character at the beginning of the first item.
Note: When copying an image from another note, it copied it as an escaped markdown text.
Note: When you copied and pasted text from Mac's Note App, it showed unnecessary HTML tags at the top and also inserted unnecessary line breaks.
Note: You cannot change the "# of Columns" for the charts with Repeat By.
Dashboard: When a parameter had a dependency on another parameter, the dependency parameter was not shown inside the parameter pane.
Released on 2/14/2024.
Note: Now you can set a color on the text.
Parameter: Now Dashboards and Notes remember the last selected Parameter values.
Parameter: Now it remembers "Auto Run" checkbox setting when publishing so that the published contents (e.g. Dashboards) have the same setting.
Data Source: CSV: The data importing hangs if the file encoding was something other than UTF-8.
Data Source: Text Input: It showed the content from the other data frame when opening the dialog after running another data frame.
Data Wrangling: After canceling a job, the 'TypeError: A.map is not a function' error was raised.
Data Wrangling: Removed the 'Group By' from all the column header menus to avoid confusion.
Data Wrangling: When multiple "Replace with Conditions" steps were combined, all the tokens showed the content from the first token.
Chart: Boxplot: Median, 1Q, and 3Q values didn't change regardless of the "Include Outliers" checkbox setting.
Chart: Color palette inside the Color setting dialog didn't match the actual color palette used on the chart if you assign a gradient color palette for more than 10 categories.
Chart: Other Group: The Other Group dialog overflowed if you had too many categories listed.
Chart: Pivot Table: Summarize Table: Totals didn't show up if you created a chart from the Summary View and switched the type to Pivot.
Chart: Pivot Table: Changing the font size didn't affect the column header text.
Note: Notes created with versions older than 9.0 couldn't be opened if they contained HTML tags.
Note: Hitting the Arrow Up key caused showing the parameter pane and it did not go away.
Note: If there was an HTML tag in a note, you couldn't click the text for the tag.
Note: If you selected multiple lines and clicked the code block button, those lines were concatenated to a single line without new lines.
Note: Loading a YouTube video was slow when reopening a note.
Note: It should prevent inserting a chart inside a bullet list.
Note: Copying text from an external browser resulted in pasting all text as one paragraph.
Note: When editing a large note, the UI became very slow.
Note: When you selected a bullet point with a break line and clicked the bullet point icon, the button did not work.
Parameter: Date parameters did not automatically update the default value even if the default value was set as max date.
Parameter: Min and ax Date were not dynamically updated.
Project: After closing a project, the sort order setting for data frames or reports was not remembered.
Project: If you opened and closed the chat window multiple times and clicked a URL link in the chat window, it opened the same URL in multiple browser tabs.
Released on 1/29/2024.
Data Wrangling: Supported the 'Remove Extra Spaces' option to 'Text Inside of…' Operation Type for 'Work with Text' and 'Change Column Names with Text Operation' steps.
Note: Now you can click the Quote button in the toolbar to switch between quote and normal text.
Note: Now you can click on the Bullet List button in the toolbar to switch between bullet list and normal text.
Note: If there is no header in a note, it automatically disable the Table of Contents option.
Note: Now you can enable or disable the "LaTeX Format" option for math formula text.
Summary View: Summary View showed info for the previous step if you created a calculation for multiple columns.
Data Wrangling: Column menu did not close after selecting an item in the menu.
Data Wrangling: Column menu did not close when clicking another column's menu.
Data Wrangling: When selecting a data frame, it showed an 'r.indexOf is not a function' error for some occasions.
Chart: If the Auto Margin option is enabled, it should ignore the margin value inputs.
Chart: Pie/Donut chart were not displayed at the center position in Dashboard.
Chart: If you clicked a chart in the chart full-screen view, the show detail dialog didn't show up.
Note: If you selected text and clicked the Code Block button, the selected text was removed.
Note: EDF export failed if the note was not previewed yet.
Note: When copying multiple lines of text from an external browser, only the first line became a bulleted list after clicking the Bullet List icon on the toolbar.
Note: If you choose the middle size option on a chart or image, it shouldn't overlap the Table of Contents area in the output.
Note: On a bullet list, if you typed "-" and hit the space key, it removed the line.
Note: Right after inserting an image, hitting the Enter key added a new line above the chart instead of the bottom of the chart even though the cursor position was right after the inserted chart.
Note: If you clicked a chart in the chart full-screen view, the show detail dialog didn't show up.
Note: Some of the charts on the note showed a "not found" message when reopening the note.
Note: Values displayed on a Pie Chart inside a note cut off at the top.
Note: When moving the cursor with the arrow keys, the movement was very slow if there was a lot of text in the note.
Note: When trying to convert copy-and-pasted text as a header, not only the first line but also all the text became a header.
Note: When copying and pasting text from an external browser, it was not fully copied when the text contained Markdown syntax special characters such as #.
Note: When you have more than one '$' symbols in a sentence it converted the text between the symbol to be LaTeX format.
Dashboard: Renaming the Page name didn't work if the dashboard has only a single page.
Dashboard: Pivot: If you clicked a Pivot Table cell including an inline bar for the filtering, the layout got corrupted.
Project: In some cases, opening a project on Windows failed with error code 127.
Project: Exporting a project failed with "line 1: syntax error: unexpected end of file" when the EPF filename contained a single quotation mark.
Released on 1/22/2024.
Project: When R was installed in a non-standard location, it failed to detect the R and showed an empty screen when opening a project.
Project: When Rserve failed to start, it should show a user-friendly message from where the user can reset R packages to the initial state.
General: On Mac platforms, attempting to log in to Exploratory Desktop resulted in a 'Security returned a non-successful error code: 44' error.
Released on 1/16/2024.
Data Source: Refreshing the stock data failed due to missing "quantmod" and "tidyquant" packages.
Data Wrangling: Create Calculation: Clicking the "Function List" link did not open the function list.
Data Wrangling: Deleting a data frame did not work on some occasions.
Chart: Bar: If you had negative values on the Stacked Bar and showed the total values on the plot, it showed incorrect values.
Chart: Date formatting was missing on the Y2 Axis tab in the Chart Property dialog.
Chart: It shouldn't create categories if you assign a numeric column with less than 200 unique values to the X-axis of the Bar chart.
Chart: Map: Bubble: Bucket colors didn't match the actual colors on the chart if you enabled the "Set 0 as Center" option.
Chart: Pivot: Subtotal layout was corrupted if you have unused factor levels on the Column Header.
Chart: Scatter: Chart failed to render if you enabled the "Show Labels on Plot" and Trend Line with the "All" target type.
Chart: Unique value check dialog should show up only if you assign a new column.
Note: After duplicating a note and updating the duplicated one, the updated content was saved to the original note.
Note: Clicking the "Keyboard Shortcut" button didn't open the Keyboard Shortcut dialog.
Note: Get back the "Export as Word Document" menu.
Note: Charts didn't show up in the exported Word document. Note that exporting Map and Word Cloud charts doesn't work properly yet.
Note: If there was an error in the R code, it shouldn't show an Error dialog but should show the error in the preview.
Note: If you added a chart, changed the size, and clicked the "Refresh" button, the chart size was reset.
Note: We should get back the Table of Contents (TOC) related properties in the Note property dialog.
Note: When you reopened the URL dialog and dragged it to a different place, an unnecessary scroll bar showed up.
Dashboard: Charts on a Dashboard did not get refreshed when the "Re-import Data" checkbox was checked.
Dashboard: After checking the "Auto Run" for the parameter, if you selected the parameter LOV items quickly, it showed an "Another R process" error.
Dashboard: Dashboard layout was corrupted if you published a dashboard right after changing the parameters.
Dashboard: It failed to capture thumbnails for some of the charts if you had a Map chart in the dashboard.
Dashboard: Note: It should remember the map position and zoom level if you update it.
Dashboard: Now it uses the new note editor for the Text widgets.
Dashboard: Previous dashboard filters remained after closing and opening the dashboard.
Dashboard: Publishing a dashboard failed if you clicked the Publish button in the Edit mode.
Parameter: When creating a Date or POSIXct parameter with the Between operator from the Filter Dialog, the created parameter was not available on the parameter list on the Filter dialog.
Project: After moving a repository to a new PC, a project using custom R packages did not open if the R package was not installed on the new PC.
Project: If you added a data frame in a project, closed the project, and searched the added data frame by the name in the Project List view, it didn't show the data frame.
Project: The "Updated" column on the Project List was not refreshed after closing a project.
Project: When clicking a project, the same project was opened with two windows at the same time on some occasions.
Released on 12/26/2023.
Chart: Map - Standard: Showing the detail data by clicking the map didn't work on the World Map with Area mode.
Chart: Map - Standard: When you changed the Map type from US State to World Map, showing the detail data by clicking the map didn't work.
Project: After renaming a project a project in a separate window, the Project List should reflect the change immediately without clicking the Refresh icon.
Project: After publishing/unpublishing a project in a separate window, the Project List should reflect the change immediately without clicking the Refresh icon.
Released on 12/22/2023.
Data Source: UTF-8 support on Windows was broken and Japanese characters were garbled for SQL Data Sources.
Data Wrangling: When opening multiple projects, moving between chart view and table view showed the "could not find function" error.
Chart: Bar chart failed to render if you created a Bubble chart with the Label and switched to the Bar chart.
Chart: Histogram: Show detail failed if you set a date column to color and choose the "Year and Month" grouping function.
Chart: Map: Circle marker for Russia should show up at Moscow.
Chart: Map: Some country names didn't show up in the hover pop-up.
Chart: Number: Pivot: Summarize Table: Table: Default text color should be configurable.
Chart: Updating parameters on the published chart failed if the chart was not pinned and the last step was disabled.
Note: Existing notes created on an older version didn't open properly.
Note: The note body width was not consistent between desktop and server.
Dashboard: Dashboard Filter didn't work properly if a column name contained braces.
Dashboard: Dashboard Filter should work even if the column is not assigned to the chart as long as the column exists in the pinned step.
Dashboard: If you closed a dashboard in Run mode and reopened it, it opened in Run mode with a blank screen.
Dashboard: If you click a slice of a Pie chart, the color palette of the Pie chart changes.
Project: After editing the project name in the project list and opening the project, the project name was still old.
Project: Project Information Dialog: Clicking the Update Button didn't work right after creating a project.
Released on 12/14/2023.
Data Source: Excel: When importing and merging multiple Excel Sheets by unchecking some of the columns, the "id" column disappeared.
Data Source: Google Sheets: Importing data failed with an error in curl::curl_fetch_memory(): ! Error in the HTTP2 framing layer for some occasions.
Data Source: JSON: It should remember the last selected node in the schema tree.
Data Source: Salesforce: Comma-separated values in a 'longtext' field were treated as numeric where they should be characters.
Data Source: Updating SQL Data Source failed with the "Cannot read properties of undefined (reading 'get')" error on some occasions.
Data Wrangling: Create Categories: The category label for the value outside the range was incorrect.
Data Wrangling: On Windows, a custom R Command failed with error code 127 for a long script.
Summary: Correlation Mode: When navigating between summary view and other view without exiting correlation mode, correlation mode UI shows incorrect result.
Chart: Bar chart showed "Invalid argument was passed to returnsNumericValue" if you assigned a numeric column to color, changed the bucket type, and unselected the column at Color.
Chart: During the SQL Data import, users could not operate in the chart view.
Chart: Pie: Under the Value tab in the Property dialog, if you set a Font Size and changed the Condition from "All" to "Range", the Font Size value was copied to the Threshold value.
Analytics: Confidence interval value was different between the Statistics tab and the Mean tab in the Wilcoxon Test.
Analytics: Prophet: Effects tab showed the "Error code 3" error if you assigned a column including single quote characters to the External Predictors or Repeat By.
Analytics: When you updated a step in the analytics view and ran analytics, the analytics did not reflect the updated data.
General: Windows: Screen flickered when going to full-screen mode
Publish: "Notify team members" option is not effective when you publish a chart to the team.
Project: After exporting a project with an EPF file, temporary data files remained in the project folder.
History: After deleting a data frame created with the "Save As New Data Frame" operation, you cannot restore it from Change History.
Released on 12/6/2023.
Released on 10/11/2023.
Data Source: S3: When clicking a source step, it did not open the Update Data Source dialog when the associated connection was not found.
Dashboard: Scheduling was not enabled when the dashboard was referencing Text Input data source.
Publish: Switching the Exploratory Server connection doesn't update the server connection when publishing contents.
Released on 10/05/2023.
Data Source: Unable to import data from Data Catalog when Exploratory Desktop was running inside the firewall with proxy server setup.
Data Source: CSV: When Separator Auto Detection fails, it should try with a comma ',' as a fallback.
Data Source: Presto/Treasure Data: It should automatically remove the trailing semicolon in the SQL query.
Data Source: Salesforce SQL: Clicking the Run button on the Source Step showed the Re-Authentication dialog where it shouldn't.
Data Source: Web Scrape: Updating Source Step did not refresh the Summary View and Table View.
Data Wrangling: Arrange (Sort): Clicking the Run button did not work when there was a step next to the Arrange step.
Data Wrangling: Create Categories: With the "Include Lower Edge" option, the incorrect inequality sign was used in the category name.
Data Wrangling: Create Categories: With the "Manual" method, setting "Label Text" ended up a blank preview.
Summary: Unnecessary HTML tags were shown on the Delete Row Filter confirmation dialog.
Chart: Bucket labels should show more meaningful text instead of operator signs. For example, "2000 or greater" instead of "2000 <=".
Chart: Color: If you created "Equal Width" buckets, set the # of buckets to more than 5, and chose the "Red / Light Blue" color palette, it repeated the 5-color palette.
Chart: Color: If you create "Equal Width" buckets on a numeric column and turn on the "Set 0 as Center", it should create buckets using the given data range and the center color of the palette should align with the bucket that contains 0.
Chart: Error dialog showed up with the "Cannot read properties of undefined (reading 'name')" error if you tried to show the detailed data on a Pivot Table.
Chart: Scatter: Error dialog showed up with the "Cannot read properties of undefined (reading '0')" error if you used Repeat By and set a Y-Axis column that contained sparse data to the Y2 axis.
Chart: "Same as the Chart Color" option at Show Values didn't work if you created categories on a numeric column at Color.
Analytics: Prophet: Error dialog showed up with the "Error code 127" error if you tried to save the chart data as a new data frame at the Forecasted tab.
Analytics: XGBoost: If you turned on the Test mode, the sum of the percentages in the Test group didn't become 100%.
Note: After applying a parameter, the viewer scrollbar went up to the top where it should stay at the current position.
Parameter: After changing a data frame selection for a dynamic parameter, other dynamic parameters also showed the changed data frame as the selected one even if you didn't change it.
Project: Unable to open a project with the Safe Mode (No User R Packages).
Project: When publishing a project, it showed 'ELOOP: too many symbolic links encountered error' for some occasions.
Released on 9/14/2023.
Released on 9/13/2023.
Data Source: SQL Data Import Job: Now you can cancel an SQL Data Import job when exiting a project or closing the App.
Data Source: FRED: Supported importing multiple Series at once.
Chart: Now if you open the chart property dialog, it opens the tab/subtab where you left off last time automatically.
Dashboard: Now you can enable/disable the font size auto scaling for Number charts from the Dashboard property dialog.
Data Source: After importing SQL data, it showed the 'There was a conflict with another R process' error.
Data Wrangling: Filter: Improved the Operator Names.
Data Wrangling: Replace Values with Condition: Token showed the internal column name for the "Selected Column".
Data Wrangling: Work with Text Data: When selecting the Question Mark as a separator, it did not work.
Summary View: If you create a chart from the Summary View, it should use the default blue color for the default color instead of light blue.
Chart: The "Always Include 0 in X/Y Axis" setting was ignored if you assigned a column to Repeat By and unchecked the "Sync X Axis" checkbox.
Chart: Description for the Shorten Numbers (Using K, M, etc.) setting was not clear.
Chart: Pie: Font size didn't change even if you set it.
Chart: The bottom part of the property dialog was chopped if you moved the dialog to the bottom and switched the tab.
Chart: Unexpected string like ".2f" showed up on the X-Axis if you set a Date column to X-Axis and set the Decimals explicitly.
Analytics: Analytics filter was not created for the first time and could not be updated after the filter was created.
Note: The style of the Table of Contents was inconsistent if you disabled the Floating Table of Contents.
Dashboard: After duplicating a page, not all the contents were shown.
Dashboard: If you inserted a Number chart in the very short row, the thumbnail looked too small to how it looked in the preview.
Dashboard: If you inserted a Number chart into a Number row, the thumbnail looked very small.
Dashboard: When running a dashboard that contains Analytics, underlying Analytics change was always recorded in history regardless of the change.
Publish: Data Share: If you publish a step with some English text in the title, the text should be used as a part of the URL but it didn't work.
Publish: Publish did not work for a source step if some of the required parameters were missing in the metadata file.
Project: It was slow after clicking the Close Project button on the Publish Confirmation Dialog.
Project: Project List: Selecting a project from the project list opened a different project.
History: After copying a project, the change history showed an empty entry and a 'Modified project.json' message which cannot be used for restoring.
History: Restore from history feature did not work if the git working branch name was other than master.
Released on 9/3/2023.
Data Source: SQL: Now it remembers the last used connection.
Data Wrangling: Fill NA With: Supported Fill NA with Today and Specific Date options.
Data Wrangling: Filter: Supported the Last N month/week/day from the last day of the data.
Data Wrangling: Join: Now it supports the option to exclude missing values in the join target data frame.
Data Wrangling: Make this row as column header: Supported the 'Re-Evaluate Data Types for All Columns' parameter.
Data Wrangling: Merge: Improved error message to indicate which target data frame the problem is coming from.
Data Wrangling: Now you can set the Decimals parameter for the Create Categories command.
Chart: Now you can move the chart property dialog by drag-and-drop.
Chart: Supported Color Thickness setting for the Axis Line.
Chart: Now you can select which of the Y-Axis columns to show values on the chart.
Chart: Supported various conditions (highlighted values, by the value range, min/max/first/last values) to limit the values to be shown on the chart.
Chart: Now you can show total values instead of each value on the chart for Stacked Bar and Area charts.
Chart: Now you can show values on the chart in the same color as the markers (bar, line, etc.) color.
Chart: Supported "Year-Month" option for the date aggregation level when a Date/POSIXct column is assigned.
Chart: Supported "yyyy/mm" and "yy/mm" date format types for the Axis label text.
Chart: Supported Angle option for the Axis label text.
Chart: Bar: Supported Sorting by the first group for the Stacked Bar chart.
Chart: Highlight: Now you can keep the original legend order even if you apply the highlight.
Chart: Supported Number Formatting for Histogram, Density, Boxplot, Violin Plot, Map.
Chart: Map: Now the map shows names in Japanese if the UI locale is in Japanese.
Chart: Pie: Now you can apply different decimal digit settings on values and percentages.
Chart: Pivot Table: Now you can hide the column header title.
Chart: Pivot Table: Now you can set the horizontal text alignment on the column header text.
Chart: Pivot Table: Summarize Table: Now you can apply the color formatting on Row to all the columns using the "Apply All Columns" option.
Chart: Pivot Table: Summarize Table: Now you can set the sort priority when assigning multiple columns to Row.
Chart: Heatmap should show all the factor levels even if it is not used.
Analytics: Variables with VIF greater than 10 should be highlighted in the Multicollinearity chart.
Analytics: K-Means Clustering: You can now choose to show the original values instead of the normalized values for Boxplot and Radar charts by setting the "Normalize Variable" option to FALSE.
Dashboard: Now you can make the row height much smaller for Text Input and for Number.
Publish: Publishing projects, charts, data, etc. now runs as a separated background process and does not block the user actions.
General: Improved the Cancel functionality to cancel only a minimum process without shutting down the entire R session.
Data Source: Azure Synapse: When querying against Azure Synapse, not all rows were imported.
Data Source: Google Analytics: After changing the property from GA3 to GA4, the property setting disappeared by clicking the Run button.
Data Source: ODBC (Legacy): When query against MS SQL Server, not all rows were imported.
Data Source: Salesforce SQL: If the query was invalid, it returned a connection error whereas it should have returned a SQL syntax error.
Data Source: When switching the data source from a parquet file to an Excel file, an unwanted ID column with the sheet name was added to the data frame.
Data Wrangling: Keep Duplicated Rows: Improved usability by incorporating the Multi-Select widget for column selection.
Data Wrangling: Merge: Improved the error message to show the data frame where the problem is coming from.
Chart: "Always Include 0 in X/Y Axis" setting was not effective if you used the Repeat By and unchecked the "Sync X Axis" checkbox.
Chart: Bar: Line: You should be able to edit the column name if you assign only one column to the Y-axis.
Chart: Boxplot: Unnecessary bottom padding showed up if you assigned a column to Repeat By.
Chart: Bubble chart failed to render due to "Invalid argument was passed to returnsNumericValue: "col is empty." error in some conditions.
Chart: The color assignment got screwed up if you created a chart from Summary View and updated it.
Chart: Decimal digit formatting didn't work in the hover popup of Boxplot and Violin Plot.
Chart: Highlight: Legend order became incorrect if you assigned the same color to multiple categories.
Chart: Line chart failed to render if you assigned columns to Y-Axis, Color, Repeat By, and unchecked the "Sync X Axis" option.
Chart: Pivot: Gradient color assignment didn't work if you assigned a categorical color palette to a numeric column on Value.
Chart: Table column order got messed up if you added a new column to the existing table.
Chart: Table: The target column of the URL Link was changed if you renamed or dropped a column used in the Table.
Chart: The "% Diffs from Prev" Window function with the "All" Group By setting didn't work as expected if you assigned a column to Color.
Chart: Values on the plot didn't follow the number formatting setting.
Analytics: K-Means Clustering: Column name "Observations" should be "PC2" in the exported data of the Biplot chart.
Analytics: Kruskal-Wallis Test: The formatting of the bucketed numbers was incorrect if you assigned a numeric column to the explanatory variables.
Note: Scroll position was not synced between editor and viewer in some cases.
Project: If you ran the search on the project list, it matched the deleted items in the project once in a while.
Project: Project List rendering was slow if you had many projects.
Released on 6/24/2023.
Data Source: Snowflake: Supported the Role parameter for Snowflake data connection.
Data Wrangling: Merge: Supported the 'Column Index as Column Name' option.
Data Source: Excel: Selecting a sheet whose name starts with a number ended up importing other sheets in the Excel file.
Data Source: Excel: Import and merge for all files in a folder failed if there was a temporary Excel file in the folder.
Data Source: Local Files: Import and Merge: Search Condition "Starts With" did not work.
Chart: Bar: Sort didn't work under some conditions on a Bar chart with the "% of" window calculation.
Analytics: Chi-Square: Show Cohen's W in the Summary tab.
Analytics: t-Test: Japanese translation is missing for some of the section titles in the property dialog.
Analytics: t-Test: Japanese translation is missing for the "Target Type 2 Error" column header in the Summary tab.
Dashboard: Note: Selecting the "Export Chart Data" menu on a chart in a published Dashboard/Note didn't start the data download.
Project: Exporting a project didn't work when there were unnecessary temporary files in the project folder.
Released on 6/12/2023.
Data Source: Excel: When a sheet name is a number, it raised a "Can't retrieve sheet in position" error and could not import the sheet.
Data Source: Windows: The 'Import and Merge' option did not work if the file name or folder name contained non-ASCII characters.
Summary View: Correlation mode: Blank screen showed up if you had more than 100 columns and applied the sorting.
Summary View: Correlation mode: Hover popup on the chart overflowed if you had long text data in a text column.
Data Wrangling: Replace Values with Condition: When you checked the 'Keep order as factor data type' and changed the new data type to numeric it showed unexpected NA in the result.
Data Wrangling: When parameters had a parent/child relationship, the child parameter values were filled with all the available options when it should just show the 'Select None'.
Chart: “Add/Edit Color Palette” menu didn't show up if there was no user palette defined yet.
Chart: Color Palette: The default color palette was ignored if you assigned a numeric column and chose the “As Discrete Numeric” function at the Color of Bar chart.
Chart: Other Group: Error dialog showed up if you selected the "Selected Values" for "Candidates for 'Others'" option and hit the "Apply" button without choosing values.
Chart: Pivot: Summarize Table: If you set it to show the function names on the header and changed the column width, function names disappeared.
Chart: The threshold value for the Show Values on Plot should take a ratio value instead of a percentage value if you showed values in percentage.
Chart: Pivot: Summarize Table: Condition values for the Conditional Color Formatting should take a ratio value instead of a percentage value if you showed values in percentage.
Chart: Pivot: Summarize Table: Numeric aggregation functions such as "Mean" should be available for the additional totals even if you use non-numeric columns to Values as long as those columns return numeric values such as "Unique Count" and "Data After Aggregation" is set.
Note: Pressing the escape key on the Note editor changed the mode from 'Side-by-Side' to 'Single View' and corrupted the layout.
General: Exploratory Desktop did not start up and hang when there were invalid connection files in the repository.
Released on 5/22/2023.
Summary View: Now you can click on the metrics and see the description.
Data Source: Supported Oracle as a Database Data Source.
Data Source: Moved the Weather and Stock Price data sources from the 'Extension' to build-in 'Cloud Apps' Data Sources.
Data Wrangling: Join: Support joining data frames based on conditions.
Data Wrangling: Filter: Support the 'Column' as filter target type.
Chart: You can set the default formatting setting such as font size, color palette, etc. from the System Settings dialog.
Chart: Supported Japanese help documents by clicking the help link.
Analytics: Added Two-Way ANOVA.
Analytics: You can run the Power Analysis for t-Test and Chi-Square Test.
Analytics: In the Summary tab, you can click on the metrics to see the metric description.
Analytics: Supported Japanese help documents by clicking the help link.
Note: Dashboard: Now you can add Button, YouTube, Tweet, and Rumble from the "+" button.
Note: Dashboard: Supported reordering Notes and Dashboards by Name or Updated Date at the left-hand side catalog tree.
Project: Collaboration: It shows what has been changed when publishing and importing the projects.
Project: Collaboration: You can import the published projects directly inside Exploratory Desktop.
Summary View: If you create a chart from the Summary View, it should use "Light Blue" as a default color.
Summary View: If you create a chart from the Correlation mode with the Prediction option, the created chart should show the Trend line.
Summary View: If you create a chart from the Character or Factor column, it should create a horizontal bar chart.
Data Source: Data Catalog: You can search data by 'Owned by Me', 'Owned by Team', and 'Shared With Me'.
Data Source: Now you can configure MS SQL Server ODBC Driver for the Collaboration Server.
Data Wrangling: Export to Google Sheets: Supported "Create as a new sheet inside spreadsheet" and "Append rows to an existing sheet" options.
Data Wrangling: Replace Values with New Values: Add a feature to convert to factor data type.
Data Wrangling: Replace Values with New Values: Supported the auto data type detection.
Data Wrangling: Window Calculation: Supported the Sort Column.
Data Wrangling: Summarize: Supported the % in conditional percentage.
Chart: Pivot: Summarize Table: Now you can show multiple Column Totals.
Chart: Radar: Now you can show values on the plot area. You can also change the tick step, grid line style, circle size, line width, line style, and fill opacity.
Chart: Radar: Now you can show reference lines on the Radar chart.
Analytics: Prophet: Now R-Squared value is available in the Summary tab.
Analytics: Now you can use a custom color palette for the Analytics chart.
Analytics: Added the Probability Distribution for Wilcoxon and Kruskal-Wallis Tests.
Analytics: Support Dunn's test for Kruskal-Wallis Test.
Note: Now you can hide the border of the Pivot, Summarize Table, and Table by specifying the border="none" attribute.
Note: Spell Checker: Updated the dictionary to minimize false alarms.
Dashboard: Note: If you change the "# of columns" setting on a chart on a dashboard or note, it should remember the setting.
Parameter: Added the 'Radio' and 'Checkbox' style for Logical data type case.
Parameter: Single Select LOV: Supported the 'Set all values when no value is selected' option.
Parameter: Multi Select LOV: Supported 'Return All' and 'Return Empty' options for the 'Set all values when no value is selected' case.
Parameter: Supported duplicating (copying) parameters.
Parameter: Changed it to sync the last selected parameter value between Note/Dashboard and other items (Chart/Analytics/Step).
Data Source: Excel: After selecting a different sheet inside an Excel file for the 'Import & Merge' operation, it was changed back to the first sheet.
Data Source: Excel: Sheet selection was not working properly when you import & merge several sheets and switched the data source.
Data Source: Exported JSON file should be formatted in a user-friendly way.
Summary View: When a custom R step did not return data, clicking the Summary Tab showed an Error Report Dialog.
Table View: If you had a "Group By" step with columns containing special characters, clicking on the "i" icon in the Table Header failed to retrieve the column metrics.
Data Wrangling: The summarize dialog did automatically not close when you selected a script on the left-hand side catalog tree.
Data Wrangling: Replace Values with Condition: The original column could not be specified as the default column when it was based on the Integer type column.
Data Wrangling: Convert to R command menu did not work.
Data Wrangling: Creating a Calculation based on multiple columns added the token in an existing step, but it should have created a new step instead.
Data Wrangling: When selecting a connection for the source step after importing the data source step, it raised an error.
Data Wrangling: Recode: If you renamed "." with something else it showed an error.
Chart: If you typed in a negative number value to the "Step" field in the Equal Step bucketing setting, the error dialog showed up.
Chart: Chart Table Column Selection Dialog: Fixed issue where unavailable columns could not be removed and an error was displayed in the table view upon closing the dialog.
Chart: Custom Color Palette: Color Picker dialog immediately closed when you clicked the Hex color code input field.
Chart: Color: If the logical condition expression was too long, it overflowed the dialog.
Chart: If you renamed "." with something else it showed an error.
Chart: Scatter: Labels on the plot area didn't match with the actual data if you assigned a column for Repeat By and unchecked the Sync X-Axis checkbox.
Chart: Pivot: Summarize Table: The number of decimal digits setting didn't apply for the numbers on the bucket labels like "< 0.63".
Dashboard: If there was only one row in a dashboard, you could not move charts inside the row by drag-and-drop.
Dashboard: In the Column Layout, if you dragged a chart and dropped it, the dropped chart was not selected.
Dashboard/Note: If you moved a Note / Dashboard under a folder while opening it with the separator window, it was moved out of the Folder after closing the Note / Dashboard.
Dashboard/Note: Changed the Spell Checker to be 'on' by default.
Parameter: When publishing contents with parameters, the parameter values were not set correctly.
General: Now it cleans up the temporary directory when Exploratory Desktop starts up.
Released on 3/7/2023.
Data Wrangling: When renaming a data frame and changing the Column Filter setting in Summary view, newly added data wrangling steps were sometimes deleted.
Data Wrangling: A step token was overridden with another step token when you click between steps too quickly.
Data Wrangling: When opening a Create Calculation dialog with the 'Extract Week Day' column menu, the default new column name was set as 'calculation_1' instead of the expected 'original column name_wday.
Chart: It showed unexpected "." between the 6th and 7th decimal digits on numbers on the X-Axis tick label if you assigned a numeric column on X-Axis with a bucketing option.
General: Creating a new project throws an error if you have installed git-secrets but not installed properly on your PC.
Released on 2/20/2023.
Released on 2/16/2023.
Data Source: PostgreSQL/Redshift: Supported SSL mode.
Chart: Bar: Improved the 'Show Value on Chart' by avodiing the text overlapping each other with 'Top', 'Middle', and 'Bottom' options.
Chart: Bar: Now you can set the Angle for the values shown on the Chart.
Chart: Now the "Quick Window Calculation" menu is available for Pivot and Summarize Table.
Chart: Now you can change the font style of the legend title text.
Chart: Pivot: Summarize Table: Table: Now you can control the default text for NA.
Data Wrangling: Column Header Menu: We have changed 'Convert to Numeric' to use 'as.numeric' function for Factor columns so that the Factor levels will become the numerical values as result.
Analytics: ANOVA summary table is re-formatted with Between-Group row and Within-Group row.
Data Source: Clicking the Refresh Excel Sheets icon did not work when multiple Excel files were selected.
Data Source: CSV: File List: Do not show hidden folders such as .DS_Store on the file list.
Data Source: CSV: When the "Auto Separator" detection failed, now it highlights the Separator input field with red color.
Data Source: Excel: Multi Sheets: Cannot type in the Search Sheet Input Field.
Data Source: GoogleAnalytics: When an account has both GA4 and UA profiles, it failed with the error 'http_403 User does not have sufficient permissions for this profile'.
Data Source: Google Drive: Excel: Import dialog did not show a list of sheets and could not import the file.
Data Source: If the Excel file was located in a folder with a name that contained multi-byte characters, an error occurred indicating that the file did not exist.
Data Source: SQL Import Dialog: When there were too many tables and views in the schema panel, Exploratory crashed.
Data Source: When some of the columns are not selected in the Excel Import Dialog, the column data type setting did not take in effect.
Data Wrangling: After updating a branch name, a step that had the branch still showed the old branch name.
Data Wrangling: Create Category: Made the "Include Lower Values" as the default for the "Edge Value Handling" option.
Data Wrangling: Long to Wide: Show the number of columns in the preview table of the dialog.
Data Wrangling: Long to Wide: When key and value columns are selected, show the preview data by default when opening the dialog.
Data Wrangling: Create Calculation: the "Create New" button was not shown in the Step.
Data Wrangling: Replace Values with Condition: The Reset button did not restore the original condition.
Data Wrangling: Select Columns: Now it keeps the column order when selecting or deleting columns.
Data Wrangling: Support the "Reset" button for 'Select Columns' and 'Reorder Columns' dialogs.
Data Wrangling: Updated the icon for the branch root so that it's much easier to understand that you can drag & drop the branch root to other steps.
Summary View: Row Filter: If you added a new "Equal To" condition, chose a character column, and clicked the value dropdown, the list of values didn't show up or the whole dialog suddenly closed once in a while.
Summary View: Row Filter: If you created the second condition. the value selected in the first condition still remained.
Chart: Density Plot: It failed to render and showed an error if you assigned a column with all NA values.
Chart: Pivot Table: Summarize Table: The chart control area became blank if you used SUM_IF (or similar functions) and changed the column in the condition to a different column.
Chart: Pivot: Summarize Table: Time-series window calculations should show up only if a Date column is set at the most detail level in the Row Header.
Chart: The "Sync Y1 & Y2 Scale at Zero" checkbox should be checked by default.
Chart: The "Include Lower Values" should be the default option for the "Edge Value Handling".
Chart: Y2 Axis scale became too big if you changed the legend position from the right to the top.
Analytics: T-Test, Wilcoxon Test: When groups were separated by TRUE and FALSE, the group for TRUE was treated as the base. We have changed this behavior so that FALSE is now the base level, which should be more intuitive.
Note/Dashboard: Chart Selection Dialog: The data frames were not sorted correctly.
Project: When duplicating a project, the duplicated project should come to the top.
Released on 1/24/2023.
Data Wrangling: Now it shows the translated function reference when the UI locale is Japanese.
Chart: Bar: Now you can add a gap between bars from the chart property dialog.
Data Source: Excel: Improved multiple Excel sheets handling on Excel Import dialog.
Data Source: Opening an existing Excel Sheets Data Source failed with TypeError: Cannot read properties of undefined (reading 'length').
Data Source: Salesforce: When the Bulk Import checkbox is checked and there was new line feeds in an SOQL, it showed an incorrect object permission error.
Data Source: Presto / Treasure Data: BIG INT data type was treated as an integer after the 6.12.0 upgrade.
Data Wrangling: Text Wrangling: Improved the 'custom' menu for the specified text for the Japanese UI locale.
Data Wrangling: Text Wrangling: Improved the 'Include Specified Characters' menu for the specified text for the Japanese UI locale.
Summary View: The label '(Others)' should be translated on a histogram chart of a category column.
Chart: Bar chart failed due to "forcats::fct_reorder(): ! Arguments in ... must be used." error if you had a data frame with 1 row for each category, assigned the category column to X-axis and Color, assigned a numeric column with Standard Deviation (SD) for Y-axis, and set the Top 10 Limit on Color.
General: Error report dialog with message "dagops.members: dataframe does not exist in the catalog" appears when deleting a branch under certain rare conditions.
General: Error dialog with the message "Failed to validate the installed R packages" keeps appearing at starting up on Windows.
Installation: When a user profile metadata file was broken, Exploratory Desktop didn't start up.
Project: It should not allow clicking the project sync button multiple times in the middle of the project update.
Released on 1/14/2023.
Data Source: On Mac, importing data from MariaDB / MySQL failed after upgrading to 6.12.0
Data Source: Twitter Data Source: screen_name column was not included in the query result.
Table View: Row Filter doesn't apply if you select a data frame, open the Table View, close and open the project, select the same data frame and create a new Row Filter.
Table View: NA showed up for the standard deviation all the time in the column metrics popup.
Project: On Mac, clicking the project information icon didn't work after upgrading to 6.12.0
Released on 1/12/2023.
Analytics: Factor Analysis: Inter-factor correlation is now shown if an oblique rotation is used.
Analytics: K-means: The new density plot view that displays the distribution of feature values for each cluster is added.
Analytics: T-test for already aggregated data is added as a new Analytics View.
Analytics: Topic models with pre-tokenized text data is added as a new Analytics View.
Analytics: Likert's sigma is now available as a pre-processing function for Analytics View. It is useful to normalize scale data in surveys, such as 5-point scales.
Chart: Now you can add a title to the chart legend.
Chart: Now you can synchronize Y1 and Y2 scale at zero from the "Y1/Y2 Assignment" menu.
Chart: Now you can treat the hms data as numeric values.
Chart: Number: Now you can assign a color by conditions.
Chart: Pie: Now you can edit the center text of the Ring chart.
Chart: Pivot: Summarize Table: Now you can add colors to the inline bars by conditions.
Chart: Pivot: Summarize Table: Now you can apply the Color Assignment to all columns by the "Apply all columns" option.
Chart: Pivot: Summarize Table: Now you can click the total values to show the detailed data.
Chart: Radar: Now you can set the legend direction from the Color, Groups & Sort Setting dialog.
Chart: Trend line: Now you can show the trend line metrics (R-squared and Coefficient) on the plot area for the Linear Regression trend lines.
Dashboard: When editing a dashboard, now you can reorder rows and columns by drag and drop.
Data Source: Excel: Now you can Import multiple excel sheets as separate data frames or a merged data frame.
Data Source: Now you can import data file such as JSON by drag and drop.
Data Source: Supported GCS (Google Cloud Storage) as a data source.
General: Now UTF-8 support on Windows is available without modifying Windows configuration.
Data Wrangling: Case When, Recode, Bin, and Text Wrangling: Now you can add a new column right after the current column.
Data Wrangling: Join Dialog: Now it shows the NA Bar on the preview table column header.
Data Wrangling: Mutate: Now it highlight newly created column on Summary View and Table View.
Data Wrangling: Reorder Columns: Now you can move multiple columns to the top or bottom on the dialog.
Data Wrangling: Reorder Columns: Now you can reorder multiple columns by drag and drop.
Data Wrangling: Summarize: Supported aggregation functions such mean and sum for hms type data.
Data Wrangling: Supported URL encode and decode on the Text Wrangling UI
Project: Now you can import a project file (epf) file by drag and drop.
Summary View: Now it shows the "# of NAs" bar for each column in the Correlation mode.
Summary View: Now you can filter columns by conditions from the "Column" button on the toolbar.
Summary View: Now you can filter the data by conditions from the "Row" button on the toolbar.
Table View: Now you can filter columns by conditions from the "Column" button on the toolbar.
Table View: Now you can view the column metrics by clicking the 'i' icon in the table header.
Analytics: Changing a base level for a character predictor column didn't work.
Analytics: K-means: Preview table kept showing original column value even if a column function was set for the column.
Analytics: K-Means: The number of rows excluded because of NAs is now shown on the Summary tab.
Analytics: T-Test: If you ran the T-Test Analytics twice, the Error Bar showed a different output.
Chart: "Equal Step" category setting did not allow setting labels.
Chart: Analytics: Performance improvement for a data frame with many columns.
Chart: Area: Chart legend didn't show if you assigned a column that has only 1 unique value to Color.
Chart: Bar chart showed weird object on the Y-axis tick area if you set "0" for the "Axis Tick Step".
Chart: Categories created on X-Axis by the "Equal Step" didn't respect the decimal digit setting for the X-Axis.
Chart: Density Plot: The label "Density" should be translated in the hover Popup.
Chart: Error Bar: If you created an Error Bar, switched the chart type to Error Bar (Summarized Data) and selected the Error Bar again, the Ratio By option became "All". This option should stay as "X-Axis".
Chart: If you selected the IQR aggregation function, the IQR output was multiplied by 1.5.
Chart: Map LongLat: Show Detail didn't work once in a while if you set the "Row ID" column to Group By.
Chart: Sort: The order when sorting is wrong when using a window calculation as a percent of the total.
Dashboard: Japanese characters were garbled if you opened a chart data CSV file exported from the Dashboard by double-clicking the file on the File Explorer.
Dashboard: Publishing failed with an error "RangeError [ERR_BUFFER_OUT_OF_BOUNDS]: Attempt to write outside buffer bounds” if you have many charts in a dashboard.
Data Source: CSV: List of files dialog didn't show any files when the directory contained a dead symbolic link.
Data Source: Excel: Could not override column data type when there are more than 100 columns.
Data Source: Google Drive: Importing multiple CSV files from Shared With Me by selecting file names didn't work.
Data Source: Local Files: Supported folder navigation by clicking the parent folder button like Cloud Storage Files.
Data Source: Salesforce: When a column data was empty, the query result didn't include the column.
Data Source: Snowflake: Warehouse was not properly set on the session and "57P03: No active warehouse selected in the current session" error was raised.
Data Wrangling: After copying a data frame with a branch that has a join step pointing to another branch in the same data frame, it showed an error message that tells that the target data frame does not exist wrongly.
Data Wrangling: Column Reorder: Added the clear selection button on the column selection area.
Data Wrangling: Create Categories: Supported "Edge Value Handling" and other parameters for category settings.
Data Wrangling: Create Categories: Unchecking the 'Save Factor Order' checkbox still created a column with Factor data type.
Data Wrangling: Excel Export: Changed the default date format to yyyy/mm/dd and now it remembers the previously selected date format.
Data Wrangling: Extract Alphabet: The conversion result should be character data type instead of List data type.
Data Wrangling: Factor values in the Recode dialog were not sorted properly.
Data Wrangling: If you had many columns (e.g. more than 5000 columns) in a data frame, UI operation such as column selection became very slow.
Data Wrangling: Long to Wide: Now it shows prereview results on the Dialog.
Data Wrangling: Make this rows as column header: Clean Column Names option did not preserve non-ASCII name column name.
Data Wrangling: Merge / Union: When a data frame used for merge was renamed, you could not remove the renamed data frame from the data frame list.
Data Wrangling: Merge/Union: "Select all" was not working when you searched data frames.
Data Wrangling: Mutate: After running a command, the table view scroll position should remain.
Data Wrangling: Now it uses pivot_longer R function instead of gather and pivot_wider R function instead of spread.
Data Wrangling: Orphan branch remained on the UI and it shows dagops.members: dataframe abc does not exist in the catalog error.
Data Wrangling: Pivot: It showed Error: Data from the previous step is empty when there was no record in the data frame.
Data Wrangling: Recode: When column name was changed in the previous step, one could not remove the column selection.
Data Wrangling: Removing a step cache didn't update the Chart.
Data Wrangling: Text Wrangling: Remove punctuation did not remove symbols such as $
Data Wrangling: Under certain conditions, the same branch was repeatedly displayed in the left-hand-side dataframe tree pane.
Data Wrangling: When exporting large numeric value to a CSV file with Shift-JIS encoding, the value was exported with scientific notation.
Export: Exporting a wider data frame (tens of thousands of columns by tens of rows) hanged.
Installation: If you try to install an invalid R package from CRAN, it showed the network error dialog.
Parameter: LOV parameter was not updated in the dashboard when there was a dependency between the parameters.
Parameter: When a data frame that provides a list of values for a parameter was exported and imported via EDF file, its name turned into a randomly generated string.
Publish: After publishing a Cloud Storage CSV data, override data type set for columns were not honored, and it caused a data type mismatch error in a Join step that uses the column.
Publish: Error message improvement for exceeding the storage size limit at publishing.
Publish: Publishing data failed with "s.getSummary(...).concat is not a function" if you tried to publish the model step.
Publish: When there was a missing Data Frame reference for a parameter, it didn't show a user-friendly error message.
Summary View: CSV data exported from the Summary View was corrupted if column names contained certain special characters such as commas or double quotes.
Summary View: If a data frame had a column with many unique text values, the Summary View took a very long time to show.
Summary View: Performance improvement for a data frame with many columns.
Released on 11/16/2022.
Data Source: Excel: Could not override column data types when there were more than 100 columns on the Excel file.
Data Wrangling: Replace Values with Condition: When changing the default type to the Column, it did not automatically set the Target Column as the selected column.
Data Wrangling: Replace Values with New Values: When the selected column was removed in the previous step, one could not remove the column from the selected columns.
Data Wrangling: When there was an update in the parent branch, cached steps in the child branches did not turn yellow to show that they turned into stale caches as expected.
Chart: When a stale cache of a step was removed, the Chart displayed at that time was not redrawn as expected.
Chart: If you selected IQR for the column aggregation function, it returned 1.5*IQR values. Values shouldn't be multiplied by 1.5.
Dashboard: Improved the Delete Row confirmation message.
Dashboard: Japanese characters were garbled on Excel if you exported a chart data CSV file from a Dashboard on the desktop and opened it by double-clicking it.
Public: A project was not removed when canceling 'project publish' at the closing time for the first time.
Upgrade: If you upgraded to recent versions of Exploratory, and your home directory name has space characters in it, you might need to move the repository (.exploratory under the home directory) to another path that does not have space characters in its name. We improved the handling of this case so that how to move your repository to a path that works with the latest Exploratory is clear.
Released on 11/9/2022.
Chart: Area: If numeric or Date data for X-Axis were all NA for a specific color category, the category showed up as the largest category in the legend. It shouldn't show up in the legend.
Chart: Equal Step category didn't honor the decimal digit setting in the chart property dialog.
Chart: If you assigned multiple columns to Y-Axis, assigned Y2 Axis on the 2nd Y-Axis column, and selected the "Middle" to the Show Value on Plot option, an error dialog showed up.
Chart: The order of the colors was incorrect on the Color, Group & Sort dialog if you selected the "Logical Condition" for the Grouping Type.
Data Source: Google Analytics: Query failed with Error : API Data failed to parse when importing G4 data.
Data Source: Google Drive: When trying to import & merge Excel files under a shared folder, it showed no files match error.
Data Wrangling: Filter: For Date and POSIXct columns, the combination of 'year and month' type and the 'Is In (Multiple Values)' operator did not work as explained in the placeholder syntax.
Data Wrangling: Join: Made the green link for target columns easier to click.
Data Wrangling: Layout was corrupted after showing a very long column name on column selector.
Data Wrangling: Limited the max number of items displayed for a LOV from 5000 to 1000 to improve usability.
Data Wrangling: Multi-Select widget: Selected items should not move to the top when a user is in the middle of selecting but show them at the top when the dialog is reopened.
Data Wrangling: Same branch was repeatedly displayed in the left-hand-side data frame tree pane after editing a custom R step.
Data Wrangling: When exporting step data to a file, the default file name contained incorrect index number.
Installation: Windows: Now the default value for the 'Use Windows System Encoding' is changed back to 'Yes'.
Installation: Error "Failed to validate the installed R packages" was shown when the repository path included space characters. Now, Exploratory will ask you to use a repository path that does not have spaces in it.
Note: We have made the width of the text area a bit wider to make it easier to read.
Summary View: The hover popup on the histogram got too wide if the text was long.
General: Error "Cannot read properties of null (reading 'name')" at opening a project when the proxy server rejects the connection.
General: Proxy: Added a validation to prevent * is set at the beginning of proxy whitelist.
Released on 10/18/2022.
Data Source: Supported the "Additional Parameters" for MS SQL Server / Azure SQL and Snowflake data connections.
Data Wrangling: Replace Values with Condition: Now you can disable a condition row.
Data Wrangling: Replace Values with Condition: Now you can reorder a condition token by drag and drop.
Data Wrangling: Replace Values with Condition: Now you can reserve the order of new values and set the data type as Factor.
Data Wrangling: Replace Values with Condition: Supported the Reset button.
Data Wrangling: Replace Values with Condition: When a new value was not set, clicking the Run button showed the error popup for deleting a whole step.
Data Wrangling: Replace Values with Condition: When the new value data type is changed, now it is set to the previously set value for the data type.
Data Wrangling: Window Calculation: Now it sets Date as the default unit for Date columns calculation and hour for POSIXct columns calculation.
Chart: Now you can configure the color sort on Line, Bar (Grouped), Scatter (With Aggregation), and Error Bar chart types.
Chart: Now you can hide the unused factor levels from the "Show Unused levels" setting on Scatter chart types.
Chart: Trend Line: Now you can draw one trend line per chart even if you set a column to Color by setting the "All" Target option in the Trend Line setting dialog on Line and Scatter (With Aggregation) chart types.
Data Wrangling: An error report dialog with the following error message came up while adding a new step in some cases. "belongsTo attribute to set to the inserted step does not match with the step that would be the next step of the inserted step".
Data Wrangling: In the English UI language, the Radio Button Label overflowed for Predict With Model Dialog.
Data Wrangling: Replace Values with Condition: Changed the default new value data type as a character.
Data Wrangling: Replace Values with Condition: When selecting multiple columns for target columns, a condition should use "selected columns" for column assignment by default.
Data Wrangling: Replace Values with New Values: Multi-column selection with Shift key was not working when the Replace Values with New Values Dialog was opened with only one column.
Chart: Color: If you choose the "Y-Axis Values" for the Sort By and "Bottom to Top" for the Direction in the Color setting dialog, the "Others" group should show up at the top on a Bar (Stacked) and Area chart types.
Chart: Color Dialog didn't open if you assigned a numeric column to Color with the "As Discrete Numeric" function and set the "Row ID" column to Group By on Map Long/Lat.
Chart: Color Dialog: The Sort dropdown should be separated into the Direction and Sort By dropdowns.
Chart: Summarize Table failed to render due to the “Invalid argument was passed to returnsNumericValue” error.
Chart: Color: The default color direction setting for a logical column should be "Bottom to Top".
Analytics: Random Forest, XGBoost, Linear/Logistic regression, etc.: If the "Reserve Order in Data" option was selected, but the training/test split itself was off, the single last row was still split into the test data set.
Dashboard: After changing a multi-select parameter widget style, the "Show Details" dialog errored out.
Dashboard: If you hover over the page tab, it should show the Popup only when the page name is long.
Note: When opening a Note after running a Dashboard, the Run button was displayed in the incorrect position.
Publish: The spin icon did not go away when opening a publish dialog for data sharing.
Installation: Supported timeout for the installation dialog for R and Git.
Released on 10/5/2022.
Chart: Now you can a legend for the Trend Line with the "All" Target option in the Scatter (No Aggregation) chart.
General: Now you can configure Data Format for Exporting to Clipboard.
Analytics: Topic Model: Documents on the Documents tab are now sorted so that documents relevant to the same topic are shown close to each other.
Analytics: Factor Analysis: Variables on the Weight (Bar) tab are now sorted so that variables that are affected by the same factor are shown close to each other.
Data Source: CSV: Importing file ends up with The size of the connection buffer was not large enough error.
Data Wrangling: Replace Values with Conditions: Drag and drop reordering for conditions did not work.
Data Wrangling: Copying a folder didn't copy chart thumbnails on the nested branches.
Data Wrangling: On a source step label, it showed an internal attribute for the Parquet data source.
Data Wrangling: Filter: When changing a column selection, the selected parameter didn't stay even though the column data type was the same as before.
Data Wrangling: Filter: When re-opening the Filter dialog, it did not populate the multi-selection widget with available options.
Data Wrangling: Merge: The data frame list didn't show selected data frames at the top.
Data Wrangling: Summarize: "1st" function is not working when you select "All Numeric Columns" as the value.
Data Wrangling: Window Calculation: When clicking the green text for a value column, it did not open the Edit Dialog when the mouse hovered at the bottom of the text.
Chart: Highlight: "Highlighted: 1 Value" showed up even though there were 2 highlighted values if you clicked the "Apply" button without clearing the table search in the Color and Group dialog.
Chart: Bar chart failed to render if you assigned a logical column to Color and added a logical condition.
Chart: Duplicate Project dialog showed up if you duplicate a note and selected the "Edit Custom Color Palette" menu from the Color Palette dropdown in Color and Group Setting dialog.
Chart: Table: Color formatting didn't work correctly on numeric columns that used to be character columns.
Chart: Table: Table failed to render due to a "non-numeric argument to binary operator" error if you assigned a numeric column with "%" formatting to the table and the column data type was converted to character.
Analytics: Topic Model: In the Documents tab, the colors of the tagged words were wrong.
Dashboard: The "more" icon on a row was cut off when the row height was the minimum height.
Publish: When publishing an insight as a team failed because the team owner's account is no longer a Business account, It didn't show a correct error message .
Parameter: Made the multi-selector widget height static instead of dynamically changing it.
Import: Importing a project failed with a "Bad archive" error.
Project Export: Stopped performing unnecessary R restart when canceling a project export.
General: The 'Use Legacy Window System Encoding' option was not saved and cleared after restarting App.
Released on 9/27/2022.
Table View: Now you can configure how to show the invisible characters such as spaces, tabs, etc, from the Property dialog.
Table View: Now you can configure the number formatting from the Property dialog.
Table View: Now you can show the NA ratio bars at the column header. You can configure it from the Property dialog.
Data Wrangling: Data Frame Merge: Supported selecting multiple data frames by checking checkboxes on the data frame list.
Data Wrangling: Filter: Now you can select multiple values more easily for the 'Is In' and 'Is Not In' operations.
Data Wrangling: Filter: Supported the Multiple Values option for the 'Starts With', 'Ends With', and 'Contains' operators.
Data Wrangling: Join: Now you can select which columns to keep from the join target data frame.
Data Wrangling: Now you can create branches on multiple levels.
Data Wrangling: Now you can replace values at once for multiple columns.
Data Wrangling: Replace Values with Condition: Redesigned the dialog to Support Re-order, Multiple Conditions, and Text Input. - Multiple Condition support
Data Wrangling: Text Wrangling: Now it automatically converts column data type to numeric for the Kansuji /numbers option.
Chart: Highlight: Now you can use the "Show as ‘Others’ for not highlighted values." option to improve the chart drawing performance in Scatter and Bubble chart types.
Chart: Now you can set the legend order and value order separately for Area and Bar (Stacked) chart types from the Color & Group Setting dialog.
Chart: Now you can show a single trend line for all the data even if you assign a column to Color by the "One Line Per Chart" Trend Line option in the Scatter chart.
Chart: Now you can show the detailed data by clicking the chart on Pivot, Summarize Table, Map (Standard), Map (Extension), and Map (Long/Lat) chart types.
Chart: Now you can use "Previous Value", "Next Value" and "Period Ago" Window Calculations.
Chart: Now you can use the "Middle" option in the "Show Value on Plot" property on Bar, Error Bar, and Error Bar (Summarized Data) chart types.
Chart: Now you can use the horizontal orientation on Boxplot and Violin chart types.
Chart: Now you can use the Limit feature in Pivot and Summarize Table.
Chart: Pivot: Summarize Table: Now you can configure the visibility of the popup on hover from the Property dialog.
Analytics: Cox Regression / Survival Forest: Now you can predict the survival rate of new observations on a specific date or the date when the predicted survival rate drops to a specific value.
Analytics: Factor Analysis: Now the table of weights is sorted so that the variables that consist of similar factors are shown close to each other.
Analytics: Topic Model: Now the topic ID numbers are assigned based on the number of documents the topic has. In other words, the most popular topic gets presented as topic 1, the second popular topic as topic 2, and so on.
Dashboard: Note: Now you can show the detailed data by clicking charts.
Dashboard: Note: Now you can use the "Export Chart Data" and "Export Chart Image" options for charts and analytics on the Desktop.
Dashboard: Now you can edit a text panel on a Dashboard with the markdown editor.
Dashboard: Supported the 'Add Chart' buttons to each row and column.
Parameter: Improved parameter value selection experience by introducing a new pulldown and list widget for single and multi List of Values.
Data Source: Data Catalog: The Data Catalog list was not sorted by updated date.
Data Source: Google Analytics: Improved the query performance for getting profile information from Google.
Data Source: Selecting a nested data frame showed the "invalid subscript type list" error in the JSON import dialog.
Data Wrangling: Added 'With Condition' option for the create calculation multi-column menu.
Data Wrangling: Adding a suffix did not work in the Join dialog when you set it for only one side.
Data Wrangling: After saving a step with POSIXct columns as a data frame, reopening the data frame caused the columns to become character columns.
Data Wrangling: Clicking the OK button in the "Select (Remove) Columns" dialog didn't respond.
Data Wrangling: Filter Dialog: The Command + Enter shortcut key didn't execute the command for a custom condition.
Data Wrangling: Reorganized the Math Functions in the Column Header Menu.
Data Wrangling: Replace Values with New Values: When searching values, it showed values that did not match with the search text.
Data Wrangling: Summarize: When assigning the same date columns multiple times to group by, the second and subsequent columns aggregated the value of the first date column which was already aggregated.
Data Wrangling: Summarize: When opening a column name edit popup on the Summarize Dialog, it showed a different column name.
Chart: Color Dialog: If you edited the custom palette that was used for the chart, the chart wasn't updated immediately.
Chart: Color: Long category names were cut off in the Color & Group Setting dialog.
Chart: Column assignments got screwed up after dragging and dropping Value columns in Radar chart.
Chart: If you exported the chart data to Google Sheets, a "null" text showed up in the empty cells.
Chart: If you have multiple columns assigned to Y-Axis and removed the 1st one, the 2nd column moved up to the 1st position but the Window Calculation setting on the 2nd column didn't follow the column move.
Chart: If you selected the "(Row ID)" column to the Group By, the show detail dialog showed all the data in Scatter (with Aggregation) chart.
Chart: Pivot: Summarize Table: Colors on categorical values should respect the factor/text order.
Chart: Pivot: Summarize Table: It didn't remember the last decision of the "Apply All" checkbox if you reopened the Formatting dialog.
Chart: Radar: Increase the default margin size between Radar charts in order to avoid label text overlapping and incorrect chart alignment.
Chart: Table: A long URL text was cut in the middle even if you set the text wrap option.
Chart: The "Others" group should show up at the end of the categories.
Chart: The Equal Step grouping type didn't include the lowest value if you set the "Include Upper Edge" and didn't set the Lower Range value.
Chart: The popup position was off if the chart used the Repeat By.
Chart: The position of the Quick Window Function submenu was off on the Area chart.
Analytics: Changing the analytics type from the "Word Count" to the "Topic Model" reset the selected dictionaries.
Analytics: Chisq: Pivot table showed % values based on the whole table as opposed to each column.
Analytics: Clicking the Pin icon in the Analytics view failed due to the "cannot read properties of undefined (reading 'deps')" error.
Dashboard: After opening a Dashboard, opening another note showed the Run button in the incorrect position.
Dashboard: Chart didn't reflect the parameter change if you showed a chart in the full-screen mode after changing parameters.
Dashboard: Chart didn't show the correct color for the "Others" if you set a custom color for the "Others".
Dashboard: The dashboard layout got corrupted if the page name contained special characters such as braces, curly braces, and underscores.
Dashboard: Desktop suddenly terminated without any notice while publishing a large dashboard.
Dashboard: If you extract a zip file created by the HTML export, the folder name should be based on the Dashboard name.
Dashboard: Japanese characters were garbled if you opened a chart data CSV file exported from the Dashboard on Excel.
Dashboard: When editing a chart title and number title, the dialog was closed by accidentally clicking outside of the dialog.
Dashboard: You should be able to update the parameter even if the Dashboard preview fails.
Note: If the chart had no data to show, it showed the "There is no data to display." message with an unnecessary vertical scroll bar.
Publish: Publish Dialog should show up after 15 sec if a connection is timed out.
Export: When exporting and importing a project, Folders in the projects were opened on some occasions.
General: The corner of the splash screen was missing at the application startup.
General: There were cases where opening a data frame hung at reading the internal data cache parquet file on Windows.
Installation: R package installation from CRAN through a password-protected proxy did not work.
Released on 8/17/2022.
Released on 7/26/2022.
Released on 7/15/2022.
General: Certified with R 4.2.1.
Chart: Color & Group Setting dialog: Now you can open the custom palette dialog from the "Edit Custom Palette" menu in the color palette dropdown.
Chart: Color & Group Setting dialog: Now you can configure which edge to include in groups from the "Edge Value Handling" option in the "Manual", "Equal Width" and "Equal Freq" Grouping Types.
Chart: Pivot: Summarize Table: Table: Now you can change the column width for all the columns at once by checking the "Apply All Columns" checkbox at the Cell Width setting.
Dashboard: Note: Now you can download data and images for each chart in the published Note and Dashboard.
Dashboard: Now you can show/hide the title of the content area from the property dialog.
Export: Now it remembers the output directory that you chose last time.
Data Source: MS Access: After closing the Exploratory Desktop, the lock file was not removed.
Data Source: AWS Athena: Supported HTTP proxy.
Data Source: RODBC data source failed to load due to the invalid UTF-8 characters in character data.
Table View: Summary View: Inf/-Inf values in Date/POSIXct columns were treated as NA in the Table and Summary View.
Data Wrangling: After duplicating a data frame, the toolbar and data frame list showed the source data frame name where it should show the new data frame name.
Data Wrangling: Importing a .df (data frame) file by drag and drop didn't work if there was a data frame name conflict.
Data Wrangling: Window Calculation / Pivot / Summarize: Improved the column selector widget usability on the dialogs.
Data Wrangling: The support of @{} parameter notation was missing in the custom calculation editor for mutate steps on multiple columns.
Data Wrangling: Pivot: When a character column was selected for value along with an aggregation function that returns a numeric value, it raised the 'cannot convert' error.
Chart: The "Show Detail" option in the popup failed and showed the "Error Code 127" error if you had a Bar chart with a logical column at X-axis and edited the display names of the values on the X-axis.
Chart: The Show Detail showed no rows if you had a Line chart, a Date column at X-axis and chose the "RAW" function for the Date column.
Analytics: When running the K-means in a step, you could not exclude character columns with the "Exclude Columns" option.
Note: Number charts didn't show up on an exported Word Doc.
Dashboard: Supported adding a row/column even when the dashboard is blank.
Dashboard: The text edit dialog should not close when clicking outside of the dialog.
Dashboard: The title of the contents area got collapsed if you set an empty text for the title.
Dashboard: When there was only one row, the 'Add Chart' button was not visible after deleting a chart from the only row.
Parameter: When changing a parameter data type, no longer needed drop-down options should be removed from a metadata file.
Collaboration: Project update failed if your home directory name had space characters.
Export: Now, the original local data files such as CSV or Excel files are included in exported/published .df files or .edf files.
General: Couldn't connect to a collaboration server when you set a proxy on the Exploratory desktop.
General: Couldn't open a project if a git lock file existed.
General: Windows: Screen was frozen and didn't respond on some occasions.
Installation: Now it removes old, not used R package folders from an Exploratory repository.
Installation: Resetting R packages on M1 Mac raised an error.
Released on 6/30/2022.
Released on 6/20/2022.
Released on 6/15/2022.
Data Source: Improved the error message when importing an excel file locked with a password.
Summary View: After switching a column for Correlation, it sometimes showed the "another R process running" error.
Summary View: Error "Cannot read properties of null (reading 'map')" was raised from mutate steps on a rare occasion.
Chart: Bar: If the custom calculation was used for the Y-axis, limiting the number of bars by the current Y-axis values didn't show the expected result.
Chart: The "Show Detail" dialog failed and showed an error if a numeric column was assigned to Color and the "Equal Step" Grouping Type was selected without an explicit Step value.
Export: When a chart or an analytics in a branch was exported, the branch name became a random string name instead of the original name when it was imported.
Project: If you search inside the project, the currently selected data frame should always show even if it doesn't match.
Project: Searching the project using special characters such as "(" didn't work.
Released on 6/12/2022.
Data Source: CSV: Now it automatically guesses an appropriate delimiter for the data files.
Data Source: CSV: Now it supports importing UTF-16 encoded files.
Data Source: Added a new Text Input Data type, with which you can manually enter delimited text data.
Data Wrangling: Added the 'Preview' button for Summarize, Window Calculation, and Pivot Dialog.
Data Wrangling: Separate: Supported the 'Regular Expression' mode for the custom separator.
Data Wrangling: Summarize: Supported 'ratio' version for count_if/sum_if function family.
Data Wrangling: Text Wrangling: Added the 'Regular Expression' and 'Character' options for the 'String before/after the specified text' cases.
Data Wrangling: Text Wrangling: Supported 'Letters (Alphabet & others)', 'Alphanumeric', and 'Letters and Numbers' options for remove, replace, and extract operations.
Data Wrangling: US State Conversion: Now it removes space and symbols from the data before the conversion.
Chart: Now you can set the target value range in the "Equal Width" bucketing option.
Chart: Now you can use the "Equal Step" bucketing option for creating buckets.
Chart: Now you can use the conditional aggregation functions such as "SUM_IF", and "COUNT_IF".
Chart: Pivot/Summarize Table: Now you can select 'Visual Formatting' from the menu to quickly format the cell.
Chart: The Custom Color Palette dialog should be accessible from the Project menu.
Analytics: Word Count/Topic Model: Now you can create your own dictionaries for Stop Words and Compound Words for Text Analysis.
Analytics: Word Count/Topic Model: You can publish and share Stop Words / Compound Words dictionaries.
Dashboard: Note: Now you can download the chart data for the published Dashboards/Notes.
Dashboard: Note: Now you can download the chart image for the published Dashboards/Notes.
Dashboard: Note: Now you can view the comment you made for the charts that are included in a dashboard.
Dashboard: Added a new 'Column Layout' option.
Dashboard: Added 'Page' support. Now you can create multiple pages inside a Dashboard.
Parameter: Move the plus button to the next of the Parameter radio button text.
Parameter: Added the' Setup' button in the Parameter Pane.
Collaboration: Now updating projects on the server or synchronizing the local project with the one on the server is done by sending/receiving only the differences. This makes the project publishing and the updating much faster.
Referencing other data frames from within mutate, summarize, filter, etc., without the "!!" operator will stop working from 6.10. This change was necessary to detect dependencies on other data frames more accurately.
This will not work anymore.
mutate(col1 = nrow(another_dataframe))
It should be rewritten this way.
mutate(col1 = nrow(!!another_dataframe))
Data Source: Google BigQuery: Numeric value became NA for INT 64 data type columns.
Data Source: Google BigQuery: On the Setup dialog, the Google Cloud Storage Bucket List only showed 200 buckets.
Data Source: Made user and password field optional for Database Data Sources.
Data Source: Publishing data to the Exploratory Server failed with the 'long packets are not implemented' error when there were too many columns.
Data Wrangling: After deleting a data frame, the 'DAG Node does not exist case' error was raised on some occasions.
Data Wrangling: After searching columns on the Summary View, a newly added step token became "In Creating".
Data Wrangling: Create Bin Dialog: Improved labels for Integer columns to show 1-3 style instead of (1,3] style.
Data Wrangling: Create Calculation (Mutate): The count_if function was not shown in the function list.
Data Wrangling: Deleting a data frame or branch did not trigger the recalculation of the steps that depend on it as it should have.
Data Wrangling: False positive errors about circular references were raised if columns with the same name as a data frame.
Data Wrangling: For the set-operation steps like intersect, data frame names were not properly enclosed with back-ticks in the generated R command, which led to R errors.
Data Wrangling: Join: Join target column was not automatically selected even if the same name column exists on the target data frame.
Data Wrangling: Pivot: The calculation result became incorrect when a column whose name is 'value' was selected.
Data Wrangling: When opening a data frame, 'TypeError: Cannot read properties of undefined (reading 'length')' error was raised on some occasions.
Table View: Text data became URL links if the text looked like the host name such as "1.introduction" or "aaa.bbb.ccc.ddd".
Chart: "% TRUE", "% FALSE", '% NA" and "% Not NA" aggregation functions should return ratio values (between 0-1) instead of percentage values (0-100%) in the Pivot and Summarize Table.
Chart: Color Dialog: The color setting didn't work if you set a numeric column that contains values greater than 1000 to the Color and used the "As Discrete" column function.
Chart: Color Dialog: If you searched the table and changed one of the colors in the search result, the search result was reset.
Chart: Color Dialog: The Color Palette dropdown didn't list the custom palettes.
Chart: Color Dialog: The Sort Order option was reset to the "Top to Bottom" if you changed the # of groups.
Chart: The "Palette 1" color palette should be the default color palette if you assign a factor column to the Color.
Analytics: K-means: Running the elbow method with fewer rows than the maximum number of the centers raised an error.
Analytics: The default color palette was a categorical one if you assigned a numeric column with the bucketing at Color in the Survival Curve analysis. It should assign the 'Blue' gradient palette by default.
Analytics: Topic Model: Add the "Text Wrap" option in the chart property dialog for the "Document" chart.
Dashboard: 'Fit to Screen' did not work when the original dashboard had many rows.
Dashboard: Note: Word Cloud was not center-aligned in the full-screen mode view.
Dashboard: Scrollbars should show up if the text content is taller than the text panel height.
Dashboard: Note: When the “Reimport all the data sources” button was clicked, cached steps were not recalculated as they should have.
Note: Publishing a note that uses data source extension failed if the data source extension was not installed.
Publish: The caption text in Number charts didn't show up in the dashboard thumbnail image.
Parameter: For a dynamic single select LOV parameter, the default value was cleared when underlying data was changed.
Project: The project info dialog should include the project info on the server side if it is published.
Project: The search result got messed up if you searched data frames and renamed one of them in the search result.
Export: Exporting/Publishing with a parametrized step that appears before a cached step could fail with an "object not found" error.
Export: Unnecessary row number column was added when exporting data to a CSV file with Shift-JIS encoding.
General: After copying a data frame, charts in the copied data frame didn't show up in the hover popup.
General: Calling the ‘install.packages’ R function in a Custom R Script hung.
General: When opening the R Package Management dialog, a confirmation dialog was kept displayed, and could not close.
Released on 4/19/2022.
Data Source: CSV: Now it automatically guesses a delimiter for files.
Data Source: CSV: Supported importing UTF-16 encoding files.
Data Source: Supported the Text Input Data Source that allows creating a data frame from manually entered delimited text.
Chart: Now you can set the target value range in the "Equal Width" bucketing option.
Chart: Now you can use the "Equal Step" bucketing option for creating buckets.
Chart: Now you can use the conditional aggregation functions such as "SUM_IF", and "COUNT_IF".
Chart: Pivot: Now you can set the Visual Formatting from the column dropdown menu in the Pivot and Summarize Table.
Analytics: Now you can create your own stop word dictionaries or compound word dictionaries and use them in text analysis with the Analytics Views. You can share your dictionaries through exploratory.io too.
Dashboard: Note: Now you can download the chart data on each chart if you set the "Download CSV" option at the publishing time.
Dashboard: Note: Now you can download the chart image on each chart.
Dashboard: Note: Now you can view the chart comment on each chart.
Dashboard: Supported Column Layout.
Dashboard: Supported multiple Pages in a Dashboard.
Collaboration: Now updating projects on the server or synchronizing the local project with the one on the server is done by sending/receiving only the differences for a much quicker update/sync.
Data Source: Google BigQuery: Numeric value became NA for INT 64 data type columns.
Data Source: Google BigQuery: On the Setup dialog, the Google Cloud Storage Bucket List only showed 200 buckets.
Data Source: Google Sheets: Improved error message for missing sheet.
Data Source: Incorrect file index number was shown as part of the spin message while importing a remote CSV file.
Data Source: Made user and password field optional for Database Data Sources.
Data Source: Publishing data to the Exploratory Server failed with the 'long packets are not implemented' error when there were many columns.
Data Source: Salesforce: Improved the error message for SOQL query too long case.
Data Wrangling: Added the 'Preview' button for Summarize, Window Calculation, and Pivot Dialog.
Data Wrangling: After deleting a data frame, the 'DAG Node does not exist case' error was raised on some occasions.
Data Wrangling: After searching columns on the Summary View, a newly added step token became "In Creating".
Data Wrangling: Create Bin Dialog: Improved labels for Integer columns to show 1-3 style instead of (1,3] style.
Data Wrangling: Create Calculation (Mutate): The count_if function was not shown in the function list.
Data Wrangling: Deleting a data frame or branch did not trigger the recalculation of the steps that depend on it as it should have.
Data Wrangling: False positive errors about circular references were raised if columns with the same name as a data frame.
Data Wrangling: Filter: Added a help link for the Regular Expression radio button.
Data Wrangling: Filter: Unnecessary Time Zone selector was shown for Date Column filters.
Data Wrangling: For the set-operation steps like intersect, data frame names were not properly enclosed with back-ticks in the generated R command, which led to R errors.
Data Wrangling: Join: Improved the error message when the join failed due to target column and source column data types mismatch.
Data Wrangling: Join: Join target column was not automatically selected even if the same name column exists on the target data frame.
Data Wrangling: Made sure to remove associated data cache files from the repository when a data frame created from a step/chart/analytics data was deleted.
Data Wrangling: Pivot: The calculation result became incorrect when a column whose name is 'value' was selected.
Data Wrangling: R command issues such as using multibyte quotation marks in place of correct ASCII quotation marks or missing quotation marks were wrongly reported as mismatching parenthesis issues.
Data Wrangling: Separate: Supported the 'Regular Expression' mode for the custom separator.
Data Wrangling: Summarize: Supported 'ratio' version for count_if/sum_if function family.
Data Wrangling: Text Wrangling: Added the 'Regular Expression' and 'Character' options for the 'String before/after the specified text' cases.
Data Wrangling: Text Wrangling: Supported 'Letters (Alphabet & others)', 'Alphanumeric', and 'Letters and Numbers' options for remove, replace, and extract operations.
Data Wrangling: The Re-import Icon color remained green after clicking it.
Data Wrangling: US State conversion should remove space and symbols before the conversion.
Data Wrangling: When opening a data frame, 'TypeError: Cannot read properties of undefined (reading 'length')' error was raised on some occasions.
Table View: Text data became URL links if the text looked like the host name such as "1.introduction" or "aaa.bbb.ccc.ddd".
Chart: "% TRUE", "% FALSE", '% NA" and "% Not NA" aggregation functions should return ratio values (between 0-1) instead of percentage values (0-100%) in the Pivot and Summarize Table.
Chart: Color Dialog: The color setting didn't work if you set a numeric column that contains values greater than 1000 to the Color and used the "As Discrete" column function.
Chart: Color Dialog: If you searched the table and changed one of the colors in the search result, the search result was reset.
Chart: Color Dialog: The Color Palette dropdown should show the custom palettes.
Chart: Color Dialog: The Sort Order option was reset to the "Top to Bottom" if you changed the # of groups.
Chart: The "Palette 1" color palette should be the default color palette if you assign a factor column to the Color.
Chart: The Custom Color Palette dialog should be accessible from the Project menu.
Analytics: K-means: Running the elbow method with fewer rows than the maximum number of the centers raised an error.
Analytics: The default color palette was a categorical one if you assigned a numeric column with the bucketing at Color in the Survival Curve analysis. It should assign the 'Blue' gradient palette by default.
Analytics: Topic Model: Add the "Text Wrap" option in the chart property dialog for the "Document" chart.
Dashboard: Fit to screen did not work when the original dashboard had many rows.
Dashboard: Note: Word Cloud was not center-aligned in the full-screen chart view.
Dashboard: The Number chart's thumbnail is small when the number is placed inside the chart row.
Dashboard: Scrollbars should show up if the text content is taller than the text panel height.
Dashboard: The width differs between the number row and the chart columns when setting equal width.
Dashboard: Note: When the “Reimport all the data sources” button was clicked, cached steps were not recalculated as they should have.
Note: Publishing a note that uses data source extension failed if the data source extension was not installed.
Publish: Publishing an analytics that was unpublished before failed if the analytics had never run yet after opening the project.
Publish: The caption text in Number charts didn't show up in the dashboard thumbnail image.
Parameter: Added the' Setup' button in the Parameter Pane.
Parameter: For a dynamic single select LOV parameter, the default value was cleared when underlying data was changed.
Parameter: Move the plus button to the next of the Parameter radio button text.
Project: The project info dialog should include the project info on the server side if it is published.
Project: When trying to import a non-project zip file, it showed an "undefined" error.
Project: The search result got messed up if you searched data frames and renamed one of them in the search result.
Export: Exporting/Publishing with a parametrized step that appears before a cached step could fail with an "object not found" error.
Export: Importing EDF files could create unwanted step cache data files, leading to errors from subsequent operations.
Export: Unnecessary row number was added when exporting data to a CSV file with Shift-JIS encoding.
Export: When exporting a chart as an edf file, the spin icon did not show up.
General: After copying a data frame, charts in the copied data frame didn't show up in the hover popup.
General: Calling the ‘install.packages’ R function in a Custom R Script hung.
General: When opening the R Package Management dialog, a confirmation dialog was kept displayed, and could not close.
Installation: Custom R Script: Improved the spin message shown after clicking the Save button.
Data Source: Google BigQuery: When leaving the Page Size parameter input field blank on the import dialog, it failed with assert_that: missing values present in the assertion message.
Data Source: Improved the error message for 'import & merge' Excel files that do not have the same sheet name.
Data Wrangling: Added description for how the "Remove Duplicated Rows" operation works in the UI dialog.
Data Wrangling: 'as_Date' function was not highlighted in the expression editor.
Data Wrangling: 'Drop NA' dialog did not close after selecting a column.
Data Wrangling: Filter: Unnecessary Time Zone selector is shown for the Date data type columns. It should be shown only for the POSIXct data type (Date and Time) columns.
Data Wrangling: When selecting the "Remove Rows with All NA Columns" from the Column Menu, it incorrectly removed the rows if any of the specified columns contains NA where it should be done only when all the columns are NAs.
Chart: Bubble: An error dialog showed up if you set the POSIXct column with "Extract Hour" on Y-axis and enabled the sorting.
Chart: The color assignment was incorrect if you set both display name and custom color to the categorized numeric values.
Chart: Color change didn't take effect if you set display names for multiple Y-axis columns.
Chart: It should use "Sum" function rather than 'Mean' function for the default total aggregation function for the number of TRUE/FALSE/NA/Not NA in the Pivot Table and Summarize Table.
Chart: Map - Standard: The "Pacific Ocean Centered" map didn't center the Pacific Ocean when the type is set to ‘Circle’.
Analytics: The Missing Value Handling parameter value could not be changed inside the Time Series Anomaly Detection dialog.
General: Rserve was unstable under memory pressure for Windows.
Released on 4/5/2022.
Data Source: CSV File Import: Supported At (@), Pipe (|), and Tab (\t) as separators.
Data Wrangling: When exporting data to Excel, now you can select the date format.
Data Wrangling: Supported timezone for Date/Time related filtering operations.
Data Wrangling: Clean Column Name: Supported 'Remove Spaces' and 'Trim Spaces' options.
Chart: You can now use the checkbox to turn on or off for the Sorting.
Chart: Bar: You can now select the "Stacked" Bar Chart Type even if you change the Marker to "Line" or "Circle".
Analytics: Chi-Square Test: Now we show the Association Coefficient (Cramer's V) in the Summary table.
Note: We increased the resolution for the exported Word Document.
Parameter: You can now use the regular expression for the filters with parameters.
General: Now you can choose to ignore the Windows/Mac level proxy setting and directly connect to the Collaboration Server.
Data Source: After opening a Note or Dashboard, 'drag and drop' for importing an EDF file didn't work.
Data Source: Database: Improved an error message to only show relevant information.
Data Source: Database: When updating or re-importing an existing database data source, column data types were updated unexpectedly where they should keep the original data types.
Data Source: Google BigQuery: Scheduling data or insights that use Google BigQuery data at the server failed with the 'Use Standard SQL' error.
Improved error messages about missing local data files (e.g., CSV, Excel, etc.). This situation typically happens after importing an EDF or DF file with local data files exported from another machine.
Data Source: Excel: Even when setting the column data type as Date in the data import dialog it was still imported as POSIXct.
Data Wrangling: When moving to another data frame or the branch data frame after having an error with the data wrangling step it showed an error with the report dialog.
Data Wrangling: Filter: Added the "Slice (Select Rows)" option under the filter column menu.
Data Wrangling: Join: After restarting the App, the Join target columns were not populated on the Join dialog.
Data Wrangling: On a Japanese Windows PC, converting data type with the 'Year / Month' option converted the date as January (1) where it should be November (11).
Data Wrangling: Rename: The rename dialog sometimes added hidden backspace characters to column names.
Data Wrangling: When exporting data to Google Sheets, it failed if the sheet name contained special characters.
Data Wrangling: Window Calculation: It showed the incorrect label 'Difference From (%)' for a Date/POSIXct column where it should be 'Difference From'.
Data Wrangling: ceiling/floor functions now have digits argument to specify at which digit the number should be ceiled/floored.
Summary View: Correlation mode: The "Failed to get information." error showed up if you had a numeric column with very large numbers.
Summary View: The transition between the Summary View Correlation mode and Chart was very slow.
Chart: Bubble: The list of values in the Color & Group Setting dialog didn't match with the values in the chart legend if you used the Repeat By and the "None" Grouping option.
Chart: Bubble: The reference line didn't show properly if you assigned an aggregation function such as "Sum" to the Color and selected the "Color By" option for the "Group By" option in the Reference Line dialog.
Chart: Bubble: Sorting didn't work if you assigned a numeric column to Color.
Chart: Bar: Sorting didn't work if you assigned the "Y-axis values" to Color.
Chart: The default color palette should be a gradient color if you assign a factor column to Color.
Chart: Chart Table: Could not move a column to the very top of the column list by drag and drop.
Chart: If you used the same name for the display name for multiple items in the Color & Group Setting dialog to reduce the number of unique values, the color assignment didn't match between the dialog and the chart.
Chart: It showed "3 Values are highlighted" in the Highlight info green text even though there were only 2 items highlighted in the Color & Group Setting dialog.
Chart: The Format Column dialog shouldn't disappear if you click outside of the dialog in Pivot Table and Summarize Table.
Chart: The "Export Chart Data as CSV" failed right after running a preview of a Note or Dashboard.
Chart: If you assigned a gradient color palette for the Logical condition in the Color & Group Setting dialog, the color assignment didn't match between the dialog and chart legend.
Chart: An error dialog showed up if you switched the column from the "Y-Axis Values" to a regular column.
Chart: The Logical condition didn't follow the column change if you created a Logical condition using the "Y-Axis Values" and changed the column assignment for the Y-Axis.
Chart: Invalid columns and operators showed up in the Logical condition setting dialog.
Chart: Pie/Ring: Labels for values less than 5% were not shown on the plot area. Now you can configure the threshold from the chart property dialog.
Chart: Axis labels became ',' if you assigned a Date column to X-Axis and unchecked the '数字の短縮化' option for X-Axis.
Chart: Labels for the "Others" created by the Others Group setting were different between the Color & Group Setting dialog and chart on Japanese UI.
Chart: Map: The chart control area became blank if you chose the 'None' option for Grouping Type in the Color & Group Setting dialog.
Chart: The color order should start from the left to the right in the Horizontal Stacked Bar chart.
Chart: Scatter: Adding a reference line to the X-Axis in a Scatter chart failed if you assigned columns for X-Axis, Y-Axis, Color, Size, Label, Repeat By and it used Trend Line.
Chart: Scatter: The "Assertion Failed" error showed up if you assigned a column with the 'difftime' type to X-axis and selected the "Show Detail" option from a Pop-up.
Analytics: K-means / PCA: An error is raised when the input data frame has columns named PC1, PC2, etc. We improved the error message so that it is clear that it should be avoided by renaming those columns.
Analytics: Distance: If any of the input columns started with V, an error was raised.
Analytics: Decision Tree: The order of the Prediction chart facets did not correspond with the order of variable importances.
Note: There was an unnecessary space below the Table and Number charts in a Note.
Dashboard: The table inside Dashboard was not expanded properly when it was in a shorter height row.
Dashboard: When opening a dashboard, the data frame list on the main window didn't highlight the related data frames.
Publish: Unpublishing and republishing a team-shared Analytics changed the URL.
Parameter: When defining a slider parameter, the default value was auto-filled with 0 even if it was outside of the min/max range.
Parameter: It now shows where the missing parameter is used when there were missing parameter references at publishing data or insights.
Export: Exporting a Dashboard with a multibyte name as HTML raised an error.
General: Improved error messages about not being able to connect to the proxy server.
General: The Rserve process crashed under certain conditions and popped up an error dialog with the message "unable to initialize the JIT".
Released on 3/14/2022.
Released on 3/10/2022.
Data Source: Raw Line: After importing a text file, clicking the "File" button then selecting a different text file switched it to a CSV data source.
Data Wrangling: After Renaming the existing Data Frame to Japanese for Join, Merge, etc, reference to these data frames break.
Data Wrangling: Export to Google Sheets: The sheet LOV did not show a list of Google Sheets when trying to override the existing one.
Data Wrangling: Filter: Cannot enter from and to values for the between operator.
Data Wrangling: Pivot: Could not select Date/POSIXct columns.
Data Wrangling: Window Calculation: Corrected sort order for Row Number.
Data Wrangling: Window Calculation: Supported Window Align argument for Moving Calculation.
Data Wrangling: Window Calculation: Changing the preview number of rows didn't work when the selected option was more than 200 rows.
Data Wrangling: Window Calculation: When Date or POSIXct columns are assigned to group columns, original columns were overridden.
Chart: Color Dialog: The 'x' button at the search input field doesn't work.
Chart: Density Plot curves are incorrect if the data contains inf/-inf values.
Chart: If you have multiple columns at Y-Axis and set the highlight color, the highlighted color doesn't come at the beginning in the chart legend and bars.
Chart: If you move the order of columns at Y-axis by drag and drop, the highlight target column changes.
Chart: Logical condition target column should be always in sync with the column selected at the Color.
Chart: Map: Colors used in the thumbnail don't match the ones in the Map on Mac.
Note: The full-screen toggle button on each chart disappears if you change the number of columns to show in the chart toolbar.
Export: Exporting a project that was originally imported via an EPF file with data files with multibyte names hangs.
Released on 3/4/2022.
Released on 3/3/2022.
Released on 3/3/2022.
Data Wrangling: Now data frames with a name with multibyte characters are supported.
Data Wrangling: Filter: Supported ‘Regular Expression’ mode.
Data Wrangling: Introducing the Window Calculation UI.
Data Wrangling: last_date function to get the last date of the period (week, month, quarter, or year) is added.
Data Wrangling: New aggregate functions to use with Summarize Step, count_rows, count_unique, and count_unique_if are added.
Data Wrangling: Now you can specify the digit to round up (ceiling) or down (floor) numbers.
Data Wrangling: Summarize Group: Supported UI for SUM_IF series.
Data Wrangling: Supported conversions for Zenkaku / Hankaku, Japanese Imperial Year / Western Year, Japanese Calendar / Western Calendar, Kansuji / Number, and Japanese Prefecture / Code.
Data Wrangling: Supported extracting Japanese holiday.
Data Wrangling: Supported UI for separating Japanese address.
Data Wrangling: Text Wrangling: Added the option to convert Hankaku including Alphanumeric to Zenkaku.
Data Wrangling: ts_lag and ts_diff functions are added for lag and diff of time series data.
Chart: Introducing the "Color & Group" dialog.
Chart: Now you can create a logical color condition against the aggregated values on Y-Axis in the Bar chart.
Chart: Now you can select a City-level Japan map in the Map - Standard map type.
Chart: Now you can set the "Group By" option in the "Cumulative", "Difference From", "% Difference From" and "Moving" Window Calculations.
Chart: Now you can use "Difference from Period Ago" and "% Difference from Period Ago" Time-Series Window Calculations.
Analytics: Chi-Square: Now we show Cramer’s V on the Summary table.
Analytics: Correlation: The order of the variables on the heatmap is optimized so that it is easier to discover sets of highly correlated variables.
Analytics: Decision Tree: Supported permutation importance in addition to the existing variable importance algorithms.
Analytics: T-Test, Wilcoxon Test: Summary table and Difference error bar chart now show which category is considered to be the base.
Analytics: Topic Model: The threshold of topic probability for highlighting the words in the Document tab is now configurable.
Dashboard: Now you can view a chart in the full-screen mode.
Note: Now you can view a chart in the full-screen mode.
Parameter: New 'Range' type parameter is supported.
Parameter: Supported Range Slider for 'Between' operator for numeric columns.
Publish: Now you can choose whether or not to notify the publishing event to the team members when you publish or republish your insight.
Data Source: File Import: Now the Update button only becomes clickable after previewing the data so that it makes sure changes made to the data source are valid.
Data Source: Google Analytics: Could not open a data source created with an older version of Exploratory.
Data Source: Google BigQuery: After performing OAuth, the Google BigQuery Setup dialog showed up even if a Billing Project was already selected.
Data Source: Google BigQuery: Improved the error message for the page size error.
Data Source: SQL Server: On Mac, improved the error message for an OpenSSL library loading known issue.
Data Source: When trying to update a data frame that merges multiple Excel files, it didn't update the data frame if you select a single Excel file for the update.
Summary View: Correlation: Moved the target column to the end when it's sorted by correlation.
Summary View: Spin icon didn't show up for a while after switching the number of columns to show.
Data Wrangling: Column Selection dialog: To prevent a column selection step becomes empty unexpectedly, now the Run button becomes clickable only when you select columns.
Data Wrangling: Data frames with a name that started with '-' could not be renamed or removed.
Data Wrangling: Error from the step before a cached step after restarting Exploratory.
Data Wrangling: Filter Dialog collapsed while setting up a between function for a Date column.
Data Wrangling: Generate R Script menu did not work when an associated connection does not exist.
Data Wrangling: Improved the display name of ”AND" and "OR" logical conditions of the filter.
Data Wrangling: Improved the performance for renaming a data frame.
Data Wrangling: On the Column Selection dialog, when a column has a long name it was displayed across multiple lines.
Data Wrangling: On Windows, columns with a name containing emojis caused issues such as not being able to select on column selection dialogs.
Data Wrangling: Unsaved changes on step dialog were used for recalculation of the step.
Data Wrangling: When selecting a data frame, an assertion error was raised for some occasions.
Chart: Exporting Summarize Table data to a CSV file failed due to the "invalid multibyte string" error if the data contained Japanese characters.
Chart: Improved the Hover Popup range information text such as Standard Deviation to show '±' prefix.
Chart: Increased the unique value validation threshold to 100 for Color.
Chart: Map - Extension: The area type name is not translated on the button even though the names in the dropdown are translated.
Chart: Map - Standard: Hover Popup content is inconsistent between Area and Circle modes.
Chart: Pivot Table failed to render due to the "character string is not in a standard unambiguous format" error if you had NA values in Row and applied the date formatting.
Analytics: Binary Classification: ROC tabs raised an error if the name of the target variable column ends with "...
Analytics: Topic Model: Indexes of topics were sorted alphabetically rather than numerically.
Dashboard: When a parameter was executed and there was a missing data connection, it didn't show the dialog from where you can select or create a connection.
Parameter: After deleting a parameter, "Add New.." was displayed as a token label and no error message was shown.
Parameter: False alarm validation at the creation of range parameter.
Parameter: Removing parameters caused an error at publishing insights.
General: Command + R Key shortcut key was overtaken even when Window focus was off.
General: Corrected the Dialog Title of the Repository Directory picker.
General: Table View: Made the column width shorter when the value in the column was long.
Project: After renaming a project, duplicated project names were shown on the Project List.
Export: “Malicious entry” error could happen at importing a project (.epf file) that was exported from a project that was originally imported via another .epf file when the project contains local data files with a name with multibyte characters.
Released on 1/31/2022.
`@{parameter_name}`Data Source: SalesForce: Could not re-authorize SalesForce OAuth when it became invalid.
Data Wrangling: After renaming a target data frame column and refreshed steps, an assertion error is raised at the Group By step.
Data Wrangling: Opening the Reorder Columns dialog from a column menu moved the selected column to the top.
Chart: Bar: Bars didn't fit the default Y-axis range if you had a Stacked Bar chart with Color By, Repeat By and you set "Above" for the "Value on Plot" property.
Note: Changing the Parameter didn't update the parameter values inside Note.
Dashboard: Could not use drag-and-drop to change the row height.
Project: Even after publishing a project as a team, it showed the author's name as the publisher in the Publish dialog.
Public: If an error occurred while importing a project by URL, the error remained in the Project Import dialog.
Public: Publish at the project close failed if your Git was configured to use "main" as the default branch name instead of "master".
Released on 1/22/2022.
Released on 1/20/2022.
Data Wrangling: Filter: Supported 'Remove Inf' for numeric data type columns.
Data Wrangling: Supported pipe ("|") as a separating character for the Separate Columns and the Separate Rows steps.
Summary View: The column search can now search all columns including ones currently not showing on the screen.
Chart: Radar: Now you can configure the font size for the column names.
Note/Dashboard: Support the '@{param_name}' notation to access parameter values in the R code snippet.
General: Add the "Create Team" button in the Project Publish dialog.
Data Source: Amazon Aurora: When trying to connect with a certificate of the CA, it failed with an error 'Failed to connect: SSL connection error: No such file or directory.''
Data Source: Google BigQuery: Improved the Set Up dialog menu. You can now open it from the Data Source Connection list.
Data Source: Google Drive: Folders and files were not displayed for the Shared drives.
Data Source: Google Sheets: On the Sheet Selection dialog, a sheet name was truncated when the sheet names included slashes.
Data Source: Google Sheets: When importing an EDF or Project, the Missing Connection Handling dialog on a Dashboard didn't show the Create Connection button.
Data Source: Google Sheets: When there were multiple files with the same name, selecting one of the files ended up with selecting all the files with the same name.
Data Source: Google Sheets: When updating an existing data source, re-selecting a Sheet ended up creating a new data frame instead of updating the existing data frame.
Data Source: Improved error handling for the case where authentication error is raised when getting OAuth token from Exploratory Server.
Data Source: RODBC: Non-Ascii characters were not imported properly.
Data Source: SalesForce: Improved the message for OAuth token revoked error.
Summary View: The minimum value that was shown at underneath the the histogram chart was incorrect.
Data Wrangling: Added a help link for a regular expression in the Text Wrangling UI.
Data Wrangling: On the Column Selection dialog, an incorrect "?" data type icon was shown for "ordered factor" columns.
Data Wrangling: Text Wrangling: The dialog now supports highlighting the matched text for '[:digit:]'.
Chart: Legend should respect the order of categorized values with the 'Manual' Cut option.
Chart: Number: It should show 'NA' instead of 'NaN' when an assigned column contains only NA values.
Chart: The hover popup positions were off if you set the hover mode to the "All Values on Same X-Axis" with the Horizontal Bar chart.
Chart: The slider widget used at the Color Opacity setting didn't allow you to set "0.9".
Analytics: When a selected column data type was changed after a pin step moved, the associated aggregate function was not properly updated.
Note: Command + R (or Ctrl + R for Windows) shortcut key for re-running the Note did not work if the mouse focus was outside of the Note Editor.
Note: Chart/Analytics Picker did not remember the last selected data frame name.
Parameter: If you run the Parameter on a Note/Dashboard, a Word Cloud chart shows error code 127 when there is no data.
Project: User created color palettes were not included in the exported projects.
Team: When imported into Exploratory Desktop, the EDF file downloaded from a team-published insight that was previously individually published was not correctly recognized as a team-published insight.
Project: Improved the performance for duplicating the projects.
Project: An error "Malicious entry: _archived_project/data/..." was raised when importing a project that contains data files with non-ascii names.
Install: Exploratory did not start on Windows if your PC doesn't have the Visual Studio library.
Install: Changed to show the setup confirmation message on the Application Toolbar.
Released on 12/31/2021.
The biggest feature of this release is to support Project Level Collaboration. Now you can publish your projects to Exploratory Server and share with others.
Collaboration: You can publish your projects and share with others.
Collaboration: You can update your projects with the latest changes published by others.
Collaboration: The published projects are version controlled so that you can restore to a particular version from the past.
Collaboration: You can publish your projects as a Team. This will make it easier to collaborate with team members.
Data Source: Amazon Aurora: Supports SSL CA file parameter.
Data Source: Google Analytics: Supports 'Sampling'.
Data Source: Google Sheets: You can now search Sheet names at the server.
Summary View: Now you can select first or last N columns / rows to show.
Summary View: Correlation Mode: You can sort the columns alphabetically.
Summary View: Correlation Mode: You can sort all the columns based on a selected sorting metric and show only the first / last N columns.
Table View: Now you can select how many columns to show.
Data Wrangling: Added "to Beginning" and "to End" options for Reorder Columns menu.
Dashboard: Now it keeps other rows' height when adjusting a given row height by drag and drop.
Parameter: We have improved the performance of enabling the interactive mode by automatically caching the step data.
Parameter: It now detects invalid Parameters and provide a better error message.
Project: It now provides more information about the projects including the creation date, project file size, and the current memory consumption size.
Data Source: Data import process didn't finish if you imported a CSV file with 2,200 columns.
Data Source: Google BigQuery: Improved the error Message for page size-related issues.
Data Source: When adding a file to an existing merged CSV/Excel data source, it only showed data from the first file.
Summary View: NA values were not counted properly for the Date data type columns.
Summary View: It showed a blank screen when you changed the column names in the previous steps.
Data Wrangling: 'Another R process running' error happened if you went to the Summary view after renaming columns.
Data Wrangling: Filter: 'Year Month' option did not work on Windows with Japanese locale.
Data Wrangling: Improved an error handling triggered by renaming existing columns.
Data Wrangling: Merge: Changed the "Force Data Type to Match" checkbox as unchecked by default for a better performance.
Data Wrangling: Replacing an empty string with something else did not finish.
Chart: "Another R process running" showed up if you assigned a column to the chart and chose the "Export Chart Data as Excel" option.
Chart: Boxplot chart should exclude 'infinite' values before the boxplot calculation.
Chart: If you check the "Skip this check for this column." option in the "Number of Unique Values Check" dialog, it shouldn't show this dialog even if you update the column assignment in the other places.
Chart: The radar chart showed an error if you assigned character columns and enabled the "Normalize Values" option in the Chart property dialog.
Chart: Sorting Bar chart didn't work properly if there were NaN values in the data.
Chart: Table View should show "Inf"/"-Inf" for infinite values instead of "NaN".
Chart: The "Sync X-Axis" option should appear in the Chart toolbar.
Parameter: Error about "another R process" was thrown when you changed the name of a Parameter.
Project: Opening a project failed with TypeError: Cannot read properties of null (reading 'classList') for some occasions.
Project: Project List showed unnecessary space when the app is resized inside the project.
Project: When you imported a project that was once exported, the images embedded in the notes were lost.
General: Improved the Network Error dialog to make it easier to understand.
General: Improved the performance for importing data files with many columns.
General: In some environments, the network connection to exploratory.io for login or OAuth failed due to the expired root CA certificate for Let's Encrypt SSL certificate. With this version, this is handled without having to adjust OS configurations.
General: Starting up in an offline environment threw the error "Cannot read properties of null (reading 'setDate')" if the name of your home directory on Windows had multibyte characters.
Installation: Re-designed the Installation UI to make it more intuitive.
Released on 11/24/2021.
Data Source: Amazon Athena: Supported workgroup parameter.
Data Wrangling: After sorting numeric columns in descending order, all the values of the column became negative.
Dashboard: Couldn't Re-Import and Run a Dashboard at the same time.
Dashboard: A dashboard panel title showed a weird text like "{data-width=100}" if a chart name contains an underscore ('_') letter.
Dashboard: A dashboard panel got unexpectedly wider or narrower if a chart name contains an underscore ('_') letter.
Publish: Connection info was not uploaded to the server for scheduled jobs or parameters if you had recreated the connection.
Installer: Improved 'Reset R Packages' feature to recreate the R packages folder to prevent unexpected folder permission issues.
Installer: Improved error messages and suggestions in case upgrading R packages failed due to a permission error while upgrading Exploratory.
Released on 11/18/2021.
Data Source: Azure: When opening an Azure Data File List for the first time, the Container LOV didn't select the first available option by default.
Data Source: Google Analytics: Could not select a time zone other than the system default.
Data Source: S3 /Google Drive/Azure: Added the 'Create Connection' link on the File List dialog.
Data Source: S3: Preview dialog did not show up after selecting a CSV file when file encoding detection failed.
Summary: Correlation Mode: Now logical columns also show a Correlation value if you select a numeric column to the target column.
Data Wrangling: 'Remove Specified Text in Another Column' operation failed for a column whose name has special characters or non-ASCII characters.
Data Wrangling: Summarize Group: On the Custom Expression editor, it didn't suggest columns from the previous step.
Chart: Custom Expression Dialog: Supported Function List dialog.
Chart: Density Plot: Show values with a unit name (μ etc) in the hover popup.
Chart: Exporting chart data to an Excel file failed if you tried to overwrite an existing Excel file.
Chart: Heatmap: Values on the heatmap cells were incorrect if you assigned numeric values to the X or Y-Axis.
Chart: Number: The lower part of the main number text was truncated.
Analytics: Chart-related error messages should show up in the chart plot area instead of the top of the application window.
Installation: Installed R was not detected if Command Prompt had a problem. If this problem is detected, we show a dialog with an instruction to resolve the Command Prompt issue.
Installation: Upgrading to Exploratory Desktop 6.8.0 failed with an error "w[1].version_command.unshift is not a function" if custom R location was specified.
Released on 11/11/2021.
Data Source: Google Drive / Amazon S3: Now it remembers the last 20 visited folders.
Data Source: Supported Azure Storage Blob / Data Lake for CSV, Excel, and Parquet files.
Data Source: Supported MS Access Data Source.
Data Source: Supported Parquet files as one of the local file data sources.
Data Source: Supported Parquet files for Amazon S3 Data Source.
Data Wrangling: Filter: Supported 'Keep NA' option for Date and Numeric column filter operations.
Data Wrangling: impute_na function can now fill NA with the mode of the column.
Data Wrangling: Supported "Remove Alphabet" and "Remove URL" parameters to the Tokenize Text step dialog.
Data Wrangling: Supported “Group by” for the TF-IDF Step.
Data Wrangling: Supported exporting step data, chart data, and analytics data as a Parquet file.
Data Wrangling: Supported sum_if, count_if, mean_if, median_if, max_if, and min_if functions.
Data Wrangling: Text Wrangling: Supported an option to remove/replace/extract specified text in another column.
Chart: Map: The World Map (Pacific Ocean centered) support.
Chart: Now you can show the grand total in Table.
Chart: Number: Now the caption text shows in multiple lines if it is long.
Chart: Pivot: Summarize Table: Now you can configure how to handle NA values from the Missing Value Handling setting.
Chart: Radar chart support.
Chart: Supported Y-axis columns reorder by drag and drop.
Analytics: Added the option to remove alphabet words at text tokenization by Tokenize Text Step.
Analytics: Added the option to remove alphabet words at text tokenization in Word Count and Topic Model Analytics View.
Analytics: Factor Analysis: The Communality column was added to the Weight table.
Analytics: Factor Analysis: You can now specify a categorical variable to look into its relationship with the discovered factors with the new Radar chart and Path chart.
Analytics: K-Means: You can now specify a categorical variable to look into its relationship with the discovered clusters with the new Radar chart and the Path chart as well as the existing Stack Bar chart.
Analytics: Now you can change the sort direction of Bar charts from the chart property dialog.
Analytics: Now you can customize the Network chart in the Market Basket analysis from the chart property dialog.
Analytics: Now you can customize the Network chart in the Word Count analysis from the chart property dialog.
Analytics: Now you can customize the Tree chart in the Decision Tree analysis from the chart property dialog.
Analytics: Time Series Clustering: Added Elbow Method mode to determine the optimal number of clusters.
Analytics: Topic Model: Words in the documents are now colored based on the most likely topic that the word belongs to.
Analytics: Topic Model: You can now specify a categorical variable to look into its relationship with the discovered topics and important words of the topics with the new Path chart and Stacked Bar charts.
Dashboard: Note: Now you can show/hide the Repeat-By controls in charts from the property dialog.
Parameter: Supported cache option for dynamic LOV result.
Parameter: Supported the option to show all the available items for dynamic LOV.
Data Source: Amazon S3: Import and merge files fails for some directories.
Data Source: CSV: The file selection dialog height didn't change dynamically when the App's window size increased.
Data Source: Excel Import and Merge: Improved the error message when duplicated column names were detected.
Data Source: Excel Import and Merge: Improved the error message when sheet names in the selected files were not all the same case.
Data Source: Excel: Data type convert didn't work after re-selecting a sheet other than the one originally specified in the Excel data.
Data Source: Improved performance for previewing multiple CSV/Excel/Parquet files import and merge cases.
Data Source: MS SQL Server: Relabeled and reordered ODBC drivers shown in the List of Values to make it less confusing.
Data Source: ODBC Data Source: Stopped blindly escaping non-ASCII table names to avoid SQL syntax becoming invalid.
Data Source: Remote Excel: After changing a remote Excel file URL, the associated Sheet Name was not properly updated.
Data Source: Twitter: Now you can use LOV for Language parameters.
Data Source: When creating a new data frame while the source step was selected on the Chart View, the newly created data frame was not displayed on the data frame list.
Data Source: When importing Stats (SPSS/SAS/Stata) files, imported column data types were incorrect when the columns were labeled.
Data Wrangling: In the expression editor, column names highlighting didn't work if a name contains both alphabet and Japanese characters.
Data Wrangling: Column Menu: 'Convert Excel numeric to Date Type' didn't work when multiple columns were selected.
Data Wrangling: The help link for the Predict with Analytics dialog didn't work.
Data Wrangling: The help link for the Sample Step dialog didn't work.
Data Wrangling: On Analytics View, the data frame comment icon position was incorrect after collapsing and expanding the right-hand side steps.
Data Wrangling: On Create Calculation for Multiple Columns dialog, the Function List dialog didn't show up when clicking the Function List link.
Data Wrangling: On Summary View, when a selected step was grouped, the 'Search Columns' label overlapped with the 'Correlation' button.
Data Wrangling: On the Create Calculation for Multiple Columns dialog, the label for Window Calculation was truncated.
Data Wrangling: Recode: the "# of unique" value label was placed way below the table when there were very few rows.
Data Wrangling: Summarize Group: Custom Expression Editor didn't have the link to open the Function List dialog.
Data Wrangling: There was a case that already deleted data frames kept showing in the data frame list and clicking the data frame threw an Error.
Data Wrangling: When deleting a branch data frame, it showed an error TypeError: Cannot read property 'getId' of null for some occasion.
Data Wrangling: When deleting a data frame, the parquet file used for data caching of the source step was left without getting removed.
Data Wrangling: When selecting a data frame on the data frame list, 'Error : dagops.members() dataframe does not exist' raised for some occasion.
Data Wrangling: When updating a source step, Cannot read property 'cache' of undefined error is raised for some occasion.
Chart: 'Show detail' didn't show filtered data when the chart had disabled chart filters.
Chart: Export data to Google Sheets failed with 'Cannot read properties of null' error.
Chart: Exporting the chart data to Excel failed with an "invalid multibyte string" error if the data contained Japanese.
Chart: If I hovered the first box from the left on a Boxplot chart, it showed hover balloons for multiple boxes.
Chart: If the order of the X-axis was reversed, the X-axis range setting was ignored.
Chart: Pivot failed to render if you assigned a date column to the Column and chose "Day of Month" in the formatting dialog.
Chart: Pivot: Summarize Table: Referring to a column in the Value in the URL formatting for a column in the Row didn't work.
Chart: Pivot: The hover pop-up didn't show the display name defined in the formatting dialog.
Chart: Summarize Table: The "Show Bars on Background" option didn't show up for a character column with a "Unique Count" function assigned to the Value.
Chart: Table: The header text didn't show fully once in a while even though the text was short.
Chart: Value text on the plot area didn't align with bars if you used a Color with highlight.
Chart: Word Cloud failed to render if you assigned a factor column to Color and chose a "Unique Count" function.
Analytics: Chart Property dialog should always show the color properties even if no color is used in the chart.
Analytics: Improved property menu for Market Basket Analysis to prevent unnecessary value set for 'Minimum Support Value' when 'Auto' is set for 'Minimum Support".
Analytics: Survival Curve: Row number shown in the Summary was larger than the actual value by 1.
Analytics: The zero line for the Y-Axis didn't show in the Probability chart in the Random Forest analytics.
Analytics: Topic Model / Word Count: Added mouse hover popup help on "Clean Up Twitter Data" menu.
Analytics: When moving to a different Analytics Tab, unnecessary file save happened and it slowed the navigation.
Analytics: Word Count: Word Count Analytics View failed to run when there was no co-occurrence.
Analytics: Y-Axis direction was flipped if you uncheck the "Sync Y-Axis" checkbox in the Prediction chart in the Random Forest analytics.
Note: When adding a chart to a note, now it inserts a new line break before the code so that the generated document can show the header section properly.
Publish: Error "Cannot read property 'getName' of undefined" raised when publishing an Analytics with Weather Data and the Weather Data extension was not installed.
Schedule: There were cases where scheduled jobs failed due to unnecessary type conversion on uploaded file data.
Installation: When Git and R download failed due to the proxy server blocking the download request, an error message didn't show up for some occasions.
Installation: When Rserve installation failed, the error message didn't show a full path of failed file
Installation: Windows: R under Documents/R/R-4.1.0 under the home directory was not properly detected and used.
Public: 'Download' button on the 'New version available' dialog was not linked to the Public Edition download page.
R Package Upgrade for 6.8.
Released on 10/30/2021.
Released on 9/29/2021.
Released on 9/28/2021.
Chart: Now, you can create a range by specifying upper and lower values manually using the "Specific Value" option in the Line chart.
Chart: Now, you can fill the Reference Line range with color.
Data Source: Amazon Athena: Supported additional parameters input field to enter any supported ODBC parameters.
Data Source: Amazon Athena: Supported VPC Endpoint parameter.
Data Source: Google Drive: Supported importing files from a Share Folder.
Data Wrangling: Work with Text Data: Supported "Remove Text Before/After Specified Character", "Replace Text Before/After Specified Character", and "Extract Text Before/After Specified Character",
General: Supported self service Offline License Key generation for users with Business Plan.
Analytics: Correlation: Result of "Correlations" heatmap or "Significance: scatter plot with "Lower Triangle Only" option did not fit in the lower triangle.
Analytics: The "Words - Count" chart in Word Count Analytics failed to render and showed "Invalid argument was passed to returnsNumericValue" error.
Chart: It showed fewer dots if you set the Trend Line in the Scatter chart.
Chart: Reference Line range values in the 2nd Repeat By was incorrect if you used the "Repeat by Y-Axis Columns" feature.
Chart: Table failed to render and showed an error dialog if the data frame had row names.
Dashboard: Dashboard didn't show more than 6 Numbers in a row even if you could add more than 6 Numbers at the design time.
Data Source: Amazon S3: Files from a child folder was listed on the parent folder.
Data Source: Amazon S3: When merging multiple csv files as a single data frame, files from a sub-folder were included mistakenly.
Data Source: Amazon S3: When selecting an empty bucket, the spin icon didn't go away.
Data Source: ODBC: Japanese Tables names got garbled for MS SQL Server in the Schema list.
Data Source: SQL Server, when a SQL query failed, it showed clearDBConnection failed message.
Data Source: Treasure Data Connection: API Key input field was not displayed for Treasure Data Connection dialog.
Data Wrangling: Caching a grouped step threw error "x must be an object of class 'data.frame', 'RecordBatch', or 'Table', not 'arrow_dplyr_query'".
Data Wrangling: Summarize Group: When using a column that is already assigned to Group Columns as a value column, column name was overridden.
Export: Error 'Cannot convert undefined or null to object' was raised from exporting a Dashboard or Note as an EDF file when a database connection missed in the project was used.
Export: Error 'Command failed: zip -q -r "edf.zip" "note_content\note.html"' was raised when publishing or exporting a Dashboard or Note from a repository on a network drive.
Export: Publishing or exporting an Insight hanged if your home directory was on a network drive.
Export: Publish dialog didn't open when the PC was offline.
Installation: Error about installing Rserve R package was raised at installation if an installer dmg file for a wrong type of Mac (Intel or M1) was used.
Released on 8/31/2021.
Chart: Now you can set the Scale option when you export the chart as an image file in order to export the image in a higher resolution.
Chart: We have added "Missing Value Handling" support for Bar, Area, and Scatter (With Aggregation) chart types.
Data Source: CSV / Excel: Now you will see a list of the last 10 used folders when you choose the folder.
Data Source: JSON: Now the "Export Data as JSON" option export the data in a nested data structure if the data frame contains list columns.
Data Source: MongoDB: Now you can use your SSL client certificate for the connection.
Data Wrangling: Added 'Email' for the 'Work with URL' menu in the column header menu.
Data Wrangling: Added the 'unnest' command to the column header menu so that it can 'unnest' the nested list columns easily.
Data Wrangling: Now the values for the true_value argument of str_logical function are suggested in Create Calculation (mutate) dialog.
Data Source: Google Analytics: After upgrading to Exploratory Desktop 6.7.0, updating an existing Google Analytics Data Source threw Time Zone not set error.
Data Source: MariaDB/MySQL: Connection failed when timezone was not properly set up on the Database server.
Data Source: ODBC: On the “Add New Connection” dialog, the dropdown for the DSN list was empty when the dialog was opened for the first time right after the installation.
Summary View: When adding a new step on Summary View, the spin message didn't show the step name and just said "Calculating Summary Info".
Data Wrangling: Mutate Multiple Columns: When using special characters for Suffix, it showed an unmatched parenthesis error.
Chart: The "Cumulative Sum" Window Calculation didn't work properly if there were NA values in the summarized data in the Line chart.
Chart: If numeric values on X-Axis were derived from a Date or POSIXct column such as the "Month Number" function, the "Fill with NA" Missing Value Handling option should complete the missing numbers and fill NAs for values.
Chart: Exported chart data didn't contain columns using the "As Category" column function.
Chart: Pivot Table failed to render and threw "Cannot read property 'url' of undefined' if you assigned multiple columns to Value and removed the first one.
Analytics: Correlation: You couldn't open an Excel file created by the "Export Table Data as Excel" feature in the Data tab if you had Japanese characters in the data and column names on Windows.
Parameter: When moving a slider to the far end, it kept sliding even after releasing the mouse.
Export: EDF/DF file export failed if exported Chart(s) had a long name.
Export: Project export failed if the path or file name included multibyte characters.
General: If project export failed in the middle, a directory named "_archived_project" was left in the project directory, and it looked like an additional project on the project list screen.
Released on 8/19/2021.
Data Source: Excel: Now you can import macro-enabled Excel files that use the .xlsm file extension.
Data Source: Google Analytics: Now you can view POSIXct column data in a time zone other than the one set in Google Analytics.
Data Source: Google Analytics: Supported ‘Between’ Date Filter Operation.
Data Source: Google Analytics: Supported Google Analytics V4.
DataFrame: Supported "Add Comments" for Data Frames.
Data Wrangling: Filter: Supported 'Contain this string (multiple)' operator.
Data Wrangling: Keep Unique Rows: Supported 'All Columns' option and Improve the UI.
Data Wrangling: Supported 'Leave Original Column' option for the 'Mutate with Multiple Columns'.
Data Wrangling: Supported 'years_between', 'months_between', 'weeks_betwen', and 'days_between' functions for Date and POSIXct columns and 'hours_between', 'minutes_between', and 'seconds_between' for POSIXct columns.
Data Wrangling: Supported the option to remove extra spaces in text wrangling dialog.
Chart: Highlight: Now you can choose the position of the highlighted colors either top or bottom in the Stacked Bar and Area chart.
Chart: Now the sort is applied within each chart if you use Repeat By.
Chart: Now you can quickly access the Trend Line and Reference Line configurations from the information green text.
Chart: Now you can quickly remove the column configuration such as Window Calculation, Limit, Other Group, and others by clicking the 'x' button at the information green text.
Chart: Pivot Table: Now you can assign multiple columns to the Value and a column to the Column at a time.
Chart: Pivot Table: Now you can do the column formatting in the same way as you do in the Summarize Table.
Chart: Pivot Table: Summarize Table: Now you can show the text in multiple lines in cells by the "Text Wrap" option in the Format Column dialog.
Chart: Pivot Table: Summarize Table: Table: Now you can fit the table width to the Chart view area by the "Fit to Screen" option in the chart property dialog.
Analytics: "Text Clustering by Topic Model" Analytics View is added.
Analytics: Correlation: In the Data tab, now we show t-value along with P-value if the method is Pearson
Analytics: Factor Analysis: Now the sum of squared loadings (SS loadings) is shown on the hover popup of the Factor Importance bar chart.
Analytics: K-Means: Added Summary tab that shows the summary of each cluster, such as cluster center and the number of rows belonging to it.
Analytics: K-Means: Now the stack bar chart hover popup shows the number of rows.
Analytics: Text analytics features (Tokenize Text Step, Word Count Analytics View, and Topic Model Analytics View) now have the "Clean Up Twitter Data'' option for tokenizing, which removes mentions and hashtags.
Analytics: Word Cloud, Topic Model: Now you can eliminate specific words from the default stopwords.
Analytics: Word Count: Now network clustering is applied to the co-occurrence network, and displayed by colors.
Analytics: Word Count: Now you can specify a minimum count of words to be displayed in the word cloud.
Data Source: Brought back 'ODBC (Legacy)' data source to support databases such as Teradata and Kintone.
Data Source: Error "object exp.file.id not found" was raised if the directory for the CSV, Excel files had been removed. Now we show a message that explains this kind of situation better, including similar cases for files on AWS S3 or Google Drive.
Data Source: File Data Source: Importing a file failed with the 'URIError: URI malformed' error when the file name contains certain special characters.
Data Source: Google BigQuery: Improved error message when columns in a SQL query did not exist.
Data Source: Google Drive: Switching from "all" mode to "select files" mode thrown 'The "path" argument must be of type string.' error.
Data Source: Multiple CSV files: When guessed file encoding was incorrect, it only imported the first file and ignored the rest after the error was recovered.
Data Source: Now ODBC data source honors the user's timezone for POSIXct column data.
Data Source: Now you can change column data types on the CSV/Excel file import dialog.
Data Source: SQL: When a table name starts with a number of other special characters, now it generates a SQL that wraps the table name with a quote string to make the SQL syntax valid.
Data Source: Supported FRED (FRB Economic Data) as a cloud apps data source.
Data Source: Switching from a CSV data source to a Google BigQuery data source didn't work.
Data Source: Switching from a multi CSV files data source to a single CSV file data source didn't work.
Data Source: Teradata: it didn't show schema information properly.
Data Source: When new columns were added to a file, these new columns were not selected when opening the Update data source dialog.
Summary View: A blank screen showed up if you removed a column from a data frame that had more than 300 columns.
Summary View: Correlation mode: Linear regression prediction lines were not straight.
Summary View: When a join step was selected, the Correlation mode didn't refresh even after changing the target column.
Data Wrangling: "Add Column Suffix" option was not shown for Inner Join.
Data Wrangling: Added “unit” to the formula for floor_date function.
Data Wrangling: After closing a project with the right-hand-side step list collapsed, re-opening the project showed the incorrect step collapse icon.
Data Wrangling: After copying a folder, branches in a data frame in the folder were not displayed.
Data Wrangling: Alignment of the Window top became broken after selecting columns for K-means step dialog.
Data Wrangling: Changed to include step number in a spin message when a step is executed.
Data Wrangling: Changed to use impute_na for filling missing value with specific value operation.
Data Wrangling: Duplicating a data frame with a "Predict with Model (Analytics View)" step raised an error.
Data Wrangling: Failed to replace NA with the other value “Replace NA… with specific value” menu if the target column is a factor.
Data Wrangling: Filter: Added an example to the Year / Month option label.
Data Wrangling: Now Filter dialog honors the user's timezone when the 'Between Date' operator is used.
Data Wrangling: Now the syntax suggestion for mutate operation is shown in Japanese when UI language is Japanese.
Data Wrangling: On the Chart View, when running a step, it shows 'length' of undefined error for some occasions.
Data Wrangling: On Tokenize Text dialog, changing the "With Sentence ID" parameter did not change the selected value.
Data Wrangling: Table View showed a blank UI when underlying metadata was corrupted.
Data Wrangling: Text Wrangling: Removing last words failed if the text contained special characters.
Data Wrangling: When navigating from Table view to Chart view while the Table Filter dialog was open, the Filter dialog did not close automatically.
Chart: Bar chart failed to render with the "Problem with mutate() column c2.sortval" error if you had "% of" window function, sort setting, and Limit with a condition that removed all the data.
Chart: Bar: Values on the plot area didn't align with bars if you used the Highlight feature.
Chart: Checking the "Sync X Axis" checkbox didn't sync the X Axis in the Line chart.
Chart: Highlight: Highlighted colors did not come up at the top in Area and Pie/Ring charts.
Chart: If you typed in '1' for the "Number of Categories" in the Category Setting dialog, it became '2' automatically.
Chart: Line chart failed to render and showed an error "argument "df1" is missing, with no default".
Chart: Pivot Table failed to render if you selected the Quantile aggregation function against the data with all NA values.
Chart: Pivot Table: "NaN" text shouldn't show up in the value cells. It should show empty cells instead.
Chart: Pivot Table: Summarize Table: Date formatting support.
Chart: Pivot Table: Summarize Table: It didn't show the total values correctly if you used a Custom Calculation and set the "Before Aggregation" option for the calculation timing setting.
Chart: Pivot Table: Summarize Table: The hover Pop-up got too wide if there was a long text in there.
Chart: Pivot Table: The Color Visual Formatting didn't work if you used a Custom Calculation that generated text output at the Value.
Chart: Pivot Table: The table border shouldn't show in the table header cells if you specify a background color in the Visual Formatting setting.
Chart: Pivot Table: Values from a hidden Row column shouldn't show up in the Pop-up.
Chart: The "Color Direction" option should be removed from the "Conditional Formatting" Visual Formatting.
Chart: The "Hide Value Cells" option was missing in the Pivot Table.
Chart: The "There is no data to display" message in the Chart view was not translated into Japanese.
Chart: The Repeat By order was incorrect if you selected more than 10 columns at Y-Axis and used the "Repeat By Y-Axis Columns" feature.
Chart: Unchecking the "Sync X Axis" checkbox didn't unsync the X-Axis in Error Bar (Summarized Data).
Chart: Values on plot area didn't align if there were missing values in the Line chart.
Chart: Word Cloud failed to render and showed a "Cannot read property 'match' of undefined" error.
Chart: Word Cloud failed to render and showed an "invalid printing width" error.
Analytics: After moving an Analytics tab by drag and drop, the spin icon didn't go away.
Analytics: After renaming a duplicated analytics, clicking another analytics tab ended up reverting name change.
Analytics: Analytics was mistakenly executed by deleting an unfinished filter condition.
Analytics: ARIMA: An error "Names must be unique. These names are duplicated" was raised if you assigned a column with the name "y" as the Value column.
Analytics: ARIMA: For some cases, only models without constant terms were searched as candidates of the model.
Analytics: ARIMA: NA handling in an aggregation of data for each time period is improved.
Analytics: Correlation, Distance: Now the column orders in the heatmap are ordered in the same way between Mac and Windows.
Analytics: Correlation: Checking the "Show Correlation Values" checkbox didn't show the correlation values on the plot area.
Analytics: Cox Regression, Survival Forest: Now a unit of the period is indicated in the status text for the Survival Curve chart.
Analytics: Cox Regression, Survival Forest: The prediction period is now shown in the status text for the Prediction chart.
Analytics: Emoji removal is improved, and some of the emoji we could not remove before can be removed now.
Analytics: Exporting the Word Cloud data should be enabled in the Text Analysis.
Analytics: K-Means: If there is a column with only NAs, we remove that column from the input automatically so that the analysis can go on with the rest of the columns.
Analytics: Multicollinearity (VIF) bar charts when used with repeat-by groups are now sorted properly by the VIF value for each repeat-by group.
Analytics: PCA: Pivot Table columns in the Weight tab were partially translated.
Analytics: PCA/Factor Analysis: A column selected at the Color By was reset if you switched the Analytics type from PCA to Factor Analysis.
Analytics: Prophet: Data that is just 2-year long was not processed with yearly seasonality by default. We adjusted the criteria of the automatic switch of yearly seasonality so that such data is processed with yearly seasonality by default.
Analytics: Revised default Japanese stopword list to avoid unwanted removal of potentially important words.
Analytics: Row number for the basis of power analysis was counting rows with NAs too. Now we filter NAs before counting rows for power analysis.
Analytics: Statistical Test: Now, when a repeat-by group is used and some of the groups got errors running the test, the errors are reported on the Note column of the Summary table, rather than blocking tests for all other repeat-by groups.
Analytics: Statistical Tests: Improved error messages that are shown when no data or only 1 row is left after removing NAs.
Analytics: Survival Curve: Error "Cannot read property 'getColumns' of undefined" showed up when a numeric column was assigned to Color.
Analytics: Survival Curve: You should be able to assign the same column to both Cohort and Start Date.
Analytics: The Data tab in the Chi-Square Test failed to render and showed a "Cannot read property 'column' of undefined" error.
Analytics: The Network chart didn't use the full chart viewing area after opening the full-screen view.
Analytics: The number of decimal digits setting didn't work in Summary or Coef Table tabs in Analytics.
Analytics: Time Series Clustering: Many of the combinations of Cluster Center Method and Distance Method raised errors.
Analytics: Tokenization done by Analytics View and Step now gives the same result.
Analytics: Variable importance bar charts (including the box plot for Boruta for Random Forest) when used with repeat-by groups are now sorted by the importance of variables properly for each repeat-by group.
Analytics: When navigating between a branch data frame and the parent data frame, a blank screen was shown after a branch data frame failed to execute.
Analytics: Wilcoxon Test, Kruskal-Wallis Test: Misleading the "MEAN" label for the Value column is removed.
Analytics: Word Count: Added random seed so that co-occurrence network result is stable.
Analytics: Word Count: The layout algorithm for the co-occurrence network is improved, and made more adjustable.
Parameter: After clicking the parameter icon, Parameter UI was not displayed when there was a parameter that refers to a missing data frame.
Note: Corrected popup text for "quote" icon in toolbar.
Note: There were cases where embedding of Chart in Note did not work because the generated chart referencing tags were malformatted.
Slide: Disable the Slide feature.
Dashboard: Changed to set bigger default row height when adding a new row.
Dashboard: When opening a dashboard, the previously opened dashboard was displayed before it showed the selected dashboard.
Dashboard: When stopping publishing a dashboard, it generated output and captured thumbnails where it shouldn't.
Dashboard/Note: Added the 'Export' button to the catalog tree menu from where users can download an EDF file.
Export: Now the chart thumbnails are shown from right after importing the EDF file or .df file.
Export: Project export from a repository on a network drive such as Google Drive consumed a lot of memory.
Export: When exporting a chart as EDF, it showed an error dialog when the chart uses a Parameter that refers to a missing Data Frame.
Project: When clicking the Update button for project rename, it did not respond for some project.
Project: When renaming a project to an existing conflicting name, the Update Name dialog showed an error but the project name on the list was updated with the duplicated name.
Install: Intel Mac run on a virtual machine environment was mistakenly considered to be an M1 Mac by the installer of Exploratory.
Installation: Improved error message when package installation failed.
Installation: When selecting a folder for Exploratory Repsotiory, it now validates the write permission on the folder and shows an error message if the user does not have the permission.
Installer: Git installed with Exploratory is upgraded to the latest 2.33.0 (Windows) and 2.32.0 (Mac).
Installer: Rcpp package installed with Exploratory is upgraded to the latest 1.0.7. This should resolve some of the problems in installing custom R packages from CRAN that worked only with this version of Rcpp.
General: If a double-quote was used in the password, login was required each time Exploratory Desktop was started.
General: Performance of loading or updating data on Windows was slower than it should have been because of a workaround we did around writing data to a parquet file for caching of data. Now the root issue with Parquet is fixed and we removed the work-around that was causing performance degradation.
General: When an incorrect password is used at the login UI, it showed an unrelated error dialog.
General: When exporting a Project as a zip file, it didn't show a spin icon and could not tell when the operation finished.
Generic: When clicking open Publish Dialog, it didn't show any error message when the Exploratory Desktop was offline.
Released on 6/24/2021.
Data Wrangling: Summarize Group: Supported Min and Max for Character Columns aggregation function.
Analytics: Text Analysis: Added "Words - Data" tab that shows and allows export of tokenized text data.
Dashboard: Maps in the Dashboard now remember the zoom level and center position if you update Maps in the Dashboard preview.
Data Source: Amazon S3/Google Drive: Changing file selection on Import Data Dialog showed there was another R running error.
Data Source: Clicking the Parameter link on the R Script Data Frame dialog did not respond.
Data Source: CSV/Excel Files: The file list is now sorted by Date Modified Column.
Data Source: Google Analytics: It failed to load data when the 'Goal 8 Completion' measure was selected.
Data Source: Google Analytics: View ID didn't have the required prefix and failed to load data for some occasion.
Data Source: Importing Remote CSV failed and showed another R process running error.
Data Source: Remote CSV File: After changing the URL, clicking the Run button did not refresh the preview table.
Data Source: Remote CSV File: Failed to load data when loading took more than 60 seconds.
Data Source: Salesforce icon on OAuth Dialog was squashed.
Data Source: When trying to import multiple CSV files with the "All" or "Conditions" option, changing the "Skip first N rows" parameter did not work.
Data Wrangling: Filter: If a filter step had only one token and was disabled, there was no way to enable the token back.
Data Wrangling: Right hand-side step showed an empty screen for some occasion.
Data Wrangling: System-Level Timezone was not reflecting on data wrangling steps.
Chart: After reordering chart tabs by drag and drop, chart tabs order was not retained when the App was restarted.
Chart: Pivot Table: Column names in the exported CSV data didn't follow the display names defined in the Chart Property dialog.
Analytics: Factor Analysis: Using factoring method other than Minimum Residual did not work with the error message "Column MR1 doesn’t exist.".
Analytics: Rendering of the Prediction chart in the Random Forest Analytics was very slow if you selected character columns as Predictor Variables.
Analytics: Text Analysis: Error was raised if the input text column had NAs. Now we automatically filter out NA rows.
General: Error Report Dialog showed up when shutting down Exploratory after exporting a project.
General: NANO-Antivirus reported a false alarm with the previous release (6.6.2.3) of the Windows version.
General: The keyword clear button ("x" button) in the search input field should show up only if there is a keyword.
Released on 6/15/2021.
Data Source: Google BigQuery: Supported Page Size on the Google BigQuery Setup dialog. And now you can import the full result from a SQL query with many columns by setting a small number to the page size.
Analytics: Factor Analysis: Now X/Y axis labels of the biplot show the percentage of variances the factors can explain.
Analytics: Text Analysis: Now, "Words To Be Treated As One Word" does not need to be specified with separating spaces for languages like Japanese, which are without word-separating spaces.
Analytics: Factor Analysis: Added Summary tab that shows info such as the significance of the factor analysis.
Data Source: Google BigQuery: Clicking BigQuery icon on the Database Data Source dialog showed 'Error: Not found Dataset' when the selected billing project does not have any dataset.
Data Source: MongoDB: Improved error message for SSL issue with Mongo Atlas connection.
Data Source: ODBC: Could not add a new ODBC connection.
Data Source: Salesforce SQL: When selecting a table from the schema tree, now it inserts the table name to the query editor.
Data Source: Salesforce: Improved error message for the case where the user did not have the Modify Metadata permission.
Data Source: Salesforce: Improved UI by switching Filter and Run button positions.
Summary View: The download button and configuration button overlapped each other in the Correlation toolbar.
Chart: If you exported chart data with reference lines to the CSV file, internal column names were shown up for the reference line data.
Chart: Table search performance improvement.
Chart/Analytics: The property dialog didn't close when you moved to a different view such as the Summary view or closed the project.
Analytics: Clicking outside the property dialog shouldn't close the dialog.
Analytics: Correlation: Error "f must be a factor (or character vector)." was raised if the names of all the input columns are numbers.
Analytics: Time Series Clustering: Error "There are missing values in the series" was raised if one or more of the time series were constant.
Note: Chart failed to render if the chart name contained special characters such as "‗" on Windows.
Dashboard: Improved UI by aligning row height between runtime and design time.
Dashboard: Left and right margins were uneven in the preview screen.
Dashboard: Set Height Evenly Button overlapped with Published Icon.
Dashboard: When in Fit to Screen Mode, adding a new row pushed the page down and it overflowed vertically.
Dashboard: When switching from 'Fit to Screen' mode to 'Fit Within the Specified Height' mode, row height unexpectedly changed where it should keep the same height.
Installation: R: Improved Installation UI and now it shows CPU architecture name along with R version.
Released on 6/10/2021.
Data Source: Supported Salesforce Data Source.
Data Source: Now you can search tables in Database Import Dialog.
Summary View: Now you can choose which algorithm to use for the Correlation mode. 2 new algorithms (Decision Tree and Random Forest) are added.
Summary View: Now you can export the Summary View data in the CSV and Excel format.
Data Wrangling: Supported the date picker on the Filter dialog.
Chart: Now you can create an Error Bar with the summarized data.
Chart: Analytics: Supported 'Export to Google Sheets' option in the Chart/Analytics export menu.
Chart: Now you can change the circle size and line width in the Error Bar.
Chart: Now you can draw Reference Lines for each color.
Chart: Now you can search the content in the Table from the toolbar.
Analytics: Added a new Factor Analysis Analytics View.
Analytics: Added new Text Analysis Analytics View with word cloud and co-occurrence network.
Dashboard: Supported the option to set row height equally.
Data Source: At EDF import, if the creation of a missing connection was canceled, the Summary View was not refreshed with newly imported data.
Data Source: Athena: Switched to use odbc package instead of RODBC package.
Data Source: CSV and Excel files were not shown when the file extension was the upper case.
Data Source: Deprecated the Dremio data source.
Data Source: Google BigQuery: Supported datasets search feature on the import dialog.
Data Source: Google BigQuery: When updating or refreshing a data frame, an Invalid Project ID error was raised.
Data Source: Google Drive: After Importing a CSV or XLS file, clicking on the Refresh icon did not update the content.
Data Source: Google Drive: Could not switch a data source to another data source type.
Data Source: Google Drive: When trying to re-select the folder for the existing Google Drive Data Frame, it didn't show files under the folder.
Summary View: A chart created by the chart button in the Summary View always shows a 95% confidence interval range even if it is set to 99% or 90% in the Summary View.
Summary View: If you created an Analytics from the column header menu in the Correlation mode, the busy icon disappeared before finishing the chart rendering.
Data Wrangling: Added 'Convert Excel Numeric to Date' menu for character data type column menu.
Data Wrangling: Added 'Unite' to the column header menu.
Data Wrangling: Replace Values with Conditions UI: The cursor was not inside the input field when opening this dialog.
Data Wrangling: For the Date and POSIXct column menu, changed it to show Create Calculation Dialog with impute_na command for the missing value operation.
Data Wrangling: Filter: Improved UI by removing the extra spaces.
Data Wrangling: Rename Dialog: Corrected the error message display position and fixed the issue that the error message was not cleared after name conflicts were resolved.
Data Wrangling: Right-hand side steps became empty when the underlying metadata file was broken.
Data Wrangling: Now it only shows SQL query on source steps.
Data Wrangling: Update text for Repeated Space.
Chart: The "Show Detail" and "Exclude" options disappeared after changing the "# of Columns" options in the chart toolbar.
Chart: Exporting the chart data to the CSV failed if the path to the folder contained single quotes.
Chart: Reset the skipping unique value check setting when you assign a new column.
Chart: Values should start from the bottom to the top by default in the Stacked Bar and Area chart.
Chart/Analytics: Column selection should show a Pop-up for the long column names when you hover it.
Analytics: It shouldn't create number buckets if you assign a numeric column that contains only a couple number of unique values to the Color By or Repeat By.
Analytics: The "Color Sort Order" chart property was missing in the Chart Property dialog in the Analytics view.
Analytics: The Variable Importance Bar chart failed to render and showed an error dialog with a message "key.replace is not a function".
Analytics: Y-Axis Range setting was not effective on the Prediction chart in the Linear Regression analytics.
Parameter: When switching LOV type from Character to Logical, it kept showing the Character list where it should show TRUE/FALSE.
Publish: Data Share: CSV option is now checked by default.
General: Git-related error was raised at closing a project if the password included single quote characters in the Public edition.
General: Error "Cannot read property 'type' of undefined" was raised if the join/merge target data frame was renamed/removed if its name included '-'.
General: 407 Proxy Authentication Required” should show appropriate error message rather than error report dialog
General: Certified R that runs natively on Apple silicon Macs (M1).
General: Certified R4.1
General: do_tfidf function miscalculated tf-idf.
Released on 5/12/2021.
Released on 5/11/2021.
Data Wrangling: On Replace Values with New Values dialog, there was no way to edit mapping for values that didn't exist in current data.
Data Wrangling: Separate Dialog: Corrected the position of the ‘Reset’ button.
Data Wrangling: The Source Step was overridden by the data wrangling step for some occasions.
Data Wrangling: Text Wrangling UI: Changed not to show NA on the preview table.
Data Wrangling: Text Wrangling UI: The Number of Preview Rows pulldown list showed unnecessary options when there were fewer than 1,000 preview rows.
Chart: Bar Chart was slow to render if you had a lot of unique values in the column for the X-Axis and specified the Sort By option.
Chart: Bar: Even if you limited the number of bars to 1,000 by the value using the Limit. it rendered more than 1,000 bars if there were ties in values.
Chart: The Highlight dialog didn't open by clicking the green Highlight info text after choosing 'Add All Values' in the Unique Value Check dialog.
Chart: The busy icon kept spinning if you created a chart from a character column that had a lot of unique values in the Summary View.
Chart: The Unique Values Check dialog should be draggable.
Chart: The default 'Group By' option of the Window Calculation didn't work as expected if you created a new Window Calculation.
Chart: You couldn't add the 2nd color condition by clicking '+' in the Column Formatting dialog.
Analytics: After moving the empty analytics tab by drag and drop, a blank analytics chart content was shown.
Export: In some cases, the last steps of data frames imported via the EDF file were missing.
General: When the last name was not set on the Account page, Exploratory Desktop showed the user ID instead of the user display name.
Released on 5/6/2021.
Data Source: BigQuery: When importing data failed, the error message dialog didn't show up.
Data Wrangling: Made the drag and drop data frame list resizer easier to grip.
Chart: Values on the plot area were off on the Stacked Bar chart if you assigned a character column with only numbers such as "1" or "2" in the data to X-Axis.
Chart/Analytics: After opening the filter dialog for an existing chart or analytics filter, clicking the Close button showed a Delete Incomplete Filter dialog even if the required field is entered.
General: On Windows, if Display Scaling is set as more than 100%, it showed an empty screen after selecting a data frame.
Released on 5/4/2021.
Released on 5/2/2021.
Data Source: S3: You can now search the bucket.
Data Source: CSV Import: Improved 'C stack usage is too close to the limit' error message when the Data Separator mismatch happened.
Summary View: Now you can set how many columns to show.
Chart: It should show a dialog to select either 'Limit' or 'Other Group' when assigning a column with too many unique values.
Chart: Summarize Table: Now you can choose numeric operators such as 'Greater Than' for the conditional color formatting for the logical columns.
Chart: Now you can hide axis labels from the Chart Property dialog.
Data Wrangling: Now EDF import dialog validates a file extension and shows an error message if a non-EDF file is selected.
Data Wrangling: Support parameter syntax for 'Replace Values By Setting' conditions.
Parameter: Now you can hit the Enter Key to execute inside the Parameter pane.
Project: Now the 'data frame export' exports all the data frames that are referenced (e.g. via Join) from the main data frame you are trying to export.
Data Source: After switching a data source, it updated the Data Frame as a merged Data Frame even if there is only one file associated with it.
Data Source: Google Drive: 'Error in curl::curl_fetch_memory(url, handle = handle) : Error in the HTTP2 framing layer' raised while navigation file list.
Data Source: On CSV/Excel Import dialog, Added 'Change' button from where you can change file selection.
Data Source: On Windows, Installation of Historical Stock Prices Data Source Extension failed while installing dependency package tidyverse.
Data Source: S3: Couldn't select a bucket when the AWS account did not have the list bucket permission.
Data Source: S3: On the file list dialog, folder structure was not properly shown and files with the same name displayed multiple times.
Data Source: When opening the Update Data Source dialog for the Data Frame created before version 6.5, the dialog title showed 'Import and merge' even if the Data Frame was created from a single CSV file.
Data Source: When updating the existing data source for a CSV/Excel file, 'Select', 'All', 'Conditions' radio buttons were displayed on the file list dialog even if the Data Frame was created from a single file.
Data Source: Google Drive: When a file name contained trailing space, it did not show up in the file list.
Data Wrangling: Added text label for 'Confidential Interval Functions' in the column header menu.
Data Wrangling: Clicking a link in the function help dialog opened the document inside the Exploratory Desktop application.
Data Wrangling: Filter: The 'Create Parameter' link remained after switching to the Custom tab.
Data Wrangling: On Windows, when exporting data to Google Sheets, if a spreadsheet name that has multibyte characters is specified, those characters are garbled in the resulting spreadsheet name.
Data Wrangling: summarize_group function was inappropriately suggested in Mutate or Filter expression dialog.
Data Wrangling: When creating a branch, it showed 'Cannot read property 'then' of undefined is raised for some occasion.
Data Wrangling: There were cases where Analytics View was lost when the Data Frame on it was renamed, if the "Predict with Model" Step was used.
Data Wrangling: When clicking the Cancel button on the Update Data Source dialog, the data frame selection was removed from the data frame list.
Data Wrangling: Opening an existing data frame failed with an error "Invalid UTF8 payload" once in a while.
Chart: Chart Filter: When hovering over the long filter condition, the text inside the popup overflowed.
Chart: Summarize Table: The total value was incorrect if you set the 'Calculation Target' in the Total Setting dialog to 'Data Before Aggregation' and assigned a logical column to the Value with the '% of TRUE' aggregation function.
Chart: Scatter: If you assigned a character column with numeric character data to the Label, the number formatting was applied to the data.
Chart: Values on the plot area didn't align if you assign many columns to Y-Axis in the Bar chart with 'Grouped' Bar Chart Type.
Chart/Analytics: Filter: Now it shows a confirmation dialog when trying to close the Filter dialog without entering the required fields.
Analytics: Chart content was messed up unexpectedly by drag-and-dropping an Analytics tab.
Analytics: Correlation Analytics View raised an error with the message "'x' must be a numeric vector" when all the input columns were logical type.
Analytics: Correlation: The Significance chart showed an error "Invalid response (expecting SEXP)" if you chose too many columns.
General: An error "Cannot read property 'getId' of null" showed up right after creating a Script and moving to a Data Frame.
General: If the 'Predict with Model' step was used, there were cases where an error with the message "Cannot read property 'get' of undefined" was raised when trying to duplicate or rename the existing data frame.
General: Server: When a Script was imported through an EDF file downloaded from an On-Premise Exploratory Server, its internal ID was displayed in place of the name of the Script.
Released on 4/19/2021.
Release announcement: https://blog.exploratory.io/exploratory-v6-5-released-6ccb768993f3
Generic: Now you can resize the data frame list width by drag and drop.
General: Now a Data Frame can be exported/imported as a .df file, with Charts and Analytics on it.
General: Now you can search objects such as Data Frames, Branches, Charts, Analytics, Notes, Dashboards, and others in the project by name, description, and comment.
General: Upgraded to R 4.0.5 for the new installs.
Data Source: Support importing multiple CSV (or Excel) files from Amazon S3, Google Drive, or local drive.
Summary View: Correlation Mode: Now it supports 3 types of visualizations - "Aggregation", "Distribution", and "Uncertainty".
Data Wrangling: Filter: Added a support for the "Keep NA" option for the "Not Contain" filter operator.
Chart: Now you can show values on the plot area in Heatmap.
Chart: The setting for Pivot Table / Summarize Table / Table / Number are now preserved when switching to other chart types.
Chart: Added more Patterns (e.g. dotted line) for the Line chart.
Chart: Pivot Table: Summarize Table: Now you can choose the total/subtotal calculation timing either before or after the summazing calculation.
Chart: Pivot Table: Now you can set the max number of rows to display from the chart property dialog.
Chart: Word Cloud: Now you can set a column to Size that is different from the one assinged to Color.
Chart: Now the sorting is applied before applying the cumulative Window Calculation.
Chart: Now you have more date formatting options on X-Axis.
Chart: Now X-Axis is sorted by the ratio of the first category value if you use "% of" Window Calculation.
Chart: Table: Added 'Date' formatting.
Analytics: Correlation: Added Significance tab to show P values of correlations.
Analytics: Correlation: Now you can show the correlation values on the Heatmap chart.
Analytics: Correlation: Positive Correlation tab and Negative Correlation tab are combined together into a Data tab.
Analytics: Added a new 'Time Series Clustering'.
Analytics: Time Series Clustering: "Normalize" option is added to the existing Analytics Step and new Analytics View.
Analytics: Added a new variance-based variable importance (FIRM) algorithm support.
Data Source: Google BigQuery: After creating the connection, the Setup Dialog didn't close after clicking the OK button.
Data Source: Google BigQuery: It showed Error in curl::curl_fetch_memory(url, handle = handle) : Error in the HTTP2 framing layer for some occasion.
Data Source: Google BigQuery: 'Import via Cloud Storage' did not use Cloud Storage but loaded data as a stream.
Data Source: On the SQL import dialog, when clicking the edge of the Run button, it did not execute the updated SQL query.
Data Source: Error was raised from refreshing Custom R Data Source Step right after EDF import.
Summary view: If you created a bar chart from the Correlation mode, the default aggregation function became "Sum". It should be "Mean".
Summary View: It showed an incorrect number of NA values if there were character data starting with "NA".
Summary View: Summary View showed a blank screen when navigating from Analytics view that had an error.
Table View: Now the Table View shows numbers with decimal separators.
Data Wrangling: The "Numeric Type convert" option was not available when selecting multiple logical columns.
Data Wrangling: After copying a data frame, the hover pop-up didn't show chart thumbnails.
Data Wrangling: After deleting a data frame, if you re-used the same name for copying another data frame, the previously selected view was displayed instead of Summary View.
Data Wrangling: On Create Bin UI, changing the method resulted in an error.
Data Wrangling: On the data frame list, the currently Selected Data Frame was unselected when creating a new note.
Data Wrangling: When creating N-Grams, it did not work if the same column was assigned for both Document ID and Sentence ID.
Data Wrangling: Error "Cannot read property 'type' of undefined" was raised if a Data Frame referenced from a step like Join or Merge was renamed.
Data Wrangling: Filter: For the Year / Month option, changed to show the locale neutral example as the placeholder text in the input field.
Data Wrangling: Filter: When today's date is the end of the month such as Mar 31st, the "Previous Month" filter operator did not work.
Data Wrangling: The Merge step should not show its own Data Frame or Branch as a possible target.
Data Wrangling: Mutate Multiple Dialog: Right-hand side options were not shown for data types other than character and logical.
Data Wrangling: On Summarize Group dialog, when typing the Japanese column name in the custom expression editor, the expression was removed.
Data Wrangling: Recreating a branch leads to a strange state where the main branch source is selected while viewing the branch.
Data Wrangling: The "Remove Text with Range Positions" option didn't work with a negative index.
Data Wrangling: Improved text for POSIXct and Date column menu label for Replace Value by Setting Conditions.
Data Wrangling: Added summarize_row function for summarizing values in different columns for each row.
Data Wrangling: The Text Wrangling dialog accidentally closed when selecting the "Extract Range of Text" option.
Data Wrangling: When creating a logical parameter from the Filter Dialog, the default value is not properly set, and an R error was raised.
Data Wrangling: When deleting a not selected data frame that had charts, it ended up showing duplicated charts when creating a data frame with the same name.
Data Wrangling: When exporting a data frame, it didn't show a spin icon.
Data Wrangling: When importing a data frame, the newly selected data frame was not selected for some occasions.
Data Wrangling: When splitting a filter step that contained a disabled token, an error with the message "Assertion failed" was displayed.
Chart: The "Tick Label Auto Scaling" option was missing in Line and Area charts.
Chart: A grayscale color palette should be added to the color palette list for publications.
Chart: Adding Limit on Word Cloud Word, Enabling Limit by default on Bar X and Word Cloud Word.
Chart: Bubble: The "As Numeric" function didn't work in the same way as other numeric functions such as "As Integer".
Chart: Bubble: No P-Value showed up in the Trend Line if number columns were assigned to both X and Y axes with the "As Integer" function.
Chart: Bubble: Trend Line was off if number columns were assigned to both X and Y axes with the "As Discrete" function.
Chart: Highlighted items didn't come at the top in the legend area if you chose the "Horizontal" orientation in the Bar chart.
Chart: You couldn't access the Color Setting if you had multiple columns assigned to Y-Axis and no column for Color.
Chart: Map: When you created a Map and assigned a column to the Color, the green information text for the "Equal Width" bucketing option didn't show up.
Chart: Now the text sort for non-English text in the legend is consistent between Windows and Mac.
Chart: If you used Repeat By and you had only 1 small multiple, it should use the full width of the chart view area regardless of the layout setting.
Chart: Summarize Table didn't show the green information text for the "Other Group" setting if a date column was assigned to "Group".
Chart: If you exported a Pivot Table to Excel, the numeric data were treated as text if the numeric column contained NA values.
Analytics: When in Analytics View, the spin icon was removed in the middle of switching the data frame.
Analytics: Correlation by Category Step: With Japanese UI language, sum and medial labels are not translated in Japanese.
Analytics: Correlation Step: The View type selector disappeared when selecting columns in the Column Selection dialog.
Analytics: Improved the UI by reducing unnecessary space between Analytics tabs.
Analytics: K-means: Stacked Bar failed to render and showed an error if there were many unique values in the column assigned to the Label Column.
Analytics: Market Basket Analysis Step: Auto-selection of support threshold is made available on Analytics Step too.
Analytics: After moving the Analytics tab by drag and drop, selecting the Correlation Analytics View tab sometimes hangs.
Analytics: Time Series Forecast (Prophet): Made built-in country holiday data available for Analytics Step too.
Analytics: Random Forest, XGBoost: Column name with single quote character raised an error with message "error code 3".
Analytics: Total number of groups showing up in the "Other Group" green information text for a Date column was incorrect.
Analytics: Configuration on the type of variable importance was lost when the type of prediction model was switched.
Analytics: XGBoost: Horizontal scrollbar was not fully displayed when there were many analytics tabs on the Analytics View.
Analytics: K-means / PCA: If columns with types such as list, difftime, etc. were there in the input Data Frame, an error with a message such as "unimplemented type 'list'" was raised.
Analytics: Logistic Regression / GLM Binomial: Output column from prediction with new data "predicted_response" was renamed to "predicted_probability", just like other binary classification models.
Note: Charts didn't show up correctly if you restored the content from the history and clicked the preview.
Note: When opening a note, it did not show a spin icon.
Note: When opening a note, related data frames were not highlighted.
Note: When you opened a note in the full-screen mode, you couldn't close the note window.
Note: If you exported a note containing a Pivot Table with color as a Word Document, the Pivot Table in the exported document had unexpected data.
Slide: Clicking the "Fit in Screen" checkbox on a chart took you to the next slide.
Dashboard: Hitting the "Run" button on Dashboard reran steps after reference to an empty-list Parameter even if the Parameter is not changed.
Dashboard: When editing a dashboard, the "Set Height" label was always displayed even if the option was not selected.
Dashboard: When moving from "Fit to Screen" mode to "Fit Within the Specified Height", row height got shrunk.
Dashboard: When resizing a Dashboard Window, it triggered unnecessary re-rendering and took some time to finish.
Dashboard: When there is an empty row, now the "add new row" menu becomes disabled since adding repeating empty rows is not supported.
Parameter: After running a parameter without a default value, it showed the previous default value when opening the Parameter UI.
Parameter: Changed to always show the "Display As" input field.
Parameter: When running a parameter, changed the default for the "Auto Run" as unchecked.
Parameter: When creating a logical parameter, clicking on the Default checkbox didn't select all the options.
Parameter: Error was raised at importing EDF file with a Date / POSIXct Parameter with a relative date default value.
Parameter: It didn't create a parameter when clicking "Create Parameter" in the Filter dialog.
Parameter: Parameter appeared in filter command as @{[object Object]} if the parameter is picked implicitly as a result of operator change.
Parameter: The same column name showed up twice for the list of values' column selector.
Parameter: When changing parameter type from Date to Text, default date value type remained and it caused the unexpected default value was set for the parameter at runtime.
Parameter: When creating a new parameter, an existing parameter display name was pre-populated for the display name of the new parameter.
Parameter: When using the multi-select list of values parameter for filter "Is In" operator, it showed an empty screen when trying to open Parameter UI.
Parameter: When using the "today" as the default value of the Date parameter, if today was outside of min and max values, the parameter was not properly rendered.
Project: After deleting a custom R package, clicking the "Auto fix" button or the "Open (No User R Package)" button on the confirmation dialog did not open the project that referred to the R package.
Project: Clicking a script didn't highlight itself in the catalog tree.
Project: On the Project List, when a search keyword exists, if you delete a project then the unmatched project is also displayed as a search result.
Project: When clicking the Create Project button, it flickered.
Project: When closing a project, there was a lag even though the project did not have any data frames.
Project: When exiting a project, there was a case where you keep seeing an Error dialog and cannot exit the project.
Publish: Insights published to an on-premise Exploratory Server before hostname / IP address change was not recognized by Exploratory Desktop after the hostname / IP address change.
Publish: When publishing an insight with Google Sheet Data source, etc. which was just imported via EDF file, without creating a Connection for it in the Project, it failed.
Export: Exporting EDF file into another drive, such as D: drive or Google Drive failed and showed an error “cross-device link not permitted, rename”.
General: Creating Project could fail because of an error from the user's custom pre-commit Git hook (e.g. git-secrets).
General: .git directory was included in exported Project zip files, but we stopped including it for size reduction and speed.
Released on 3/1/2021.
Data Wrangling: Added the 'Replace Values By Setting Conditions' menu to the logical data type column header menu.
Data Wrangling: Fill NA with Predict (impute_na) raised an error when the first row's value of the first predictor column was 0 or NA.
Data Wrangling: Closing the Join dialog without selecting Key Columns created an invalid step.
Chart: No rows showed up in the 'Show Detail' dialog.
Chart: Unnecessary '%' signs showed up on the chart plot area for NA values when you set the 'Show Values if Greater than This Value' option in the chart property dialog.
Chart: Values on the chart plot area showed the percent numbers with '%' signs for Y-Axis columns when it was not necessary when you used the 'Repeat by Y-Axis Column' feature.
Analytics: Table columns in the Summary tab were not translated (Japanese).
Dashboard: When adding a chart to a row, charts' widths were not proportionally distributed.
Dashboard: When adding a chart to an existing dashboard created with the previous version, the added chart's width was not adjusted properly.
Released on 2/25/2021.
Data Source Extension: After publishing the Weather Data, clicking the 'Run Immediate' button didn't refresh the data.
Data Wrangling: After a data wrangling step error was resolved, the error indicator icon on the data frame was not cleared right away.
Data Wrangling: The spin icon disappeared before a new step was completely added to the right-hand side step list.
Data Wrangling: Text Wrangling UI: Improved the error message for when it failed to load a large preview data.
Chart: When duplicating a chart, there was a time lag until the chart menu became active when there were many charts.
Analytics: If you ran the Random Forest with 3.600 variable columns, it failed to run and showed an error 'invalid response (expecting SEXP)'.
Analytics: model_info function threw an error 'object
Note: If you had an HTML script tag for Speaker Deck slides in a published Note, the loading bar kept showing for a long time even if the content was already loaded.
Dashboard: After changing the Text Box width by drag and drop, the updated text was reverted to the original one.
Dashboard: Set Height Mode: Adding or deleting a row changed other rows' height unexpectedly.
Publish: After republishing a publicly published insight to make it private, a new URL was assigned, where it should keep the original URL.
Parameter: Starting to use Parameter on the Server failed if the Insight had a Parameter that was based on another Data Frame.
Project: On Windows: When exporting a project as a zip file, non-ASCII characters in the project names were removed from the default name.
Installation: On the Proxy setup dialog, the port number input field implies 8080 as the default port, but port 80 was actually used as the default port.
General: On Japanese Windows, when publishing data that include Dame-moji, the table view on the published data didn't show data.
General: There was no way to switch server or account when the associated Collaboration Server license had expired or the user was a viewer.
Released on 2/15/2021.
Data Wrangling: Filter: For the 'Last N Months' operator for POSIXct column, changed to use as_date function instead of as.Date function to make sure the correct timezone is used.
Chart: Bar chart failed to render and showed an error "Assertion failed" if you left the "Value" field empty and hit the "Apply" button in the Logical Condition dialog.
Chart: After removing the Chart Pin, selecting a different data wrangling step didn't refresh the chart.
Analytics: Time Series Clustering: Since the random seed was not set, the result changed for each run. Now the random seed is set by default, and you can change it if you like in the dialog.
Dashboard: When opening a dashboard created with the previous version on Set Height mode, it didn't honor the previously set row height.
Dashboard: Scrollbars showed up in Number charts once in a while in the Preview mode.
Released on 2/14/2021.
Chart: Now the "CSV" Download option is available when you publish a Chart or Analytics. If you check this option, you can download the data used for Chart/Analytics in the CSV format from the published Chart/Analytics insight page on the server.
Chart: If the "# of Columns" was set to 1 or 2 with Repeat By, the height of the chart is now set to the window height, which will make it easier to see the charts when there are multiples.
Chart: Table: It now supports 'Apply' button so that you can setup the formatting and see the result in preview without closing the setup dialog itself.
Analytics: Added a checkbox to enable/disable data sampling for the prediction models under Analytics Views.
Analytics: ARIMA: The hover popup on the line chart in the Stationarity tab now shows how many differentiations and/or seasonal differentiations were applied on the original data to get the displayed differentiated data, which the stationarity test is performed on.
Analytics: Time Series Cluster: The default algorithms were changed to 'DTW with L2 Norm' and 'DTW barycenter averaging' to make it more robust for various type of data. They used to be 'Soft-DTW' and 'Soft-DTW center' respectively, which could throw an error like "gradient of objective in x0 returns NA" when a given data includes an outlier time series.
Analytics: Random Forest / Decision Tree: Prediction with a binary classification model under Analytics View now returns the original target column as Logical data type rather than Factor data type under the Data tab.
Data Wrangling: Summarize Dialog: Now the column names of the result do not have an aggregate function as suffix unless the same column used multiple times.
Data Source: Improved Teradata Data Source for the performance and multibyte characters handling.
Dashboard: When you change the page height with 'Set Height' mode, now it adjusts the height only of the bottom row and keeps heights of other rows as original.
Dashboard: Now it dynamically shows the current row height and column width while adjusting them by drag and drop.
Data Wrangling: Moved 'Keep Only' menu to under 'Filter' of the column header menu when multiple columns are selected.
Data Wrangling: Number of rows was shown as 0 when directly opening a chart view of a branch data frame.
Data Wrangling: 'Predict with Model (Analytics)' Dialog: The order of model pull-down list items did not match with the order of the tabs under Analytics View.
Data Wrangling: When you duplicate a data frame and give a conflict name that is used by another data frame, an incorrect '[Object object]' error message was shown.
Chart: Chart Table: When trying to remove a column that didn't exist anymore, the Column Selection UI hung.
Chart: Density Plot chart failed to render with an error when an assigned column's values are mostly NA.
Chart: 'Show Details' didn't open if the chart had a chart filter with the 'Last N Months' condition for a POSIXct column.
Chart: The Custom Calculation dialog didn't validate the expression even if the expression didn't aggregate the data and returned more than one row.
Note: If you opened a Note with a Pivot Table created in an older version of the desktop without opening it in the Chart view, it showed the '|||' sign in the Value cells.
Parameter: At the publishing of insight, now we do a validation check on whether the Data Frames referenced from Parameters for list-of-values or range actually still exists. This will prevent the scheduler from trying to load non-existent parquet/rds files and ending up throwing an error.
Installation: Setting up the proxy configuration during installation caused the installation process to hang.
General: When the 'request offline license key' button was clicked, there was no way to see the required information if the PC did not have a mail client setup.
General: Clicking on the sort icon of the 'Updated' column on the Project List page did not sort the project names correctly when the system locale is set to a Russian locale on Windows PC.
Released on 2/8/2021.
Data Source: Data Source Extension dialog now has the 'Details' button from where you can open each Data Source Extension's help page in a browser.
Data Wrangling: Create Bin: The 'Column to Categorize' field was not shown.
Chart: Exported CSV data was separated by "|||" in Summarized Table and Pivot Table.
Chart: If you used a custom calculation, it didn't multiply values by 100 even if you chose 'percentage' for the number formatting.
Chart: Now you can choose "None" for the bucketing type at Color to disable the color bucketing in "Map - Standard", "Map - Extension", "Map - Long/Lat" and "Bubble" charts.
Analytics: Data tab failed to render and showed an error "Cannot read property '0' of undefined".
Dashboard: Dashboard didn't show in the same layout (height/width) configuration as it used to in the previous desktop version even without a change made for resizing the row/column.
Dashboard: Resizing a dashboard row height by drag and drop was not smooth and difficult to set desired height.
Dashboard: Dashboard row height/ratio was different between the design mode and the preview mode.
General: Mac: Removed HTTPS option from Proxy Setup UI since Mac does not support HTTPS for proxy.
General: With the existing proxy setup, remote file data source and web scraping did not work after upgrading to 6.4.1.
General: Windows: When making the window size to full, it showed an empty screen for some occasions.
Released on 2/4/2021.
Data Source: Connection Test failed with "type 26 is not implemented" error for Teradata connection.
Data Wrangling: Not all rows were copied to the clipboard when exporting data to the clipboard on Windows.
Data Wrangling: Filter: When a character parameter was used along with the 'Ignore Case' filter option, an empty string was not detected with the filter.
Chart: Table: Column Selection dialog disappeared when the chart was pinned to a step that had no rows and selected a column from the list.
Chart: Histogram failed to render and showed an error "Problem with summarize()" if Limit was set on Color.
Chart: It shouldn't create categories on number values on X-Axis if the number of unique values is not too many when you switch the chart type from Scatter to Bar.
Chart: Line chart failed to render and showed an error “q is not a function”.
Chart: Pivot Table didn't show Value cells property if the column for the Value contained ',' in the value.
Chart: Summarize Table failed to render and showed an error “Cannot read property 'url' of null” when a column at Row was removed.
Chart: Summarize Table: "Hide" menu was missing for columns at Row in Summarize Table.
Chart/Analytics: In the multiple columns selection dialog, the preview table didn't show preview results once in a while because the previous R process was still running.
Analytics: "GLM - Gamma" Analytics failed and showed an error "no valid set of coefficients has been found".
Analytics: ARIMA: Auto correlation with lag 0 was shown in the ACF bar chart.
Analytics: ARIMA: Bars for negative ACF values were not shown in the ACF bar chart.
Analytics: Cox Regression: At the Data tab, you couldn't select the "All" option from the "Rows" drop-down in the toolbar.
Analytics: Sample size should be configurable at the Analytics control pane.
Dashboard: After resizing a dashboard window, clicking an URL in a table inside the dashboard opened another Exploratory Desktop window where it should open a browser.
Dashboard/Note/Slides: Wordcloud didn't refresh even if you updated parameters on the browser in the published Dashboard, Note and Slides.
Dashboard: Unnecessary Dashboard refresh was performed if you clicked the information ("i") icon in the toolbar.
Parameter: Error "type 26 is not implemented" was raised when the parameter was used in a Data Source Step.
Parameter: When opening a parameter pane, it didn't show a spin icon while loading the list of values.
Project: Could not enter an URL for Public Project Import UI.
General: Even after setting correct proxy info, re-login still failed until restarting Exploratory.
Released on 1/26/2021.
Data Source: Now you can adjust "Max Tree Depth" and "Max List Size" when you load JSON data in the JSON data import dialog.
Data Source: Supported Snowflake as a new data source.
Summary View: Now you can create Anova, Wilcoxon and T Test from the Correlation view.
Data Wrangling: Tokenize Text: Now you can sort results by 'Document ID'.
Data Wrangling: Separate: Added 'Combine with Original Column Name' parameter.
Chart: Now you can add vertical reference lines in Bar chart.
Chart: Summarize Table: Table: Now you can customize column header formatting.
Chart: Now you can disable using unit abbreviations such as "k" or "M" on the chart axis by the "Shorten Numbers" option in the Chart Property dialog.
Chart/Analytics: Changed the default name for copied charts/analytics to have "-x" suffix where x is a number to make the name unique.
Analytics: Time Series Forecast Analytics View with Prophet now supports quarterly and monthly seasonality.
Analytics: Now you can adjust how many rows to show for the Table data under the "Data" tab.
Analytics: Time Series Clustering is added as a new Analytics Step.
Data Source: Added "Optional" label for an optional parameter to make it obvious.
Data Source: Removed an old MS SQL Server (DSN) option from the Data Source selection dialog.
Data Source: When trying to add a Teradata connection, UI became empty and hung.
Summary View: Loading Summary View was slow comparing to the previous version for Windows.
Summary View: P Values under 0.001 should be shown as "< 0.0001" instead of "0.0000" in the Correlation view.
Summary View: When clicking the Ratio button on Summary Highlight mode, the Ratio button didn't get highlighted.
Data Wrangling: _tam_isDataFrame function, which is an internal function of Exploratory, was included in exported R script for web scraping, CSV, etc., which made the exported script hard to run outside of Exploratory.
Data Wrangling: Filter: On a Filter step, changing the logical operator showed an incorrect "Condition is empty, Do you want to delete" message.
Data Wrangling: For local file data sources, now it shows the file full path when hovering over the source step.
Data Wrangling: Remote File Data Source: Hitting the Tab key inside the URL field was running the preview again.
Data Wrangling: Text Wrangling UI: Preview table showed unnecessary sort icons on the column header.
Data Wrangling: Text Wrangling: Matched text was not highlighted for Replacing Range of Text option.
Data Wrangling: When importing data right after started the App, the Summary, Table, Chart, and Analytics tab labels were shown in English even if the UI Language was set as Japanese.
Data Wrangling: When updating an existing Select Columns step, it didn't allow you to select additional columns.
Chart: After deleting a chart table that included invalid columns, it showed an empty screen.
Chart: After duplicating a chart with a chart filter, when you changed the chart filter setting it also changed the original chart filter setting.
Chart: Show Detail showed no rows if numeric columns were assigned to Y and Color in Bar chart.
Chart: Summarize table failed to render if you added multiple columns to Row and selected "(None)" for the 1st one.
Analytics: ARIMA: In the Summary tab, Repeat-By column wrongly showed up twice.
Analytics: Cox Regression: P-values and coefficients are now displayed in the hover popups.
Analytics: R squared and RMSE are now added to the Summary table of "GLM - Gaussian" Analytics View.
Analytics: When creating an analytics from the Summary View, the spin icon disappeared in the middle of the transition from Summary View to Analytics View.
Analytics: XGBoost: In some cases, multiclass classification threw the error "SoftmaxMultiClassObj: label must be in [0, num_class).".
Note: Publish Dialog got closed when clicking outside of the dialog where it should have stayed open.
Note/Slide/Dashboard: When importing a Note/Slide/Dashboard EDF file, it should open it in a separate window.
Parameter: In some cases, when publishing an Insight, a cached data file for Parameter was missing in the uploaded EDF file, which caused an error when using the Parameter on the Server.
Project: Improved the error message when it failed to open a project due to Rserve start failure.
Project: On Windows, exporting a project failed if the exploratory repository was on a network drive.
Project: When deleting a project from the project list, it didn't show a spin icon.
General: While exporting a Dashboard as an EDF file, it didn't show a spin icon.
General: Windows: Supported Windows-1251 as System Encoding.
Released on 12/30/2020.
Data Source: Added "EDF" option to File Data Source menu.
Data Source: Extension: Added the "Open" button on the Data Source Extensions list. You can click it to open the corresponding help page in the web browser.
Data Source: Github: Improved the error message with a link to the instruction page when authentication with password failed.
Data Wrangling: You can now select "Week of Year - Sunday Start" or "Week of Year - Monday Start" options when you want to get the week number under "Extract" menu of the column header menu.
Data Wrangling: New columns added by the "Predict with Model" step are now getting highlighted under the Summary View and the Table View.
Data Wrangling: Text Wrangling UI: Now you can sort the preview table by clicking the column header.
Data Wrangling: Tokenize Text: Generating N-Gram for Japanese words is now supported.
Data Wrangling: A "cumsum_decayed" function is added. It can be used to calculate Adstock for Marketing Mixed Modeling, etc.
Data Wrangling: Count Text Pair & Tokenize Text dialog: Improved Japanese translation for the dialog title text and the label text.
Data Wrangling: Filter: Now it preserves the selected value in the input field when switching between columns as long as the operator is one of the 'contains', 'not contain', 'starts with', and 'end with'.
Data Wrangling: Filter: Now it preserves the selected value when switching the filter operator between "Equal To" and "Is In".
Data Wrangling: The 'Group By' columns no longer have a trailing suffix with function name when there is no conflict.
Data Wrangling: Improved Japanese translation for Text Pair dialog title and step label.
Data Wrangling: Now the "Country Code" is the default destination for the 'Convert Country' when opening the Text Wrangling dialog from the column header menu.
Data Wrangling: On Rename dialog, added the "x" icon for clearing search text.
Data Wrangling: On Summarize dialog, changed the data type of Number of Rows, unique, etc as Numeric instead of Integer.
Data Wrangling: Replace Values By Conditions: Changed 'Create New Column' option to be the default.
Data Wrangling: Replace Values By Conditions: Now the Condition Setting dialog is draggable.
Data Wrangling: Text Wrangling UI: Changed 'Overwrite Existing Column' option to be the default.
Chart: You can now rename the column names that are assigned to Y-Axis.
Chart: You can now select "Week of Year - Sunday Start" or "Week of Year - Monday Start" options when you want to get the week number for the Date/POSIXct columns.
Data Source: Google BigQuery: When OAuth token was invalid, Google BigQuery Configuration dialog showed an empty project list.
Data Source: SQL Server: Import dialog didn't show an error message and just closed when an error happened during the import.
Summary View: After deleting a data frame while the current view was the Summary View, importing a CSV file ended up with an empty screen.
Summary View: A new Analytics created from the Summary View had a weird name if UI Language was set to English.
Summary View: Emoji data didn't show up correctly.
Summary View: It showed an empty screen when navigating from a branch data frame to the parent data frame.
Data Wrangling: Added description to the column menu for numeric functions.
Data Wrangling: Cached steps did not work correctly if the previous step was updated with some columns being dropped.
Data Wrangling: The column names were not highlighted properly in the Calculation Editor when they contained Japanese character and "_".
Data Wrangling: Replace Values With New Values: The Input field for "Default Value" didn't show up even if you checked the "Set Default Value" checkbox.
Data Wrangling: Table Filter dialog didn't close automatically when moving to other views.
Data Wrangling: When selecting the Row Number from a Window Function Column Menu, the row_number function shouldn't have the column name.
Data Wrangling: Windows: Emoji data used in the data wrangling steps were garbled.
Data Wrangling: When creating a calculation using with_tz function, syntax suggestion showed multiple timezones for the same "GMT" timezone.
Chart: Icons for Column Format dialog didn't show up if column names were long in Column Selection dialog in Table.
Chart: Maps installed locally shouldn't show up in the "Updates" section in Map Extension dialog.
Chart: Table didn't show 0.1 as "10%" even when the "Percentage" number format was applied.
Chart: Visual Formatting condition dropdown didn't show fully if you defined multiple conditions in the Column Formatting dialog.
Chart: "(Number of Rows)" was missing at Label for the 'Scatter (With Aggregation)'' chart.
Analytics: After duplicating an analytics, the "Prediction" tab did not show the content until the green link was clicked again.
Note: Table of Content part overlapped the content body if you opened a note in Safari browser and used the browser's zoom out feature.
Publish: Publishing a data frame that contains empty list columns with enabling "CSV" download option failed and showed "Flat files can't store the list column" error.
Publish: RDS/Parquet files were included in EDF even when no EDF download, Scheduling, or Parameter optiones were turned off.
Publish: Cached prediction models were not properly updated by scheduled jobs.
Publish: In some cases, column data types of data from some data sources were different between when it was on Exploratory Desktop and when it was on the Server with Parameters.
Parameter: Now it shows a warning message and icon for a parameter that refers a data frame that no longer exists.
Project: Publishing a project at the closing of the project with Exploratory Public failed.
General: On Mac, in some cases, at the installation, the error "Security returned a non-successful error code: 51" was raised.
General: When exporting a project as a zip file, if it was done by overwriting an existing zip file, the content of the existing zip file remained in the new zip file.
Released on 12/11/2020.
Released on 12/10/2020.
Data Source: ODBC: Now it has one unified "ODBC" data source that supports both 'unixodbc' and 'iodbc' types.
Chart: Table: You can now set the column width and also enable text wrapping.
Chart: Table: The Font Style and Visual Formatting options are now supported even for the non-numeric columns.
Analytics: Time Series Forecasting (Prophet): "Autoscale Y Axis" is supported for the Forecasted and the Trend charts.
Analytics: Prediction by a model created with Analytics View is now supported on Interactive Session at Exploratory Cloud and Exploratory Collaboration Server.
Analytics: Adding 'model_info' function to extract model information from a list column of a data frame that stores model objects.
Installation: Supporting a proxy server connection test capability in the System Configuration dialog.
Data Source: With ODBC data source, a SQL query that included non-ascii column names in a 'where' clause didn't work for Oracle Database.
Data Wrangling: Error message from an invalid step kept shown even after opening a different project.
Data Wrangling: Reorganized the column menu for Text Data Wrangling.
Data Wrangling: On the Table View, adding a step failed with an error when a newly added step removed a column that was used for the table filter.
Data Wrangling: On Recode dialog, switching a column to overwrite did not work and it kept showing the previously selected column.
Data Wrangling: 'Create Bin' dialog froze right after opening the dialog.
Chart: Line chart failed to render and showed an error dialog when you entered non-numeric values for the Constant Values in Reference Line setting.
Chart: Pivot Table failed to render and showed an error dialog when you entered the same value twice for Cutting Points in Category Setting dialog.
Analytics: It is now easier to show a popup by hovering a reference line in Error Bar charts in T Test and Wilcoxon Test.
Analytics: Prediction by a model created with Analytics View on a scheduled job at Exploratory Cloud server failed, if Date information extraction function was applied on predictor variables, and the server's locale was set differently from that of the Exploratory Desktop.
Installation: On macOS Big Sur, installation of R, as part of Exploratory's installation, did not properly create R's executable at /usr/local/bin/R, resulting in Exploratory repeatedly requiring R to be installed.
Released on 12/3/2020.
Summary View: Supported creating analytics (e.g. Random Forest) by selecting multiple columns.
Summary View: Supported more chart/analytics types for creating from Summary View.
Data Wrangling: Supported 'Text inside of', 'Text by Range', 'First Word', 'Last Word', 'Email Address', 'URL', and 'Emoji' options for Text Wrangling Dialog.
Data Wrangling: Added "Unite" parameter to the Count Text Dialog.
Data Wrangling: Supported ‘Group by’ parameter for Count Token Pair.
Data Wrangling: Supported an option to summarize the count by Token, not by Document ID for Tokenize Text (No Spaces Between Words).
Data Wrangling: You can now move the rename dialog inside Summarize Step UI.
Data Wrangling: Supported pagination for Text Wrangling and 'Replace Values with New Values' UIs when there are too many rows in the preview table.
Data Wrangling: It now has an option to show 'space/tab/new line' in the preview table inside the Text Wrangling UI.
Data Wrangling: On the Text Wrangling Dialog's Preview Table, now it shows the number of unique values in Count Column.
Chart: Added a new 'Summarize Table' to summarize data in a table format.
Chart: Now you can repeat charts for each Y-Axis column when you assign multiple Y-Axis columns.
Chart: Added "Logistic" and "Poisson" Trend Line types.
Chart: Added a "Quick Window Calculation" menu.
Chart: Supported clicking to highlight rows in Table, Pivot Table and Summarize Table.
Chart/Analytics: Column Selection dialog now shows how many columns are selected.
Chart/Analytics: When duplicating a Chart/Analytics, it now shows a dialog to set the name.
Analytics: You can now add a step to predict by using a model that is created in the Analytics View
Analytics: Cox Regression and Survival Forest now has chart for time-dependent ROC with AUC.
Analytics: Cox Regression and Survival Forest now support 'Test Mode' and show the model evaluation metrics under the Summary tab.
Analytics: K-Means: Error bar chart for cluster means now can be displayed either in normalized values (default) or in raw values.
Analytics: Logistic Regression: On the Prediction chart, odds ratio of each predictor variable is displayed on the mouse-hover popup.
Analytics: Maximum VIF (Multicollinearity) is now displayed on Summary table of Linear/Logistic/Cox Regression, and GLMs.
Analytics: When switching type of Analytics, more properties are preserved, instead of getting reset to the default value.
Analytics: Supported changing a base level for Character/Factor columns when selecting predictor columns.
Analytics: T-Test, ANOVA, Chi-Square test: Added Probability Distribution tab to show the probability distribution of test statistic under null hypothesis.
Analytics: Time Series Forecasting (Prophet): 0 as forecast period is allowed. This is useful when you'd like to create a model with external variables, which do not have future values.
Analytics: By-class summary table for multiclass classification is added back.
Analytics: Linear Regression: Residual/Prediction scatter plot is added back.
Report: Now you can see the setting menu of the charts with 'Repeat By' even inside Note, Slide and Dashboard.
Data Source: CSV Import failed with invalid multibyte characters with 'element 3' error.
Data Source: Google Analytics: Failed to get a list of account when there were too many properties.
Data Source: Mongodb connection string stored in connection turned into random string when userconf.json file was broken.
Data Source: Web Scraping: Run button didn't work when the previous preview didn't return any data.
Data Source: On Windows, Web Scraping failed with invalid multibyte characters.
Data Source: Re-opening the Data Source Dialog was slow when not all the columns were selected for the first import.
Data Wrangling: 'Replace Values with new Values' Dialog became unresponsive when the selected column has too many unique values.
Data Wrangling: Added 'Replace Values by Conditions' menu to the column header menu of the Date and POSIXct data type columns.
Data Wrangling: After selecting multiple steps, selecting another data frame causes the issue that right hand-side steps showing incorrect steps.
Data Wrangling: Changed to show the 'Replace Values by Conditions' dialog for "Replace ... with NA" column menu.
Data Wrangling: Cleaned and consolidated the column header menu for Text Wrangling related operations.
Data Wrangling: Could not select multiple columns for the "Add Row Manually" step.
Data Wrangling: Exporting a step data as a data frame at the source step caused an error.
Data Wrangling: Exporting table data was not honoring the Table Filter setting.
Data Wrangling: Added 'Remove Duplicate' option to the column header menu under 'Filter'.
Data Wrangling: Moving Pin did not work and right hand side area became blank for some occasions.
Data Wrangling: On Duplicate Data Frame UI, "Include Chart" and "Include Analytics" checkboxes are now checked by default.
Data Wrangling: On Text Data Wrangling UI, the preview table highlight was not happening for some cases.
Data Wrangling: On the Table View, after adding a Group By step, the table shows incorrect coloring for the groups.
Data Wrangling: On Windows, When creating a filter and hovering mouse over the custom tab, the right border is missing in the right tab.
Data Wrangling: Right hand-side step pane is not displayed when selecting a data frame that uses a data source extension but the extension was not installed.
Data Wrangling: System Locale was not affecting result of month function and shows English names.
Data Wrangling: When creating multiple tokens inside a 'Replace Values with New Values' step, the dialog for the new token did not show an expected result.
Data Wrangling: The 'Duplicate' icon did not show up when there was only one token in the Mutate / Filter steps.
Chart: "Map - Extension" showed an error dialog if you assigned a logical column to Color By and choose "ALL" for the aggregation function.
Chart: After deleting a step that caused the missing column issue for a chart, the chart did not get updated.
Chart: Applying "As int10" function against the 'difftime' data type columns failed with an error "No method asJSON S3 class: difftime"
Chart: Axis range setting should be ignored if "Sync Axis" option is disabled.
Chart: The column assignment area (left side) became blank if you click the format button in the column selection dialog of the Table.
Chart: Chart filter failed with an error "TypeError: Cannot read property 'formType' of null" for some occasions.
Chart: If you used a column with special characters for Y-Axis and tried to click the "Exclude" menu in the popup, Exploratory app hung.
Chart: Line chart shows an error dialog if a column used in the Limit at Color becomes unavailable by the step change.
Chart: On a low resolution Windows PC, after selecting an aggregation function on the Filter dialog, the entire UI pushed up.
Chart: Pivot Table failed with an error dialog if you renameed or removed a column that is used in a custom calculation.
Chart: Sort by frequency option didn't work for the Pivot Table.
Chart: When a step, which is referenced by a chart, had an error, the error message mentioned a wrong step name and the error didn't go away even after the chart's pin was pointed to an non-error step.
Chart: When disabling a column used for the color, it showed 'object not found error.'
Chart: Long/Lat Map: You couldn't assign a column to Size if "(Row ID)" is assigned to Group By.
Analytics: Axis order doesn't change even if you check "Sync Y Axis" option in the Contribution chart in Chi-Square Test.
Analytics: Unchecking the "Sync Y-Axis" option didn't adjust the Y-Axis under the Prediction tab.
Analytics: If you import a project that contains a data frame created by "Save Chart Data as Data Frame", it shows an error dialog with "Error in gzfile(file, "rb") : cannot open the connection".
Analytics: Prediction Matrix: Columns with only 0 values used to be dropped, but now it is reserved.
Analytics: The random seed is set at each group level when the Repeat-by is used for more stability in the results.
Parameter: Dynamic Slider: Min/Max value was not properly set when there is a Group By step.
Parameter: When changing parameter type from Slider to Text Input, it was still showing the data frame selector.
General: Improved the error message for the proxy network setting.
General: With R 4.0.3, Date operations that involve timezone raised an error "Unrecognized timezone".
General: Improved an overall performance for opening / closing projects and moving between data frames and views.
Installation: Windows: When User's home directory contains Japanese characters, the selected custom folder name was not properly displayed.
Released on 10/16/2020.
Released on 10/12/2020.
Data Wrangling: Expose the confidence interval functions in Summarize dialog.
Data Wrangling: Improved label and text of Unnest Wider and Unnest Longer parameters.
Data Wrangling: Japanese column name is now highlighted in orange color in Mutate or other expression editor.
Data Wrangling: On Summarize Dialog, changed the default preview sample size to 10K rows to make the initial performance better.
Chart: Expose the Repeat By Layout Toolbar in Chart.
Chart: Support a property to adjust the double click timing for the Chart legend.
Chart: Support the custom bandwidth option for Density chart.
Chart: Now you can show/hide 'number of rows' in the chart popup.
Analytics: ARIMA: Seasonal ARIMA parameters can be manually specified now.
Analytics: XGBoost: The default validation metrics for the 'Learning' is changed to negative log likelihood.
Note/Slide: When a note or slide is opened in the Side by Side mode, now the Run button is placed at the preview toolbar.
General: Now the Chat Dialog inside Exploratory Desktop shows Japanese User Interface when Exploratory Desktop UI language is Japanese.
Data Wrangling: On Mutate Step, a token showed "Creating" instead of expression when the it was not saved before closing the project.
Data Wrangling: Added calc_confint_mean and calc_confint_ratio under the numeric functions of the column header menu.
Data Wrangling: After converting the step to a Custom R Script, you couldn't get it back even after you clicked the Cancel button.
Data Wrangling: Drag and drop a branch data frame root ended up showing "dataframe undefined does not exist in the catalog" error for some occasions.
Data Wrangling: When selecting multiple columns for Unite command, the selected column order was not preserved properly.
Data Wrangling: On Text Wrangling Dialog, if the "end" input box for the Extract Range of Text was empty, the preview showed duplicated text.
Data Wrangling: Syntax suggestion was not suggesting correct candidates when column names with multibyte characters are in the expression in the Mutate step.
Data Wrangling: Table View: When collapsing the data frame list on the Analytics View, the table does not use full width after moving to the table view.
Data Wrangling: When disabling a step, associated branches now move to the previous valid step.
Chart: The Color was not respecting the result of the Limit configuration done for the X-Axis.
Chart: Long/Lat Map: Decimal digit setting shouldn't apply to the number of rows in Popup.
Chart: 'Show detail' dialog was showing empty when you assigned a POSIXct column at X-Axis with 'Floor to Month' function.
Chart: When re-opening a data frame, if previously selected step had an error, it showed TypeError: Cannot read property 'getTransformName' of undefined when underlying metadata was corrupted.
Analytics: ARIMA: In some cases for shorter data, error with message "Column 'seasonal' doesn't exist" was raised.
Analytics: Cox Regression Model Step: Residual was missing in prediction result on training data.
Analytics: Cox Regression Step: Layout got broken while selecting the predictor variables
Parameter: Duplicated parameters were shown in the Parameter Pane if the same parameter was used in the SQL query multiple times
Parameter: Filter with "Is In (Multiple Values)" operator with "Ignore Case" option always returned no data even when the Parameter was set to "All".
Parameter: Importing EDF file with parameters failed with error "Cannot read property 'type' of undefined".
Parameter: When defining a data frame based parameter, the last step info was not saved when updating a parameter.
Install: On Windows, the repository location validation is now prevents it from creating the repository directly under C:/Users directory.
General: Accidentally dropping an image file onto Exploratory broke the User Interface.
General: Clicking "See all your conversations button" inside Chat Dialog didn't display the conversations.
General: When published to exploratory.io or Collaboration Server, database query returned no data, if the data source was originally imported from a published EDF file.
General: On Project List, renaming project was super slow when there are many projects.
Released on 10/2/2020.
Here is a v6.2 release announcement blog post for more details on some of the key new features.
Summary: Show Mean and Median reference lines for the numeric and date data type columns.
Summary View: It now shows a percentage of each category when you place the mouse over on the bar.
Summary: Correlation mode: It now removes NA values instead of treating them as a category.
Data Wrangling: Supported Unnest wider and Unnest Longer.
Data Wrangling: Supported Disable/Duplicate a step token by clicking icon on the token.
Data Wrangling: Introduced a new UI dialog for the conditional replacing values with 'case_when'.
Data Wrangling: Support extracting values from the List column by specifying the name or the position.
Data Wrangling: When selecting/removing multiple columns, it now executes the step without showing the column selection dialog.
Data Wrangling: Added a series of functions for calculating the confidence interval.
Chart: It now support searching column names for the Other Group and the Highlight dialogs.
Chart: Now you can manage to show/hide unused factor levels at X-Axis and Color.
Chart: Error Bar: Add 3-way button control in "Ratio (%)" Calculation Type mode.
Chart: Support "Confidence Interval" option in the Range setting in Line chart.
Analytics: T-Test Analytics View: Added the "Difference" tab with error bar chart of mean differences between the 2 groups.
Analytics: Added the XGBoost to Analytics View.
Analytics: Added the ARIMA to Analytics View.
Analytics: Random Survival Forest: Improved the importance evaluation logic to make the result more robust.
Analytics: Random Forest: We made the Importance tab to use a bar chart instead of the boxplot to be consistent with other models. You can bring it back by enabing 'Boruta' in the property.
Analytics: Prediction tab: It now shows 'Number of Rows' in the popup for the "Actual" line.
Dashboard: Now you can set the row height when the "Fit to Screen" option is off.
Parameter: On SQL Editor, changed to show parameter runtime panel when clicking parameter link.
Parameter: Supported dynamically querying data for min/max value for numeric parameters or the list of values for categorical parameter.
Parameter: Supported "today" as a default value for Date data type and Timezone for Date / POSIXct Parameter.
Parameter: It now keeps opening the dialog when clicking the Save button instead of closing it so that you can continue working on other parameters.
Data Source: With Public Edition, clicking Re-importing button does not reflect the change.
Data Source: MySQL: Character column is shown as numeric column in the preview when the value is something like 9E.
Data Source: On Google Analytics Data Import Dialog, the "TypeError: Cannot read property 'some' of null" error was raised for some occasions.
Data Source: Google BigQuery: Corrected the Help Link for the storage bucket creation.
Data Source: CSV: When trying to import a CSV file, it failed due to missing Default Encoding for some occasions.
Summary: When moving a step while correlation mode is on, if the target column was not available on the moved step, it showed an empty screen.
Summary: Correlation Mode: Sorting by the 'P Value' didn't sort the columns properly.
Summary: Correlation Mode: When you imported data from the Data Catalog while the Correlation Mode was on, it opened the imported data with the Correlation mode.
Summary: Highlight Mode: When creating a chart by clicking on the chart icon while the highlighting column was not selected it showed an error.
Data Wrangling: In the 'Replace Values' the values shown in the preview table did not honor the levels of a Factor column.
Data Wrangling: Custom Step: The Run button did not respond right after you converted the step to a R Custom step.
Data Wrangling: The Comment was gone after splitting a step into multiple steps.
Data Wrangling: After saving a step as a data frame, switching to the Summary View threw an error sometimes.
Data Wrangling: The Comment popup for a step didn't close even after moving the mouse cursor to the other steps.
Data Wrangling: Even after resolving the step error, the step title was still showed in red.
Data Wrangling: Select Columns step became empty when the step was created by selecting multiple columns from the column menu.
Data Wrangling: An error dialog showed up when you selected "Save Step Data as New Data Frame (Without Steps)".
Chart: Map: The background map image was not showing up.
Chart: Map: type dropdown didn't close when you opened the dropdown and clicked outside the dropdown area.
Chart: Map: Standard map failed to render if the column for the State name was renamed.
Chart: When you exported a boxplot chart as a data frame, the column names for '1Q' and '3Q' were reversed.
Chart: The Axis range setting for the X-Axis didn't work when you used the Repeat By.
Chart: Table: Column Selection was cleared when the selected column was removed from a step
Chart: Error Bar: The Limit with "Current Y column" didn't work with the "Ratio(%)" Calculation Type.
Chart: Pivot Table: Fixed the text color of the "Viridis" color palette.
Chart: Clicking "Add to Dashboard" icon didn't work.
Analytics: When you created a new analytics and published it immediately, the thumbnail image didn't show up on the published analytics.
Note: Clicking a URL link in a Note in the single view mode, it opened up another desktop window where it should have opened a web browser.
Dashboard, Slides, Note: It now updates the charts directly inside the Dashboard, Note, and Slides instead of refreshing the whole page.
Dashboard: Could not get out of the project nor open the dashboard once clicking an url link from the dashboard edit window.
Dashboard: It takes a long time to preview a dashboard when resizing the window size.
Slide: When you click the "Refresh" button, it now stays on the currently opened page in the preview.
Publish: Canceling the 'publish' ended up restarting an R session.
Publish: The Lock icon remains on the published contents even after switching the mode from Private Share to Public Share.
Parameter: A 'name conflict' error was shown if the Save button was clicked for the second time.
Parameter: The parameter pane was kept opened even after selecting a different dashboard
Parameter: An error "Cannot read property 'querySelector' of null" was shown after being a long time opening the parameter pane for Dashboard sometimes.
Parameter: The name conflict error was shown when you renamed a parameter, moved to other parameters, and clicked the Save button on the Confirmation Dialog.
Parameter: The display name was not properly shown for the dropdown type parameters.
Project: When opening a project with the Safe Mode, it didn't skip loading the custom R Scripts created for the project.
General: An error dialog showed up when you duplicated a data frame that pointed a data file which didn't exist anymore.
General: When trying to exit project, 'Extension context invalidated' error was raised for some occasions.
Released on 9/11/2020.
Released on 8/25/2020.
General: When dragging a mouse inside input field toward the edge of the dialog to select text, it caused the Dialog to be closed.
General: When closing Exploratory, 'No window with id: 5' error was raised for some occasions.
General: When closing Exploratory, 'Extension context invalidated' error was raised for some occasions.
Data Source: ODBC: On Schema Tree, changed to sort the table and view names alphabetically.
Data Source: Changing the data source to the 'data catalog' type didn't work
Data Source: When importing a file with long path name, the file path name was not shown properly.
Data Source: PostgreSQL: The Preview failed and showed "No method asJSON S3 class: pq__text" if you have a column with text[] data type.
Data Source: Google Sheets: Could not get data from Google Sheets when the selected sheets is only accessible by id.
Data Source: Google BigQuery: When streaming data with many columns, some columns contained missing values.
Summary View: After exiting from the highlight mode, the 'unique value' was still showing the values for the highlighted.
Summary View: When an analytics raised an error on the analytics view, moving to the Summary View showed a blank screen.
Summary: Pop-up shows up always at the left side when you hover the histogram in Summary view.
Table View: Clicking on the Filter's LOV made the dialog closed at the first time.
Table View: Popover text box for the Table Filter Token was too long with unnecessary space.
Data Wrangling: When a step had an error on Analytics view, analytics column selector widgets became disabled and could not change them even after moving to a valid step.
Data Wrangling: When the step cache was removed, the step was unnecessarily recalculated even when the step was already up to date.
Data Wrangling: When navigating to a build model step, it tried to show the table view when it should be showing the model summary view.
Data Wrangling: The Step token label text was removed after adding a Filter Step.
Data Wrangling: When opening the Export to Google Sheet Dialog, the Sheet list was empty.
Data Wrangling: After importing a data, a step selection in right hand-side step list was removed for some occasions.
Data Wrangling: The Tokenize Text (No Space Between Words) step failed when selecting TRUE for the 'Keep Other Columns' parameter.
Data Wrangling: Changed not to multiply by 100 for the % window calculations.
Data Wrangling: On Rename Dialog it didn't select/highlight text when moving between the cells by the tab key.
Data Wrangling: Selector widget: Improved the UI by making the selected value font weight as bold.
Data Wrangling: Added dense_rank to the Date and POSIXct column header menus.
Data Wrangling: Filter: Improved the performance for showing the dropdown values when there are many values.
Data Wrangling: When creating a recode step after a group by step, the Recode Dialog showed incorrect values in the table.
Data Wrangling: The Summary and the Pivot step UIs' preview table now shows all the data. You can still limit the rows if you want.
Data Wrangling: The Prediction step with cached Random Forest or XGBoost model step failed with an error.
Chart: Error Bar: A strange number showed up on Y Axis if you enabled the reference line and used the Horizontal orientation.
Chart: The Show Details dialog showed no data when the chart had a chart filter and X-Axis had a numeric column with category function applied.
Chart: When creating a chart from the Summary View, an extra space was appended at the end of the chart name.
Chart: Map - Heatmap: Circles didn't show up if there were NAs in the Value column.
Chart: Filter token width was not long enough to show the filter condition text.
Chart: When transitioning from Chart view to Summary view, it pushed the UI down for a second.
Chart: Quantile dialog position was incorrect and input field validation was missing.
Chart: Map - Long / Lat: The larger circles are shown under the smaller circles so that you can click on any circles.
Analytics: Random Forest Step: On Windows, when creating a build model step, number of rows for test data was not displayed on Model Summary View when UI language was Japanese.
Analytics: NAs in the target variable is now filtered out before building the prediction models.
Analytics: When changing the Analytics Type to the one that does not support Repeat By like Normality Test, the previously selected Repeat By column was not cleared and it ended up showing an unexpected result.
Analytics: Survival Curve: "%" was missing for the survival rate displayed on the mouse-over pop-up.
Note: After previewing a note, the last scrolled position was not remembered and it went back to the top of the content.
Publish: When the publishing failed, a proper error message was not shown.
R Package: Improved style for Tabs and Table inside the R Package Management Dialog.
Project: When there is an warning icon next to a project, mouse hovering the icon didn't show the warning message in the instant pop-up.
Released on 8/4/2020
Summary View
Data Wrangling
Chart
Analytics
Parameter
Data Source: Google BigQuery: When importing data, it sporadically failed with error "Invalid value at 'start_index' (TYPE_UINT64), "3e+05" [invalid]".
Data Source: Google BigQuery: When there were more than 100 datasets under a project, not all the datasets were displayed.
Data Source: Excel: Reading excel files with multibyte path or filename raised an error.
Data Source: Web Scraping: Encoding option was not working properly.
Data Source: ODBC: Views are not displayed on the left-hand side schema tree.
Data Source: Data Connection information is now managed separately from the Data Source step on the exploraotry.io server, or the upcoming release of Collaboration Server. This means that if setting of a Data Connection changes, you only need to publish one Insight with the Data Source, instead of publishing all the insight with the updated Data Connection.
Summary: A column selected for Correlation was not saved after creating a chart from summary view and coming back to the summary view.
Summary: When switching to the correlation mode, selected column and other fields are not shown while waiting for correlation calculation.
Summary: With Highlight mode, when a column is not selected, TypeError: Cannot read property 'escapedName' of undefined error is raised for some occasions.
Summary: Column name became shorter in the summary panel if you ran the Highlight in Summary View, moved to Analytics View, and came back.
Summary: Correlation calculation was not skipped when a column was not selected nor the selected column was invalid.
Table View: Vertical grid lines didn't align vertically between the table header and body in Windows.
Data Wrangling: Filter: A selected aggregate function got reset to the default after selecting different column.
Data Wrangling: The Recode dialog showed an error when it has "FALSE" as an original value
Data Wrangling: Error "ProjectDir.getObject: Metadata file not found in project:" was raised for some occasions.
Data Wrangling: After copying a folder with data frames, the source token of the copied R Script data frame did not show label.
Data Wrangling: On Filter Dialog, changed the label from Range to Option for Outlier operator.
Chart: Shor Detail: Number of rows in a table doesn't change when you change the "Rows to show" dropdown to the other values.
Chart: Show Detail: It doesn't shows no rows if a logical condition with a categorical column such as JobRole == "Sales Rep" is applied at Color.
Chart: Boxplot: You cannot change/reset the sort option because it is disabled if a numeric column is assigned to X-Axis.
Chart: When creating a chart filter, 'Day of Week' list of values didn't show locale aware values.
Chart: Window calculation name repeats in a hover popup if you turn on "Show function name" option in the chart property dialog.
Chart: Chart filter dialog was not automatically closed when moving to Analytics or other views.
Chart: Table: URL link points incorrect URL if you sort a table by clicking the table column header.
Chart: Number: Thumbnails was removed after clicking the OK button on Title / Comment dialog without changing anything.
Chart: Pivot: When you assigned a Date or POSIXct column with "Extract Day of Month" option, the day of month numbers were sorted as text.
Analytics: Prophet: When deleting an External Predictor column, the function assigned to the deleted column was assigned to the next External Predictor column.
Analytics: When clicking the Run button for Analytics, it didn't properly check if there was another R process running.
Analytics: When Switching analytics type from Cox regression to Survival Forest, Start and End date column selections were removed.
Analytics: Result of Variable Importance (permutation importance) was affected by the order of predictor variables, but now it always returns a same result regardless of the predictor variable order.
Analytics: Prediction with Random Forest Model Step on another Data Frame raised error when the other Data Frame did not already have a target variable column.
Analytics: "Cannot Combine" R error showed up if you set "Auto" at Period and used Repeat By in COX Regression.
Analytics: Other Group setting green text didn't show up automatically when you assigned a character column with a lot of unique values to Repeat By in Survival Curve and COX Regression.
Analytics: Cox Regression: Repeat By column selector disappeared right after assigning a column
Analytics: Random Forest: Predictor variables of insignificant importance on Boruta boxplot was not sorted properly.
Analytics: Variable Importance: P Value of categorical predictor variables were displayed as (NA) under some perfect collinearity cases.
Reporting: Unexpected "No search result" text showed up in the Analytics Chart picker dialog in Note, Slide and Dashboard.
Reporting: Charts in Notes, Slides and Dashboards sensitive should be sensitive to the UI language setting.
Reporting: Published date is not shown on the Publish Dialog header area.
Dashboard: Chart thumbnail was not updated after updating the display name in Number.
Dashboard: Chart returns no data if more columns are added to the data source and those new columns were used in the chart.
Dashboard: Text overflows from a text panel if you have text with a lot of line breaks.
Note: Dependency from embedded R code to Data Frames were not handled properly when there were spaces before the triple-backtick.
Note: When moving between notes, the content get overridden by the old content of the same note.
Parameter: The number of rows information was not updated in Chart view when updating the Parameter values.
Parameter: Parameters imported with EDF file were not immediately available after the import.
Parameter: After changing the order of the Parameters in the layout setting, sometimes it was not saved.
R Package: On R package Dialog, an error message from the previous installation was kept being shown even after installing another package.
R Package: When the installation of R packages failed due to a package loading problem, both the success and the failure messages were shown at the same time.
General: Rserve process remaining from the previous time the Exploratory Desktop was up prevented starting up of Exploratory Desktop.
General: The in-app chat window was not available right after Exploratory Desktop was installed.
Released on 6/23/2020
This release is to certify R 4.0.
The installation of v6.0.3 will automatically install R 4.0, which will make all the R packages you have installed in the past invalid and you will be asked to re-install them so that they will be compatible with R 4.0.
Released on 6/13/2020.
Released on 6/4/2020.
Released on 5/19/2020.
Summary View: Added a new 'Highlight' mode to highlight a matching data based on a condition you create.
Summary View: Added a new 'Correlate' mode to explore the correlation among the variables.
Summary View: Switched to a parallel processing engine to calculate the chart data and the metrics.
Table View: Added Filter support.
Data Source: Weather Extension Data Import now supports list of values for Country Network and Station parameters.
Data Source: Added a support for Timezone for the CSV Import.
Data Source: Google Sheets: Added 'Auto Detect Data Type' checkbox next to Run button.
Data Wrangling: Added 'Remove Outliers / Keep Outliers' as the Filter's operators.
Data Wrangling: Added 'Previous' and 'Next' options for Window Function column menu.
Data Wrangling: Added an encoding property inside the Merge Data with 'bind_rows' option.
Data Wrangling: Added a Window Calculation menu for the Date and POSIXc columns.
Chart: Added the 'Limit' feature for Group By, Repeat By and Color By options.
Chart: Added an 'Odds' calculation for the Logical data type columns.
Chart: Error Bar: The Reference Line is now supported for Error Bar.
Chart: Heatmap: It now exports the data as it is shown in the Heatmap chart, which is in the wide format rather than in the long format.
Chart: Map: Added a 'Standard' type to make the map creation easier. This is only for World Countries, US States, US Counties, Japan Prefectures for now.
Chart: Map: Supports more granular level of the zoom in and out.
Chart: Support multiple reference lines for X-Axis.
Chart: Support showing the label text for the X-Axis reference lines (the vertical ones) on the plot area.
Analytics: Survival Forest: We have added a new Random Survival Forest under the Analytics View
Analytics: Cox Regression: We have added a Prediction tab (partial dependence plot) to show the predicted values based on the predictor values.
Analytics: Cox Regression: Added a Data tab to show the prediction result.
Analytics: Cox Regression: Added 'Outlier Removal' as the data pre-processing section in the property.
Analytics: Cox Regression: Added an Importance (variable importance) tab to show which predictor variables are more important.
Analytics: Cox Regression: Added a Survival Curve tab to show impacts on the survival curve for each predictor variable.
Analytics: Survival: Added the "Auto" mode for the Period, which sets an appropriate period based on the data.
Analytics: We have added Permutation Importance for all the prediction models including Linear Regression, Logistic Regression, GLM (Poisson, Binomial, and Gaussian families), Cox Regression, Random Survival Forest. Decision Tree and Random Forest have already been using it. With this, you will have a consistent way for looking at the importance among the models.
Analytics: We have added the ROC tab to show the ROC curve for Binary Classification types.
Analytics: Charts under the Prediction tab (as formally known as "Effects") are now sorted based on the variable importance scores.
Analytics: Survival Curve: We have combined the Survival Curve and Survival Curve with Confidence Interval tabs into one. Now you can control whether showing the confidence interval or not by clicking on a radio box.
Analytics: Added 'Effect Size (Epsilon Squared)' for Kruskal-Wallis Test.
General: After canceling a process, an error dialog with 'This process is canceled.' message showed up where it was not needed.
General: When opening a project, the Chat icon was displayed even when you didn't click on the 'Questions?' button.
General: The 'Latest Version Available' Button was not displayed even though new version was available.
General: When a connection error happens, could not go into offline mode even after clicking the 'Go Offline Mode' button on Connection Error Dialog.
Data Source: Could not Import an EDF file if it included sample data with invalid Japanese characters.
Data Source: Fixed incorrect help link for MS SQL Server Connection.
Data Wrangling: Removing Cache from a step didn't update the cache stale status.
Data Wrangling: On the Filter Dialog, it didn't clear the value when switching the column selection to a column with a different data type.
Data Wrangling: On Windows, "Replace Values" Step (recode and case_when function) on a multibyte character column broke encoding property of the column, which caused garbling of the texts in later steps such as Merge Step.
Data Wrangling: When exporting POSIXct data to a CSV file, it didn't honor Timezone information and exported it as UTC.
Data Wrangling: When column names used in an expression contain certain Japanese characters, 'Only ASCII characters are supported' message was displayed in Mutate Dialog.
Data Wrangling: On Windows, after merging data frames, Japanese data got garbled.
Data Wrangling: One Hot Encoding did not work in Japanese UI.
Data Source: After OAuth token sync was done, it still opened the Add Connection dialog where it shouldn't.
Data Wrangling: Removed unnecessary sub-menu under 'Remove Columns' from multi column menu.
Data Wrangling: Chart Filter didn't recognize the updated column data type.
Data Wrangling: Analytics under a branch data frame disappears when the parent data frame's step was deleted.
Data Wrangling: When hovering a mouse over Remote File Data Source Step, the URL for the remote file was not fully visible.
Chart: The Show Detail Dialog didn't show data for a Heatmap when the X or Y axis is categorized.
Chart: Error Bar: Ratio calculation was incorrect when 'Number of Rows' was assigned to Y Axis.
Chart: Now clicking 'Cancel' button in the custom function dialog would ask whether you want to delete the custom function when you have an invalid expression.
Chart: When an OAuth token expiration is detected while refreshing the chart data, it would open the re-authorization dialog.
Chart: Show Details Dialog didn't show any data when assigning a numeric column to Color with 'Outlier' categorization being applied.
Chart: The sort icon was not shown in the Pivot Table's total column header when embedded in Note.
Chart: When navigating between data frames, Chart or Analytics level filter buttons were truncated.
Chart: Negative numbers as the Cutting Point values were not handled correctly in Category Setting dialog.
Chart: Custom Calculation dialog shows an error "Object Custom not found" when you use the 'Limit' in Bar chart.
Analytics: When moving among analytics chart tabs, unnecessary thumbnail generation happened even when there was no update.
Analytics: On Windows, the bottom of the Column Selection Dialog was not fully visible when creating a Logistic Regression Analytics.
Analytics: '(NA)' group showed up at the top in the "Group" LOV in Cox Regression.
Analytics: When an analytics metadata file was broken, it didn't open the data frame properly.
Analytics: Correlation: Selecting "Only lower triangle" option in the property caused an error.
Analytics: XGBoost: It now works with data with NAs.
Analytics: When you run Random Forest, it shows "TypeError: r[e.facet].push is not a function" error if you have a text 'map' in the column name for 'Repeat By'.
Analytics: The metrics of F Score, Precision, Recall, Accuracy Rate were not consistent between the Step and the Analytics view for Random Forest because the underlying model parameters were using different default values. The model parameters including the random seed and the number of trees are now set to the same default values.
Note: Numbers in Table became links if you viewed an exported HTML on Windows Edge
Note: Refreshing a note showed an error when the referencing analytics was already removed.
Dashboard: Thumbnail image for a chart and analytics didn't show up when it's added to a dashboard by clicking the "Add to Dashboard" button.
Dashboard: Creating a dashboard with duplicated name was not prevented.
Dashboard: When opening a chart on a main Window from a Dashboard in a separate window, "Add To Dashboard" dialog in a main window didn't respond and prevented any operation on main window.
Dashboard: When the thumbnail image was not available, the description for 'Number' chart was displayed outside of the layout box.
Parameter: Default value was not set on a numeric multi-select list of values.
R Script: Supported 'Control + /' (Command +/ for Mac) shortcut key for comment out multiple lines R script.
Released on 4/22/2020
Released on 3/20/2020
Project: When opening a project that has a Date parameter, there was a case that it showed "e.replace is not a function" error and couldn't open it.
Data Wrangling: Saving a step as a "New data frame without steps" incorrectly kept the grouped state where it shouldn't.
Data Wrangling: Date Filter: 'This Month' option did not work for a POSIXct column when the timezone for the column is different from the system timezone setting.
Data Wrangling: When selecting multiple columns then open the Column Selection Dialog, the dialog didn't show the columns as selected.
Chart: A column dropdown list was not shown correctly when 'Keep' option was selected for Other Group setting.
Chart: Histogram: Bucket range info was incorrect in the hover popup of the cumulative sum reference line.
Chart: Error Bar: It should show 100% bars in Ratio Mode when the group by setting is 'X Axis' and 'Number of Rows' is assigned to Y Axis.
Chart: Error Bar: Make the '95% Confidence Interval' the default.
Chart: Pivot failed to render and showed an error "Cannot read property 'length' of undefined"
Chart: Show detail dialog showed an incorrect number of rows if 'Number of Rows' was assigned to Y Axis in Bar.
Analytics: Add "Number of Rows" information to the Summary table for T-test and Wilcoxon test.
Analytics: When an Analytics tab was 'Pinned' to a particular step and the step was deleted, running the Analytics showed 'Required metadata is not available' error.
Analytics: Effects by Variables: Increased the number of variables setting to 20 by default.
Analytics: Logistic Regression: Coefficent (Significant) tab was still showing not significant variables when Repeat By is used Analytics: Logistic/GLM: 'Effect by Variables' setting in the property was missing.
Released on 3/16/2020
Data Source: Google Analytics: Changed 'Hour of Day' dimension label to 'Date/Hour'.
Data Source: Google Analytics: Supported Timezone Parameter and added more 'Last N Date' related options.
Data Source: Supported MS SQL Server Data Source without DSN.
Data Wrangling: Added 'Use "." to represent the columns. e.g. log(.)' message inside the 'Create Calculation (Mutate) for Multiple Columns' dialog.
Data Wrangling: Supported "Add Row Number" option under the Plus button menu.
Chart/Analytics: Added “Styling with Markdown is supported” text and help link at description fields in Comment / Rename Dialogs.
Analytics: Decision Tree: Charts in the Effects of Variables tab are now sorted by the variable importance scores.
Analytics: Effects by Variables: Categorical predictor values on X-axis are now sorted by the predicted values.
Data Source: Google Sheets: Inside the Data Source step, sheet title was showing the title of the first sheet even when you selected a different sheet.
Data Wrangling: Tokenize Text: Selecting 'Yes' for 'Keep Original Column' parameter didn't save the original column.
Data Wrangling: Sample Step raised error if data had fewer rows than the specified sample size.
Data Wrangling: Removed the sub menu items under "Select Columns" of the column header menu when multiple columns were selected.
Chart: Error Bar: In 'Ratio' mode with grouping by 'X Axis', the percentage is now calculated with devision by the numbers for each X-axis, as opposed to devision by the total number for all the X-axis values.
Analytics: Effects by Variables: Confidence intervals of "Actual" lines/dots for binary classification now correctly uses confidence interval of population proportion.
Released on 3/5/2020
Analytics: Linear Regression: Variable Importance: The variable names at X-Axis were wrong.
Analytics: Prophet: MAPE was using percent as the unit, but it's now changed to 0-1 scale just like MASE.
Data Source: Google Sheets: Upgraded to use Google Sheets V4 APIs instead of V3.
Data Source: Google Sheets: Now it correctly detects the Date/POSIXct data types.
Data Source: Google Sheets: Introduced a Timezone parameter in the data import dialog.
Data Source: For Stripe, MailChimp, and Google Analytics Data Sources, the Last N Years parameter did not work when you run it on Feb 29 in the leap year.
Data Wrangling: Added 'Count Text Pairs' option to the column header menu.
Data Wrangling: After converting POSIXct column data type to Date, the spin icon did not go away and could not navigate from the Summary View to other views like Table View.
Released on 2/28/2020
Released on 2/24/2020
Here is a v5.5.2 release announcement blog post for more details on some of the key new features.
Data Source: Excel: Date column was imported as a numeric column where it should be a Date or POSIXct column.
Data Source: Excel Import Dialog: Supported Timezone Parameter.
Data Source: MongoDB: Supported Data Connection by Connection String.
Data Source: MongoDB: Added 'Last N Rows' option.
Data Wrangling: Filter: Now the 'Stop words' operator supports more languages.
Data Wrangling: Supported the 'Stop Words' parameter for Tokenize Text Step UI.
Data Wrangling: Supported the 'First Word' and 'Last Word' options for Extract Text.
Data Wrangling: Supported remove 'Full-width space' and 'Special Characters' options.
Data Wrangling: Now you can copy and paste the same set of the data wrangling steps to the multiple data frames.
Data Wrangling: Supported Chinese, Japanese, Korean, and Vietnamese for Text Tokenize.
Data Wrangling: Supported locale argument to 'Re-Evaluate Data Types for All Columns'.
Data Wrangling: Supported 'Last N Months (Exclude This Month)' option for Date Filter.
Data Wrangling: Added column menu to convert year numbers to Date type.
Data Wrangling: Now you can move the 'Published' button to other steps by drag and drop.
Data Wrangling: Filter: Supported This Year, This Quarter, This Month, This Week, and Today options for Date Filter.
Chart: 'Other Group' is supported at 'X Axis' of Bar, Line, Area, Error Bar, Boxplot and Violin.
Chart: 'Show Values on Plot' option works on charts even with 'Repeat By'.
Chart: The chart popup shows a number of rows.
Chart: 'Custom Calculation' is supported in Bar, Line, Area, Bubble chart types.
Chart: Now, you can use 'Repeat By' for the Horizontal Bar chart.
Chart: We now support Error Bar in the horizontal direction.
Chart: Support 'Constant' option in '% Difference' and 'Difference' Window Calculations.
Chart: Now you can adjust the vertical and horizontal padding between charts in Repeat By charts.
Chart: Reference Line: Support 'Standard Error' Range Type.
Chart: Changed to show 'Number of Rows' information inside the 'Show Details' dialog.
Chart: Support title text alignment option (Left, Center, Right)
Analytics: Time Series Forecasting (Prophet): Model Summary view is now shown even when it is not in the Test mode.
Analytics: Time Series Forecasting (Prophet): In the Effects chart, the names of the multiplicative external predictors are now shown by the original column names, as opposed to by indexes. (e.g. Predictor 1, Predictor 2...)
Slide: Now you can show Table and Pivot Table into a slide without scrollbars.
Parameter: When a Parameter is changed, data for Source Steps using the Parameter are kept as "Out-of-Date" cache, instead of just getting removed as being old, to avoid potentially expensive reloading of the data.
Parameter: Values of Parameters from the previous session on the project are now remembered and restored.
Collaboration Server: Support switching the server between Collaboration Server and Cloud Server when there is a connection error.
Collaboration Server: Improved Error Message when Exploratory Desktop is opened with Public Account.
Data Source: Import Log File Dialog: Hitting the Enter key inside the 'Skip N Rows' input field caused unexpected App Restart.
Data Source: Google BigQuery: Query result was not refreshed when the data was updated via Google Cloud Storage.
Data Source: Google Analytics: Incorrect Data Type was mapped to some of the Dimensions.
Data Source: Google Sheet: Improved Error message for the case where a column has only NA.
Data Source: Google Analytics: Moved Custom Dimensions and Metrics at the bottom of the list for better scroll search experience.
Data Source: Google Analytics: Hour of Day (dateHourMunite) column data type was returned as interger instead of POSIXct.
Data Source: Google Analytics: Supported Dimensions and Metrics label translation for Japanese UI language.
Data Source: When trying to open MySQL Data Import Dialog, it didn't open in some situations.
Data Source: On MySQL Data Import Dialog, "external pointer is not valid" error was raised when the connection became invalid after certain amount of time.
Data Wrangling: Added 'Cache Step Data' icon on a step header.
Data Wrangling: Opening Text Data Wrangling Dialog for an existing step showed object not found error.
Data Wrangling: Chart and Analytics Pins now move to the most previous available step instead of the source step when the pinned step is disabled.
Data Wrangling: Summarize Dialog: When Quantile function was selected, it did not keep the entered value when the Cancel button was clicked.
Data Wrangling: Could not remove multiple text with 'Text (Multiple Candidates)' Option.
Data Wrangling: Join Dialog: Data Frame List didn't show the folder names and the icons.
Data Wrangling: Filter: It should keep the filter condition even if a custom expression is removed and the Cancel button is clicked.
Data Wrangling: Preview Table showed incorrect data when moving back from the next step.
Data Wrangling: When clicking an existing Summarize step, Summarize Dialog sometimes showed object not found error.
Data Wrangling: Chart and Analytics Pin should move to the last step when the pinned step was split into multiple steps.
Data Wrangling: Filter Dialog: Now it sets a default value for the 'Last N' operation.
Data Wrangling: When "Replace with New Values" Step was applied on a Japanese column, the column was garbled at a later Merge step.
Chart: Error dialog showed up when removing a column selection on a chart filter then click the Run button.
Chart: Wordcloud: 'Minimum Frequency for Words' option didn't work if you specify a larger value than the maximum value of the data.
Chart: Bar selection wasn't removed after closing a Popup.
Chart: Wordcloud failed to render and showed an error "unable to start png() device".
Chart: Scatter: Values didn't show up in the plot area if you selected 'Bar' marker.
Chart: Line: Values on plot didn't align if a categorical column was assigned to 'X Axis'.
Chart: Switching from Table was slow if you had many columns assigned to the Table.
Chart: Highlight: The List of values became empty if you assigned a column, which was used in 'Group By', step to Color.
Chart: Creating a chart filter failed if a column with a name 'x' was assigned to 'X Axis' of a chart.
Chart: Pivot Table failed to render and showed an error "TypeError: Cannot read property 'slice' of undefined".
Chart: Edit Display Name: '(NA)' showed up even when there was no NA.
Analytics: When editing existing Analytics, previously selected Variable Columns were not shown on the Column Selection Dialog.
Analytics: Linear Regression, Logistic Regression, GLM: Various errors were raised when special characters like parentheses were used in column names.
Analytics: Random Forest: With Test Mode and Repeat-By enabled, error in model building was not handled cleanly. Now the error message is displayed in the Summary table in case of error.
Analytics: K-Means: When all but one column have constant values, "subscript out of bounds" error was raised.
Analytics: PCA: When only one column was specified, "subscript out of bounds" error was raised.
Analytics: Decision Tree: "subscript out of bounds" error was raised when the target variable was a character column with values "TRUE" or "FALSE".
Analytics: Correlation by Column: On the Heatmap, white cell with NA was displayed when the correlation was 0, where a gray cell with value 0 should have been displayed.
Analytics: Analytics shouldn't run when you click 'Apply' button in the property dialog if not all mandatory fields are assigned yet.
Analytics: Resizing the window size reset 'Number of Columns' configuration.
Note: 'Not found' message showed up for a chart even that chart existed if you ran a note right after opening a project.
Note: Spin icon on main window disappeared right after the mouse focus moved to a Note window but the spin should remain until the process ends on main window.
Parameter: Parameter input fields, list of values, sliders, date pickers should not be updatable when the process is still running.
Parameter: Empty Parameter Pane was shown after closing and reopening a project.
Parameter: Filter: When a new parameter was created from Filter Dialog, the parameter should be selectable from the parameter list on the Filter Dialog.
Parameter: The min value, max value, and step defined for numeric parameters were ignored on the Parameter Pane.
Parameter: Supported 'List of Values (Multi Select)' for the Logical data type.
Install: After installing RTools, Exploratory became unable to open a Project.
Released on 1/26/2020
Data Source: Google Analytics: Added Refresh button to refresh Accounts, Properties, Views, and Segments.
Data Source: Google Sheet: Supported Detect Data Type parameter.
Chart: Supported 'Disable' option for chart filters.
Chart: Scatter: LongLat Map: It now supports Binning by Hour, Minute and Second if you assign a POSIXct column at Color.
Analytics: 'Number of Columns' setting is now exposed at the top of the charts as a dropdown menu.
Analytics: Supported Hour, Minutes, and Seconds for POSIXct components for predictors.
Analytics: It now supports Binning at Color By and Repeat By.
Installation: Unnecessary 'Admin Privilege is required' error message was displayed on Windows.
Installation: The Web Proxy Server input field now prevents an server name entry if it starts with protocols such as http:// or https://, which would cause problem in connecting to the proxy.
Project: At closing a project, there were cases where an error dialog showed up with a message "Error Code 127".
Data Source: CSV: Improved an error message for a file character encoding mismatch.
Data Source: Google Analytics: Could not update date parameter with Date Picker.
Data Source: Google Sheet: Importing a sheet with sparse data failed with 'Error in nchar(x) : invalid multibyte string' error.
Data Source: Twitter: Search hangs when canceled the previous search and tried a new search.
Data Source: Supported 'Connection Mapping' dialog that allows mapping connections used in the imported EDF to existing connections.
Data Wrangling: The Rename dialog showed an unnecessary vertical scrollbar on Windows.
Data Wrangling: Step's label was broken showing text like "PLACEHOLDER" when column names were numbers.
Data Wrangling: Text Data Wrangling: The Preview Table didn't reflect previous text wrangling results in the same step.
Data Wrangling: Text Data Wrangling: Preview data was cleared when the 'Create New Column' checkbox was clicked.
Data Wrangling: Summarize Dialog: Now it sets the '(Number of Rows)' as a default Value Column when an existing Value Column was removed.
Data Wrangling: Filter: Improved logical operator dropdown style.
Data Wrangling: Filter: Now numeric input fields prevent unwanted non numeric text entry.
Data Wrangling: The filter operator and condition information were wiped out when changing the column selection even if the column data type was the same.
Data Wrangling: Aggregate functions (mean, median, min, and max) for Date operations were not fully available on the Filter dialog.
Data Wrangling: Splitting a step did not show the resulting steps immediately and had to re-select a step to show them.
Data Wrangling: Text Data Wrangling: Now matched text gets highlighted in the Preview Table.
Data Wrangling: Rename column shouldn't allow entering duplicated column name.
Data Wrangling: Gather dialog was not vertically scrollable when many columns were selected.
Data Wrangling: Brought back 'Work with Text Function' to Column menu.
Data Wrangling: Incorrect error message was shown for a data frame even if it didn't have an error.
Data Wrangling: Corrected the Column menu and Step dialog titles to be consistent.
Data Wrangling: Moved 'Ungroup' menu to the top level of Step menu.
Data Wrangling: Text Data Wrangling: Supported to show full text in the popup when hovering a mouse over a column that contains long text.
Data Wrangling: Recode dialog shouldn't show images when text contains img HTML tag.
Data Wrangling: Summarize dialog should reject duplicated column name when editing the column name.
Data Wrangling: Could not click OK button on Column Selection Dialog on a PC with lower screen resolution.
Summary: Group-By Columns were not highglihted with green color.
Summary: Show time and timezone information for POSIXct columns.
Summary: 'Unique Values' shouldn't count NA as a unique value.
Summary: Text on the summary panels was selected if you chose multiple columns by Shift+Click action.
Summary: Show an actual number of NA/Non-NA values in popup when you hover over an NA/Non-NA ratio bar.
Chart: Pivot Table: More user-friendly message for an invalid Custom Function.
Chart: Pivot Table: It showed 'V1' for an empty string in Column Header if you assigned a column that had empty strings in values to Column.
Chart: Pivot Table: If you set a descending sort on a Row Header, (NA) showed up at the top.
Chart: Line chart failed to draw and showed an error dialog if you switched the chart type from Heatmap to Line.
Chart: Could not add a chart filter when a chart is pinned to a cached step.
Chart: Export Chart to CSV sometimes failed and showed an error dialog.
Chart: Supported moving 'Edit Display Name' dialog position by dragging it.
Chart: Contour chart showed an incorrect set of functions for Date column at Color.
Chart: Number failed to render and showed an error dialog if there were multiple columns with the same name.
Chart: Histogram: Y2 axis labels were missed once in a while in Histogram with 'Cumulative Sum Ratio' lines.
Chart: Boxplot: Pop-up showed a meaningless text 'trace0' if you assigned columns to X-Axis, Y-Axis and Repeat By.
Analytics: On Effects by Variable charts, now we show charts for variables up to the specified limit, regardless of the variable's significance.
Analytics: Timeseries Forecast (Prophet) : Message "This chart is available only when there are more than 2 years/weeks of data" was shown even when the chart was actually available and shown.
Analytics: Timeseries Forecast (Prophet) : Sometimes removing existing External Variables in a duplicated Analytics did not work.
Analytics: Timeseries Forecast (Prophet) : Format of the output dataframe was broken.
Analytics: Timeseries Forecast (Prophet) : X-axis Date in Yearly Seasonality chart showed a specific year.
Analytics: Timeseries Forecast (Prophet) : Error with message "cols must select at least one column." was raised when there was neither seasonality nor external variables.
Analytics: If you typed in "0.0" to a number text field, it was getting back to "0", which was preventing you from typing in a value like "0.01".
Analytics: When using Repeat-By, sometimes it error-ed out due to an issue with a specific group. It is now showing the warning messsage in the Summary table, rather than stopping the entire analysis.
Analytics: Random Forest: Error with message "object 'variable' not found" was raised for a classification when there is a category with only one row.
Analytics: Repeat-By toolbar showed up in 'Effects by Variable' analytics chart even if no Repeat-By column was set.
Note/Slide/Dashboard: Improved error handling when the History information was corrupted.
Parameter: "Assertion failed" error was raised at creating data source with parameters.
Parameter: After making changes to a parameter and moving out to edit another parameter, the confirmation dialog about the change getting discarded didn't show up.
Released on 1/10/2020
Here is a v5.5 release announcement blog post for more details on some of the key new features.
Data Source: Google Analytics: Supported Custom Dimensions and Custom Metrics.
Data Wrangling: We have introduced 2 new UI for 'Text Data Wrangling' to support 'extract', 'replace', 'remove', and 'convert' operations.
Data Wrangling: You can now reorder the columns in Group-By and Values sections by drag-and-drop.
Chart: Histogram: Add 'Cumulative Ratio' and 'Cumulative Sum' reference lines.
Chart: Number: It now supports the Custom calculation.
Chart: It now supports the Nth & Quantile functions.
Chart: Pivot Table: It now supports 'drag-and-drop' to change the order of columns for Rows and Values.
Chart: It now captures the thumbnail images for Pivot Table and Table.
Analytics: Time Series Forecast (Prophet): It now shows Variable Importance based on coefficients of the Prophet model.
Analytics: You can select which components of Date/POSIXct data to be included as the predictors.
Analytics: Linear Regression: Variable Importance bar chart is now colored based on statistical significance of the variables.
Analytics: The text labels inside the chart pop-ups are now translated for Japanese UI.
Dashboard: Table/Pivot is now expanded to fill the space.
Dashboard: We have added Text Box for entering comment text and writing R script for custom visualizations.
Dashboard: It now captures the thumbnail image of the Dashboard output.
Table View: The long text in the pop-up were not shown fully.
Data Source: Google Sheet: Import Dialog: The long sheet names were not shown fully.
Data Source: Google Sheet: The default data frame names are sanitized automatically.
Data Source: Google Sheets: Changed default Data Frame Name from dataframe to GoogleSheet when the sheet name is non-ascii
Data Source: Google Analytics: Popup, which showed the dimension/measure detail information, was showing at wrong positions.
Data Source: Google Analytics: Dimension/Metrics names were not fully shown in the pop-up.
Data Source: Google Analytics: Clicking 'x' icon to clear Dimension/Metrics search words removed focus from the search input field and couldn't start next search right away.
Data Source: Google Analytics: Goal 1 Metrics were not properly sorted in the Metrics List.
Data Source: Google Analytics: Couldn't delete the Last N Days parameter value with the Delete Key.
Data Source: Google Analytics: Opening the Update Data Import Dialog was slow.
Data Source: Google Analytics: Clicking Show Only Selected Icon didn't clear the search words automatically.
Data Wrangling: It now keeps the current scroll position of the Preview table when adding new columns in the Column Selection dialog.
Data Wrangling: Clicking the cached step caused the previous step being executed.
Data Wrangling: Multiclass classification evaluation menu is hidden when the window size is small.
Data Wrangling: 'Use Row as Header' now automatically handles duplicate names or NA values by default.
Data Wrangling: Filter: The filter operator and condition information was wiped out when changing the column.
Data Wrangling: Mutate: The syntax suggestion inside the Expression editor was not showing the proper values when updating the existing step.
Data Wrangling: You can rename the newly created column names inside the 'Summarize' dialog.
Data Wrangling: Summarize: The categorical columns are now assigned to Group By when opening the dialog from the column header menu.
Data Wrangling: The text labels for 'Step Data Export' menu is overflowing in Japanese UI.
Data Wrangling: You can move a Step UI dialog by dragging it.
Chart: Pivot Table threw an error if you selected "Ascending by Frequency" sort option against a row header column which was Numeric data type and categorized.
Chart: 'Previous' and 'Next' options were missing for the '% of' Window Calculation.
Chart: Couldn't change the chart name to something that is already used in different data frames.
Chart: The data in Edit Display Name dialog and Highlight dialog didn't reflect the "Other Group" setting.
Chart: Area Map failed to render and showed an error "Error in prettyNum invalid 'nsmall' argument" if you set a negative value at the decimal digit setting in the Chart Property dialog.
Chart: Line Chart: When you assigned text column whose data containing "1", "2", "3", "4" to the X-Axis it showed only "1", "2", "3".
Chart: The space between the X-Axis text labels and the chart were not stable after you zoomed in.
Chart: Table: It didn't save the column order information when the column names consist of only numbers such as '2018'.
Chart: Pie: It threw an error "e.split is not a function" with a certain condition.
Chart: Limit Axis Value: The validation error message showed up at a wrong timing.
Analytics: K-Means clustering result was different on Mac and Windows.
Analytics: When you run the analytics, any invalid data wrangling steps are now automatically removed.
Analytics: K-means Clustering: The results were different between running it with the data wrangling step and running it inside the Analytics view.
Analytics: Time Series Forecast (Prophet): Couldn't run it due to an alert from Mac OS X Catalina's Gatekeeper.
Analytics: Market Basket Analysis: The Lift values shown on mouseover balloons on the scatter plot was wrongly labeled "Lift (Color)", while Lift was actually expressed as Size of circles.
Analytics: K-means: "subscript out of bounds" error was raised when only one variable column was selected
Dashboard: Empty rows should be automatically removed in Dashboard Config UI.
Dashboard: Table showed an extra border line underneath the column header when you set a smaller font size.
Parameter: When the Parameter Dialog is opened from the Filter Dialog, the Filter Dialog was closed when it should have remained opened.
Released on 12/23/2019
This release is only for Public Version for below bug fixes.
Public: Closing a project failed with an error (Command failed: git push --force) when the last login inside the desktop app was not done properly.
Public: After restarting Exploratory Public, projects were not listed on the Project List.
Released on 12/12/2019
Installation: On Mac OS X Catalina, automatic installation of R and/or Git failed.
Installation: On Mac, opening downloaded dmg file failed with error message "no mountable file system".
Improved error handling and guidance when Exploratory cannot connect to the internet.
Opening project failed on machine with Avast antivirus software.
Data Source: Data Catalog: It failed to import data if Exploratory was initially started without internet connection.
Data Source: Google Analytics: Not able to switch View ID when there are multiple View IDs.
Data Wrangling: Summarize step default output column names now always have function name as suffix, to avoid confusion between original column and aggregated column.
Released on 12/1/2019
Data Source: If you clicked an "Import" button in Data Catalog Import dialog, it showed an error message.
Data Wrangling: Now NA is exported as an empty string instead of an "NA" string if you export data to CSV, Google Sheets or Clipboard from a data wrangling step, Chart or Analytics.
Data Wrangling: On Windows, the cursor position didn't match with the text in the Calculation Editor of the Mutate dialog.
Released on 11/28/2019
Data Source: Google Analytics: Supported additional "Period" parameter options such as "Yesterday" for Google Analytics Data Import
Data Source: On Data Connection Setup Dialog, now unnecessary trailing white space for input fields are automatically removed except for password
Data Source: Now you can import data that is privately shared with you at the Data Catalog.
Chart: Support hiding the reference line information shown inside the chart legend.
Chart: Table: Support Date/Time formatting for Date/POSIXct columns inside the Table.
Chart: Error Bar: Support more aggregation functions in addition to "Count" and "Unique Count" for Y-Axis in Error Bar when the calculation type is "Ratio (%)".
Chart: Contour: Support the 'Repeat By' for Contour chart.
Chart: You can set the output width and height for Wordcloud, which will make sure that the Wordcloud output will have exactly the same output regardless of where it was generated. (e.g. Chart view, Note, Slide and Dashboard.)
Chart/Analytics/Wrangling: Added a "Week of Quarter" function for Date/POSIXcit columns. This is available through Column Header Menu, Chart and Analytics.
Data Source: Google Analytics: "Account", "Property", and "View" list of values were empty when reopening the Google Analytics Data Import Dialog.
Data Source: Google Analytics: Now we don't move the selected Dimensions and Metrics to the top.
Data Wrangling: The parse_number function didn't work for the factor type columns.
Data Wrangling: Unfinished step in a Branch data frame showed up in the parent data frame.
Data Wrangling: On Windows, filter operators such as "Starts With", "Ends With", "Contains" did not work if the column contains non-ascii data.
Chart: When you used a Conditional Coloring for the Table, the opacity was set unintentionally.
Chart/Analytics/Wrangling: On the Column Selection Dialog, clicking the "Clear All" link did not remove the selected columns.
Chart/Analytics/Wrangling: The background color of the Column Selection Dialog was too dark when the column configuration dialog was opened.
Analytics: The comment entered without being explicitly saved for the Analytics was cleared after closing the dialog.
Note: If you click a URL link in a Note in the Side-by-Side view mode, it opened 2 web browser tabs.
Note: Publishing a Note that was duplicated from another Note overwrote the original one at the Exploratory Cloud (exploratory.io).
Released on 11/16/2019
Chart: Updated Table under Chart view by supporting Conditional Formatting, Function, Column Rename, and Column Reorder functionalities.
Chart: Now you can edit the values of the columns assigned to Color with 'Edit Display Name' menu.
Chart: You can now manually set which values to keep or remove when creating 'Other' group under Chart view.
Chart: Error Bar chart supports various 'Directions' for calculating the ratio.
Chart: Support 'Number of TRUE/FALSE' functions for the logical columns assigned to Y-Axis of Error Bar.
Chart: When you move the mouse over on the error bar it should show the actual values of the range along with the length of the range.
Chart: Show a dropdown to select the range type (SD, 95% Confidence Interval, etc) dropdown below the Y Axis for Error Bar.
Data Wrangling: You can now set the seed within the Sample step UI.
Analytics: We have added a Collinearity tab for Linear Regression, Logistic Regression, and GLM, which will help you diagnosis the multicollinearity.
Analytics: We have added a Effect tab for Linear Regression, Logistic Regression, GLM, and Decision Tree, which is basically the same as the one for Random Forest and helps you understand how the change in the predictor variables would effect the target variable.
Analytics: ANOVA/T-Test: Added weekend function option to categorize Date data.
Analytics: Coefficients plot for regression analysis now has base level for categorical variable in mouse-over popup.
Analytics: Support "Week of Month" function for the date/time columns assigned to Repeat By and Color By.
Analytics: Regression Analysis/T-Test/ANOVA: Now you can apply functions like normalization or log to the input data as part of the data pre-processing.
Analytics: Regression Analysis/T-Test/ANOVA: Now you can filter outliers as part of the data pre-processing.
Analytics: Random Forest, Decision Tree: The actual data is displayed as a gray line along with the blue line representing the predicted values under Effects by Variable tab.
Public: Added R Script and Cloud App data sources for the Public edition.
Data Source: Google BigQuery failed to import data via Google Cloud Storage.
Data Source: Google Analytics: Re-designed the data import dialog to improve the usability.
Summary: the bars for NA were always showing 0 for the logical data type columns.
Chart: Number should be able to show 0 instead of NA.
Chart: 'Show Detail' button failed to show data when a numeric column at X-axis is setup with int10 function.
Chart: 'Show Values on Plot' is not working correctly when X-Axis is categorized on grouped bar chart.
Chart: the Chart Control area was not showing up after moving between Table View and Chart View.
Chart: Reference line was not shown when you used the 'Limit' feature (e.g. Top 10) with Bar chart.
Chart: Reference Line was not shown when you used the 'Categorize' feature at X-Axis of Bar chart.
Chart: Comment Dialog should keep the text entry during the same session even when you didn't save it and closed the dialog.
Chart:A broken chart thumbnail was displayed when you duplicated an existing chart and entered the comment.
Chart: Selected values for "is in" operator inside the Filter dialog were lost when you navigated to another chart and came back.
Chart: Text was chopped in the middle in Number.
Chart: 'Show Detail' didn't show any data of the lowest edge bar of the histogram chart.
Data Wrangling: "equal to" option was not available for the logical data type columns inside the Filter menu.
Data Wrangling: When converting POSIXct column to Date Column, timezone information was lost.
Data Wrangling: 'Go back to project list' button should not be clickable when there is another R process running.
Analytics: When you changed the font size for the biplot chart under PCA the color setting was lost.
Analytics: You couldn't read the whole message when it was too long.
Analytics: Time Series Forecasting: Default value of test period was not set correctly.
Parameter: Using parameter in custom function for Summarize step did not work.
Installation: When you create a directory under C:\Users\ and use it for Custom Repository, Exploratory didn't start up and show an empty screen.
Installation: The required R packages were not installed when switching the repository.
General: When you clicked an URL link inside the chat window it opened an Exploratory Window instead of a web browser.
Public: 'Quote exceed' message was shown incorrectly when there is a problem in the network connection.
Released on 10/23/2019
Unlike other major version upgrades (e.g. 5.2.0, 5.3.0, etc.), this release (5.4.0) is a 'merge' release that brings all the recent enhancements that we have made for 5.3.4 patch set. Also, we have made the below listed enhancements and bug fixes.
We're going to release an 'official' v5.4, which is going to be as 5.4.1, in early November, and add new features and enhancements we're currently working on.
Beta Features:
These are not official features, but we have exposed them as beta features. We'll support these as official features in the next release (5.4.1).
Public Version Only:
Released on 10/8/2019
Data Source: MySQL: On Windows, Japanese characters used in the column names and data were garbled.
Data Wrangling: Mutate All dialog had a wrong function name for "log1p".
Data Wrangling: On Summarize dialog, it shows "? ordered" as dat type on preview table when choosing weekdays() as an aggregation function for Date Column
Data Wrangling: It now shows the 'last imported' date/time at the data source step.
Chart: Added 'Apply' button for the number of bucket control in Histogram.
Chart: when you delete a parameter that is assign to a chart, the chart hangs when viewed
Analytics: Time Series Forecasting: Supported Japan as Country for Holidays
Analytics: Time Series Forecasting: Prophet: Multiple countries for holidays were not honored
Publish: The description/title/tags for shared contents (e.g. Note, Dashboard, Chart, Data) can be editted at the server.
Publish: Keep original url when stop publishing and republishing contents (e.g. Note, Slide, Dashboard, Chart, Data, etc.)
Installation: On Windows, an installed R is not detected if it is installed with non-privileged user who has not activated OneDrive.
Released on 9/23/2019
Released on 9/4/2019
Released on 9/3/2019
Installation: Added "Reset" Button to reset the System R packages to originally installed versions (a.k.a. factory setting).
Performance: Improve the performance for opening Note/Slides/Dashboard editor.
Performance: Improved SQL Query performance in general.
Chart: Support 'Auto-Binning' for numeric columns when they are assigned to Color with functions such as LOG/ABS/INT10.
Chart: Support the Trend Line even when categorical columns are assigend to X Axis.
Chart: Support "Show Details" even when the X-Axis Columns are categorized.
Chart: Support for creating Custom functions inside Pivot Table.
Chart: Support Auto-Binning of X Axis for Line and Area charts.
Chart: Support Auto-Binning for Repeat By and Group By in Chart.
Chart: Support Auto-Binning for Coloumn/Row Headers of Pivot Table.
Chart: Support Vertical Reference Line for Line chart. Chart/Analytics: Now "Save Chart/Analytics data as Data Frame" will add the data frame name as part of the name.
Chart: Support 'Limit Values' for Y Axis in Bubble chart.
Chart: Support 'Export as Data Frame' option.
Chart: The "Show Details" dialog now shows 'Number of Rows' information and use the same filter conditions as shown in Chart Hover Popup.
Chart: It now dynamically change the scale of the colors depends on the unique values. Currently, we support only up to 10.
Data Wrangling: Extended the Case Insensitive text matching for character related filter operations such as 'Start with...'
Data Wrangling: It now shows the comment icon in an always visible way when there is a comment at any data wrangling step.
Analytics: Support for multibyte/special characters in column names.
Analytics: Now it shows the number of rows for each Repeat-By group under Summary tabs.
Analytics: For binary classification models under Analytics Views, we have added a "Probability" tab to show a histogram of the probability.
Analytics: Support 'Reserve Order in Data' method for splitting Training/Testing data under Analytics view.
Analytics: Bayesian A/B Test: Added option to flip A and B
Analytics: Time Series Forecasting: Support the External Predictors even when the Target Value is Number of Rows.
Analytics: Time Series Forecasting: Support for External Predictors created from same column but with different aggregate functions.
Analytics: Random Forest: Effect by Variable tab now shows only the significant variables based on Boruta's result.
Analytics: Decision Tree: Added more properties for finer control of branching in decision tree.
Dashboard/Note/Slides: It now always opens Dashboard/Note/Slides in a separate window.
Parameter: Supported Tab key for move between input fields for the manual input values option.
Installation: On Windows, "No admin privilege" error was shown when user actually had admin privilege.
Installation: Already installed Git was not detected.
Project: Opening a project after creating a parameter with name that includes "-" shows "Error 127" and could not open the project.
Project: When Importing a project with offline mode, it showed an error that says unable to connect exploratory.io and could not import it.
Generic: Clicking an URL link inside the Chat window opened a blank page.
Generic: Error "parseJsonSafe raises Unexpected token \ in JSON" was raised when data had SJIS's problematic characters. (So called "damemoji")
R Package: Success message was not displayed on Manage R Package Dialog after R Package installation
R Package: Custom R package installed in a project was not automatically checked as used in the project
Data Source: a proper default encoding was not assigned for CSV file data import.
Data Source: SQL Data Source: Comments inside SQL query caused invalid syntax error
Summary View: When hovering a mouse over Column Name on Summary View, it broke word in the middle if the column name was long.
Summary View: Histogram chart in the Summary View panel was gone after clicking the chart icon to create a new chart and came back to the Summary View.
Chart: Drag and Drop the Chart Pin button sometimes didn't highlight the target step while it's moving.
Chart: Decision Tree picture size was too small when it's embedded inside Note.
Chart: A previous Chart tab selection was not preserved when moving between Summary and Chart views.
Chart: Scatter chart failed to render if you set a numeric column at Color and enabled the circle option.
Chart: On Windows, vertical scrollbar overlaps with the chart legend of the Line chart.
Chart: Pivot sort by clicking the column header didn't work properly if there were empty rows.
Chart: Heatmap was not showing NA at X/Y Axis.
Chart: It no longer shows the warning dialog when you assign a column with too many unique values to Color.
Chart: Renaming an inactive Chart name didn't reflect the change immediately.
Chart: "Show Details" dialog didn't show the data for "Others" or "NA" group.
Chart: The sample data size number was not reflecting the data size after the Chart level filter being applied.
Chart: Sorting of Bar chart with % of Total Window Calculation was not correct.
Chart: LongLat Map showed unexpected lines if you assigned a column to Label with the "Connect Data Points by Lines" option enabled.
Chart: Pivot Table didn't show factor levels that didn't have any values.
Chart: NA values in row/column header should show something like "(NA)" instead of being empty in Pivot Table
Chart: Trend Line property dialog now shows a reason why Loess trend line type is sometimes disabled.
Chart: Support 'Other Group' for Group By of Bubble and LongLat Map charts.
Chart: Renaming a Chart Tab Name didn't update the Number's caption immediately
Chart: Character and Logical columns in Bubble chart should show the column functions.
Chart: It should show '%' in the balloon and legend if "% of TRUE" is assigned to Color.
Chart: Charts created by "Create a chart" from the Summary view shouldn't have an index number in the chart name unless the name conflicts.
Chart: 'Limit Values' was not effective if "% of Total" Window Calculation was applied.
Chart: Highlight showed only 1 value in the LOV in Area Map.
Chart: Pivot Table failed to render if a column with double quotes was assigned to Value.
Chart: Exclude/Keep Only generated an invalid chart filter on a Pie/Ring chart without Color By/Repeat By.
Chart: Chart Level Filter should not be created if the filter syntax entered in expression editor was invalid.
Chart: Pie/Ring chart didn't show the pop-over by clicking a slice.
Chart: Numeric value on X-Axis with Discrete option didn't sort even the sorting option was set in Bubble Chart.
Chart: "Show Details" Dialog ignored Chart Filter condition for Histogram.
Chart: Failed to show the Show Detail dialog and opened an error dialog with "error code 3" on Scatter chart.
Data Wrangling: Unnecessary column suggestions were shown when the Mutate Dialog was opened from the column header menu.
Data Wrangling: When a step failed to execute, an error message incorrectly mentioned that the error is from the currently selected step even if the error is coming from other step.
Data Wrangling: Adding or updating a Mutate Step sometimes did not update the result on the Table View
Data Wrangling: Selecting a column value from the suggestion was adding extra double quotes in Mutate Expression editor.
Data Wrangling: Summarize: Newly created column should have aggregation suffix as part of the name only when there are multiple entries with the same column with various aggregation functions.
Data Wrangling: Column names were not suggested inside ifelse function.
Data Wrangling: unnecessary column suggestion happened on a Mutate Dialog for excel time to date conversion.
Data Wrangling: When an invalid token exists in the middle of Mutate Step tokens, it should be automatically removed.
Data Wrangling: When a data frame is grouped by group_by function in the Custom R Script Data Source, the grouping status was not shown in the UI.
Data Wrangling: End Date could not be entered for between filter with POSIXct Date columns in Japanese UI.
Data Wrangling: Moving Branch root should change Chart/Analytics Pin Point if the Chart/Analytics points to the branch root.
Data Wrangling: %in% operator was not suggested in Mutate command dialog.
Data Wrangling: The last digit of 64 bit integer is displayed with wrong value in Table View.
Analytics: Deleting an analytics level filter showed an error - Cannot read property 'getAnalysisType' of undefined.
Analytics: Data tab in Time Series Forecast Analytics showed an error with Japanese column name on Windows.
Analytics: Should not show 'Sample Size is set to 50,000' message when the data is less than 50,000 in Analytics view.
Analytics: When exporting Random Forest prediction result from Analytics View, Logical columns were turned into Factor. It should be Logical.
Analytics: Poisson Regression / Negative Binomial Regression: Stopped using Incident Rate Ratio as metric of coefficients when link function is not log.
Analytics: Anomaly Detection: Error “object ‘negative_anomalies’ not found” showed up when Direction of Anomaly is set to Positive
Analytics: Now it shows both training data is and test data for the prediction matrix when Test Mode is enabled.
Analytics: Message text for Other Group disappeared after changing the Analytics configuration.
Analytics: On Build Random Forest Dialog, logical column should not be selectable for numeric regression.
Analytics: Hitting enter key didn't refresh a chart at the input field in the Analytics Chart Property dialog.
Dashboard/Note/Slides: When a note is opened, the related Data Frames were not highlighted in the data frame list (at the left hand side).
Dashboard: Dashboard failed when there are double quotes in the Dashboard name.
Dashboard/Note/Slide: Publishing raised error "Local NTFS volumes are required to complete the operation." when the repository is on a remote file system such as Google Drive File Stream.
Parameter: When updating a parameter value, "Select Values" text was shown over the values in the dropdown.
Parameter: Could not create a new parameter on a Note opened with a separate window
Parameter: Could not edit a parameter that references a deleted data frame or step.
Parameter: Data type validation on Numeric parameter was missing at parameter creation.
Parameter: Input field of Slider Parameter didn't work.
Released on 8/11/2019
Released on 8/7/2019
Here is the v5.3 release announcement blog post where you can find the details for all the new features.
Generic: 'Hide Sidebar' icon didn't show up after hiding it and re-opening a project
Generic: It now use the current OS locale for the R connection if locale is not defined in case of Mac.
Generic: Another R Process running error shows Re-Run button so that users can clear the process without restarting the R session.
Installation: It threw an error complaining about existing Rserve process when switching the repository location.
Installation: When you did not have admin privilege, installed Git/R was not recognized by Exploratory
Project: Create Project failed with git init due to missing email and username
Data Source: MailChimp: Date parameter did not work and gave Unsupported value type for form field 'since' error Customer
Data Source: Redshift: Integer64 columns are forced to be converetd as Numeric columns since Integer64 is not fully supported yet.
Data Source: Google BigQuery: Adding comments inside SQL editor caused an error.
Data Source: Google BigQuery: Opening Data Import Dialog from Source Step ended up with empty Table List under schema section on the Import Dialog.
Data Source: CSV: Support a mode for importing the data as character data type.
Data Source: MailChimp: Date parameter was not working properly.
Data Source: GoogleBigQuery: Support UTF8 data properly.
Data Source: Could not open an SPSS file.
Data Source: PostgreSQL: Upgraded the underlying R package for better quality.
Data Source: SQL: Optimize for data re-fetching logic when importing the data into a data frame.
Data Wrangling: Shortcuts Hint button now show "Control+Enter" for Windows.
Data Wrangling: Filter: Is Not Alphabet condition did not work
Data Wrangling: The calculation text was copied from the existing one even when creating a new calculation in the same Mutate step.
Data Wrangling: Recode: ’Equal Frequency Option' now shows the numeric ranges as the category names.
Data Wrangling: Build Random Forest step has switched to use Ranger for better performance.
Data Wrangling: is_alphabet function to support non-ascii characters properly.
Chart: Heatmap: Now Y axis direction starts from the bottom to the top.
Chart: After creating a chart from Summary View by clicking Quick Chart Icon, the column search box remained.
Chart: Property dialog overflowed if the screen size is small on Windows
Chart: Pie chart failed to render if you switch the chart type from Bubble
Chart: Enter key did not refresh the chart when a value was changed in Chart Property Dialog
Chart: Show Details should show a user friendly filter condition information.
Chart: Multiple LOV dropdowns opened at a time in the chart property dialog.
Chart: Reference line was not showing when the bar chart in the horizontal mode.
Chart: Area Map failed to render when I changed the data type from number to logical.
Chart: When drag and drop a Chart Pin, unwanted pin image was shown at the left hand side top.
Chart: The dropdown list for Highlight was empty when a numeric column was assigned to Color and the data function was changed to Text/Int/Int10.
Chart: The mouse over pop-up always showed the 1st measure information even when there are multiple measures.
Chart: Pivot: Support Post Calculation for the Grand Total
Chart: The order of the Repeat By was corrupted if you assigned a numeric column that contained positive and negative values.
Chart: Comment: In the Comment Dialog, Enter key didn't work.
Chart: The DAY aggregation function was reset to YEAR when you switch columns.
Chart: Violin Plot: Sorting is now supported.
Chart: Column value dropdown was sometimes empty inside Highlight dialog.
Chart: "Number" chart thumbnail didn't get updated when it was duplicated.
Chart: Word Cloud thumbnail didn't get updated when moving between Table view and Chart View.
Chart: Number chart failed to render when the chart type was changed to Number from Pivot
Chart: Pivot: Grand Total was not reflecting the current sorting order.
Analytics: Prophet: Error 'argument "n.changepoints" matched by multiple actual arguments' was raised when number of changepoints was specified
Analytics: Decision Tree: Multiclass Tree was displayed without color
Analytics: Decision Tree did't use the full available space for the first time rendering
Analytics: PCA: NA was showing up when there was no NA
Analytics: On the Delete Confirmation Dialog, Hitting Enter Key did not work.
Analytics: Prophet: Support Logical data type columsn for Holiday variable.
Analytics: K-Means Clustering: It was producing a wrong result.
Parameter: On Dashboard, a default value was not populated on single LOV
Note: The Markdown table text now uses bigger font size.
Note: Set "dpi=300" in the default R code block template to avoid blurred graphical output from R.
Dashboard/Note/Slide: It should not show Parameter button when not necessary
Released on 6/3/2019
This release is to certify R 3.6. The installation of v5.2.1 will automatically install R 3.6, and this will make all the R packages you have installed in the past invalid and you will be asked to re-install them so that they will be compatible with R 3.6.
Released on 5/17/2019
Released on 4/12/2019
Released on 4/10/2019
Released on 4/6/2019
Released on 4/2/2019
Check out all the new features in the following v5.1 introduction announcement blog posts!
And here is a list of the other enhancements and bug fixes.
Installation: Support Exploratory Repository Location Switch from System Configuration UI
Chart: Support "Include Outlier" in Histogram/Scatter/Violin/Density charts.
Chart: Order support in Rank Window function.
Chart: Duplicating a Chart now place the copied chart right next to the original chart.
Chart: Pivot/Table to remember the last sort position and direction.
Chart: Show/hide row header option support in Pivot.
Chart: Categorical column support on X/Y Axis in Bubble chart.
Chart: Support categorical colors on Pivot text measure.
Chart: Property key value shouldn't show if the 1st label is set as a title in Area Map.
Analytics: "Normalize Data" parameter is now supported in K-Means Clustering command dialog.
Analytics: Correlation Analytics View: Group By is supported.
Analytics: Correlation Analytics View: Scatter Matrix is added.
Analytics: Re-designed "Adjust Imbalanced Data" feature inside Analytics View and the command dialog.
Analytics: Chi-Square: Supported grouping functions for numeric variables
Analytics: T-Test: Properties such as "Paired" are supported.
Analytics: Support 'Return' key on Analytics Property Dialog to execute Analytics.
Wrangling: Single Select Column List now automatically selects the first item if a user types in to find a match
Wrangling: Introduce 'Add a new step' at the end of the right-hand side steps list
Wrangling: Mutate Dialog now shows a warning message when it detects non-ASCII numbers and special characters in an expression without quotes.
Wrangling: Support Aggregate Filter options on Filter Dialog
Wrangling: Support additional str functions (str_trunc, str_normalize, etc) for Column Header Menu
Wrangling: Slice command did not set n() as end argument by default.
Wrangling: Add column menu for Excel numeric date/time to POSIXct
Wrangling: Join command now supports 'Case Insensitive' mode.
Wrangling: Added Ascending and Descending Options to Rank Column Header Menu
Reports: When creating a Note, Data Frame was not searchable on Chart and Analytics Pickers.
Reports: Note: Improved the plain table style in Note.
Reports: Dashboard: You can set a Dashboard name when creating a new Dashboard with "Add to New Dashboard" menu inside Chart view.
Data Source: Support Account Switch for OAuth Data Sources (Google Sheet, Google Analytics, Google BigQuery, Stripe, MailChimp, Twitter Search)
Data Source: Enhance EDF import so that you can import a Report EDF from Data Frame Menu (and a Data Frame EDF from Report menu)
R Package: Support R Package Installation from inside a Project
Schedule: Data refresh on server is supported even when local file data sources, such as local CSV files, are joined.
Installation: when there is a .Rprofile sometimes it caused an error when opening the projects.
Installation: When upgrading Exploratory on Windows, 'Switch Repository Location' dialog was displayed even if the repository already existed.
Installation: OS locale was not automatically picked up on Windows.
Installation: An empty screen was shown after the fresh installation.
Installation: On Windows, sometimes Exploratory Desktop doesn't start and stuck with the Starting-up Screen.
Summary: NA value shouldn't ben shown as a bar Summary view.
Summary: Summary view failed when the data frame had only one column and that is POSIXct.
Chart: Histogram didn't show all the factor levels in legend.
Chart: Legend showed weird items if you assigned a numeric column with NA to Color in Boxplot.
Chart: Property Menu showed up far from the chart property icon
Chart: Other Group info didn't show up when you assigned a numeric column to Color.
Chart: Pivot sort icon was hidden if the text on the column header was long.
Chart: The bucket range was incorrect in Histogram when a column is assigned to Color.
Chart: Couldn't rename the locally installed GeoJSON maps.
Chart: Clicking on 'Show Details' menu inside Chart showed a loading icon forever with Histogram.
Chart: Clicking on 'Show Details' menu inside Chart did not show data when POSIXct/Date columns are assgined to X-Axis.
Chart: 'Show Detail' doesn't show the data with floating numbers in scatter.
Chart: Scatter chart with the range data din't work properly with % (Percent) Number Formatting for Y-Axis.
Chart: Order of chart thumbnails displayed by mouse hovering on data frame didn't reflect the order of the actual chart tabs.
Chart: % (Percent) number format should be done automatically if the % based aggregation function is used for Number.
Chart: Creating a new chart caused an error - "Cannot read property 'top' of undefined".
Analytics: PCA biplot chart showed NA in the chart legend.
Analytics: In Property dialog, hitting the "Enter" key for IME(Input Method Editor) selection caused the Analytics to be executed.
Analytics: Heatmap color palette option didn't work in Correlation analytics view.
Analytics: The order inside the chart legend in Survival Analysis was wrong when a logical column is assigned.
Analytics: Decision tree didn't show Japanese characters correctly.
Analytics: Canceling Analytics View raised error "Cannot read property 'evaluate' of null".
Analytics: Survival Curve: The green message text about Others group was not displayed when coming back from Table View
Analytics: Chart was sometimes not displayed even when it was generated before.
Analytics: Market Basket Analysis: Color was not utilized for indicating confidence of rules.
Analytics: Numbers in scientific notation was not shown correctly in Linear Regression.
Analytics: After the PC wakes up from the sleep mode, adding a new analytics caused an error.
Analytics: a chart from a different Analytics in a different data frame was displayed.
Analytics: Setting a random seed by default for Analytics View to be able to reproduce the same result.
Analytics: Exploratory process did not go away even after shutting down the app after using Time Series Forecasting.
Wrangling: In Create Bin dialog, Chart was not displayed when the previous step was disabled.
Wrangling: In Column Selection Dialog, selecting columns sometimes caused an incorrect column order.
Wrangling: Multi-Step Selection did not work when the Source step is also selected along with other steps.
Wrangling: 'Clean Column Names' did not handle non-ASCII characters well.
Wrangling: In Create Bin dialog, description text was cut off by chart bottom
Wrangling: In Custom R Command dialog, join target columns were not suggested when typing join command.
Wrangling: In Filter Dialog, the list of values did not show all the values from a given column.
Wrangling: In mutate step, another token was created after empty token
Wrangling: In Table View, 'Rows to show' dropdown didn't work if there were less than 500 rows.
Wrangling: 'Change Data Type to Character' ended up converting the columns to Factor data type when selecting multiple columns.
Wrangling: Creating a new step didn't work when Auto-Run mode is set to 'Off'.
Wrangling: 'New Token' button inside Mutate step was sometimes disabled.
Wrangling: 'Convert Excel Numeric to Date' menu was not available when multiple columns are selected.
Reports: Clicking URL link opened another application window instead of opening an external browser in Note.
Reports: Position of an embedded chart with full width option was off in Note when TOC was enabled.
Reports: Restoring Dashboard from the history didn't work.
Reports: Dashboard rendering failed and showed an error: "Error at running Dashboard - Error in file(con, "w") : cannot open the connection".
Reports: Dashboard: Unnecessary padding showed between rows when Numbers are inserted in Dashboard.
Data Source: Data import failed with data which contains date data type columns whose date range is too small.
Data Source: In Data Source dialog, after account is switched, viewID (for GA) and Sheet (for Google Sheets) didn't get updated automatically.
Data Source: Dremio Data Source didn't handle Data type correctly.
Data Source: Google BigQuery Data Source raised "Response Too Large To Return" error and could not import data.
Data Source: Enhance ODBC Database Connection to detect ODBC drivers and change to timeout in 30 sec for getting a connection.
R Script: Copied and pasted script on R Script Data Source didn't work on Windows because of the wrong new line feed character handling
Released on 2/14/2019
Released on 2/13/2019
Repackaged 5.0.1.0 release with the Installer. You can double click the downloaded EXE file to start the installer. Once you finish the installation, you will have shortcuts on Desktop and Program Menu. You can also uninstall Exploratory from the Windows Control Panel.
The product functionality is the same as 5.0.1.0 release.
Released on 2/04/2019
Released on 1/02/2019
Released on 12/10/2018
Released on 10/31/2018
Check out all the new features at the following v5.0 introduction announcement blog posts!
And here is a list of the other enhancements and bug fixes.
General
Data Source
Data Wrangling
Viz / Chart
Analytics
General
Data Source
Data Wrangling
Viz / Chart
Analytics
Dashboard/Note/Slides
Released on 8/13/2018
Released on 7/31/2018
Released on 7/15/2018
Released on 6/22/2018
Released on 6/19/2018
Released on 6/12/2018
Released on 4/18/2018
Released on 4/8/2018
Released on 3/25/2018
Released on 2/19/2018
Released on 2/19/2018
Released on 2/3/2018
Released on 1/30/2018
Released on 1/28/2018
Released on 1/23/2018
Released on 1/23/2018
Released on 1/3/2018
Release announcement blog post
Released on 12/15/2017
Released on 12/13/2017
Released on 10/28/2017
Released on 10/22/2017
Released on 10/21/2017
Released on 9/16/2017
Released on 8/27/2017
Released on 8/8/2017
Released on 8/7/2017
Release announcement blog post
Released on 6/9/2017
Released on 6/6/2017
Released on 6/5/2017
Release announcement blog post
Released on 5/20/2017
Released on 5/18/2017
Released on 5/11/2017
Released on 5/16/2017
Released on 5/14/2017
Released on 5/7/2017
Released on 5/6/2017
Released on 5/4/2017
Released on 5/2/2017
Released on 5/1/2017
@{<expression>} is not working.Released on 4/29/2017
Released on 4/27/2017
Released on 4/14/2017
Released on 4/12/2017
guess_max must be a positive integerReleased on 3/13/2017
Released on 3/7/2017
Released on 3/3/2017
Released on 2/27/2017
Released on 2/8/2017
Released on 1/26/2017
Released on 1/25/2017
Released on 1/24/2017
Released on 12/1/2016
Released on 11/10/2016
Released on 10/26/2016
Released on 10/10/2016
Released on 9/29/2016
Released on 9/21/2016
Released on 8/29/2016
Released on 8/26/2016
Released on 8/16/2016
Released on 7/29/2016
Released on 7/18/2016
Released on 7/5/2016
Released on 7/1/2016
Data Share - Now you can publish and share your data at any step of the data transformation pipeline (right hand side) with a click of a button through Exploratory.io. The published data can be downloaded and imported into your project along with the data transformation steps so that others can understand how the data was prepared, can reproduce the data with all the steps, and can modify or add their own steps. This would make it easier for you to collaborate with your team members through data.
New remote data support - Redshift, PostgreSQL - Now you can write SQL queries to extract data from these two data sources, much like existing MySQL / MongoDB options.
Custom R package installation - Finally, you can install your preferred R packages inside Exploratory Desktop. In this release, the installed packages will be automatically loaded when you open the projects. In future release. you will be able to control this at each project level. Also, only CRAN repository is supported for this release, but Github support will be coming shortly.
'get_sentiment' function has been refactored so that now it can return the sentiment for sentences, not just per word. The old version of 'get_sentiment' functionality is now provided through 'word_to_sentiment' function. The new 'get_sentiment' function uses sentimentr package internally, which provides a super fast sentiment scoring capability at the sentence level.
tidyr is upgraded to v0.5.1. The biggest new addition with this upgrade is 'separate_rows' function, which would separate delimited words into rows. Detail
dplyr is upgraded to v0.5.0. There are many enhancements and new functions with this release. Here's the detail. Note that 'distinct' function has been updated to keep only the specified columns and this might break your transformation steps. You can bring those dropped columns back with '.keep_all=TRUE' argument. Also, now column names with multibyte characters is supported in 'mutate' command. Great news for users in East Asia!
Reproducible! with R script generation - Now the generated R script contains all the core R packages with 'library' commands and '.libPaths' command to set the library path to Exploratory repository. This will make it a lot easier to reproduce the transformation steps outside of Exploratory Desktop, such as R console, RStudio, etc.
Released on 6/20/2016
Released on 6/19/2016
Released on 6/16/2016
Released on 6/6/2016
Released on 6/2/2016
Released on 5/30/2016
Released on 5/26/2016
Released on 5/26/2016
Text data wrangling with the tidytext package, which makes it easy to work with text data in a tidy format.
With this tidytext package introduction, we are introducing unnest_tokens and pair_counts functions from the tidytext package as data frame level functions and get_sentiment and get_stopwords functions from the exploratory package as mutate / filter level functions.
Introducing 'ip_to_country' function from the rgeolocate package to convert from IP addresses to country names.
Introducing 'countrycode' function from the countrycode package to map among all the combinations of country names and country codes including ISO2 and ISO3 letters and numbers.
Introducing 'calc_cor_cat' function from the exploratory package to calculate correlations between all the combinations of category column values based on a tidy data. There is also another function 'calc_cor_var', which calculate correlations between all the combinations of a given set of columns (variables).
Introducing a new chart type 'Choropleth - Map' which would visualize the data based on either US State names or World country names.
Released on 5/16/2016
Released on 5/9/2016
Support Correlation calculation with Base R (stats pkg) cor() function.
calc_cor(ARR_DELAY, DPE_DELAY, DISTANCE)
> This will produce correlation values for each pair.
Text Matching function - str_count_all
Note that this is not from 'stringr' package.
str_count_all("I ate banana, apple, and peach yesterday, and banana, peach today.", patterns=c("apple", "banana"), remove.zero=TRUE)
> Returns a list column of data frames with 'apple' and 'banana' columns.
Twitter Search Data Support
Added Heatmap and Contour chart types
Clustering function improvement
Now you can specify which columns to use for building the clustering with Base R (stats pkg) kmeans() function.
do_kmeans(ARR_DELAY, DEP_DELAY, DISTANCE, groups = 5)
Scatter plot: the circle sizes are now scaled better based on the values assigned to Size shelf
Local data types are organized and presented better in Data Import Dialog
Syntax Suggestion: Now it supports mutate_each / summarize_each functions with funs() for the syntax suggestion and help.
Syntax Help: the help text and table are formatted much better now.
Command builder menu for the following data types are supported. : difftime, interval, time, period
Hot Key support - 'Return (Enter)' key can be used instead of clicking on OK button (e.g. Login UI, Create a new project dialog, etc)
Table: You can click rows to highlight now.
Chart: Line chart used to be starting from the minimal value on Y-axis, but now it starts from 0 just like Bar chart.
Released on 5/2/2016
Released on 4/26/2016
Released on 4/18/2016
Released on 4/11/2016