--- title: Table Widget description: >- Display tabular data with columns, rows, and sorting capabilities for detailed metric and event analysis. breadcrumbs: Docs > Dashboards > Widgets > Table Widget --- # Table Widget ## Overview{% #overview %} The table visualization displays columns of aggregated data grouped by tag key. Use tables to compare values across many groups of data and see trends, changes, and outliers. {% image source="https://docs.dd-static.net/images/dashboards/widgets/table/table_conditional_formatting.37efc410d6bc13615a935be6c834f626.png?auto=format" alt="Table widget with conditional formatting" /%} ## Setup{% #setup %} ### Configuration{% #configuration %} 1. Choose the data to graph: - Metric: See the [Main graphing documentation](https://docs.datadoghq.com/dashboards/querying/#configuring-a-graph) to configure a metric query. - Non-metric data sources: See the [Log search documentation](https://docs.datadoghq.com/logs/search_syntax/) to configure an event query. 1. Add additional columns to the table by using the + Add Query and + Add Formula buttons. ### Options{% #options %} - Rename column headers by setting aliases, click the as... button. - Configure whether or not the search bar displays. Auto is the default and shows the search bar depending on the size of the widget, this means if your screen gets too small, it prioritizes displaying the data on the widget and hides the search bar, but is still available in full-screen mode. #### Column formatting{% #column-formatting %} Customize the visualization of cell values for each column with Column Formatting Rules. Create color codes for your data to visualize trends and changes. - Threshold formatting: highlight cells with colors when specific value ranges are met. - Range formatting: color code cells with a range of values. - Text formatting: replace cells with alias text values to improve readability. - Trending information: visualize metrics and events queries. {% image source="https://docs.dd-static.net/images/dashboards/widgets/table/conditional_formatting_trends.0d1a234e45a9f4308ce8f5611ee56d3a.png?auto=format" alt="Table widget showing conditional formatting with trend indicators" /%} #### Context links{% #context-links %} [Context links](https://docs.datadoghq.com/dashboards/guide/context-links/) are enabled by default, and can be toggled on or off. Context links bridge dashboard widgets with other pages in Datadog, or third party applications. ## N/A values{% #na-values %} Columns in the table widget are queried independently from one another. Overlapping groups with matching names are joined realtime to form the rows of the table. As a result of that process, there might be situations with no total overlap, showing N/A cells. To mitigate this: - Extend the limit of queries to higher numbers, to maximize overlap between columns - Sort tables according to the one column that you could consider as "driving" the insight ## API{% #api %} This widget can be used with the **Dashboards API**. See the [Dashboards API documentation](https://docs.datadoghq.com/api/latest/dashboards/) for additional reference. The dedicated [widget JSON schema definition](https://docs.datadoghq.com/dashboards/graphing_json/widget_json/) for the table widget is: {% tab %} ModelExample {% tab title="-model" %} Expand AllFieldTypeDescription custom_links[object]List of custom links.is_hiddenbooleanThe flag for toggling context menu link visibility.labelstringThe label for the custom link URL. Keep the label short and descriptive. Use metrics and tags as variables.linkstringThe URL of the custom link. URL must include `http` or `https`. A relative URL must start with `/`.override_labelstringThe label ID that refers to a context menu link. Can be `logs`, `hosts`, `traces`, `profiles`, `processes`, `containers`, or `rum`.descriptionstringThe description of the widget.has_search_barenumControls the display of the search bar. Allowed enum values: `always,never,auto` requests [*required*][object]Widget definition.aggregatorenumAggregator used for the request. Allowed enum values: `avg,last,max,min,sum,percentile`aliasstringThe column name (defaults to the metric name). apm_queryobject**DEPRECATED**: Deprecated - Use `queries` and `formulas` instead. computeobjectDefine computation for a log query.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. group_by[object]List of tag prefixes to group by in the case of a cluster check.facet [*required*]stringFacet name.limitint64Maximum number of items in the group. sortobjectDefine a sorting method.aggregation [*required*]stringThe aggregation method.facetstringFacet name.order [*required*]enumWidget sorting methods. Allowed enum values: `asc,desc`indexstringA coma separated-list of index names. Use "*" query all indexes at once. [Multiple Indexes](https://docs.datadoghq.com/logs/indexes/#multiple-indexes) multi_compute[object]This field is mutually exclusive with `compute`.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. searchobjectThe query being made on the logs.query [*required*]stringSearch value to apply. apm_stats_queryobjectThe APM stats query for table and distributions widgets. columns[object]Column properties used by the front end for display.aliasstringA user-assigned alias for the column.cell_display_modeenumDefine a display mode for the table cell. Allowed enum values: `number,bar,trend`name [*required*]stringColumn name.orderenumWidget sorting methods. Allowed enum values: `asc,desc`env [*required*]stringEnvironment name.name [*required*]stringOperation name associated with service.primary_tag [*required*]stringThe organization's host group name and value.resourcestringResource name.row_type [*required*]enumThe level of detail for the request. Allowed enum values: `service,resource,span`service [*required*]stringService name.cell_display_mode[string]A list of display modes for each table cell. conditional_formats[object]List of conditional formats.comparator [*required*]enumComparator to apply. Allowed enum values: `=,>,>=,<,<=`custom_bg_colorstringColor palette to apply to the background, same values available as palette.custom_fg_colorstringColor palette to apply to the foreground, same values available as palette.hide_valuebooleanTrue hides values.image_urlstringDisplays an image as the background.metricstringMetric from the request to correlate this conditional format with.palette [*required*]enumColor palette to apply. Allowed enum values: `blue,custom_bg,custom_image,custom_text,gray_on_white,grey,green,orange,red,red_on_white`Show 9 more`,white_on_gray,white_on_green,green_on_white,white_on_red,white_on_yellow,yellow_on_white,black_on_light_yellow,black_on_light_green,black_on_light_red` timeframestringDefines the displayed timeframe.value [*required*]doubleValue for the comparator. event_queryobject**DEPRECATED**: Deprecated - Use `queries` and `formulas` instead. computeobjectDefine computation for a log query.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. group_by[object]List of tag prefixes to group by in the case of a cluster check.facet [*required*]stringFacet name.limitint64Maximum number of items in the group. sortobjectDefine a sorting method.aggregation [*required*]stringThe aggregation method.facetstringFacet name.order [*required*]enumWidget sorting methods. Allowed enum values: `asc,desc`indexstringA coma separated-list of index names. Use "*" query all indexes at once. [Multiple Indexes](https://docs.datadoghq.com/logs/indexes/#multiple-indexes) multi_compute[object]This field is mutually exclusive with `compute`.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. searchobjectThe query being made on the logs.query [*required*]stringSearch value to apply. formulas[object]List of formulas that operate on queries.aliasstringExpression alias.cell_display_modeenumDefine a display mode for the table cell. Allowed enum values: `number,bar,trend` cell_display_mode_optionsobjectCell display mode options for the widget formula. (only if `cell_display_mode` is set to `trend`).trend_typeenumTrend type for the cell display mode options. Allowed enum values: `area,line,bars`y_scaleenumY scale for the cell display mode options. Allowed enum values: `shared,independent` conditional_formats[object]List of conditional formats.comparator [*required*]enumComparator to apply. Allowed enum values: `=,>,>=,<,<=`custom_bg_colorstringColor palette to apply to the background, same values available as palette.custom_fg_colorstringColor palette to apply to the foreground, same values available as palette.hide_valuebooleanTrue hides values.image_urlstringDisplays an image as the background.metricstringMetric from the request to correlate this conditional format with.palette [*required*]enumColor palette to apply. Allowed enum values: `blue,custom_bg,custom_image,custom_text,gray_on_white,grey,green,orange,red,red_on_white`Show 9 more`,white_on_gray,white_on_green,green_on_white,white_on_red,white_on_yellow,yellow_on_white,black_on_light_yellow,black_on_light_green,black_on_light_red` timeframestringDefines the displayed timeframe.value [*required*]doubleValue for the comparator.formula [*required*]stringString expression built from queries, formulas, and functions. limitobjectOptions for limiting results returned.countint64Number of results to return.orderenumDirection of sort. Allowed enum values: `asc,desc` default: `desc` number_formatobjectNumber format options for the widget. unit Number format unit. Option 1objectCanonical unit.per_unit_namestringThe name of the unit per item.typeenumThe type of unit scale. Allowed enum values: `canonical_unit`unit_namestringThe name of the unit. Option 2objectCustom unit.labelstringThe label for the custom unit.typeenumThe type of custom unit. Allowed enum values: `custom_unit_label` unit_scaleobjectThe definition of `NumberFormatUnitScale` object.typeenumThe type of unit scale. Allowed enum values: `canonical_unit`unit_namestringThe name of the unit. styleobjectStyling options for widget formulas.palettestringThe color palette used to display the formula. A guide to the available color palettes can be found at [https://docs.datadoghq.com/dashboards/guide/widget_colors](https://docs.datadoghq.com/dashboards/guide/widget_colors)palette_indexint64Index specifying which color to use within the palette.limitint64For metric queries, the number of lines to show in the table. Only one request should have this property. log_queryobject**DEPRECATED**: Deprecated - Use `queries` and `formulas` instead. computeobjectDefine computation for a log query.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. group_by[object]List of tag prefixes to group by in the case of a cluster check.facet [*required*]stringFacet name.limitint64Maximum number of items in the group. sortobjectDefine a sorting method.aggregation [*required*]stringThe aggregation method.facetstringFacet name.order [*required*]enumWidget sorting methods. Allowed enum values: `asc,desc`indexstringA coma separated-list of index names. Use "*" query all indexes at once. [Multiple Indexes](https://docs.datadoghq.com/logs/indexes/#multiple-indexes) multi_compute[object]This field is mutually exclusive with `compute`.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. searchobjectThe query being made on the logs.query [*required*]stringSearch value to apply. network_queryobject**DEPRECATED**: Deprecated - Use `queries` and `formulas` instead. computeobjectDefine computation for a log query.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. group_by[object]List of tag prefixes to group by in the case of a cluster check.facet [*required*]stringFacet name.limitint64Maximum number of items in the group. sortobjectDefine a sorting method.aggregation [*required*]stringThe aggregation method.facetstringFacet name.order [*required*]enumWidget sorting methods. Allowed enum values: `asc,desc`indexstringA coma separated-list of index names. Use "*" query all indexes at once. [Multiple Indexes](https://docs.datadoghq.com/logs/indexes/#multiple-indexes) multi_compute[object]This field is mutually exclusive with `compute`.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. searchobjectThe query being made on the logs.query [*required*]stringSearch value to apply.orderenumWidget sorting methods. Allowed enum values: `asc,desc` process_queryobject**DEPRECATED**: Deprecated - Use `queries` and `formulas` instead.filter_by[string]List of processes.limitint64Max number of items in the filter list.metric [*required*]stringYour chosen metric.search_bystringYour chosen search term. profile_metrics_queryobject**DEPRECATED**: Deprecated - Use `queries` and `formulas` instead. computeobjectDefine computation for a log query.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. group_by[object]List of tag prefixes to group by in the case of a cluster check.facet [*required*]stringFacet name.limitint64Maximum number of items in the group. sortobjectDefine a sorting method.aggregation [*required*]stringThe aggregation method.facetstringFacet name.order [*required*]enumWidget sorting methods. Allowed enum values: `asc,desc`indexstringA coma separated-list of index names. Use "*" query all indexes at once. [Multiple Indexes](https://docs.datadoghq.com/logs/indexes/#multiple-indexes) multi_compute[object]This field is mutually exclusive with `compute`.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. searchobjectThe query being made on the logs.query [*required*]stringSearch value to apply.qstring**DEPRECATED**: Query definition. Deprecated - Use `queries` and `formulas` instead. queries[ ]List of queries that can be returned directly or used in formulas. Option 1objectA formula and functions metrics query.aggregatorenumThe aggregation methods available for metrics queries. Allowed enum values: `avg,min,max,sum,last,area,l2norm,percentile`cross_org_uuids[string]The source organization UUID for cross organization queries. Feature in Private Beta.data_source [*required*]enumData source for metrics queries. Allowed enum values: `metrics`name [*required*]stringName of the query for use in formulas.query [*required*]stringMetrics query definition.semantic_modeenumSemantic mode for metrics queries. This determines how metrics from different sources are combined or displayed. Allowed enum values: `combined,native` Option 2objectA formula and functions events query. compute [*required*]objectCompute options.aggregation [*required*]enumAggregation methods for event platform queries. Allowed enum values: `count,cardinality,median,pc75,pc90,pc95,pc98,pc99,sum,min`Show 2 more`,max,avg` intervalint64A time interval in milliseconds.metricstringMeasurable attribute to compute.cross_org_uuids[string]The source organization UUID for cross organization queries. Feature in Private Beta.data_source [*required*]enumData source for event platform-based queries. Allowed enum values: `logs,spans,network,rum,security_signals,profiles,audit,events,ci_tests,ci_pipelines`Show 3 more`,incident_analytics,product_analytics,on_call_events` group_by Group by configuration for a formula and functions events query. Accepts either a list of facet objects or a flat object that specifies a list of facet fields. Option 1[object]List of objects used to group by.facet [*required*]stringEvent facet.limitint64Number of groups to return. sortobjectOptions for sorting group by results.aggregation [*required*]enumAggregation methods for event platform queries. Allowed enum values: `count,cardinality,median,pc75,pc90,pc95,pc98,pc99,sum,min`Show 2 more`,max,avg` metricstringMetric used for sorting group by results.orderenumDirection of sort. Allowed enum values: `asc,desc` default: `desc` Option 2objectFlat group by configuration using multiple event facet fields.fields [*required*][string]List of event facets to group by.limitint64Number of groups to return. sortobjectOptions for sorting group by results.aggregation [*required*]enumAggregation methods for event platform queries. Allowed enum values: `count,cardinality,median,pc75,pc90,pc95,pc98,pc99,sum,min`Show 2 more`,max,avg` metricstringMetric used for sorting group by results.orderenumDirection of sort. Allowed enum values: `asc,desc` default: `desc` indexes[string]An array of index names to query in the stream. Omit or use `[]` to query all indexes at once.name [*required*]stringName of the query for use in formulas. searchobjectSearch options.query [*required*]stringEvents search string.storagestringOption for storage location. Feature in Private Beta. Option 3objectProcess query using formulas and functions.aggregatorenumThe aggregation methods available for metrics queries. Allowed enum values: `avg,min,max,sum,last,area,l2norm,percentile`cross_org_uuids[string]The source organization UUID for cross organization queries. Feature in Private Beta.data_source [*required*]enumData sources that rely on the process backend. Allowed enum values: `process,container`is_normalized_cpubooleanWhether to normalize the CPU percentages.limitint64Number of hits to return.metric [*required*]stringProcess metric name.name [*required*]stringName of query for use in formulas.sortenumDirection of sort. Allowed enum values: `asc,desc` default: `desc` tag_filters[string]An array of tags to filter by.text_filterstringText to use as filter. Option 4objectA formula and functions APM dependency stats query.cross_org_uuids[string]The source organization UUID for cross organization queries. Feature in Private Beta.data_source [*required*]enumData source for APM dependency stats queries. Allowed enum values: `apm_dependency_stats`env [*required*]stringAPM environment.is_upstreambooleanDetermines whether stats for upstream or downstream dependencies should be queried.name [*required*]stringName of query to use in formulas.operation_name [*required*]stringName of operation on service.primary_tag_namestringThe name of the second primary tag used within APM; required when `primary_tag_value` is specified. See [https://docs.datadoghq.com/tracing/guide/setting_primary_tags_to_scope/#add-a-second-primary-tag-in-datadog](https://docs.datadoghq.com/tracing/guide/setting_primary_tags_to_scope/#add-a-second-primary-tag-in-datadog).primary_tag_valuestringFilter APM data by the second primary tag. `primary_tag_name` must also be specified.resource_name [*required*]stringAPM resource.service [*required*]stringAPM service.stat [*required*]enumAPM statistic. Allowed enum values: `avg_duration,avg_root_duration,avg_spans_per_trace,error_rate,pct_exec_time,pct_of_traces,total_traces_count` Option 5objectAPM resource stats query using formulas and functions.cross_org_uuids[string]The source organization UUID for cross organization queries. Feature in Private Beta.data_source [*required*]enumData source for APM resource stats queries. Allowed enum values: `apm_resource_stats`env [*required*]stringAPM environment.group_by[string]Array of fields to group results by.name [*required*]stringName of this query to use in formulas.operation_namestringName of operation on service.primary_tag_namestringName of the second primary tag used within APM. Required when `primary_tag_value` is specified. See [https://docs.datadoghq.com/tracing/guide/setting_primary_tags_to_scope/#add-a-second-primary-tag-in-datadog](https://docs.datadoghq.com/tracing/guide/setting_primary_tags_to_scope/#add-a-second-primary-tag-in-datadog)primary_tag_valuestringValue of the second primary tag by which to filter APM data. `primary_tag_name` must also be specified.resource_namestringAPM resource name.service [*required*]stringAPM service name.stat [*required*]enumAPM resource stat name. Allowed enum values: `errors,error_rate,hits,latency_avg,latency_distribution,latency_max,latency_p50,latency_p75,latency_p90,latency_p95`Show 1 more`,latency_p99` Option 6objectA formula and functions APM metrics query.data_source [*required*]enumData source for APM metrics queries. Allowed enum values: `apm_metrics`group_by[string]Optional fields to group the query results by.name [*required*]stringName of this query to use in formulas.operation_modestringOptional operation mode to aggregate across operation names.operation_namestringName of operation on service. If not provided, the primary operation name is used.peer_tags[string]Tags to query for a specific downstream entity (peer.service, peer.db_instance, peer.s3, peer.s3.bucket, etc.).query_filterstringAdditional filters for the query using metrics query syntax (e.g., env, primary_tag).resource_hashstringThe hash of a specific resource to filter by.resource_namestringThe full name of a specific resource to filter by.servicestringAPM service name.span_kindenumDescribes the relationship between the span, its parents, and its children in a trace. Allowed enum values: `consumer,server,client,producer,internal`stat [*required*]enumAPM metric stat name. Allowed enum values: `errors,error_rate,errors_per_second,latency_avg,latency_max,latency_p50,latency_p75,latency_p90,latency_p95,latency_p99`Show 6 more`,latency_p999,latency_distribution,hits,hits_per_second,total_time,apdex` Option 7objectA formula and functions metrics query.additional_query_filtersstringAdditional filters applied to the SLO query.cross_org_uuids[string]The source organization UUID for cross organization queries. Feature in Private Beta.data_source [*required*]enumData source for SLO measures queries. Allowed enum values: `slo`group_modeenumGroup mode to query measures. Allowed enum values: `overall,components`measure [*required*]enumSLO measures queries. Allowed enum values: `good_events,bad_events,good_minutes,bad_minutes,slo_status,error_budget_remaining,burn_rate,error_budget_burndown`namestringName of the query for use in formulas.slo_id [*required*]stringID of an SLO to query measures.slo_query_typeenumName of the query for use in formulas. Allowed enum values: `metric,monitor,time_slice` Option 8objectA formula and functions Cloud Cost query.aggregatorenumAggregator used for the request. Allowed enum values: `avg,last,max,min,sum,percentile`cross_org_uuids[string]The source organization UUID for cross organization queries. Feature in Private Beta.data_source [*required*]enumData source for Cloud Cost queries. Allowed enum values: `cloud_cost`name [*required*]stringName of the query for use in formulas.query [*required*]stringQuery for Cloud Cost data.response_formatenumTimeseries, scalar, or event list response. Event list response formats are supported by Geomap widgets. Allowed enum values: `timeseries,scalar,event_list` rum_queryobject**DEPRECATED**: Deprecated - Use `queries` and `formulas` instead. computeobjectDefine computation for a log query.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. group_by[object]List of tag prefixes to group by in the case of a cluster check.facet [*required*]stringFacet name.limitint64Maximum number of items in the group. sortobjectDefine a sorting method.aggregation [*required*]stringThe aggregation method.facetstringFacet name.order [*required*]enumWidget sorting methods. Allowed enum values: `asc,desc`indexstringA coma separated-list of index names. Use "*" query all indexes at once. [Multiple Indexes](https://docs.datadoghq.com/logs/indexes/#multiple-indexes) multi_compute[object]This field is mutually exclusive with `compute`.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. searchobjectThe query being made on the logs.query [*required*]stringSearch value to apply. security_queryobject**DEPRECATED**: Deprecated - Use `queries` and `formulas` instead. computeobjectDefine computation for a log query.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. group_by[object]List of tag prefixes to group by in the case of a cluster check.facet [*required*]stringFacet name.limitint64Maximum number of items in the group. sortobjectDefine a sorting method.aggregation [*required*]stringThe aggregation method.facetstringFacet name.order [*required*]enumWidget sorting methods. Allowed enum values: `asc,desc`indexstringA coma separated-list of index names. Use "*" query all indexes at once. [Multiple Indexes](https://docs.datadoghq.com/logs/indexes/#multiple-indexes) multi_compute[object]This field is mutually exclusive with `compute`.aggregation [*required*]stringThe aggregation method.facetstringFacet name.intervalint64Define a time interval in seconds. searchobjectThe query being made on the logs.query [*required*]stringSearch value to apply. sortobjectThe controls for sorting the widget.countint64The number of items to limit the widget to. order_by[ ]The array of items to sort the widget by in order. Option 1objectThe formula to sort the widget by.index [*required*]int64The index of the formula to sort by.order [*required*]enumWidget sorting methods. Allowed enum values: `asc,desc`type [*required*]enumSet the sort type to formula. Allowed enum values: `formula` Option 2objectThe group to sort the widget by.name [*required*]stringThe name of the group.order [*required*]enumWidget sorting methods. Allowed enum values: `asc,desc`type [*required*]enumSet the sort type to group. Allowed enum values: `group`text_formats[array]List of text formats for columns produced by tags. time Time setting for the widget. Option 1objectWrapper for live spanhide_incomplete_cost_databooleanWhether to hide incomplete cost data in the widget.live_spanenumThe available timeframes depend on the widget you are using. Allowed enum values: `1m,5m,10m,15m,30m,1h,4h,1d,2d,1w`Show 7 more`,1mo,3mo,6mo,week_to_date,month_to_date,1y,alert` Option 2objectUsed for arbitrary live span times, such as 17 minutes or 6 hours.hide_incomplete_cost_databooleanWhether to hide incomplete cost data in the widget.type [*required*]enumType "live" denotes a live span in the new format. Allowed enum values: `live`unit [*required*]enumUnit of the time span. Allowed enum values: `minute,hour,day,week,month,year`value [*required*]int64Value of the time span. Option 3objectUsed for fixed span times, such as 'March 1 to March 7'.from [*required*]int64Start time in milliseconds since epoch.hide_incomplete_cost_databooleanWhether to hide incomplete cost data in the widget.to [*required*]int64End time in milliseconds since epoch.type [*required*]enumType "fixed" denotes a fixed span. Allowed enum values: `fixed`titlestringTitle of your widget.title_alignenumHow to align the text on the widget. Allowed enum values: `center,left,right`title_sizestringSize of the title.type [*required*]enumType of the table widget. Allowed enum values: `query_table` default: `query_table` {% /tab %} {% tab title="example" %} ```json { "custom_links": [ { "is_hidden": false, "label": "Search logs for {{host}}", "link": "https://app.datadoghq.com/logs?query={{host}}", "override_label": "logs" } ], "description": "string", "has_search_bar": "auto", "requests": [ { "aggregator": "string", "alias": "string", "apm_query": { "compute": { "aggregation": "avg", "facet": "@duration", "interval": 5000 }, "group_by": [ { "facet": "resource_name", "limit": 50, "sort": { "aggregation": "avg", "facet": "@string_query.interval", "order": "desc" } } ], "index": "days-3,days-7", "multi_compute": [ { "aggregation": "avg", "facet": "@duration", "interval": 5000 } ], "search": { "query": "" } }, "apm_stats_query": { "columns": [ { "alias": "Requests", "cell_display_mode": "number", "name": "Reqs", "order": "desc" } ], "env": "prod", "name": "rack.request", "primary_tag": "datacenter:*", "resource": "CartsController", "row_type": "service", "service": "web-store" }, "cell_display_mode": [ "number" ], "conditional_formats": [ { "comparator": ">", "custom_bg_color": "string", "custom_fg_color": "string", "hide_value": false, "image_url": "string", "metric": "string", "palette": "blue", "timeframe": "string", "value": 0 } ], "event_query": { "compute": { "aggregation": "avg", "facet": "@duration", "interval": 5000 }, "group_by": [ { "facet": "resource_name", "limit": 50, "sort": { "aggregation": "avg", "facet": "@string_query.interval", "order": "desc" } } ], "index": "days-3,days-7", "multi_compute": [ { "aggregation": "avg", "facet": "@duration", "interval": 5000 } ], "search": { "query": "" } }, "formulas": [ { "alias": "string", "cell_display_mode": "number", "cell_display_mode_options": { "trend_type": "area", "y_scale": "shared" }, "conditional_formats": [ { "comparator": ">", "custom_bg_color": "string", "custom_fg_color": "string", "hide_value": false, "image_url": "string", "metric": "string", "palette": "blue", "timeframe": "string", "value": 0 } ], "formula": "func(a) + b", "limit": { "count": "integer", "order": "string" }, "number_format": { "unit": { "per_unit_name": "bytes", "type": "canonical_unit", "unit_name": "bytes" }, "unit_scale": { "type": "canonical_unit", "unit_name": "bytes" } }, "style": { "palette": "classic", "palette_index": 1 } } ], "limit": "integer", "log_query": { "compute": { "aggregation": "avg", "facet": "@duration", "interval": 5000 }, "group_by": [ { "facet": "resource_name", "limit": 50, "sort": { "aggregation": "avg", "facet": "@string_query.interval", "order": "desc" } } ], "index": "days-3,days-7", "multi_compute": [ { "aggregation": "avg", "facet": "@duration", "interval": 5000 } ], "search": { "query": "" } }, "network_query": { "compute": { "aggregation": "avg", "facet": "@duration", "interval": 5000 }, "group_by": [ { "facet": "resource_name", "limit": 50, "sort": { "aggregation": "avg", "facet": "@string_query.interval", "order": "desc" } } ], "index": "days-3,days-7", "multi_compute": [ { "aggregation": "avg", "facet": "@duration", "interval": 5000 } ], "search": { "query": "" } }, "order": "desc", "process_query": { "filter_by": [], "limit": "integer", "metric": "system.load.1", "search_by": "string" }, "profile_metrics_query": { "compute": { "aggregation": "avg", "facet": "@duration", "interval": 5000 }, "group_by": [ { "facet": "resource_name", "limit": 50, "sort": { "aggregation": "avg", "facet": "@string_query.interval", "order": "desc" } } ], "index": "days-3,days-7", "multi_compute": [ { "aggregation": "avg", "facet": "@duration", "interval": 5000 } ], "search": { "query": "" } }, "q": "string", "queries": [], "response_format": "timeseries", "rum_query": { "compute": { "aggregation": "avg", "facet": "@duration", "interval": 5000 }, "group_by": [ { "facet": "resource_name", "limit": 50, "sort": { "aggregation": "avg", "facet": "@string_query.interval", "order": "desc" } } ], "index": "days-3,days-7", "multi_compute": [ { "aggregation": "avg", "facet": "@duration", "interval": 5000 } ], "search": { "query": "" } }, "security_query": { "compute": { "aggregation": "avg", "facet": "@duration", "interval": 5000 }, "group_by": [ { "facet": "resource_name", "limit": 50, "sort": { "aggregation": "avg", "facet": "@string_query.interval", "order": "desc" } } ], "index": "days-3,days-7", "multi_compute": [ { "aggregation": "avg", "facet": "@duration", "interval": 5000 } ], "search": { "query": "" } }, "sort": { "count": "integer", "order_by": [ { "index": 0, "order": "desc", "type": "formula" } ] }, "text_formats": [ [] ] } ], "time": { "hide_incomplete_cost_data": false, "live_span": "5m" }, "title": "string", "title_align": "string", "title_size": "string", "type": "query_table" } ``` {% /tab %} {% /tab %} ## Further Reading{% #further-reading %} - [Building Dashboards using JSON](https://docs.datadoghq.com/dashboards/graphing_json/) - [Learn how to build a graphing query](https://docs.datadoghq.com/dashboards/querying/)