...
...
...
| Panel | ||
|---|---|---|
| ||
Welcome to our training materials! We're excited to have you here and hope that this training will provide you with valuable knowledge and skills. Below, you can find the complete table of contents, this will give you an overview of what topics will be covered and in what order. Be sure to check back regularly for any updates, as we make changes or additions to the training materials. |
| Table of Contents |
|---|
...
Working with Subset Editor
...
Select }Hierarchies_Product dimension
Open Subset Editor
Click All E button
Select Product:Color and Product:Size from the list of available elements
Click Apply button
Select Product global filter dimension
Open the advanced options panel Dimension Settings
Click Select button visible above Hierarchy dropdown list
In the editable text box input UX Placeholder: $<<UX_Demo.}Hierarchies_Product.}Hierarchies_Product>>Product::Hierarchy>>
Change the List Type to MDX
Select Product dimension added in columns
Add the same placeholder in the Hierarchy text box
Change the List Type to MDX
...
Click on the cube icon to open cube settings
Select Product dimension added in columns
Open advanced options panel and select Dimension Settings
Click Select button visible above Hierarchy dropdown list
In the editable text box input UX Placeholder: $<<UX_Demo.}Hierarchies_Product.}Hierarchies_Product::Hierarchy>>
Change the MDX query to:
| Code Block | ||
|---|---|---|
| ||
{[Product].[$<<UX_Demo.}Hierarchies_Product.}Hierarchies_Product>>].[$<<UX_Demo.Product.$<<UX_Demo.}Hierarchies_Product.}Hierarchies_Product>>>>]} |
...
Charts configuration and edition
1.
...
Application offers various chart types and depending on which widget is selected, settings panel will return the available options. But some of them are common to most of chart types and first we will focus on those.
Tooltip shared
Chart title
Chart Null Values
Calculated Rows and columns.
Series section, which gives you many customization options, after clicking on the + icon next to Populate our data will automatically be added to the advanced options panel and now you can change:
Type: we have area, line, bar and column option
Color, which can be selected from the color picker
We can enable data labels for selected series
And change their format
Plot Options and Data Labels
What’s more graphs in the app naturally come with drill through capacity.
You can adjust those settings in the Charts Driablle section:
...
Cross drill ➟ Available when we right click on the column and select Drill down by, we can turn it off using this option
...
In one of the latest versions a new option has been added to the advanced options GUI: Chart Show Percentage o facilitate adding percentage formatting in charts. Enabling the option will result in % format and recalculated values to be displayed in data labels, tooltips as well as y- axis. No further configuration is required.
open the advanced options panel
select Chart widget by clicking on its header
select Chart Options
set Chart Show Percentage option to Yes
save the changes
The formatting in the chart will change, you will notice % visible in the data labels, tooltips as well as y- axis.
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Every update that occurs in settings also gets codded and we can check it in the code tab, which is another place where the widget can be customized. |
2. Waterfall Chart
...
Waterfall Chart
In this section we will check out some of the advance adoptions specific for Waterfall chart. For the purpose of this exercise navigate to Latest Releases - UX Version 2020.08 - Waterfall Chart improvements
...