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
 10.5K All Categories
 5 Connect
 915 Connectors
 250 Workbench
 459 Transform
 1.7K Magic ETL
 69 SQL DataFlows
 476 Datasets
 186 Visualize
 250 Beast Mode
 2.1K Charting
 11 Variables
 16 Automate
 354 APIs & Domo Developer
 88 Apps
 3 Workflows
 20 Predict
 5 Jupyter Workspaces
 15 R & Python Tiles
 245 Distribute
 62 Domo Everywhere
 242 Scheduled Reports
 20 Manage
 41 Governance & Security
 170 Product Ideas
 1.2K Ideas Exchange
 10 Community Forums
 27 Getting Started
 14 Community Member Introductions
 55 Community News
 4.5K Archive