Subsplash

Tyler Kraeger

Jonathan Crouch

Connor Stallings

Trends AI

Use natural language to explore your data.

AI Analysis Basics

Utilizing Subsplash Trends's AI Analysis to build Charts

AI Analysis

Search

You can use the chart builder to answer questions about your data without needing to consult a data analyst.

Chart Builder

You can start a new search session from any page in Trends by clicking the Chart Builder button in the top navigation bar.

Create a Chart

Choose a data source that works best for your desired Charts.

Choose a data source

Discover the different categories of search terms and learn how the search bar guides you as you build a chart.

Search bar features within the Chart Builder

Discover how the search bar learns from your past searches and adapts to help you find what you need more quickly.

Search Suggestions

In Trends AI, your searches use columns defined as either attributes or measures. Learn more about how they impact your Charts.

Search results and column types

Work with charts

Learn how to use tables to display your data.

Results that are tables

Search Basics

You can use keywords when asking a question to precisely narrow and define your chart builder search within Trends.

Keyword search basics

You can compare data across different time periods easily, even without creating a custom formula.

Time series analysis

Date filters for Charts and Boards

You can easily visualize the growth of a measure over time using the growth of keyword in your Chart Builder.

Search using growth over time

Use keywords to preform subquery searches within the Chart Builder

Subquery search (in keyword)

Keyword Searches

Filters are a powerful way to refine your search results to include only the specific data you wish to examine.

Filter basics

Quickly filter a Chart directly from a column header.

Add a filter to a table

Add a filter to a Chart by interacting directly with the chart axis.

Add a filter to a chart

Create a bulk filter directly on any saved Chart.

Create a Bulk Filter

Discover how to delete filters from a Chart.

Delete a Filter

Filtering on NULL and empty values can sometimes be challenging, especially if your data contains both of these types. By using the methods outlined here, you will learn how these…

Filter on null, blank, or empty values

Work with Filters

There are several other actions you can perform by interacting directly with your chart results.

Other search actions

Learn how to download your search results as a table or a chart.

Download your search

Other Search Actions

Charts display your search in a visual way.

Charts

Nico Londono

Ian MacDonald

Charts & Boards

These charts use vertical bars to compare values across different categories, making it easy to track changes or differences clearly.

Column charts

These charts divide each column into colored segments, helping you compare totals and understand the component parts that make up those totals simultaneously.

Stacked column charts

Bar charts visually compare data categories using horizontal bars, making comparisons straightforward, especially when category names are long.

Bar charts

Stacked bar charts divide horizontal bars into color-coded segments to simultaneously show total values and the individual parts contributing to those totals.

Stacked bar charts

Line charts are the ideal visualization for clearly showing trends, changes, and connections over periods of time by connecting data points with straight lines.

Line charts

These charts display a key metric, alongside its comparative performance over time to instantly convey a ministry’s status.

KPI charts

A pie chart divides a circle into slices to visually represent the numerical proportion of each segment relative to the whole.

Pie charts

Area charts feature a filled region between the plotted line and the axis, which is effective for visualizing quantitative data and showing magnitude over a continuous scale.

Area charts

Stacked area charts effectively visualize how each part contributes to the accumulated total of a measure over time.

Stacked area charts

Scatter charts are a powerful tool for discovering correlations or outliers within your data.

Scatter charts

The bubble chart is a variation of the scatter chart where your data points appear as bubbles.

Bubble charts

Type of chart that combines both column bars and a specialized line chart to display information.

Pareto charts

Designed to clearly illustrate how an initial metric value is influenced by a series of intermediate positive (increases) or negative (decreases) values.

Waterfall charts

Heatmap charts use a comparable color-coding system to represent data values.

Heatmap charts

The line column chart provides a versatile way to visualize your data by combining column and line charts into a single view.

Line column charts

Line stacked column charts

Learn how to use a funnel chart for visualizing processes

Funnel charts

Learn how to use a Sankey chart to visualize your data.

Sankey charts

Learn how to use Radar charts to visualize data.

Radar charts

Learn how to use a pivot table to visualize your data.

Pivot table

Learn how to use Geo charts to display your data.

Geo charts

The tree map chart displays hierarchical data as a set of nested rectangles

Tree map charts

Your search results, which we call charts, offer various display options. You can change the visualization used to display your results, adjust their sort order, modify how Trends groups the…

Change result, display options

This article guides you through adjusting the display options for chart axes in Trends AI

Change Axes Options

Configure the columns

Customize all visual elements of your charts, including colors, legends, axis settings, and data formatting, to perfectly present your insights.

Changing charts

Customize your data visualization experience by renaming chart axes and table columns to match your specific needs for clarity and impact.

Rename columns and axes

Customize the layout of your visualizations by reordering labels on your chart axes or legends

Re-order the labels

Manually adjust the y-axis range to focus on specific data

Set the Y access range

Easily manage your chart's display by toggling legend items to focus on the specific data points that matter most to your ministry.

Hide and show values

Efficiently navigate and understand your high-volume ministry data with dynamic scrolling and visualization scaling.

Charts and tables with a very large number of data values

Learn how to customize colors to bring clarity to every chart you build.

Change chart colors

Learn how to display and customize data labels to make your visualizations easy to read and understand

Show data labels

Show Data Markers

Null values in charts

Easily visualize trends and patterns in your data by adding a regression line to charts

Add regression lines

Improve the readability of your visualizations by enabling horizontal and vertical gridlines

Display grid lines

Focus on the details that matter most by zooming in on a specific area of your chart

Zoom into a chart

Changing Charts

Group your headlines, tables, and charts into a single Board to get a clear, live view of your ministry’s most important trends.

Boards

Learn how to create a layout that helps your team focus on what matters most.

Edit a Board

Boards that contain consolidated data can be personalized for a specific user or group

Personalized Boards

Suggestions on how to explore and understand your data.

Chart explorer

Add notes to your Boards so that viewers can quickly understand the value of your data and how to use the visualizations you have gathered.

Boards note tiles

Use filters on a Board to see only the data that you are interested in across your tables and charts

Board filters

Learn how to apply filters to specific visualizations

Selective Boards filters

Search actions within a Board

Remove visualization in just a few steps to refine the data in your Board.

Delete a visualization

Learn how to make a copy of any Board in Trends AI so you can edit and explore with ease

Copy a Board

This guide shows you how to group visualizations into logical sections on your Board for better clarity

Boards Tabs

To provide richer insights, you can add a formula to your Trends AI search.

Formulas

Learn how to add a formula directly to a chart.

Add a Formula to a Chart

View or edit a formula in a search

When working with formulas, it is helpful to understand the difference between regular (or row-wise) formulas and aggregation formulas.

Aggregate formulas

Cumulative functions

Learn how to use group aggregation functions, also known as pinned measures, to enhance your data analysis.

Group aggregation functions

Keywords “of”, “percentage of”

Formula operators help you perform conditional calculations within your data. By using these operators, you can apply if/then/else logic to return specific values or simple true/false results based on your…

Formula operators

Learn how to use nested formulas with your data.

Nested formulas

You can use standard mathematical functions to calculate numerical results within your formulas.

Simple numerical calculations

Viewing the underlying data of your chart gives you an un-aggregated, granular view of the data that comprises your result set.

Show underlying data

When you drill down, you gain access to more detailed information about the data within your search.

See the search behind the result

Learn how to use conditional formatting in a table.

Apply conditional formatting into a table

You may use your own data in Subsplash Trends by importing a CSV file of the data directly!

Import Data into Trends AI

Learn about the advanced importing data types available to you with Trends AI.

Advanced Trends AI importing options

Work with Data

Share your work

Sharing a Board provides a live link that always reflects the most current version. When someone views a shared Board, they see the most recently saved updates and the latest…