Configuring Label Parameters

Note

Label parameters are not supported for SSAS data source currently.

You can configure the label parameters by using the field name in the Header section of widget. Use the below format to configure the label parameter.

Syntax: {{:Column_Name}} when single data source is present

Or

Syntax: {{:DataSource_Name.Column_Name}} when more than one data source is present.

For example, The header text of the Grid widget as: Ship Country - {{:ShipCountry}}.

Now, the dashboard will show the label parameter for all the countries like Ship Country - All

You can select the required country to display by selecting the country name in the grid widget. Based on the selected country the values may get displayed on the widget.

You can also use Label widget to configure the Label parameters.

Drag and drop the label widget into the Design pane and click the edit label option to add the label parameters.

While previewing the dashboard, initially the parameter of the ship country will be shown as All in the label widget.

While selecting the particular country, it may show that Country name in the label widget.

You can add the Data source before the parameters in Header section of properties pane when more than one data source present in the dashboard.

While previewing the dashboard, initially the values of the parameters will be shown as All.

While selecting the particular country, you may show that country name in the widget.

Functions supported in Label Parameters

You can configure the label parameters using the column name with functions like Sum, Count, Average, Min, Max, StdDev, Var, Distinct Count, Weighted Score for numeric values.

For Date Time type, the supported functions are Date, Year, Month, Quarter, Day, Day Month Year, Minutes, Second, Month Year, Date Hour, Day of Week and Week of Year.

For Text type, the supported functions are Count and Distinct Count.

Use the below format to configure the label parameter.

Syntax: {{:function(Column_Name)}} when single data source is present

Or

Syntax: {{:function(DataSource_Name.Column_Name)}} when more than one data source is present.

Functions	Supported Type	Examples
sum	Numeric	Ship Country : `{{:sum(OrderID)}}`
Average	Numeric	Ship Country : `{{:avg(OrderID)}}` or `{{:average(OrderID)}}`
Count	Numeric	Ship Country : `{{:count(ShipCountry)}}`
Distinct Count	Numeric	Ship Country : `{{:dcount(ShipCountry)}}` or `{{:distinctcount(ShipCountry)}}`
Standard Deviation	Numeric	Ship Country : `{{:stdev(OrderID)}}`
Minimum	Numeric	Ship Country : `{{:min(OrderID)}}`
Maximum	Numeric	Ship Country : `{{:max(OrderID)}}`
Weighted Score	Numeric	Ship Country : `{{:WeightedAvg([OrderID],[ProductID])}}`
Date	Date Time	Shipped Date : `{{:date(ShippedDate)}}`
Year	Date Time	Shipped Date : `{{:year(ShippedDate)}}`
Month	Date Time	Shipped Date : `{{:monthname(ShippedDate)}}`
Quarter	Date Time	Shipped Date : `{{:quarter(ShippedDate)}}`
Day	Date Time	Shipped Date : `{{:day(ShippedDate)}}`
Day Month Year	Date Time	Shipped Date : `{{:daymonthyear(ShippedDate)}}`
Minutes	Date Time	Shipped Date : `{{:minutes(ShippedDate)}}`
Seconds	Date Time	Shipped Date : `{{:quarteryear(ShippedDate)}}`
Month Year	Date Time	Shipped Date : `{{:monthyear(ShippedDate)}}`
Date Hour	Date Time	Shipped Date : `{{:datehour(ShippedDate)}}`
Day of Week	Date Time	Shipped Date : `{{:dayofweek(ShippedDate)}}`
Week of Year	Date Time	Shipped Date : `{{:weekofyear(ShippedDate)}}`

Note

Function name of label parameters are case insensitive.