ckatzman Contributor

Here's a link to an older thread on this topic. https://dojo.domo.com/t5/Card-Building/Stacked-Bar-Chart-Sorting-Incorrectly/m-p/12433#U12433

I presume a - f are individual field values? I presume you've created a distinct Beast Mode for Series 3 to sum all of the a - f values? Are you creating a distinct beast mode calcs for your Series 1 & 2 results, or doing that as a CASE since the results a - c and d - f are mutually exclusive? Then in SORTING, are you…

That's an interesting idea, Aaron! Saying it back to make sure I understood your methodology. Please correct me if I misspeak here... Workbench job with a dummy dataset, leveraging the workbench scheduler to only run once/month. Then attach that dummy dataset in some innocuous way to the primary dataset within a workflow,…

@DaniBoy, is there a dojo protocol for being able to reach out for help from someone at DOMO when the Dojo has been unable (either no one has seen the question, or no one knows the answer) to provide a solution? Is that just a matter of redirecting the inquiry to DomoSupport, and if so, is there a way (an @name) to be able…

Try this... https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Conditional-formatting-of-Columns-in-a-table-view-card/m-p/12495#M881

Thanks, @AS. I think I had actually found it, as it was already checked when I went to take a look. But the real mystery may be why it's NOT rotating the labels. It would seem to me that an overlap problem does exist. I could solve it by shortening the displayed timeline or rolling up to quarters instead of months, but…

@klicks, be sure to understand the difference between Move/Copy, and Duplicate. Move/Copy allows you to either pick up and re-locate a card, or to spawn linked-copies to other locations. Change it one place, it changes all the linked copies. Duplicate will create a clone of the original card, but it is self-contained. Good…

@DaniBoy, it's already there... https://dojo.domo.com/t5/Ideas-Exchange/Control-which-columns-show-up-in-list-for-filtering/idi-p/1490 and https://dojo.domo.com/t5/Ideas-Exchange/Allow-Card-Builders-to-hide-fields-in-Analyzer/idi-p/13478

@product_John, any insight you or one of the PMs can share? 

Good deal.

Combining a conditional test, and an aggregation, could be a simple matter of wrapping a CASE statement in the appropriate aggregation function. Ex: SUM(CASE WHEN `TEST` = 'TRUE' THEN 1 ELSE 0 END) That case could be much more involved with multiple tests, or even nest a CASE within a CASE if you have a two-layer (or more)…

I am not familiar with HTML myself, but there are numerous examples of HTML related inquiries and responses within the Dojo, which can be located by searching "html formatting". In addition to the one previously provided, here is another that appears to provides some examples of code and results images.…

@crocija, there was a previous post in the Dojo that showed an example similar to what you are trying to do. Take a look at the post at this link and see if this helps you in the right direction. https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Number-formatting-when-using-HTML-conditional-colors/m-p/14272#M1083

If you submit it, I'll vote for it. I've had the same thought about just letting a table card roll to multiple pages if necessary due to length. May just be card builder responsibility to make sure the columns fit, but the rows should just flow to extra pages if needed. Good luck!

Got it. What kind of conditional formatting are you applying? Still thinking in terms of an Excel output, and while not as aesthetically pleasing, perhaps you can accomplish the same net effect by creating some sort of flagged values in a Beast Mode column to draw attention (as opposed to color highlights, or something…

@theCliffs, how are you "publishing" your table card? If you are exporting an extensive table card in a PowerPoint format, then I have experienced the same issue, and opted to switch to a different medium, Excel being the obvious choice. If you are using "Publications" and a link for the users to access, then that may be…