Exploratory
  • Introduction
  • Product Features
    • Summary View
    • Table View
    • Row Filter
    • Column Filter
    • Dashboard
    • Dashboard (日本語)
    • Note
    • Note (日本語)
    • Steps (Right-hand side)
    • Branch
    • Parameter
    • Parameter (日本語)
    • Export
    • Share
      • Share Type
      • Chart / Analytics
      • Data
      • Report (Note / Dashboard)
      • Notification
      • Version History
      • Restore Older Version
      • CSV API
    • Share (日本語)
      • 共有のタイプ
      • チャート / アナリティクス
      • データ
      • レポート (ノート / ダッシュボード)
      • 通知
      • バージョンの履歴
      • 古いバージョンの復元
      • CSV API
    • Schedule
      • Manage Schedules
      • Notification
      • Scheduling History
    • Schedule (日本語)
      • スケジュールの設定
      • 通知
      • スケジュールの履歴
    • Team
      • Manage Teams
    • Team (日本語)
      • チームの設定
    • Project
      • Import
      • Export
      • Search
  • Data Import
    • File Data
      • CSV / Delimited File
      • Amazon S3
      • Google Drive
      • Google Cloud Storage
      • Excel
      • JSON
      • Log File
      • Microsoft Azure
      • Stats - SAS / SPSS / STATA
      • RData / RDS
      • Parquet File
      • EDF - Exploratory
    • Database Data
      • SQL Troubleshooting
      • Create Connection
      • Amazon Athena
      • Amazon Aurora
      • Amazon Redshift
      • Amazon Redshift (日本語)
      • Google BigQuery
      • HP Vertica
      • MariaDB / MySQL DB
      • MariaDB / MySQL DB (日本語)
      • Microsoft Access
      • MongoDB
      • ODBC
      • Oracle
      • PostgreSQL
      • PostgreSQL (日本語)
      • Presto
      • Snowflake
      • SQLServer (DSN)
      • SQLServer
      • Teradata
      • Treasure Data
    • Cloud Apps Data
      • Create Connection
      • FRED - Federal Reserve of Economic Data
      • Github Issues
      • Google Analytics
      • Google Analytics (日本語)
      • Google Spreadsheet
      • Google Cloud Storage
      • Salesforce
      • Twitter Search
      • Stripe
      • Weather Data
      • Stock Price Data
    • Write R Script as Data
      • Currency Exchange Rate
    • Write R Script as Data (日本語)
    • Web Page Scraping
    • Text Input Data
    • Data Source Extension
      • Quandl
      • Holiday
      • RSS Data
    • Create Custom Data Source
  • Data Wrangling
    • Command Line mode for faster and more flexible data interaction in Exploratory
    • Select / Remove Columns
    • Reorder Columns
    • Create New Calculation
    • Create New Calculation for Multiple Columns
    • Summarize (Aggregate)
    • Group
    • Filter
    • Rename
    • Arrange (Sort)
    • Top / Bottom N
    • Join
    • Merge
    • Gather
    • Spread
    • Pivot
    • Expand
    • Complete
    • Separate
    • Unite
    • Bind Rows
    • Bind Columns
    • Keep Only Unique Rows
    • Keep Only Duplicated Rows
    • Slice
    • Drop NA
    • Sample
    • Impute NA
    • Fill
    • Create Buckets
    • Assign New Values to Existing Values - Recode
    • Assign New Values by Setting Conditions - Case When
    • Work with Categories
    • Data Type Conversion
    • Row as header
    • Ungroup
    • Unnest
    • Separate List Items into Columns (Unnest Wider)
    • Separate List Items into Rows (Unnest Longer)
    • Separate Address (Japan)
    • Hoist
    • Remove Empty Rows
    • Remove Empty Columns
    • Clean Column Names
    • Window Calculation
    • Window Calculation (日本語)
    • Add Row
    • Text Wrangling
    • Regular Expression Cheat Sheet
    • Regular Expression Cheat Sheet (日本語)
  • Visualization
    • Types
      • Pivot
      • Summarize Table
      • Table
      • Bar
      • Line
      • Area
      • Pie/Ring
      • Radar
      • Histogram
      • Density Plot
      • Scatter (No Aggregation)
      • Scatter (With Aggregation)
      • Boxplot
      • Violin
      • Error Bar
      • Error Bar (Summarized Data)
      • Map - Standard
      • Map - Extension
      • Map - Long/Lat
      • Map - Heatmap
      • Heatmap
      • Contour
      • Number
      • Word Cloud
      • Word Cloud (日本語)
    • Features
      • Trend Line
      • Reference Line
      • Repeat By
      • Window Calculation
      • Date/Time Aggregation
      • Show Range
      • Highlight
      • Change Marker
      • Multiple Y-Axis Columns
      • Layout Configuration
      • Column Configuration
      • Column Configuration Dialog
      • Color and Group Setting
      • Color and Group Setting (日本語)
      • Color Setting
      • User Color Palette Setting
      • Pin
      • Save as PNG/SVG
      • Save as Exploratory Data File
      • Share/Schedule
      • URL Link
      • Category (Binning)
      • Highlight
      • Limit Values
      • 'Others' Group
      • Edit Display Name
      • Missing Value Handling
      • Rename Column Names
      • Axis Setting
      • Axis Formatting
      • Show Detail
      • Fit to Screen (Table)
      • Number of Unique Values Check
      • Number of Unique Values Check (日本語)
  • Analytics
    • Correlation
    • Distance
    • K-Means Clustering
    • Principal Component Analysis
    • Factor Analysis
    • Correspondence Analysis
    • Linear Regression Analysis
    • Logistic Regression Analysis
    • Generalized Linear Models
    • Survival Curve
    • Cox Regression
    • Random Survival Forest
    • Decision Tree
    • Random Forest
    • XGBoost
    • Time Series Forecasting (Prophet)
    • Time Series Forecasting (ARIMA)
    • Time Series Clustering
    • Anomaly Detection
    • Word Count
    • Text Clustering with Topic Model (LDA)
    • Market Basket Analysis
    • T Test
    • T Test (Aggregated Data)
    • ANOVA
    • Wilcoxon Test
    • Kruskal-Wallis Test
    • Chi-Square Test
    • A/B Test
    • Normality Test
    • Prediction
    • Dictionaries for Text Analysis
  • Statistics
    • Correlation
    • Distance
    • Cosine Similarity
    • SVD
    • Multi Dimensional Scaling
    • T-test
    • F-test
    • Chi-square test
    • A/B Test (Bayesian)
  • Machine Learning
    • Linear Regression
    • Logistic Regression
    • GLM
    • Multinomial Logistic Regression
    • K-means Clustering
    • Random Forest
    • XGBoost
    • Forecasting
    • Time Series Clustering
    • Anomaly Detection
    • Survival Curve
    • Survival Model (Cox Regression)
    • Market Basket
    • Causal Impact
    • Evaluate Prediction - Regression
    • Evaluate Prediction - Binary
    • Calculate ROC
    • Evaluate Prediction - Multiclass
    • Prediction
    • Prediction - Binary Classification
    • Prediction - Survival Model
    • Simulate Survival Curve
    • Extract Summary of Fit
    • Extract Parameter Estimates
    • Run ANOVA Test
    • Fix Imbalanced Data (SMOTE)
  • Text Analysis
    • Tokenize Text
    • Create N-gram Tokens
    • Calculate tf-idf
    • Count Text Pairs
  • Extend with R
    • R Package Install
    • Custom R Script
    • Custom Model Function
  • Setup
    • Disable McAfee virus scan
    • Change Repository Location
    • Change Repository Location (日本語)
    • Holidays Data for Forecast
    • Possible Reasons for Install Error
    • Upgrade Microsoft .NET Framework
  • Diagnostics
    • Log file for debugging
    • Log file for debugging (日本語)
    • Startup Log file for debugging
    • Startup Log file for debugging (日本語)
    • Check version of Exploratory Desktop
    • How to Recover the History Data
  • Keyboard shortcuts
Powered by GitBook
On this page
  • Display Name
  • Header Font Style
  • Font Style
  • Function
  • Character
  • Number Formatting
  • Date Formatting
  • Time Zone
  • Text Wrap
  • Sort
  • URL
  • Column Width (px)
  • Apply All Columns
  • Color Assignment
  • Color Bars
  • Background / Text
  • With Conditions
  • Apply All Columns
  • Direction
  • All (Down then Across)
  • Row (Across)
  • Column (Down)
  • Column (Down within Group)
  • Column (Down then Across within Group)

Was this helpful?

  1. Visualization
  2. Features

Column Configuration Dialog

PreviousColumn ConfigurationNextColor and Group Setting

Last updated 1 year ago

Was this helpful?

You can change the format of the target column in the Column Configuration Dialog.

Display Name

You can set the column display name that you want to use.

Header Font Style

You can set font styles that you want to use for headers.

Font Style

You can set font styles that you want to use for text in cells.

Function

You can choose the column function you want to apply to the column data if available. The following functions are available depending on the data type of the target column.

Character

  • Uppercase

  • Lowercase

  • Titlecase

  • Extract Alphabets

  • Extract Numbers

  • Extract First Word

  • Remove Spaces

  • Remove Repeated Spaces

  • Remove Alphabets

  • Remove Numbers

Number Formatting

You can set Number Formatting for numeric columns. The following formatting options are available.

  • Type

    • Number: Format as simple numbers. This is the default type.

    • Currency: Format as currency. If you set a currency symbol, it will be added at the beginning of each number.

    • Percentage: Format as percentages. "%" sign will be added at the end of each number.

  • Digit: Number of decimal digits.

  • Symbol: Current symbol. It will be added to it will be added at the beginning of each number if the "Currency" type is selected.

Date Formatting

You can set the date formatting for Date and POSIXct columns at the "Formatting" section.

Time Zone

You can set which time zone to apply for the POSIXct column data.

Text Wrap

You can enable the Text Wrap option to allow showing the text in multiple lines.

Sort

You can set the sort order of the column. You can set either "Descending" or "Ascending". You can set the sort order in multiple columns. In this case, the sort happens in the priority order.

In the case of Summarize Table, there will be no priority option. If you set a sorting option in one place, the sorting option you set in another place will be reset.

URL

You can set a URL Link on the column. You can dynamically construct the link with the associated column values by referencing the column name by ${}. Once you define a URL Link, the column value will be clickable and if a user clicks the value, it opens up the URL in an external browser.

For example, if you have a "Country" column in your table, you can set the URL http://exploratory.io/?q=${Country}. Then, the table output will look like this.

If you click "Germany", a browser opens up the URL https://exploratory.io/?q=Germany

If you have $, {, { or \ in the column name, you need to add a \ letter before each letter like the following.

  • $ -> \$

  • { -> \{

  • } -> \}

  • \ -> \\

For example, if you have a column US$ Sales, the URL should look like http://exploratory.io/?q=${US\$ Sales}.

If you want to use values as a URL parameter, check the "Apply URL encoding for the column value." checkbox.

Column Width (px)

You can set column width. The unit is a pixel.

Apply All Columns

If you check the "Apply All Columns" option, you can apply the column width setting to all the columns.

Color Assignment

You can set a Color Assignment on each column.

Color Bars

You can show inline bars in the column value cells. The bar length is depending on the column value. You can choose colors for positive values and negative values.

The output will look like this.

Background / Text

You can apply color encoding to the column values. You can choose a color palette to apply from the list. You can apply colors to either the value text or background color.

This is an example of the color encoding applied to the background color.

If you assign a categorical data for Value, such as a character column with the "First" aggregation function, the color palette will be assigned to the values in the alphabetical order. If it is a factor column, it will be assigned to the values in the factor level order.

With Conditions

You can apply a specific color only for the values that meet the condition. You can choose an operator and enter the value to construct a condition, and you can choose a color to apply from the list. You can apply colors to either the value text, background color or inline bars.

You can create multiple conditions by clicking the "+" icon. The conditions are evaluated from the top to bottom. You can remove unnecessary conditions by clicking the "x" icon.

The following operators are available.

  • equal to

  • not equal to

  • is in

  • is not in

  • less than

  • less than or equal to

  • greater than

  • greater than or equal to

  • between

  • not between

This is the sample output of the Conditional Formatting.

Apply All Columns

You can check the "Apply All Columns" checkbox to apply the same color formatting for all the other columns including row headers and row totals. It doesn't apply the color formatting to the columns that already have their own Color Assignment.

If you check this checkbox in multiple columns, the setting on the 1st column will be effective.

Direction

For "Color Bars" and "Background / Text" color formattings, you can choose how you group the Values for the color formatting at the Direction option. The following Direction types are available.

All (Down then Across)

It formats Value cells for the entire pivot table.

Row (Across)

It formats Value cells for each row.

Column (Down)

It formats Value cells for each column.

Column (Down within Group)

It formats Value cells for each column within each row group, which means the 2nd Row Header group from the right.

Column (Down then Across within Group)

It formats Value cells for each row group, which means the 2nd Row Header group from the right.