# HowTo **URL:** https://community.exploratory.io/c/howto/9.md?page=1 [Latest](https://community.exploratory.io/latest.md) · [Categories](https://community.exploratory.io/categories.md) **Page:** 2 --- ## [Get a Value from a Specific Row in a Column](https://community.exploratory.io/t/get-a-value-from-a-specific-row-in-a-column/3960)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [July 3, 2025, 4:06pm UTC](https://community.exploratory.io/t/get-a-value-from-a-specific-row-in-a-column/3960 "2025-07-03T16:06:22Z")
This guide explains how to extract a value from a specific row number by creating a calculation from the column header menu. Get the First Row’s Value with the first() Function From the Sales column header menu, select … --- ## [How to Calculate Row-wise Sums for Multiple Numeric Columns with Missing Values (NA)](https://community.exploratory.io/t/how-to-calculate-row-wise-sums-for-multiple-numeric-columns-with-missing-values-na/3959)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [July 3, 2025, 3:33pm UTC](https://community.exploratory.io/t/how-to-calculate-row-wise-sums-for-multiple-numeric-columns-with-missing-values-na/3959 "2025-07-03T15:33:20Z")
You may want to calculate the row-wise sum of multiple numeric columns, such as Service\_Usability and Service\_Quality, which may contain missing values (NA). If you simply use the + operator to add them, rows where eith… --- ## [To access Google BigQuery with a service account, which service account file should I specify?](https://community.exploratory.io/t/to-access-google-bigquery-with-a-service-account-which-service-account-file-should-i-specify/3956)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [July 3, 2025, 12:02am UTC](https://community.exploratory.io/t/to-access-google-bigquery-with-a-service-account-which-service-account-file-should-i-specify/3956 "2025-07-03T00:02:58Z")
Starting with Exploratory Desktop v13.2, you can now connect to Google BigQuery using a service account. Here we’ll explain the service account file required for this connection. For Google BigQuery, you need to specify… --- ## [Excluding Rows with a Specific Numeric Value](https://community.exploratory.io/t/excluding-rows-with-a-specific-numeric-value/3952)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [June 27, 2025, 2:11am UTC](https://community.exploratory.io/t/excluding-rows-with-a-specific-numeric-value/3952 "2025-06-27T02:11:45Z")
When you want to remove specific values (e.g., 0) from numeric columns, click on the column header menu of the numeric column. From the menu, select “Filter” and then click “Is Not (Single Value)” When the Filter dia… --- ## [How to change the order of bars in the Bar chart](https://community.exploratory.io/t/how-to-change-the-order-of-bars-in-the-bar-chart/3946)
**Author:** [@user1](https://community.exploratory.io/u/user1)\ **Replies:** 0\ **Last updated:** [June 21, 2025, 12:18am UTC](https://community.exploratory.io/t/how-to-change-the-order-of-bars-in-the-bar-chart/3946 "2025-06-21T00:18:34Z")
When you assign a character column to the X-axis of a bar chart, the bars are sorted alphabetically by default. If you want to customize the order, you can convert the column to a factor and specify the order you prefer. … --- ## [How to Change the GCP Project Used for Google BigQuery Connections](https://community.exploratory.io/t/how-to-change-the-gcp-project-used-for-google-bigquery-connections/3939)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [June 13, 2025, 4:17am UTC](https://community.exploratory.io/t/how-to-change-the-gcp-project-used-for-google-bigquery-connections/3939 "2025-06-13T04:17:39Z")
How to Change the GCP Project Used for Google BigQuery Connections You can change the GCP project used for your Google BigQuery connection by following these steps: From the Project menu, select Data Connections. I… --- ## [Want to draw a moving average line on a chart](https://community.exploratory.io/t/want-to-draw-a-moving-average-line-on-a-chart/3914)
**Author:** [@Ikuya\_Murasato](https://community.exploratory.io/u/Ikuya_Murasato)\ **Replies:** 0\ **Last updated:** [May 20, 2025, 7:54am UTC](https://community.exploratory.io/t/want-to-draw-a-moving-average-line-on-a-chart/3914 "2025-05-20T07:54:12Z")
When you want to calculate a moving average or moving sum on a chart, select “Moving Average” from the Window Calculation in the Y-axis menu. Then, a green window calculation text will be added. By clicking on it, yo… --- ## [How to Create a "Grouped Bar Chart" with Multiple Bars per Item](https://community.exploratory.io/t/how-to-create-a-grouped-bar-chart-with-multiple-bars-per-item/3906)
**Author:** [@Takato\_Shiroto](https://community.exploratory.io/u/Takato_Shiroto)\ **Replies:** 0\ **Last updated:** [May 15, 2025, 12:44am UTC](https://community.exploratory.io/t/how-to-create-a-grouped-bar-chart-with-multiple-bars-per-item/3906 "2025-05-15T00:44:28Z")
If you want to create a “Grouped Bar Chart” with multiple bars per item, please refer to the note below. --- ## [Why can't I use Logistic Regression with a target variable with 0/1 values?](https://community.exploratory.io/t/why-cant-i-use-logistic-regression-with-a-target-variable-with-0-1-values/3897)
**Author:** [@Kan\_Nishida](https://community.exploratory.io/u/Kan_Nishida)\ **Replies:** 0\ **Last updated:** [May 12, 2025, 4:57pm UTC](https://community.exploratory.io/t/why-cant-i-use-logistic-regression-with-a-target-variable-with-0-1-values/3897 "2025-05-12T16:57:23Z")
If your target column is Numeric data type with 0 or 1 value, then you want to convert to Logical data type first. You can do so from the column header menu. Once you converted the data type to Logical data type, the… --- ## [How to Fix Unexpected Decimals Like 61200.000000000007 When Importing from Excel](https://community.exploratory.io/t/how-to-fix-unexpected-decimals-like-61200-000000000007-when-importing-from-excel/3880)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [April 8, 2025, 3:17pm UTC](https://community.exploratory.io/t/how-to-fix-unexpected-decimals-like-61200-000000000007-when-importing-from-excel/3880 "2025-04-08T15:17:28Z")
Problem When importing an Excel file, some cells correctly show values like 61200, but in other cases, unexpected decimals appear — for example, 61200.000000000007 — even though the value in Excel looks like a clean inte… --- ## [How to install an R package available only on Github](https://community.exploratory.io/t/how-to-install-an-r-package-available-only-on-github/3876)
**Author:** [@user1](https://community.exploratory.io/u/user1)\ **Replies:** 0\ **Last updated:** [March 25, 2025, 7:37pm UTC](https://community.exploratory.io/t/how-to-install-an-r-package-available-only-on-github/3876 "2025-03-25T19:37:31Z")
Please see this note for how to an R package that is available only on Github. If it is available on CRAN or in a file format, you can follow this note to install it. --- ## [How to Encode Column Data as Base64](https://community.exploratory.io/t/how-to-encode-column-data-as-base64/3871)
**Author:** [@user1](https://community.exploratory.io/u/user1)\ **Replies:** 0\ **Last updated:** [March 10, 2025, 4:35pm UTC](https://community.exploratory.io/t/how-to-encode-column-data-as-base64/3871 "2025-03-10T16:35:07Z")
What You Want to Do I want to encode the string data in a column as Base64. Solution For example, to encode string data in a “name” column as Base64 in Exploratory, follow these steps: Add a Create Calculation step. E… --- ## [How to Perform a Silent Installation of Exploratory Desktop on Windows Using Only the Command Line](https://community.exploratory.io/t/how-to-perform-a-silent-installation-of-exploratory-desktop-on-windows-using-only-the-command-line/3869)
**Author:** [@user1](https://community.exploratory.io/u/user1)\ **Replies:** 0\ **Last updated:** [March 3, 2025, 7:42pm UTC](https://community.exploratory.io/t/how-to-perform-a-silent-installation-of-exploratory-desktop-on-windows-using-only-the-command-line/3869 "2025-03-03T19:42:00Z")
Objective To install Exploratory Desktop on a Windows environment using only the command line, skipping the interactive installer and performing a silent installation. Solution Follow these steps to install Exploratory … --- ## [How to Change the URL of an Already Published Insight](https://community.exploratory.io/t/how-to-change-the-url-of-an-already-published-insight/3859)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [February 6, 2025, 4:35pm UTC](https://community.exploratory.io/t/how-to-change-the-url-of-an-already-published-insight/3859 "2025-02-06T16:35:29Z")
How to Change the URL of an Already Published Insight Currently, Exploratory does not offer a direct way to update the URL of a published insight. However, you can achieve this by using the following workaround: Dupli… --- ## [How to hide the page footer in Exploratory Server (On-Premise)](https://community.exploratory.io/t/how-to-hide-the-page-footer-in-exploratory-server-on-premise/3855)
**Author:** [@user1](https://community.exploratory.io/u/user1)\ **Replies:** 0\ **Last updated:** [February 1, 2025, 2:18am UTC](https://community.exploratory.io/t/how-to-hide-the-page-footer-in-exploratory-server-on-premise/3855 "2025-02-01T02:18:42Z")
In Exploratory Server version 11, you can hide the page footer on each page. The configuration method is as follows. 1. Modifying the On-Premise Server Configuration File Open the docker-compose.yml file located directl… --- ## [How to calculate duration between order dates for each customer with ‘lag’ function](https://community.exploratory.io/t/how-to-calculate-duration-between-order-dates-for-each-customer-with-lag-function/3853)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [January 29, 2025, 3:46pm UTC](https://community.exploratory.io/t/how-to-calculate-duration-between-order-dates-for-each-customer-with-lag-function/3853 "2025-01-29T15:46:22Z")
Prerequisites Assume that each row represents one order and that there are columns for the customer ID and order date Open Window Calculation Dialog From the Column Menu, select the “Create Window Calculation”. Crea… --- ## [How to Handle Shared Insights When the Owner or Creator Leaves the Team](https://community.exploratory.io/t/how-to-handle-shared-insights-when-the-owner-or-creator-leaves-the-team/3845)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [January 14, 2025, 4:44am UTC](https://community.exploratory.io/t/how-to-handle-shared-insights-when-the-owner-or-creator-leaves-the-team/3845 "2025-01-14T04:44:40Z")
How to Handle Shared Insights When the Owner or Creator Leaves the Team When using the shared Exploratory server (exploratory.io), certain actions are necessary if the owner or creator of insight leaves the team. Followi… --- ## [How to request the Offline License Key manually if the "Generate License Key" fails](https://community.exploratory.io/t/how-to-request-the-offline-license-key-manually-if-the-generate-license-key-fails/3832)
**Author:** [@user1](https://community.exploratory.io/u/user1)\ **Replies:** 0\ **Last updated:** [December 5, 2024, 5:22am UTC](https://community.exploratory.io/t/how-to-request-the-offline-license-key-manually-if-the-generate-license-key-fails/3832 "2024-12-05T05:22:37Z")
If you encounter an error while clicking the Generate License Key button to create the Offline License Key like the following, you can manually request it by email. Follow these steps to request the Offline License K… --- ## [How can I fill in the NA columns with the duplicated rows then remove the duplicated rows?](https://community.exploratory.io/t/how-can-i-fill-in-the-na-columns-with-the-duplicated-rows-then-remove-the-duplicated-rows/3824)
**Author:** [@Kan\_Nishida](https://community.exploratory.io/u/Kan_Nishida)\ **Replies:** 0\ **Last updated:** [October 25, 2024, 4:53pm UTC](https://community.exploratory.io/t/how-can-i-fill-in-the-na-columns-with-the-duplicated-rows-then-remove-the-duplicated-rows/3824 "2024-10-25T16:53:36Z")
You want to group the data by something like Customer ID (or name) first. Then, you want to use ‘Work with NA’ / ‘Fill NA with Previous / Next Row’. If the order inside the group is not what you expect, then you … --- ## [How to export data automatically on local PC?](https://community.exploratory.io/t/how-to-export-data-automatically-on-local-pc/3817)
**Author:** [@Kan\_Nishida](https://community.exploratory.io/u/Kan_Nishida)\ **Replies:** 0\ **Last updated:** [October 6, 2024, 6:07pm UTC](https://community.exploratory.io/t/how-to-export-data-automatically-on-local-pc/3817 "2024-10-06T18:07:29Z")
You can create a R command step, which will export the data as CSV every time you run the step. Here is the how-to note. Exploratory checks if the underlying data has been changed. If a change was not detected then t… --- ## [How to call multiple R commands in a single Custom R Command step](https://community.exploratory.io/t/how-to-call-multiple-r-commands-in-a-single-custom-r-command-step/3032)
**Author:** [@user1](https://community.exploratory.io/u/user1)\ **Replies:** 0\ **Last updated:** [August 1, 2024, 4:37am UTC](https://community.exploratory.io/t/how-to-call-multiple-r-commands-in-a-single-custom-r-command-step/3032 "2024-08-01T04:37:45Z")
You can use the Custom R Command to run a single command you want. The command should take a data frame as a parameter and return a data frame. (e.g. mutate, filter, etc). ​ But, sometimes you want to run multiple R co… --- ## [How to write back to Snowflake](https://community.exploratory.io/t/how-to-write-back-to-snowflake/2982)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [June 20, 2024, 5:51pm UTC](https://community.exploratory.io/t/how-to-write-back-to-snowflake/2982 "2024-06-20T17:51:37Z")
Here is how to write back to Snowflake. --- ## [How to Resolve the "abc.json: does not match index" Error When Restoring from History](https://community.exploratory.io/t/how-to-resolve-the-abc-json-does-not-match-index-error-when-restoring-from-history/2955)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [May 27, 2024, 3:42pm UTC](https://community.exploratory.io/t/how-to-resolve-the-abc-json-does-not-match-index-error-when-restoring-from-history/2955 "2024-05-27T15:42:41Z")
Error When Restoring Project from History When attempting to restore your project from history, you might encounter the following error: Command failed: git diff --binary master tmp | git apply --index error: dataframs/… --- ## [How to embed Exploratory charts into other applications](https://community.exploratory.io/t/how-to-embed-exploratory-charts-into-other-applications/2911)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [April 17, 2024, 5:16pm UTC](https://community.exploratory.io/t/how-to-embed-exploratory-charts-into-other-applications/2911 "2024-04-17T17:16:05Z")
Here is how to embed Exploratory charts into other applications. Publish Charts to exploratory.io Open the Chart URL with the browser Click the ... menu and select the Embedding Code You can get an HTML (iframe) c… --- ## [Smooth contour plot data](https://community.exploratory.io/t/smooth-contour-plot-data/2871)
**Author:** [@Rob\_Sherlock](https://community.exploratory.io/u/Rob_Sherlock)\ **Replies:** 0\ **Last updated:** [March 14, 2024, 8:06pm UTC](https://community.exploratory.io/t/smooth-contour-plot-data/2871 "2024-03-14T20:06:24Z")
Hello! I’d like to smooth data in a contour plot. I think using a custom function when plotting the data is one way to do this. First I used the custom function to calculate the data means: mean(O2\_umol\_kg, na.rm=TRUE) … --- ## [Scatter Chart for Data from Two data frames](https://community.exploratory.io/t/scatter-chart-for-data-from-two-data-frames/2859)
**Author:** [@pun\_damen](https://community.exploratory.io/u/pun_damen)\ **Replies:** 1\ **Last updated:** [March 6, 2024, 10:47pm UTC](https://community.exploratory.io/t/scatter-chart-for-data-from-two-data-frames/2859 "2024-03-06T22:47:50Z")
Hi, I am quite new to exploratory, and finding it quite useful. I am wondering though if there is a quick way to do a scatter chart based on data from two data frames directly (without joining the data frames manually)? … --- ## [How to offset start of year?](https://community.exploratory.io/t/how-to-offset-start-of-year/2861)
**Author:** [@Rob\_Sherlock](https://community.exploratory.io/u/Rob_Sherlock)\ **Replies:** 0\ **Last updated:** [March 6, 2024, 12:16am UTC](https://community.exploratory.io/t/how-to-offset-start-of-year/2861 "2024-03-06T00:16:00Z")
I have a dataframe of oceanographic measurements organized by sample date: The oceanographic year (here) is based on upwelling, so Instead of Jan-Dec, it runs from ~ March of year 1 to Feb of year 2. I’d like to adj… --- ## [Unsupported Folders for Your Exploratory Repository](https://community.exploratory.io/t/unsupported-folders-for-your-exploratory-repository/2826)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [February 6, 2024, 5:26am UTC](https://community.exploratory.io/t/unsupported-folders-for-your-exploratory-repository/2826 "2024-02-06T05:26:18Z")
Unsupported Folders for Your Exploratory Repository Windows Multi-Byte Characters: We do not support folder names containing multi-byte characters. Space: We do not support folder names containing spaces. Root Drive Loc… --- ## [How to resolve ‘Cannot Perform SELECT’ Error in Snowflake](https://community.exploratory.io/t/how-to-resolve-cannot-perform-select-error-in-snowflake/2824)
**Author:** [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\ **Replies:** 0\ **Last updated:** [February 5, 2024, 4:51pm UTC](https://community.exploratory.io/t/how-to-resolve-cannot-perform-select-error-in-snowflake/2824 "2024-02-05T16:51:33Z")
Problem When attempting to query data from Snowflake, you may encounter the following error message: “Cannot perform SELECT. This session does not have a current database. Call ‘USE DATABASE’, or use a qualified name.” … --- ## [Complete function does not works](https://community.exploratory.io/t/complete-function-does-not-works/2733)
**Author:** [@ramon\_torres](https://community.exploratory.io/u/ramon_torres)\ **Replies:** 0\ **Last updated:** [November 25, 2023, 7:53pm UTC](https://community.exploratory.io/t/complete-function-does-not-works/2733 "2023-11-25T19:53:48Z")
Hi Exploratory team, I am trying to use the function “complete” to fill the gap between empty values in TIME column but it does not work. do you know if there is a new function to do same job or what I am doing wrong?. … [Previous page](https://community.exploratory.io/c/howto/9.md) [Next page](https://community.exploratory.io/c/howto/9.md?page=2)