The following properties are settings that are common across all tile types.
Write a custom caption to serve as a title for each tile and optionally turn it on or off. Even if the caption is turned off, the caption will be used to identify this dashboard tile in the Dashboard Manager.
Each dashboard tile must be connected to a data source. If the data source you require is not available you must first add it to the dashboard in the Dashboard Manager.
A Summary Type must be defined for all values mapped processed as a measure. The summary type determines how to aggregate and summarise results. For example, if your data source included monthly results but your dimensions display by quarter you may wish to Sum or Average the monthly results for the quarterly dimension. See Summary Functions for details on each summary type.
Hidden Dimensions & Hidden Measures
See the Key Concepts help article for an explanation on the difference between a Dimension and Measure, however on occasion you may need to add a Hidden Dimension or Hidden Measure. For example, you may wish to filter on a dimension or sort on a measure not included on the tiles selected properties.
Filters allow you to exclude data from the data source in this dashboard tile. This can be useful if you want to have a single data source but use it on multiple tiles.
Tip: 💡if the property required to filter is not a dimension of the tile, you can add it as a Hidden Dimension and then it will be available to use in your filter.
Sort Order & Sort By
Some tile arguments allow you to choose a Sort Order and Sort By property. Sorting can only be performed on values processed as a Measure.
Tip: 💡if the property required to sort by is not a measure displayed on the tile, you can add it as a Hidden Measure and then it will be available to sort by. A common example of this is when you use the PeriodLabel as an Argument in a chart. Since it is just a text label the sorting will be alphabetical. In order to sort by Period you will need to add it as a Hidden Measure.