Best Of
Cutting the Strings in updated MagicETL?
I don't seem to be able to cut the strings between tiles in MagicETL anymore. Anyone else seeing this?
Update: I closed and re-opened the ETL and was able to cut strings again.
Re: Extract data from Image or PDFs using Domo AI
Yeah, we could process and parse images from S3, SFTP, etc…
We've also got some new stuff getting announced tomorrow that will be an unlock here…
Re: Area Chart 2025-2028
You need to reshape your data so the years are in a column. That would be easy in a MagicETL:
Re: Bar Chart 2025-2028
With the 4 columns you describe (Product, 2025, …, 2028), I don't think there's a way to get the bar chart you described without reshaping your data first. The only card I can think of that would analyze your data as is would be the pivot table:
If you're willing to do a quick MagicETL to unpivot your data to a long format, then it's very easy to get what you described:
Re: Pagination issue with JSON No Code Connector (API PennyLane)
Hello ggenovese,
This method worked very well, thank you for your help!
Makam
Re: Hello from a new Domosapien in Melbourne, Australia
Hi Brian, great to have you in the community!
Re: row count at each step
@WHM It looks like that's a bug. An engineer on my team has coded a fix for it and it will be rolled out within the next week. Thanks for spotting that for us!
Re: Enable Conditional Coloring in Charts Based on Another Column or Beast Mode
Yes, this is a frequent question in the forum, and multiple ideas have been posted about it. Pasting a few of those for additional visibility.
https://community-forums.domo.com/main/discussion/66625/column-level-color-rules-based-on-multiple-statements?utm_source=community-search&utm_medium=organic-search&utm_term=color+rules
Hello from a new Domosapien in Melbourne, Australia
I’m excited to join the APAC team as a Solution Consultant based in Melbourne, Australia! As a proud new Domosapien, I bring over 20 years of experience in AI, Data, and Analytics, working on the vendor side to help customers turn data into actionable insights.
Looking forward to connecting—please feel free to reach out and say hello!
Re: Can I sum 2columns one being Aggregation SUM and other (No Aggregation) fixed number?
Since you have mixed types of aggregation, I think instead of putting the SUM on the drop-down of the Total beastmode, where it affects the entire BeastMode, I would write it into the BeastMode itself:
SUM(
Online Fee +
(amFee-`Platinum amFee`)+
…
Royalty Inside Charge) +
AVG( `Ticketing Royalties Expense 1 `)
The thing is that your Ticketing Royalties Expense 1 BeastMode assigns a value of $-2,294.62 to every row of your data where the Organizer is HubMusicFactory and the Performer is The Offspring. So every row where that is true gets added to your total. Averaging it across the group acts as simplifying it into a single value.
One note of caution is that your current set-up won't work if you have multiple nmPerformers in your data. You either need to insure a single performer is filtered or include the performer as a column in your table.