Table view replaces percentage column with "Total" in widget

[OlgaBorokhova]

A pivot in Analyzer is configured with one column (Count) and uses the "% of Total" display option to show relative values. This configuration is correctly reflected in the Analyzer view (screenshot 1).

In the widget, only the "Count" property is selected, and the chart view renders the data as expected.
However, when switching the same widget to table view, instead of "% of Total" column a "Total" column appears (screenshot 2)

Expected behavior: The table view in the widget should preserve the "% of Total" column if it is part of the Analyzer pivot setup.

[Frisle]

Take a look at this example

https://samples-bi-demo.demo.community.intersystems.com/csp/user/_DeepSee.UserPortal.Analyzer.zen?PIVOT=Use%20in%20Dashboards/Demo%20Bubble%20Chart.pivot

https://samples-bi-demo.demo.community.intersystems.com/dsw/index.html#/USER/Widget%20Examples/Bubble%20Charts.dashboard

[OlgaBorokhova]

Take a look at this example

https://samples-bi-demo.demo.community.intersystems.com/csp/user/_DeepSee.UserPortal.Analyzer.zen?PIVOT=Use%20in%20Dashboards/Demo%20Bubble%20Chart.pivot

Add into pivot that settings

Pivot in Analyzer gets new column

https://samples-bi-demo.demo.community.intersystems.com/dsw/index.html#/USER/Widget%20Examples/Bubble%20Charts.dashboard

and in table view get "Total" instead of "% of Total"

[OlgaBorokhova]

A bug was discovered in the implemented solution.
When “% of total” is added by rows and “Total” is shown at the bottom by columns, the percentage values are incorrectly halved.

Analayzer

DSW