Delete Blank Rows in Table Chart with columns built with BeastModes
Hello:
This question looks like another one in this section but it is different. I have a Table chart with only the first column being a field from the card's dataset and all the other columns are BeastModes Columns that depend on the Time Period selected by the user.
I get lots of rows in this Table Chart with no info across all columns that I need to NOT SHOW and can't find how to do that. Remember all my columns except the first one are BeastModes with some sort of Aggregation dependant on the Time Period selected by the user.
Thank you in advance for any help!
Comments
-
Hi,
I think this depends on the reason why the rows are appearing empty in the first place.
Did you try filtering them out?
Can you provide some more info on your data and beast modes?
Regards,
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Thank you Ricardo for your prompt reply. I tried to filter them out, but Domo says I can't put aggregations in the filters. All my columns, except for the first one (the subject), is a BeastMode of this kind:
SUM(oneField * aSecondField) / SUM(aThirdField)
they are basically weighted averages where the user plays with the time period to get different answers. That is why I can't do it in the dataset, I have no idea of the time period beforehand.
For some time periods, some subjects will have NULL across all columns and those are the ones I would like to disappear.
Is there like a post-load card event? or something like it?
My card looks almost like these (my actual card has private data):
Time Period: Last Quarter
Person Average1(BM) Average2(BM) Average3(BM)
John 4.5 5.3 3.2
Mary (NULL) (NULL) (NULL)
Paul 2.5 6.3 4.2
(BM) = BeastMode
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive