Best Of
Re: Line chart to show the values as % of the column total
Should the Plan be the series instead?
Re: Table of contents on dashboards
ok great, thanks for sharing.
I kind of was expecting that answer and will try to convince the business that that's the way to build their dashboards.. :)
Stefano
Re: My beast mode is not calculating correctly
Your numerator appears to be totaling the billable orders by country. Over the total of attempted transactions and voucher transactions by country. The use of "FIXED" seems redundant. What happens if you simply to something like SUM(BILLABLE_ORDERS)/SUM(ATTEMPTED_TXNS + VOUCHER_TXNS)?
Re: My beast mode is not calculating correctly
Any reason why you're using FIXED (add field) ? If you would explain what you're trying to calculate in words that could help but if the idea is to do the total of the Billable Orders divided the total sum of Attempted__txns plus Voucher_txns and calculating this at whatever level your card is displaying using just:
SUM(`BILLABLE_ORDERS`)/SUM(COALESCE(`ATTEMPTED_TXNS`,0)+COALSECE(`VOUCHER_TXNS`,0))
In most cases, you will use FIXED when you want the calculation to be performed at a different level than the one used for the card (like you want to show global average next to the value for each country). Coalesce is just being added to ensure it either of the two values is null that we use 0 instead.
Re: Data Labels should default as the Field Name
@KenzieBrown @JaneMoore @KCSpencer
If you like this idea please upvote and like the suggestion
DOMO_Dan
Re: 🎊 Congratulations to our New Community Coach DataMaven!
Thanks @GrantStowell! I've been working more directly with Domo and with top contributors here, but I miss that direct connection in the community forum. I have also learned and seen evidence that under Ben's leadership, Product is looking at the ideas a lot more, so I will have to get my lists documented here!
Re: Is there any way to hide cards on a scheduled report?
No, the closest thing to that would be to apply a filter to the scheduled report that makes the cards blank. You'd still see card titles though. You could also make a duplicate of the dashboard and remove those cards from it.
Re: Tracking Cards with Errors
The card errors happen when the card is rendered but not recorded. The closest you can get is having the status at a specific time and then look through those cards specifically. There isn't a real-time option to see which cards are actively broken.
Re: Is there a way for a DDX brick to go outside of its frame?
Due to how DDX bricks are designed and iframes work in general this isn't possible. <iframe> is another separate browser window. It's just a means of 'seeing' inside that web document through your parent document. It's different than a normal in which you can extend elements outside of its margins.
Also, it is considered a security vulnerability for other sites to be able to place content outside their given space.