Data Management allows the user to configure additional settings for a given dataset. It can be accessed via the query listing screen by clicking the Data Management icon to the right of each query, or via a widget by navigating to More Settings > Data Diagram and then selecting the edit icon of the dataset (blue box).
Data Types
Allows you to view/edit the data type of existing fields in the dataset.
NLP
NLP Indexer
Defaults to ON. Turning it off will exclude the dataset from Search-based Analytics/NLP queries. Note that it may take a few minutes for the change to take effect.
Synonyms
Synonyms are useful for adding context awareness to your Search-based Analytics/NLP queries. For example, if you have a field in your dataset named customer, you can add a synonym “tag” to this field such as “shopper”, “buyer”, “clent”, etc. So, when you type in a question like “total sent by client”, it will recognize the term “client” as equivalent to the field “customer”. Multiple synonyms can be added for each field.
Indexes
Allows you to specify one or more index fields for commonly used filter attributes. Useful for larger datasets to help speed up results. For example, if the field date is a commonly used filter, setting this is an index will help speed up results when you filter by date.
Data
Displays the raw dataset in tabular format. Date/Time of the last data upload/update for this dataset is listed at the bottom left of the dataset. Click on the Export button to export data in CSV form.
Dynamic Widget Names
Widgets can be dynamically named, based on parameters passed into the dashboard, or via data elements within the widget.
To dynamically pass in widget name via runtime parameters, use the $c9$ syntax and pass the token in via contentFilters in the UI/embed mode, or using the filters. Example: _A widget for $c9orgname$. In this case, the $c9orgname$ token is dynamically populated. SeeContent Filtersfor more info.
To dynamically populate widget names driven by a field within the data, use the {{fieldname:n}} syntax where fieldname is the field to use and n is the row position of that field. Example: A widget for {{orgId:1}}. In this case, the first item in the orgId field in the dataset is used to dynamically display the widget name.