Best Of
Re: Can the Bar Total Label be the Total % of the bar instead of the integer?
You need to write a BeastMode for your Y-axis to format it all as percentages. It will probably be something like:
sum(Aloc..)/Sum(SUM(Aloc..) FIXED())
Re: Add time zone option to inbuilt date/time functions
You can achieve this via Beast Mode. So, they probably won't spend time adding it.
CONVERT_TZ(NOW(), 'UTC', 'America/New_York')
brycec
Re: Within an App, can I filter only one card & have it not affect (filter) the other cards in the app
You can choose to have a filter card only affect certain cards (or one card) just like you can on a regular dashboard.
As for filters, they work the same as a regular dashboard. Users can customize and save a view for just themselves.
brycec
Re: Conditional Gateway Tile
https://community-forums.domo.com/main/discussion/55570/is-there-a-reliable-way-to-make-magic-etl-intentionally-fail
Re: Account Sharing for DataSet Copy Account not working
I was able to share just fine. Can you open up the network console and see if there is a specific error code being returned from the API response? Right click, then click Inspect at the bottom of that context menu, then click Network at the top of that new window. Click the circle with a line through it on the top left to clear the network console. Then, try to share the account again. Find the request, it'll be close to the bottom and be a PUT request to https://<instance>.domo.com/api/data/v2/accounts/share/<account_id>. Click the Preview tab at the top of the right-side panel. Then, expand any objects you see there and see if you can find an error message.
brycec
Re: History Keyboard Shortcuts for Undo and Redo
i definitely do this by default in any software i use, despite if i should know better - this would be a great feature for Magic ETL
Re: Duplicate Sticky Notes
big agree, this would be huge - especially as we're deciding on "conventions" to somewhat standardize the information kept there as a team
Re: Challenges using API Trigger - Payload - Append To Dataset
No - just do Custom and type in comment.
And your value is correct, except you don't need to encapsulate everything in quotes. Also, use the "Insert Variable" instead of typing them out yourself that way. I wish we could shortcode them like that, but we can't right now. Use "Insert Variable" to plug it in.
Re: App Studio text box - hyperlinks limitations
I agree it would be great if we could utilize mailto: links consistently throughout the platform. This allows for standard business process actions like submitting service tickets, sending inquiries to groups, etc.
While there is a workaround by using a beast mode in a table card, it isn't as seamless as the built-in linking options available throughout the platform.
Re: Trying to get different values into the pivot table
You may want to try this update, if it doesn't work it might be helpful to share a screenshot of your pivot table so that we can see how it's configured:
CASE
WHEN MOS_Year = 2023 AND Metric = 'Member Month' THEN SUM(MM)
WHEN MOS_Year = 2023 AND Metric = 'MLR' THEN SUM(COST_MLR) / SUM(REV_MLR)
WHEN MOS_Year = 2023 AND Metric = 'Shared Savings Dollars' THEN SUM(PAID)
WHEN Metric NOT IN ('MLR', 'Shared Savings Dollars') THEN SUM(PAID)/ SUM(MM)
END
