Chart Type Configuration for Direct Queries in CRM Analytics Lenses

Direct queries have distinct characteristics and requirements that influence which options are available when configuring charts in CRM Analytics. The purpose of the matrix in this document is to help you understand chart capabilities and limitations related to the data from a direct query.

Chart Types:

Bars
Lines
Dates & Times
Gauges
Circles & Dots
Grids
Maps
Pipelines

Chart Type: Bars

Chart Properties	Bar	Column	Stacked Bar	Stacked Column	Pyramid	Stacked Pyramid
Bars	Supported	Supported	Supported	Supported	Supported	Supported
Bar Length	Supported	Supported	Supported	Supported	Not Supported	Not Supported
Bar Segments	Not Supported	Not Supported	Supported	Supported	Not Supported	Supported
Trellis	Supported	Supported	Supported	Supported	Supported	Supported
Unused Fields	Supported	Supported	Supported	Supported	Supported	Supported
Left Axis	Not Supported	Not Supported	Not Supported	Not Supported	Supported	Supported
Right Axis	Not Supported	Not Supported	Not Supported	Not Supported	Supported	Supported

Fields Panel	Bar	Column	Stacked Bar	Stacked Column	Pyramid	Stacked Pyramid
Filter by All	Supported	Supported	Supported	Supported	Supported	Supported
Filter by Dimension	Supported	Supported	Supported	Supported	Supported	Supported
Filter by Measure	Supported	Supported	Supported	Supported	Supported	Supported
Filter by Date	Supported	Supported	Supported	Supported	Supported	Supported
Rename	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Hide	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Edit Values	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Format Numbers	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Copy API Names	Supported	Supported	Supported	Supported	Supported	Supported
Add Derived Measure	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Add Derived Dimension	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported

Filters	Bar	Column	Stacked Bar	Stacked Column	Pyramid	Stacked Pyramid
Select a field or value	Supported	Supported	Supported	Supported	Supported	Supported
Add Filter Logic	Supported	Supported	Supported	Supported	Supported	Supported

Chart Type: Lines

Chart Properties	Line	Combo	Parallel Coordinates	Metrics Radar
X-Axis	Supported	Supported	Not Supported	Not Supported
Y-Axis	Supported	Supported	Not Supported	Not Supported
Lines	Supported	Not Supported	Supported	Not Supported
Node Measures	Not Supported	Not Supported	Supported	Not Supported
Axes	Not Supported	Not Supported	Not Supported	Supported
Polygons	Not Supported	Not Supported	Not Supported	Supported
Trellis	Supported	Supported	Supported	Supported
Unused Fields	Supported	Supported	Supported	Supported

Fields Panel	Line	Combo	Parallel Coordinates	Metrics Radar
Filter by All	Supported	Supported	Supported	Supported
Filter by Dimension	Supported	Supported	Supported	Supported
Filter by Measure	Supported	Supported	Supported	Supported
Filter by Date	Supported	Supported	Supported	Supported
Rename	Not Supported	Not Supported	Not Supported	Not Supported
Hide	Not Supported	Not Supported	Not Supported	Not Supported
Edit Values	Not Supported	Not Supported	Not Supported	Not Supported
Format Numbers	Not Supported	Not Supported	Not Supported	Not Supported
Copy API Name	Supported	Supported	Supported	Supported
Add Derived Measure	Not Supported	Not Supported	Not Supported	Not Supported
Add Derived Dimension	Not Supported	Not Supported	Not Supported	Not Supported

Filters	Line	Combo	Parallel Coordinates	Metrics Radar
Select a field or value	Supported	Supported	Supported	Supported
Add Filter Logic	Supported	Supported	Supported	Supported

Chart Type: Dates & Times

Chart Properties	Timeline	Time Combo	Time Bar	Calendar Heatmap
Time Axis	Supported	Supported	Supported	Not Supported
Y-Axis	Supported	Supported	Supported	Not Supported
Lines	Supported	Not Supported	Not Supported	Not Supported
Time Periods	Not Supported	Not Supported	Not Supported	Supported
Color	Not Supported	Not Supported	Not Supported	Supported
Trellis	Supported	Supported	Supported	Not Supported
Unused Fields	Supported	Supported	Supported	Supported

Fields Panel	Timeline	Time Combo	Time Bar	Calendar Heatmap
Filter by All	Supported	Supported	Supported	Supported
Filter by Dimension	Supported	Supported	Supported	Supported
Filter by Measure	Supported	Supported	Supported	Supported
Filter by Date	Supported	Supported	Supported	Supported
Rename	Not Supported	Not Supported	Not Supported	Not Supported
Hide	Not Supported	Not Supported	Not Supported	Not Supported
Edit Values	Not Supported	Not Supported	Not Supported	Not Supported
Format Numbers	Not Supported	Not Supported	Not Supported	Not Supported
Copy API Name	Supported	Supported	Supported	Supported
Add Derived Measure	Not Supported	Not Supported	Not Supported	Not Supported
Add Derived Dimension	Not Supported	Not Supported	Not Supported	Not Supported

Filters	Timeline	Time Combo	Time Bar	Calendar Heatmap
Select a field or value	Supported	Supported	Supported	Supported
Add Filter Logic	Supported	Supported	Supported	Supported

Chart Type: Gauges

Chart Properties	Gauge	Polar Gauge	Flat Gauge	Bullet	Rating
Value	Supported	Supported	Supported	Supported	Supported
Trellis	Supported	Supported	Supported	Supported	Supported
Unused Fields	Supported	Supported	Supported	Supported	Supported

Fields Panel	Gauge	Polar Gauge	Flat Gauge	Bullet	Rating
Filter by All	Supported	Supported	Supported	Supported	Supported
Filter by Dimension	Supported	Supported	Supported	Supported	Supported
Filter by Measure	Supported	Supported	Supported	Supported	Supported
Filter by Date	Supported	Supported	Supported	Supported	Supported
Rename	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Hide	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Edit Values	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Format Numbers	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Copy API Name	Supported	Supported	Supported	Supported	Supported
Add Derived Measure	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Add Derived Dimension	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported

Filters	Gauge	Polar Gauge	Flat Gauge	Bullet	Rating
Select a field or value	Supported	Supported	Supported	Supported	Supported
Add Filter Logic	Supported	Supported	Supported	Supported	Supported

Chart Type: Circles & Dots

Chart Properties	Donut	Scatter Plot	Horizontal Dot Plot	Vertical Dot Plot
X-Axis	Not Supported	Supported	Supported	Supported
Y-Axis	Not Supported	Supported	Supported	Supported
Bubble Size	Not Supported	Supported	Supported	Supported
Bubbles	Not Supported	Supported	Supported	Supported
Segment Size	Supported	Not Supported	Not Supported	Not Supported
Segments	Supported	Not Supported	Not Supported	Not Supported
Trellis	Supported	Supported	Supported	Supported
Unused Fields	Supported	Supported	Supported	Supported

Fields Panel	Donut	Scatter Plot	Horizontal Dot Plot	Vertical Dot Plot
Filter by All	Supported	Supported	Supported	Supported
Filter by Dimension	Supported	Supported	Supported	Supported
Filter by Measure	Supported	Supported	Supported	Supported
Filter by Date	Supported	Supported	Supported	Supported
Rename	Not Supported	Not Supported	Not Supported	Not Supported
Hide	Not Supported	Not Supported	Not Supported	Not Supported
Edit Values	Not Supported	Not Supported	Not Supported	Not Supported
Format Numbers	Not Supported	Not Supported	Not Supported	Not Supported
Copy API Name	Supported	Supported	Supported	Supported
Add Derived Measure	Not Supported	Not Supported	Not Supported	Not Supported
Add Derived Dimension	Not Supported	Not Supported	Not Supported	Not Supported

Filters	Donut	Scatter Plot	Horizontal Dot Plot	Vertical Dot Plot
Select a field or value	Supported	Supported	Supported	Supported
Add Filter Logic	Supported	Supported	Supported	Supported

Chart Type: Grids

Chart Properties	Heatmap	Matri✓	Treemap
X-Axis	Supported	Supported	Not Supported
Y-Axis	Supported	Supported	Not Supported
Bubble Size	Not Supported	Supported	Not Supported
Bubbles Color	Not Supported	Supported	Not Supported
Segment Size	Not Supported	Not Supported	Supported
Segments	Not Supported	Not Supported	Supported
Color	Supported	Not Supported	Not Supported
Trellis	Not Supported	Not Supported	Supported
Unused Fields	Supported	Supported	Supported

Fields Panel	Heatmap	Matri✓	Treemap
Filter by All	Supported	Supported	Supported
Filter by Dimension	Supported	Supported	Supported
Filter by Measure	Supported	Supported	Supported
Filter by Date	Not Supported	Supported	Supported
Rename	Not Supported	Not Supported	Not Supported
Hide	Not Supported	Not Supported	Not Supported
Edit Values	Not Supported	Not Supported	Not Supported
Format Numbers	Supported	Supported	Supported
Copy API Name	Supported	Supported	Supported
Add Derived Measure	Not Supported	Not Supported	Not Supported
Add Derived Dimension	Not Supported	Not Supported	Not Supported

Filters	Heatmap	Matri✓	Treemap
Select a field or value	Supported	Supported	Supported
Add Filter Logic	Supported	Supported	Supported

Chart Type: Maps

Chart Properties	Map	Bubble Map	Geo Map
Locations	Supported	Supported	Supported
Color	Supported	Not Supported	Not Supported
Bubble Size	Not Supported	Supported	Supported
Bubbles Color	Not Supported	Supported	Supported
Latitude and Logitude	Not Supported	Not Supported	Supported
Trellis	Supported	Supported	Supported
Unused Fields	Supported	Supported	Supported

Fields Panel	Map	Bubble Map	Geo Map
Filter by All	Supported	Supported	Supported
Filter by Dimension	Supported	Supported	Supported
Filter by Measure	Supported	Supported	Supported
Filter by Date	Supported	Supported	Supported
Rename	Not Supported	Not Supported	Not Supported
Hide	Not Supported	Not Supported	Not Supported
Edit Values	Not Supported	Not Supported	Not Supported
Format Numbers	Not Supported	Not Supported	Not Supported
Copy API Name	Supported	Supported	Supported
Add Derived Measure	Not Supported	Not Supported	Not Supported
Add Derived Dimension	Not Supported	Not Supported	Not Supported

Filters	Map	Bubble Map	Geo Map
Select a field or value	Supported	Supported	Supported
Add Filter Logic	Supported	Supported	Supported

Chart Type: Pipelines

Chart Properties	Waterfall	Stacked Waterfall	Funnel	Origami	Sankey
Bars	Supported	Supported	Not Supported	Not Supported	Not Supported
Bar Length	Supported	Supported	Not Supported	Not Supported	Not Supported
Bar Segments	Not Supported	Supported	Not Supported	Not Supported	Not Supported
Segment Size	Not Supported	Not Supported	Supported	Supported	Not Supported
Segments	Not Supported	Not Supported	Supported	Supported	Not Supported
Flow Width	Not Supported	Not Supported	Not Supported	Not Supported	Supported
Nodes	Not Supported	Not Supported	Not Supported	Not Supported	Supported
Trellis	Supported	Supported	Supported	Supported	Not Supported
Unused Fields	Supported	Supported	Supported	Supported	Supported

Fields Panel	Waterfall	Stacked Waterfall	Funnel	Origami	Sankey
Filter by All	Supported	Supported	Supported	Supported	Supported
Filter by Dimension	Supported	Supported	Supported	Supported	Supported
Filter by Measure	Supported	Supported	Supported	Supported	Supported
Filter by Date	Supported	Supported	Supported	Supported	Supported
Rename	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Hide	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Edit Values	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Format Numbers	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Copy API Name	Supported	Supported	Supported	Supported	Supported
Add Derived Measure	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported
Add Derived Dimension	Not Supported	Not Supported	Not Supported	Not Supported	Not Supported

Filters	Waterfall	Stacked Waterfall	Funnel	Origami	Sankey
Select a field or value	Supported	Supported	Supported	Supported	Supported
Add Filter Logic	Supported	Supported	Supported	Supported	Supported

Chart Type Configuration for Direct Queries in CRM Analytics Lenses

General Information

Required Cookies

Functional Cookies

Advertising Cookies

General Information

Required Cookies

Functional Cookies

Advertising Cookies

Cookie List