Data on multiple lines
My data is showing on multiple lines even though the parameters are the same. For example, as shown below the area (Boca Del Ray) and the discipline (COTA) are the same, but it's showing separate lines with different data for the measures. I want each area and discipline to show only once. This happens throughout the full data set. Is there a way to ensure it's combined in one row?
Best Answers
-
By trailing white space I mean something like this.
"BOCA DEL RAY" vs "BOCA DEL RAY "
In any case though, it looks like the reason is that your beast mode is calculating a percentage, but you're not aggregating that percentage. See how you have 2 different values for BOCA DEL RAY
You'll need to either wrap your beast mode in a AVG/MIN/MAX function, or you should be able to select that by setting the Aggregation context from the column pill
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**1 -
Got it - thank you!
0
Answers
-
Are you absolutely certain those 2 rows are the same? I’ve had this happen before where 1 had a trailing white space.
Also, not sure what the logic is for your Open Capacity beast mode, but make sure it is aggregating.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0 -
What do you mean by a trailing white space?
Open capacity is a calculated field: ((
Visits Agreed Upon
-Billable activities
)/Visits Agreed Upon
).Essentially it's taking the columns "contracted" minus billable activities over contracted.
0 -
By trailing white space I mean something like this.
"BOCA DEL RAY" vs "BOCA DEL RAY "
In any case though, it looks like the reason is that your beast mode is calculating a percentage, but you're not aggregating that percentage. See how you have 2 different values for BOCA DEL RAY
You'll need to either wrap your beast mode in a AVG/MIN/MAX function, or you should be able to select that by setting the Aggregation context from the column pill
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**1 -
Got it - thank you!
0 -
I think david's point about the beast mode lacking aggregation is the issue. It should probably look like this:
sum(
Visits Agreed Upon
-Billable activities
)/sum(Visits Agreed Upon)
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive