Configuring Advanced Widget Settings

In this section:

1. Combining Two Types of Visualizations in a Widget
   In chart widgets, such as line charts, area charts, column charts, and bar charts, you can represent one or more selected fields using a different visualization than the visualization of the original widget.
2. Selecting Colors in Widgets
   The Widget Designer automatically assigns different colors to different field values.
3. Sorting Field Values in Widgets
   By default, the values that you add to a widget are not sorted. You can select a sorting option to specify the order in which the items are displayed.
4. Renaming Fields in Widgets
   The names of fields in widgets are taken from the raw data. You can change the names of the fields according to your needs.
5. Formatting Numbers in Widgets
   You can change the way numbers are displayed in widgets. For example, you can display a number as a percentage and set the number of decimal places.
6. Formatting Date and Time Values in Widgets
   You can change the format of the date and time values that are displayed in your widgets.
7. Creating a Continuous Chart with Missing Date Values
   If your data is missing date values, you can add the missing dates to your chart to create a continuous data flow. You can also specify whether to display missing dates as gaps in the chart or to include null values as zero values to avoid gaps and maintain a continuous data flow.
8. Adding Drill Hierarchies to Widgets
   Viewers can drill down in a widget and get an in-depth view of a selected value.
9. Disabling the Drill to Anywhere Option
   As a self-service user, you can give access only to predefined drill hierarchies and prevent viewers from drilling down freely to any field.