What's new in Graphext?

PreviousPage 2Next

November 26, 2024

Save Summary Tables, Conditional Formatting, New Line Interpolation, Markers, Advanced Query Features and more…

🌟 New Features

Save Summary Table as Dataset: Add the ability to save the summary table (group by) from plots as a new dataset, enabling users to load it in the Data tab for further exploration. This streamlines workflows and allows deeper analysis by treating the summarized data as a base dataset, for example grouping a dataset of transactions by user id

Conditional Cell Highlighting in Tables: Add the ability to color table cells based on conditions for all variable types. For example, highlight exam marks below 5 in red or emails containing @gmail.com in yellow. Users can choose from three highlight styles: pill, background, or text, with automatic text color adjustment (white or black) to ensure perfect readability against the background.

Display Value Counts: Introduce the option to show the value count next to the Y-axis value in plots, indicating how many rows or samples are represented in each group. For example, in a bar chart of job titles with the highest average annual income, users can see the sample size alongside the income to validate whether the data is representative or is just an outlier

New interpolation options: Add control in Plot for showing missing values in line charts. You have three options: As solid lines, as gaps or as zeros.

Check Connection Status & Query Preview: You can now verify if the connection to your data source is successful and preview your query results before committing to create a project. This ensures a smoother setup process and saves time by letting you address any issues upfront.

Segmentation Query Editing: Enable query editing directly from the UI, allowing users to refine and customize the logic behind their segmentation with ease.

🛠️ Improvements

Decimal Format Selection: Introduce the option to customize the decimal format for quantitative columns, providing greater control over data presentation and ensuring consistency and clarity in numerical displays.

Advanced Search: Enable the use of the advanced query builder UI for searching within variables by clicking on the magnifying glass

🎨 UI Updates

Plot Line Markers alway active: Plot Line Markers are now active by default & can be configured in General tab in the Customization panel (instead fo Annotations tab)

Numbers format: The current format configuration (for numbers) is now visible in the Account Settings modal

🔧 Technical Updates

Cluster probabilities for HDBSCAN: when a second output column is requested in ”cluster_dataset" or ”cluster_embeddings" it will contain the probability that a data point belongs to the assigned cluster:

https://docs.graphext.com/api-docs/analyse/graph_and_map/cluster_dataset#outputs

Time-based validation of ML models (train on past, test on recent data)

November 12, 2024

Custom Variable Queries, Variable Search in Omnibar, and Enhanced AI Prompt Step

🌟 New Features

Custom Queries for Variables: You can now perform custom queries on each variable, enabling faster category searches and more advanced queries that were previously not possible, such as AND conditions in categorical columns or disjoint ranges in numerical columns (e.g., "younger than 18 or older than 65"). For basic searches, a user-friendly UI is available, making it seamless, while for more advanced queries, a query editor and detailed documentation are provided to help you learn how to craft and execute complex queries.

Search for Variables in Cmd+K Omnibar: You can now search for variables from any section of Graphext directly through the Cmd+K omnibar. You'll be able to preview the distribution of those variables, making it easier to explore and analyze them without navigating through multiple sections.

🛠️ Improvements

Improved “prompt_ai” Step: There's no longer a need to be so explicit when forcing the output, making it more intuitive to use. A new JSON schema mode has been introduced for more structured data outputs. We now ensure that only the explicitly defined categories are returned, streamlining the results and ensuring more relevant outputs.

🔧 Technical Updates

Add support for Date columns in replace_values step

November 5, 2024

Hall Redesign, Quick Variable Tagging, and Group By with Discretization

🌟 New Features

Hall Redesign Implementation: The Hall has been redesigned for better clarity and navigation. The distinction between Home and Teams is now clearer, offering a more intuitive experience. Additionally, "What's New" is updated more frequently, and recent projects now include more filtering options, such as recently created, recently updated, recently refreshed, recently viewed, and Trending Projects coming soon

Quick Variable Tagging from Other Sections: You can now tag variables quickly from other sections, not just from the VM, making it easier and more efficient to tag relevant variables across your workflow. This feature is especially useful during EDA (Exploratory Data Analysis) before training a predictive model, allowing you to tag variables, such as those with high correlation to your target, for more focused analysis.

Discretization for Numeric Columns in Group_By: Implement the ability to create bins when using a numeric column for group_by, allowing for more granular grouping of data by dividing numeric values into specified ranges or intervals

🛠️ Improvements

Metrics Formula Editor with Syntax Highlighting and Autocompletion: Edit your metric formulas with ease using a new formula editor that includes syntax highlighting and autocompletion, making it faster and more intuitive to create and modify formulas.

🐛 Bug Fixes

Fix for Significant Variable Navigation: We have fixed the issue where clicking on a significant variable would not take you to the crossfilter if the "Show" was set to a specific group of tags. Now, it will automatically change the "Show" to "ALL", ensuring smooth navigation and proper visualization.

🎨 UI Updates

Updated Table Header in Plot: The header of the tables in plots has been rearranged for improved usability. The "+" button is now positioned on the right, while the pagination is moved to the left, offering a more intuitive layout for managing and navigating tables.

Shortcut to Open Plot from Data Table: Easily open the plot directly from the data table with a new shortcut, streamlining the transition between data exploration and visualization for more efficient analysis.

🔧 Technical Updates

Optimize metrics aggregation

October 29, 2024

Sort Stacked Plots, Drag-and-Drop Ordering, and Advanced Group By Options

🌟 New Features

Sort Stacked Plot by First Color: You can now sort plots by the first color, enabling more intuitive visualization and better comparison of category proportions in the chart.

Option to Include or Exclude Nulls in Comparisons: You now have the option to include or exclude null values when comparing a selection to the total population

Drag and Drop to Order Categories in Ordinal Columns: You can now reorder the categories in an ordinal category column using drag and drop, providing a more intuitive way to reorder them

🔧 Technical Updates

Enhanced Group_By Step for Numerical and Date Variables: The group_by step has been modified to work with both numerical and date variables, now supporting discretization. This allows for grouping based on specified ranges or time intervals, providing more flexible and detailed aggregation of your data.

Group By Date with Custom Aggregations: A new method allows you to group by date and select specific aggregations, such as Day, Month, or Year, enabling more flexible and insightful date-based analysis.

October 15, 2024

Create and Compare Metrics and Use them in Plots

🌟 New Features

Create and Compare Metrics in Graphext: You can now define custom metrics like MRR or NPS within Graphext. These metrics will dynamically react to your selections, allowing you to compare them across the total population versus specific segments. For example, you can easily identify if a particular client segment has a much lower NPS than the overall average, helping to uncover valuable insights.

In this example, we can see the NPS for all the reviews of a McDonald's. The NPS of the entire dataset is shown in grey around 46, while the NPS of the reviews with negative sentiment (highlighted in blue) is -36.9, highlighting a significant difference and offering insights into customer satisfaction based on sentiment.

You can also visualize the difference in absolute numbers or as a percentage change between metrics.

Use Metrics in Plots: Now, you can use custom metrics like MRR or NPS directly in your plots, allowing you to visualize and compare these metrics across different segments or selections, enhancing your data analysis and insight generation.

🎨 UI Updates

Updated Row Removal and Reverse Selection: The trash icon has been removed from the top right corner. You can now remove rows or reverse your selection directly from the dropdown in the top left corner. A confirmation modal will appear with an explanation of what will be removed, ensuring clarity and preventing accidental deletions.

🔧 Technical Updates

Sorting Parameter for "Filter Duplicates" Step: Introduce a sorting parameter in the "filter_duplicates" step, allowing you to define how duplicates are prioritized and removed, making data cleaning more customizable and efficient.

PreviousPage 2Next