Skip to content

Releases

ChartFactor 5.23

December 10, 2024

High level summary of many updates across ChartFactor Toolkit and ChartFactor Studio

  • New Beta The ChartFactor Studio Assistant allows users to interact with their data without menus, by using simple conversational prompts. Just ask the assistant what data you'd like to explore and visualize. You can ask the assistant to suggest visualizations as well as to explain the visusalization you are seeing in simple terms. Then, you can command the assistant to add the charts as well as the explanations to your dashboard. Finally, you can ask the assistant to deploy your dashboard as a web application. Please contact us to set you up with our AI API. Requires an Open AI token.
  • New Markdown Widget: Easily ask our AI Assistant to explain your visualizations, add explanations to dashboards, and edit them in a simple markdown format.
  • Improved Logging: Enhanced troubleshooting tools for embedded use cases, making it easier to narrow down issues in descriptive and geo visualizations.
  • Local Uploads: A smoother CSV upload experience for local data visualization, available in ChartFactor Studio Desktop.
  • AI Assistant Updates: Now supporting two LLMs (OpenAI and Gemini), we’re continuing to explore innovative new ways to enhance your data experience with AI.

ChartFactor 5.1

June 14, 2024

Studio

  • New ChartFactor Studio now supports custom code to easily extend the functionality of Studio widgets. For example, you can create custom visualizations to render data from multiple data sources, implement custom interactions, query external data sources, and more.
  • New Studio Editor now supports defining a 2nd axis on multimetric trends. Users can now select a second y-axis for newly added metrics to visualize them on a different scale.
  • New Automatic switch from bars, trends, area lines, and floating bubbles to their multimetric equivalents, for a more intuitive user experience in ChartFactor Studio
  • Fix for the Data Provider validation issue reported when editing an existing URL
  • Fix for auto-upgrade issue on Intel Macs: If auto-upgrade is not working, please remove ChartFactor Studio from the Applications folder and re-download from our website. Auto-upgrade will start working from there on.

Toolkit

  • New Multimetric Pie and Donut charts now require no attributes (e.g. groups). Users can now create these charts with only metrics.
  • New Multimetric Bars now require no attributes (e.g. groups). Users can now create multimetric bars with only metrics.
  • New Multimetric Trend charts now support a 2nd y-axis for metric selection and settings. This allows you to easily place a right axis with a different scale to better visualize metrics.
  • New Word cloud now includes a setting to specify that it should render words only horizontally, not vertically. The word cloud also brings updates to fix overlapping issues during animation.
  • Interaction Manager's modern skin was improved to better support range filters

ChartFactor 5.0

March 7, 2024

Studio

  • New ChartFactor Studio Desktop now supports local uploads. Easily upload your CSV files to visualize them immediately. Studio automatically suggests data types that you can quickly edit if needed. The uploads module also includes a "Manage" tab where you can delete your uploaded files or edit their data types.
  • New Users can now provide application descriptions right from the home page using its context menu
  • New Our Studio Desktop version now includes an auto-update feature so you are always on the latest, no need to unzip versions and run a web server. Also, we now include an installer specific to Apple's M chip (Silicon). So, if you have a Mac with an M chip, you will enjoy great performance improvements.
  • Our AI chart suggestions are improved with more suggested charts than before
  • Databricks integration is improved to avoid passing the Personal Access Token (PAT) when sharing applications
  • Table pinned columns support: interactive code generation

  • New heatmap options for data zoom and client filters (see video)

Toolkit

  • Field selector improvements to support Map GL circle and shape layers as well as column groups and pivot queries
  • Table pinned columns support
  • Table column statistics component improvements to allow for more configuration
  • Table column filters mobile support improvements

ChartFactor 4.18

October 18, 2023

Studio

  • New AI Suggestions (beta), available in ChartFactor Studio. It requires a valid OpenAI API token that you can provide in the AI Suggestions' settings section. It works by sending data aggregates, similar to the ones you see on the top row of the Raw Data Table, to obtain table and field descriptions in addition to chart suggestions that can be added to your Studio app with the push of a button.
  • New Chart descriptions that users can provide themselves or update when the chart is AI suggested
  • New Studio chart editor ability to drag/drop groups or metrics to change their order when your chart has more than one group or metric respectively.

Toolkit

  • New Databricks integration: You can now use the ChartFactor toolkit to easily visualize data in your Databricks data warehouse. It is also available in ChartFactor Studio through our Electron app or through ChartFactor Node.
  • New Geo Map GL support for 3D models (beta) in glTF format
  • New Geo Map GL support for custom polygons and distance filters for markers and heatmap layers. Similar to Geohash queries, available where supported by the data engine. Auto tested with Postgres, Elasticsearch, and BigQuery.
  • Scatter Plot support for no grouping at the toolkit and Studio levels. Example below. Also, please review its documentation

image

  • Box Plot support for no grouping at the toolkit level. Please review its documentation
  • Improved data-zoom and auto-drill-in functionality for trends

ChartFactor 4.1

March 21, 2023

Studio

  • New Map GL Editor allows you to easily create multi-data-layer geographical maps with shapes, markers, proportional circles, heat maps, tile, and WMS layers
  • New KPI UI Editor allows you to configure KPI widgets with specific labels, colors, and positioning options while always showing you the code for easy embedding
  • New Static filters option enables you to view, add, and remove static filters for any visualzation. You can easily exclude values (nulls, outliers, etc) or apply specific filters to your visualization independent from other filtering interactions.
  • New Time offset metric for KPI and Multimetric Trend visualizations to enable users to quickly configure time period comparisons
  • New Growth rate metric for KPI visualizations allows you to quickly configure and visualize growth rates for any metric
  • New Metric option to enable/disable the rendering of aggregation functions in the visualizations tooltips and axis labels
  • New Custom queries support for data provideds running on the server side so that users can configure custom SQL for their SQL providers even when ChartFactor data providers are deployed on the server-side instead of deployed as a front-end-side monolith.

Toolkit

  • New Geo Map GL allows you to visualize geospatial data and provides an improved API, improved performance, and 3D rendering capabilities when compared with our previous Geo Map versions
  • New Intersection queries which are ideal for heatmaps and multi-group trends. They are supported across SQL and No-SQL data providers.
  • New ChartFactor Node support for custom queries so that users can configure custom SQL for their SQL providers even when ChartFactor data providers are deployed on the server-side instead of deployed as a front-end-side monolith.
  • New Mouse drag or finger pinch support for bar and trend charts to select one or more shapes as filters
  • New Auto-drill option for trend charts allows you to drill-in to different time granularities depending on the size of the time window selected. It includes out-of-the-box breakpoints that you can also configure using the Interaction Manager.
  • Geo Map v1 rescale option for heat maps allows you to better visualize sparse data
  • Markup widget improvements
  • Raw data table tooltip rendering options

ChartFactor 4.0

January 3, 2023

Studio

  • New Geo Map UI Editor that includes:

    • Shape layer editor to configure shape metrics, color palettes and ranges, legends, shape opacity, animation, and visibility zoom ranges between many other options
    • Marker and Heatmap layer editor to easily enable geo-hash query precisions, configure marker color palettes, legends, query limits, and visibility zoom ranges between many other options
    • Proportional circles layer editor to configure circle metrics, tooltip fields, color palettes, opacities, query limits, legends, and visibility zoom ranges between many other options
    • Tile WMS layers with layer, max zoom, and format, between other options

  • New GeoJSON library application to easily browse and select GeoJSON files for Geo Map shape layers, directly accessible from Studio's Geo map UI editor

  • New Geo map layer control widget to easily view layer legends and manage layer order/priority

  • New Studio UI for the Sankey visualization

  • New Studio UI for the Tree visualization

  • Data list widget improvements

  • Raw Data Table improvements including an option to quickly beautify field labels

  • Enhanced Markup widget functionality adding many more editing tools

Toolkit

  • Geo Map revamp with many enhancements including between others:

    • Declarative multi-layer support from any source
    • Enhanced zoom info control
    • Dynamic color legends for marker clusters: they update as users zoom-in and out and markers re-cluster
    • New heatmap layer plug-in functionality
    • Layer control widget to allow users to easily change their map layer priority and visibility as well as viewing the legend of the geo layer when enabled

  • Elasticsearch/Opensearch native GeoPoint type support

  • Vector Map and Heat Map color enhancements

ChartFactor 3.2 and 3.3

September 5, 2022

Studio

  • New Interaction Manager widget UI stays always at the top of the page as users scroll through their dashboards. It supports all IM options including both classic and modern skins.

  • New Studio "hide title" option for its widgets, useful when the purpose of the widget becomes self-explanatory

  • New Serie label UI allows to render metric values on top of visualization shapes with a simple yet powerful user interface. It is available for Bars, Multimetric Bars, Pies, Donuts, and Tree Maps. The component includes automatic behavior for colors (auto-assigning color depends on the shape color) and rotation (auto-rotation depending on the width of the shape). Users can easily override these auto-assignments if they prefer. Additionally, they can specify background colors, text alignments, label positions when rendering labels inside or outside the visual shape, between other properties.

  • New Widet title functionality allows users to use markdown and HTML tags in their widget tittles

  • New Studio Field Selector UI allows users to add field selector components to their dashboards to enable dashboard consumers to configure attributes and metrics for one or multiple visualizations at the same time. Just select the charts that you want your users to be able to update, the options that should exist in the field selector, and any details on the attributes and metrics to update.

  • New Studio Group Legend UI allows users to add group legends to their dashboard. A group legend component is a legend for one or many visualizations. It is a "live" legend in that it updates as users interact with the visualizations. It supports triggering filters by selecting/deselecting one or many legend items. It also supports hovering and client filtering. Client filtering allows users to keep the filtered-out items around in a gray-out fashion.

  • Trend and Area Line UI improvements for better transitioning between bars/stacked bars and trend charts

  • Text Search component improvements

  • Enhanced widget pull-down menu

ChartFactor Py

  • Raw Data Table UI improvements for better field drag/drop functionality

Toolkit

  • Postgres data provider support for:

    • Geohash queries
    • Bigint, smallint, and int, in addition to int2, int4, int8, and integer data types

  • Support for additional filter operations such as EQUALI (case insensitive EQUAL), LIKE and LIKEI (case insensitive LIKE) for SQL-based providers such as Postgres, BigQuery, and Snowflake

  • Trend and Area Line API improvements

ChartFactor 3.1

July 8, 2022

Studio

  • New Glass-box support across all ChartFactor Studio functions using our new ICU (Intelligent Code Updater) engine. Users can view and copy the code of their visualizations as they drill-down, drill-up, slice and dice their data. It supports UI (user interface) mode and Editor mode, accurately merging code changes without the need of code markers.

  • New Users can now easily assign specific colors to attribute values, metric ranges, and enable automatic color range generation using the UI. This functionality was previously available only using the code editor.

  • New Users can now use the UI to specify if they'd like to highlight a selected element in a visualization (e.g. bar chart) while keeping the other elements in view as opposed to removing filtered-out elements. This functionality was previously available only using the code editor.

  • New The Slicer and Drop-down components now include a user-friendly chart configuration. Studio now includes user-friendly chart configurations for Bars, Disk, Donut, Packed Bubbles, Pie, Nested Pie, Tree Map, Tree Map 2D, Trend, Word Cloud, Multimetric Bars, Multimetric Trend, Histogram, Box Plot, Vector Map, Heat Map, Floating Bubbles, Slicer and Drop-down.

ChartFactor Py

  • New ChartFactor Py on Jupyter Lab now supports saving and exporting notebook files containing fully interactive ChartFactor Studio apps for easy sharing and version control.

Toolkit

  • New Searching within slicers and column filters support now infinite data, allowing users to quickly find and select any data item no matter how big the dataset

  • New Drill-down and drill-up can now be declaratively defined across multiple sources so that users don't need to accommodate their data to implement these special cases

  • The restriction functionality of the Interaction Manager now enforces parent/child filter relations not only when adding/removing filters but also when enabling and disabling them, triggering notification events when these rules are not met.

ChartFactor 3.0

ChartFactor Py

  • New ChartFactor Py is a new product built on top of ChartFactor that enables you to visually interact with your pandas dataframes in JupyterLab and Jupyter Notebook without having to write code and without moving your data.

    With ChartFactor Py, you can easily create beautiful web-based visualizations and interact with them using the ChartFactor Studio canvas in your Jupyter Lab or Jupyter Notebook environment. You can visually examine column statistics, create multiple charts, filter between them, and use the "Copy code" function to copy the code of any of your charts and paste it on a separate cell.

Studio

  • New Support for Jupyter and JupyterLab environments with "copy python" code functionality for all widgets, cell height management, and immediate display of available dataframes on initial rendering

  • Expanded its user-friendly chart configuration support, now available for the following charts: Bars, Disk, Donut, Packed Bubbles, Pie, Nested Pie, Tree Map, Tree Map 2D, Trend, Word Cloud, Multimetric Bars, Multimetric Trend, Histogram, Box Plot, Vector Map, Heat Map, and Floating Bubbles.

  • New Intelligent Code Updater engine (ICU) provides accurate code generation while also allowing users to edit that same code. Deployed initially on the metadata module.

Toolkit

  • New Pandas dataframes data provider enables the visualization and filtering across charts using pandas dataframes as well as multi-source filtering with other data engines such as BigQuery and Elasticsearch
  • New Users can now easily render column statistics for all columns of a raw data table with a simple setting. Column statistics calculations and rendering work lazily as users scroll horizontally through table columns.
  • New Tree Data Table for hierarchical data with expand/collapse functionality and support for unlimited amounts of data for Elasticsearch
  • Open sourced ChartFactor Node, a reference implementation of a Node server running ChartFactor data providers on the server-side to power lightweight visual analytics
  • Word Cloud improved animation for data in motion
  • Packed Bubbles improved animation for data in motion

ChartFactor 2.3

November 9, 2021

Studio

  • Brand-new raw data table user interface enables you to create column groups, column filters, relabel fields, limit page sizes, apply color themes, and modify them as needed, between others without typing a line of code.
  • Improved data exploration experience. Now the RDT appears as soon as you select your source instead of the bar chart. Also, the Interaction Manager is added automatically to your dashboard when you enable column filters.
  • Smart time granularity defaulting for trend and area line charts: Studio picks the right time granularity (e.g. year, month, day, hour, minute) as soon as you select the chart. You can of course adjust it if needed.

Toolkit

  • 10x loading time improvements for data streaming applications. Try it out with our https://chartfactor.com/cx-analytics/ app!
  • Bundle sizes of toolkit and interactive modules are significantly smaller, 14% and 36% reduction respecively
  • Geo Map: map clusters and markers now support color ranges provided manually or calculated automatically
  • Geo Map data merge means you will not see tile repainting or flashing when applying filters. This applies all Geo Map options including shape layers, heat map, proportional circles, and markers. Performance is also greatly improved.
  • Gep Map proportional circle color by attribute and data streaming support with animation
  • Geo Map metric legend size and position improvements
  • Elasticsearch improved support for nested objects
  • The Raw Data Table column filters now include a time filter to complement the slicer and number filter components. This allows you to enable column filters to any column type and apply to them the same color themes of your tables.
  • Slicer API to reset selectable values allows you to limit selectable values depending on any condition
  • Raw Data Table API to obtain the ID of a column filter to access it directly if needed

ChartFactor 2.2

September 28, 2021

Studio

  • New The new web app generation option allows you to generate your advanced data applications straight from ChartFactor Studio. Select a single dashboard or many dashboards for multi-tab applications.
  • Customize your upload process by using your own Python script. Using its glass box approach, Studio allows you to view/copy/paste/download the generated Python script so that you can modify it as needed to upload your data.

Toolkit

  • Geo Map
    • Shape multi-select functionality for choropleth maps that can work together with drill-in configurations and client filters
    • Fully configurable shape and shape border styles such as color, thickness, and opacity
    • WMS header configuration that may include Authorization and Content-Type to support secured WMS servers
    • Heat Map declarative way to swith to a markers layer when reaching "raw" level according to its geohash query configuration
  • Raw Data Table
    • New The new column filters functionality allows you to slice and dice your data directly from your table columns no matter their type. Column components are fully configurable and you can also provide your custom column components.
    • Render table header icons instead of labels easily in a declarative way
    • Column totals functionality that you can configure declaratively
  • Interaction Manager and Slicer performance improvements

ChartFactor 2.1

June 30, 2021

Studio

  • Floating Interaction Manager option allows you to easily view and modify the state of your application as you scroll through it
  • Responsiveness improvements on the home and application views to better support iPads and mobile devices
  • Easily search for apps across all folders
  • Contextual menu to move apps and folders throughout the folder hierarchy
  • Undo functionality when editing apps

Toolkit

  • Interaction Manager filter restriction functionality allows you to easily specify filters that cannot be removed, filters that cannot be added, and filters that depend on other filters, at the visualization and application levels
  • Interaction Manager/Search integration allows you to easily view and reset searches from your visualizations
  • Pivot and raw data tables copy/paste feature
  • Table custom options enables complete configuration of table properties including row and cell events and formatters
  • Pixel-perfect configuration of shape and text properties of charts (e.g. font style, family, size, text border colors, position) through the new advancedOptions setting
  • Additional configuration options for tooltips and legends
  • Slicer filtering improvements
  • Time slider improvements to seemlessly support streaming and historical data

ChartFactor 2.0

April 30, 2021

Studio

  • Application bulk export/import functionality. You can now easily export all your applications, export folders, or just a few of apps, all at once into a convenient zip file. On the import side, you can import a zip file with multiple applications straight from the home page. You can also import a single application CFS file or a combination of both zip and CFS files.
  • You can now select top, bottom, left, and right legend positions using the self-service UI
  • Easily create folders and organize your apps in any way needed

Studio CLI

  • All Studio applications can be easily transformed into standalone web applications with the Studio CLI. All Studio widgets are supported.

Toolkit

  • Geo Map
    • Support to declaratively and dynamically render multiple layers of markers, shapes, tiles, and proportional circles using static and dynamic data
    • Geohash markers with the ability to specify their precision for different zoom levels
    • Automatic zoom, center, and geohash recluster when navigating through different zoom level
    • Configurable icons to add to the standard representation of geohash clusters
    • Automatic bounding box queries on map panning to only bring the data needed depending on users' navigation
    • Proportional circles option for agregate data in addition to the existing shape (choropleth) functionality
    • Easily provide additional leaflet parameters (ie: from other plugins like CRS) to the map
  • New Data List widget for better viewing of incoming non-aggregated streaming data in a pixel-perfect way
  • Static Values option to keep bar chart groups in their axis even when they are filtered out
  • Legend top and bottom options in additionn to left and right
  • Metric option to not render the metric operation in charts' axis and tooltips
  • AQL improvements to make it easier for you to implement your own raw data query visualizations
  • Time Slider
    • Fit selection option
    • Play and pause programmatic events
    • Performance improvements when playing streaming data
  • Interaction manager performance improvements to support 500+ filter values on a field
  • Elasticsearch data provider brings shard routing support. It allows you to efficiently partition and search large amounts of data across shards.

ChartFactor 1.19

Sep 16, 2020

Studio

  • New Dremio and Redshift data providers now support custom queries!
  • New Relative filters: A new type of filter triggered when using presets in the Time Slider keeps the time window up-to-date in relation to the present moment, no matter when you re-open your dashboard
  • The Time Slider player now notifies users when the data ends (historical re-play)

Toolkit

  • New Flexible drill-in capabilities for Geo Map
  • New Geo Map fixed markers: In addition to dynamic markers, you can now pre-define markers (pins) to be displayed permanently in the map independent of filters, shapes and fields used
  • New The Raw Data Table and Pivot Table now expose a new configuration that enables access to their underlying ag-grid options, providing greater rendering flexibility
  • New You can now turn off column and/or row totals in the Pivot Table and format its cell values
  • Slicer: Sort configuration is persisted when a filter is applied and the dashboard is reloaded
  • The Geo Map now brings an improved legend that saves space and looks great

ChartFactor 1.18

May 12, 2020

Studio

  • New Custom Queries: You can now create custom queries at the dashboard level for Snowflake, BigQuery, and SparkSQL
  • New Snowflake: You can now create multiple Snowflake providers in Studio with the same URL, different credentials, and without storing these credentials.
  • New Studio CSV download option for all charts
  • The chart's data view now allows sorting and filtering in addition to cell copy
  • Studio dialogs now move to the front when selected to add comfort to users
  • Many Studio code generation improvements

Studio CLI

  • CLI support to render visualizations with custom queries
  • CLI support for Snowflake multi-logins without storing credentials
  • CLI version awareness: no need to clear cache when re-generating an app and re-deployging it on the same url

Toolkit

  • New Custom Query functionality for embedded data apps easily accessible through its API
  • New Snowflake multi-login functionality for embedded data apps easily accessible through its API
  • New Dropdown widget: the Slicer now supports the dropdown setting to easily convert it into a dropdown widget
  • Legend widget now supports selectMode setting to allow for single and multiple selections, same as the Slicer
  • Time slider: dialogs now close by clicking outside of them in addition to their close icon
  • Time slider: better support for multiple Time Sliders in the same dashboard
  • Box Plot color support
  • Markup widget: toolbar now allows to add hyperlinks
  • Serie label improvements for bar chart and histogram

ChartFactor 1.17

April 7, 2020

Studio

  • New File Upload feature allows you to easily upload your local csv, tsv, and json files to visualize them
  • New Saved Filters functionality allows you to easily apply previously saved filter configurations
  • New ChartFactor Electron App with installers for Mac and Windows. You can open multiple tabs with multiple dashboards, in the same fashion as in the web browser. Simply use the ChartFactor Studio top menu and select "Open New Tab" or type Cmd+N.
  • Studio Metadata window now includes generated commented-out code to guide new users
  • Improved Studio code generation to better guide users when editing code such as when adding static filters
  • Dependency upgrades to address npm-reported package vulnerabilities

Studio CLI

  • Code generation improvements and fixes
  • "About" information on generated apps when users click on the ChartFactor logo

Toolkit

  • New Snowflake data provider allows you to seemlessly visualize data stored in Snowflake tables and views
  • Elasticsearch error reporting improvements, specially important with Elasticsearch v7.x when hitting the "too many buckets" limit which can be triggered by high cardinality aggregations
  • Bar chart option to show values, in addition to existing metric marker options. It supports intelligent fitting, coloring and rotation.
  • Improved comparative metrics support for Pivot tables
  • Pivot and Raw Data Table sort by any column and any combination of columns
  • Pivot csv programatic download support. This works in the same way as with the Raw Data Table.
  • Slicer improvements
    • New tooltips to inform users that Cmd+Click (mac), Ctrl+Click (win) and Shift-Click commands are available
    • New sort-changed event to notify of sort change configurations
  • Time Slider improvements
    • Guides users to either play the current preset or start playing from the selected time window
    • Single-period mode makes sure users select only a single period when the dataset requires it
    • Auto-panning when users move the brush beyond the time slider boundaries
  • Multiple histogram improvements
    • Parameters such as showEmptyIntervals and offset previously available only for Elasticsearch are now also available on all SQL-based providers
    • Improved validation when providing invalid fields
    • Improved code generation when switching from other charts
  • CLI-tool improvements
  • Dependency upgrades to address npm-reported package vulnerabilities

ChartFactor 1.16

February 5, 2020

Studio

  • New Studio widget border option allows you to remove border lines between widgets
  • Studio widget menu user experience improvements
  • Time player code generation improvements
  • All new ChartFactor Toolkit features available in ChartFactor Studio

Studio CLI

  • All new ChartFactor features available in applications generated using Studio CLI. A partial list is below:
    • Field selector
    • Group legend
    • Time player animation
    • Axis label rotation
    • KPI colors
    • Studio widget border setting

Toolkit

  • New Field Selector component allows you to interactively change fields for a group of visualizations
  • New Group Legend widget provides interactive legend functionality for a group of visualizations
  • New Elasticsearch 7 support
  • New Elasticsearch Object datatype support
  • New Elasticsearch Alias support
  • New Histogram showEmptyIntervals and offset options
  • Time player animation and configuration improvements
  • Axis labels can be rotated to specific degrees
  • Improved KPI widget's color support
  • Improved derived fields and client filters interactions
  • Pivot improvements:
    • Metrics can be top group columns
    • Top group columns can be aligned as needed
    • Totals for columns and rows can be turned off and on
    • Sort is available for all columns and sub-columns

ChartFactor 1.15

December 11, 2019

Studio

  • New Option to manually execute updates when modifying the data configuration of a chart. Very useful for slow sources. It automatically detects slow sources and suggests users to use this feature!
  • New Studio "scroll aware" header. Now users don't need to scroll all the way up in long dashboards to use options available in the Studio header.
  • New Studio Home search feature
  • CFS file format and stored representation improvements with backwards compatibility and automatic upgrade when opening older CFS files with the latest Studio version
  • Improved generated code across charts to provide defaults for color metrics and limits where applicable
  • Legend font size consistency between Studio and generated apps
  • Responsive behavior for the visualizations menu when the editor is opened
  • Support for very long dashboard titles
  • Metadata popup draggable and resizable
  • No re-query when maximizing charts
  • Look and feel improvements to the Studio home page

Studio CLI

  • No re-query when maximizing charts
  • Optimizations to loading time
  • Look and feel improvements on application header, widget header, and space between widgets
  • Error handling improvements

Toolkit

  • New Pie slice filter selection while keeping the remaining slices for visual context. Similar support added for Donut, Scatter Plot, Floating Bubbles, Tree Map, Word Cloud, Disk, and Slicer in addition to existing support for Bars, Vector Map, and Geo Map.
  • New Metric markers for bar charts with full flexibility for images and font sizes and colors. Images can be base64-encoded or URL resources.
  • Vector and Geo Maps metric values in tooltips even when hovering on unselected shapes
  • Interaction Manager palette improvements for its modern skin
  • BigQuery data provider improvements to also run on the server side
  • ChartFactor Node payload optimizations
  • Improvements and fixes across charts

ChartFactor 1.14

October 15, 2019

ChartFactor 1.14 includes many customer-driven improvements and fixes. Here are the highlights:

Studio

  • New Tree visualization integrated in Studio
  • New Maximized view option
  • Improved Custom Metadata window to make it draggable and resizable

Studio CLI

  • New Generated applications with maximized view option
  • Look and feel improvements of generated apps

Toolkit

  • New Tree visualization, useful to visualize hierarchical data
  • New Advanced Drill-in functionality allows users to change visualization properties depending on the values selected to drill-in. Examples are changing map shapes, moving the center of a map, changing its zoom level and legend position in addition to the visualization group by.
  • New Automatic color range calculation option using the Jenks Fisher natural breaks classification algorithm. It includes an option for dynamic recalculation during user interactions.
  • New ChartFactor Node data provider allows ChartFactor applications to interact with ChartFactor Node. ChartFactor Node enables the execution of ChartFactor data providers on the server-side for the purpose of applying custom logic such as filters before executing the actual queries on the data engine. This is useful for multi-tenant scenarios where data from multiple accounts reside on the same table and we need to ensure that end users only see data related to their account.
  • New Redshift/PostgreSQL data provider with Lambdas and Cognito support
  • New S3 and parquet files support through Spark SQL
  • Tree Map improvements to support metric-driven colors
  • Pie chart and Donut chart include multiple improvements:
    • Labels can render inside or outside the slices
    • Users can choose what to show for the slice labels, the metric values or the attribute values
    • Users can select the color of the slice labels when rendered outside the slices
    • The color of slice labels is dynamic when rendered inside the slices for better readability
    • Responsive behavior for slice labels so that they only print when they fit
  • Bar chart now supports bar selection while keeping the other bars for context
  • Area Line now supports trend point selection plus marker while keeping the other trend points for context
  • General improvements for rates, growth rates, benchmarks, and rate benchmarks functionality
  • Time Slider resize and single-unit selection improvements
  • Sunburst improvements
  • KPI widget improved for performance

ChartFactor 1.13

August 14, 2019

Studio

  • New Widget copy option. Now Studio users can duplicate widgets instantly.
  • New Search option for datasets and datasources
  • Improved data view for all widgets

ChartFactor Geo - Beta

  • New This is a three-dimensional geographical environment based on the ChartFactor Toolkit where users can connect to their datasources and visualize them using markers, geometric figures, and shapes through layers they can turn on and off. It leverages ChartFactor's custom chart functionality so that it can run standalone or within a system of interactive visualizations such as your custom applications or ChartFactor Studio. This application also makes use of ChartFactor's geohash aggregations and bounding box queries, allowing users to navigate in this 3-D world while retrieving only the data users see based on their navigation.

Toolkit

  • New Easy expression language to visualize the following:
    • Time series comparisons with other time periods
    • Rates, for example when comparing the revenue of a brand against the total revenue within a given category
    • Growth rates, that is how much a metric has increased or decreased when compared to a different time period
    • Benchmarks, for example the revenue of a brand, institution, or event, compared to others, usually within a category
    • Rate benchmarks, for example the conversion rate of a campaign compared to others, usually within a category
  • New GeoHash queries support
  • New Geo bounding box filtering support for Elasticsearch
  • New Highly configurable skin for the Interaction Manager. This is in addition to the standard skin option.
  • Slicer component is completely new for better performance, configurability, and maintainability
  • Normalized histogram calculations across data engines. This makes it possible to switch to a different data engine (e.g. Elasticsearch, BigQuery) and have the same numbers.
  • Simplified color metrics API. Now, there is no need to specify a color metric again within the main metrics() method.
  • Table column widths can now be specified programatically. This works across pivot, raw data table, and slicer visualizations.
  • Aggregate and row-level derived metrics improvements across data providers
  • Geo map visualization performance improvements

ChartFactor 1.12

June 5, 2019

Studio

  • New Self-service UI: Now it's easier than ever to create data applications with Studio. Users can configure many of the charts with an intuitive user interface. They can see the code that powers their visualizations as they change settings and interact with them. They can also switch to code editing if they prefer. And it is backwards compatible with existing Studio apps. Supported charts for this release are: Bars, Disk, Donut, Packed Bubbles, Pie, Nested Pie, Tree Map, Tree Map 2D, Trend, and Word Cloud. Charts not covered by the self-service UI will open with the code editor as usual.
  • New Studio CLI tool: Generate native html/js/css applications in seconds from Studio files. It supports individual and multi-tab applications with cross-tab and cross-source filtering. Its multi-tab support is great for multi-source applications with a large number of visualizations across multiple sources. Users can apply filters in one tab to see them immediately reflected in all tabs.
  • Improved CFS file format so that changes can be easily tracked by version cotrol diff tools. It is backwards compatible with the previous format.
  • Home page usability improvements
  • Metadata window usability improvements

Toolkit

  • New Flexible number formatting: Users can now define number spearators, decimal point, decimal places, and anything else to render numeric types exactly as they desire. They can define number formats for all fields or for specific fields of a source.
  • New Currency support: Users can now define the currency of MONEY fields for all fields or for specific fields of a source. They can also specify the position where its currency symbol should be rendered.
  • New Time zone support: ChartFactor now supports time zone conversions. Time zones can be defined at the source level to convert all time fields of a specific source or at the time field level. It includes a "local" time zone setting that automatically converts time fields to the time zone where the user is located.
  • New Flexible date and time format support: Users can now define the exact date and time format for all fields or for specific fields of a source.
  • New Custom charts: ChartFactor users can now easily bring in their custom visualizations and applications to ChartFactor as micro-services. Users can interact with out-of-the-box and custom charts, add filters, drill-ins, and have their custom charts react to those interactions in any custom way needed.
  • Slicer enhanced to support single selection in addition to the existing multi-selection feature
  • Visualization transition improvements to better support playing data
  • Color range support improvements
  • KPI visualization improvements with more fine-grained color configurations
  • Label auto-coloring for Tree Map and Heat Map depending on luminosity of background color
  • Heat Map visualization improvements with option to print values inside shapes and with auto-adjusting margins and labels. Note: Heat Map grid margins may need to be adjusted after upgrade, specially left and top margins.
  • Time Slider color syntax improvements
  • BigQuery data provider update for new Google BigQuery client api

ChartFactor 1.11

March 6, 2019

  • New Time Slider component is out, we believe it is the most advanced time slider in the industry. Its main features are:
    • Zoom-in/zoom-out functionality allows users to visualize the full time range of their data within the width of their screen and seemlessly zoom-in from years to months to days, hours, minutes, seconds, deci-seconds, etc. using their mouse wheel or trackpad gestures.
    • Zoom control provides an alternative way for users to zoom-in and zoom-out. It also gives a visual clue on how far the time slider is zoommed in or out.
    • Dynamic time selection allows users to select different time ranges without having to drag time handles
    • Dynamic time pickers provide users another option to select date/time ranges. The pickers adjust depending on the resolution of the data.
    • Dynamic scroll bar allows users to navigate through the expanded time slider. The size of the scroll bar follows the size of the expanded time slider given the current zoom level.
    • Data Player allows users to play streaming data in near-real-time fashion. It also allows to pause and re-play historical data. The Data Player also includes these features:
      • Configurable step size when replaying historical data. For example: Advance 1 DAY on each step.
      • Configurable refresh interval in seconds plus the "immediate" option
      • Pinnable left handle to provide incremental in addition to rolling time windows
      • Live mode to visualize sources in near-real-time as the data arrives
      • Autoplay mode to start playing data as soon as the application loads. It removes the need to click on the Play button which is perfect for war room dashboards.
    • Dynamic presets allow easy configuration of time ranges such as today, yesterday, this year, this month, etc. Users can provide their own presets.
    • Custom colors allow users to change the look of the time slider to match their application colors or dashboard themes.
  • Robust color support - enhanced our existing color support as follows:
    • Color by Metric: In addition to previously supported metric-driven color gradients, ChartFactor now supports color ranges. Users can specify different ranges and the color they would like to use for them. Charts and legends will render according to the configuration provided.
    • Color by Attribute: In addition to previously supported color auto-assignment according to configurable color pallettes, ChartFactor now supports manually assigning colors to attribute values. This is useful when users need to assign specific colors to specific attribute values across charts. Charts and legends will render according to the configuration provided.
  • New Sankey visualization with flexible data support. Users can render it using pivot-type queries, multi-queries to obtain nodes and links, and with static data.
  • The Filter Control component was renamed to Interaction Manager to better reflect its functions. Please use imanager() or graph("Interaction Manager") instead of fc() or .graph("Filter Control"). The change is backwards compatible. Using the old names prints a deprecation warning in the console.
  • Rendering improvements for visualizations and tables when the Time player is on
  • Slicer improvements when configured to move selected items to the top to avoid jumpiness after selecting items
  • Improved metadata definition to make field types case insensitive
  • All new functionality also available using ChartFactor Studio
  • Bug fixes on Studio metadata window when using multiple data providers on the same dashboard
  • Documentation content and organization improvements

ChartFactor 1.10

January 15, 2019

  • Interaction Management: Filter Rules enhancement allows to easily customize how visualizations react to user interactions beyond standard drill hierarchy definitions
  • Interaction Management: Filter Events enhancement allows full customization at any point of a filter life cycle
  • Static Filters enhancement allows to specify filters that should always be applied to a visualization regardless of user interactions.
  • Optimizer now avoids executing a query for a visualization when only client filters change
  • Slicer client filter support
  • Slicer sort improvements
  • New Geo Map visualization with the following main features:
    • Geo Shape mode: this mode is activated when users group by a single attribute plus metrics, and provide a shape file. The shape file is in GeoJSON format. The shapes are selectable/filterable when interacting with other visualizations.
    • Map Markers mode where users group by latitude, longitude, other attributes plus metrics. In this case, one marker represents one or many events happening on the selected location (e.g. 311 calls)
    • Map Markers mode where users perform a raw query that includes latitude, longitude, and any other fields. In this case, one marker represents a single event. Multiple events on the same location will render multiple markers.
  • Additional Geo Map features:
    • Configurable marker shapes and colors
    • Configurable initial zoom and center position
    • Configurable maximum and minimum zoom positions
    • Zoom-in, zoom-out, and panning events for full behavior customization
    • Configurable palettes for Geo shapes
    • Limit option for Map Markers with raw queries
    • Additional configuration information in Maps documentation
  • Auto-test additions for BigQuery and Elasticsearch data providers

ChartFactor 1.9

December 10, 2018

  • New Multi-Attribute Trend visualization enables users to trend data with each line representing a combination multiple attributes in addition to time. Applicable in financial sector use cases.
  • Enhanced Raw Data Table visualization to allow column groupings and advanced custom formatting options
  • Enhanced Raw Data Table with advanced export functionality
  • Enhanced Slicer component with showSearch configuration
  • Improved wildcard support for metadata definitions. This is useful when applying the same field types, labels, and derived fields across similar sources.
  • Addressed derived field issues including custom sort order functionality on multi-group configurations
  • Sunburst visualization label and client filter improvements
  • Pivot drill-in support with time fields
  • Improved Studio export/import functionality
  • Updated BigQuery data provider with the latest Google API client
  • Addressed all 1.9 reported issues
  • Our Studio demo application "London Fire Brigade Calls" now pulls data from our Elasticsearch server instead of Google BigQuery. This was done per requests from users since they previously had to sign up to Google Cloud, provide their credit card number, and create a Google Cloud project, simply to get to play with the Studio sample app.

ChartFactor 1.8

October 30, 2018

  • Google BigQuery
    • Includes support for nested array structures
  • Visualization packages built as npm modules
  • Markdown text widget
  • Data Providers auto test improvements with baseline dataset across SQL and NoSQL providers
  • Derived fields support at the aggregate level for calculated metrics and attributes
  • Count distinct support across providers
  • Elasticsearch data provider improvements
  • Donut visualization improvements when grouping by time
  • Performance testing and improvements
  • AQL validation improvements
  • Data visualization watermarks for Community Edition
  • Documentation and Live Examples website supporting multiple versions
  • Community website for user discussions
  • ChartFactor download pages with license agreement functionality
  • ChartFactor home page improvements
  • ChartFactor website security improvements to prevent access to all its components before launch

Known Issues

  • Floating Bubbles fail on SQL-based data providers when the two group attributes are the same and only one metric is selected. Solution is to select different attributes for the two groups.
  • Trend Attribute Values visualization displays count metric twice in tooltips
  • Studio: manually removing a filter element in the Code Editor, is not removing that filter from the visual. The workaround is to close the editor and remove the value using the Interaction Manager.

ChartFactor 1.7

August 8, 2018

  • New Data Visualizations
    • KPI and Gauge visualizations
    • Heat Map visualization
    • Sunburst visualization
    • Word Cloud visualization
    • Packed Bubbles visualization
    • Box Plot visualization
    • Floating Bubbles visualization
    • Histogram visualization
  • Dremio data provider
  • Improvements and fixes across SQL-based providers
    • Nulls on main group in multi-group aggregation was not included
    • Limit in multi-group aggregation was not respected
  • Auto tests of data providers enriched with multi-groups, time aggregations, and different sort criteria
  • Interaction Manager drill-in functionality
  • Range Filter editable limits
  • Slicer component

ChartFactor 1.6

June 8, 2018

  • Data providers as npm modules that can run independently either on the browser or on the server
  • Client filter implementation for Vector Map and Trend Line use cases
  • Range Filter component
  • Auto-unit tests for data providers
  • Disk visualization improvements to support multiple metrics
  • New Data Visualizations
    • Grouped Bars
    • Multiple-metric Bars
    • Multiple-metric Trend Lines
    • Horizontal Bars
  • Pivot Table improvements for range filters
  • Vector Map improvements for better color support
  • Negative validations and unit tests
  • End-to-end auto-test improvements

ChartFactor 1.5

April 17, 2018

  • Search component with support of Lucene Query Syntax to work with the Elasticsearch data provider
  • Raw data table term highlighting feature
  • Improved Disk visualization to match hours received in a clock fashion
  • Pivot table implementation
    • Includes row, column, and full totals
    • Supports all data providers
    • Full featured demo in website with draggable rows and columns
  • Improved themes and palettes support
  • Vector map visualizations with out-of-the-box shapes for World Countries and US States
  • Raw Data Table formatting improvements for numbers, timestamps, and strings
  • Studio improvements of look and feel, and home page functionality
  • Studio reload of charts without resetting them
  • Studio themes support
  • Studio Pivot table integration with Interaction Manager support

ChartFactor 1.4

January 9, 2018

  • AQL (Aktive Query Language) for RDT (Raw Data Table) should allow to bring all fields by default and ability to exclude a few of them
  • Implemented scalable way to update charts options
  • Implementation to allow injecting data to charts as an option when data needs to be obtained separately
  • ElasticSearch Provider
    • Most visualization supported
    • Date range filters
    • Min, max, sum, avg aggregations
    • Sort by time (ascending) in AQL
    • Support count distinct aggregation
    • Support source wildcards at the CF level
    • Area line y-axis label fix (same issue across providers)
  • Network visualization implementation
  • Time Range Filter (TRF) widget.  Support all time granularities and drill-in.
  • Time Range Picker (TRP) with presets and time player.  It works together with the  TRF.

ChartFactor 1.3

October 21, 2017

  • Calculated fields support for Zoomdata provider
  • Added release tag to header in minified js file. Release tag is a timestamp in the format 20171115 14:42 UTC
  • Pivot query is using the wrong source. Making sure it uses the source specified in the AQL
  • React demo
    • Line Trend Attribute Values: turning labels off and on changes the size of the chart.  It should be left with its original size.
    • ReferenceError: BigNumberFormatter is not defined when removing labels from Line Trend Attribute Values
    • Edit dialog resizing: Data/Settings/Color bar is rendered over the dialog header.  Also, text is rendered over the dialog header bar.
    • Added arrow with animation to call users’ attention, telling them they can use the Edit button to change the chart settings.
  • Datazoom bar default position is too close to x-axis labels on Line Trend Attribute Values and Area Line charts

ChartFactor 1.2

September 21, 2017

  • Pivot query implementation for Zoomdata provider
  • Legend support for metric coloring
  • Tooltips correctly formatted as integer with comma separator when applicable
  • Implementation for bars, pie, donut, trend attribute values, scatter, tree map
  • Initial support for the Zoomdata provider
  • Implemented events that developers can listen to when building functionality across charts
  • Implemented how to interact with chart options (colors, legends, axis properties, marklines)
  • Legend support
    • Formatter
    • Color configuration
    • Positioning
    • More option
  • AQL functions for Raw Data query

ChartFactor 1.0-1.1

August 4, 2017

  • Initial Bars implementation
  • Initial events that developers can listen to when building functionality around bars
  • Developed metadata specification for toolkit and added example using our SparkSQL demo server
  • Complete all AQL functions
    • Multi-group window (up to 2 for now)
    • Filters, including time filters
    • Time granularities