Charts & Boards
Overview on Answers & Boards
By Nico and 3 others4 authors60 articles
ChartsCharts display your search answer in a visual way.
Charts
Exploring Charts
Column chartsThese charts use vertical bars to compare values across different categories, making it easy to track changes or differences clearly.
Stacked column chartsThese charts divide each column into colored segments, helping you compare totals and understand the component parts that make up those totals simultaneously.
Bar chartsBar charts visually compare data categories using horizontal bars, making comparisons straightforward, especially when category names are long.
Stacked bar chartsStacked bar charts divide horizontal bars into color-coded segments to simultaneously show total values and the individual parts contributing to those totals.
Line chartsLine charts are the ideal visualization for clearly showing trends, changes, and connections over periods of time by connecting data points with straight lines.
KPI chartsThese charts display a key metric, alongside its comparative performance over time to instantly convey a ministry’s status.
Pie chartsA pie chart divides a circle into slices to visually represent the numerical proportion of each segment relative to the whole.
Area chartsArea 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.
Stacked area chartsStacked area charts effectively visualize how each part contributes to the accumulated total of a measure over time.
Scatter chartsScatter charts are a powerful tool for discovering correlations or outliers within your data.
Bubble chartsThe bubble chart is a variation of the scatter chart where your data points appear as bubbles.
Pareto chartsType of chart that combines both column bars and a specialized line chart to display information.
Waterfall chartsDesigned to clearly illustrate how an initial metric value is influenced by a series of intermediate positive (increases) or negative (decreases) values.
Heatmap chartsHeatmap charts use a comparable color-coding system to represent data values.
Line column chartsThe line column chart provides a versatile way to visualize your data by combining column and line charts into a single view.
Line stacked column charts
Funnel chartsLearn how to use a funnel chart for visualizing processes
Sankey chartsLearn how to use a Sankey chart to visualize your data.
Radar chartsLearn how to use Radar charts to visualize data.
Pivot tableLearn how to use a pivot table to visualize your data.
Geo chartsLearn how to use Geo charts to display your data.
Tree map chartsThe tree map chart displays hierarchical data as a set of nested rectangles
Changing Charts
Chart Configurations
Change result, display optionsYour 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 Axes OptionsThis article guides you through adjusting the display options for chart axes in Trends AI
Configure the columns
Changing chartsCustomize all visual elements of your charts, including colors, legends, axis settings, and data formatting, to perfectly present your insights.
Rename columns and axesCustomize your data visualization experience by renaming chart axes and table columns to match your specific needs for clarity and impact.
Re-order the labelsCustomize the layout of your visualizations by reordering labels on your chart axes or legends
Set the Y access rangeManually adjust the y-axis range to focus on specific data
Hide and show valuesEasily manage your chart's display by toggling legend items to focus on the specific data points that matter most to your ministry.
Charts and tables with a very large number of data valuesEfficiently navigate and understand your high-volume ministry data with dynamic scrolling and visualization scaling.
Change chart colorsLearn how to customize colors to bring clarity to every chart you build.
Show data labelsLearn how to display and customize data labels to make your visualizations easy to read and understand
Show Data Markers
Null values in charts
Add regression linesEasily visualize trends and patterns in your data by adding a regression line to charts
Display grid linesImprove the readability of your visualizations by enabling horizontal and vertical gridlines
Zoom into a chartFocus on the details that matter most by zooming in on a specific area of your chart
Boards
Exploring Boards
BoardsGroup your headlines, tables, and charts into a single Board to get a clear, live view of your ministry’s most important trends.
Edit a BoardLearn how to create a layout that helps your team focus on what matters most.
Personalized BoardsBoards that contain consolidated data can be personalized for a specific user or group
Chart explorerSuggestions on how to explore and understand your data.
Boards note tilesAdd notes to your Boards so that viewers can quickly understand the value of your data and how to use the visualizations you have gathered.
Board filtersUse filters on a Board to see only the data that you are interested in across your tables and charts
Selective Boards filtersLearn how to apply filters to specific visualizations
Search actions within a Board
Delete a visualizationRemove visualization in just a few steps to refine the data in your Board.
Copy a BoardLearn how to make a copy of any Board in Trends AI so you can edit and explore with ease
Boards TabsThis guide shows you how to group visualizations into logical sections on your Board for better clarity
Formulas
Guides for Using Formulas
FormulasTo provide richer insights, you can add a formula to your Trends AI search.
Add a Formula to a ChartLearn how to add a formula directly to a chart.
View or edit a formula in a searchLearn how to view or edit a formula.
Aggregate formulasWhen working with formulas, it is helpful to understand the difference between regular (or row-wise) formulas and aggregation formulas.
Cumulative functionsLearn how to use cumulative functions.
Group aggregation functionsLearn how to use group aggregation functions, also known as pinned measures, to enhance your data analysis.
Keywords “of”, “percentage of”
Formula operatorsFormula 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…
Nested formulasLearn how to use nested formulas with your data.
Simple numerical calculationsYou can use standard mathematical functions to calculate numerical results within your formulas.
