Column created with Beast mode with numeric and porcentage format
.Dear community, this month I have receipt separately two cases with the same concern:
The users have shown to me functions created with beast mode, inside a pivot table card. The goal is set in the same column figure with number format and percentage, including the symbol “%”. I have attempted so many ways, but I don´t found method to combine my pivot and beast mode options card to reach the outcome.
A common factor of those parallel cases is, happen after last domo update occurred early May 23.
Before above event, users show me support, like below, where through a beast mode function inside the card, provide the having of Mixed format (numeric and percentage) in the same column and a subtotal, which grouping the numeric figurate and another line/subtotal add up all the line with percentage.
Sorry if I am bothering you with such complex case, but I feel little frustration to not find options to that.
If someone here read this and a spark about how to sort out, please let me know
Best Answer

Depending on how you structure your data. For simplicity, assume each row is already summarised like the below
In the beast mode, the formula is defined as below. Note I am using Avg() with the assumption that row is already summarised.
Output:
0
Answers

Depending on how you structure your data. For simplicity, assume each row is already summarised like the below
In the beast mode, the formula is defined as below. Note I am using Avg() with the assumption that row is already summarised.
Output:
0
Categories
 All Categories
 1.2K Product Ideas
 1.2K Ideas Exchange
 1.3K Connect
 1.1K Connectors
 273 Workbench
 1 Cloud Amplifier
 3 Federated
 2.7K Transform
 78 SQL DataFlows
 525 Datasets
 2.1K Magic ETL
 2.9K Visualize
 2.2K Charting
 434 Beast Mode
 22 Variables
 510 Automate
 114 Apps
 388 APIs & Domo Developer
 8 Workflows
 26 Predict
 10 Jupyter Workspaces
 16 R & Python Tiles
 332 Distribute
 77 Domo Everywhere
 255 Scheduled Reports
 66 Manage
 66 Governance & Security
 1 Product Release Questions
 Community Forums
 40 Getting Started
 26 Community Member Introductions
 68 Community Announcements
 4.8K Archive