Best Of
Re: Google Analytics Append / Replace
Sounds like a bug. I'd open a ticket with Domo Support if it's doing an Append even though it's set to Replace.
Re: Date_Format Fiscal week number and Year
Try this in a beast mode
DATE_FORMAT(`yourdatefield`,'Week-%U %X')
Re: Domo Role "Admin" Can't see dashboards by default - why?
This is currently how Domo functions. You'd need to share all the pages with the admins (or dynamic group of admins) so they have access to all of the pages.
Re: Help with Beast mode to calculate time in tier
Ahh... It was hard to tell from the screenshot if you need to access info from two different rows. In this case, You can still use the TIMEDIFF function, but you are going to need to do some work in Magic ETL first. You would need to utilize the rank and window tile and then use the Lag or Lead function so that you can add the data from a different row as an additional column. After you have that added, you can then use the timediff function. This KB article breaks down the Rank & window tile nicely if you haven't used it before. https://domohelp.domo.com/hc/en-us/articles/360044876094-New-Magic-ETL-Tiles-Aggregate#3.
Re: Dashboard embed codes and the API
Re: Dynamic series line bar
@Godiepi ok thank you for confirming - using multiple beastmodes is sadly what I was hoping to avoid!
LCash
Re: COUNT(DISTINCT CASE WHEN THEN)
You are missing an END statement for your CASE statement
COUNT(DISTINCT CASE WHEN `Account.Status__c` LIKE 'Cancel%' THEN 'Canceled' END)
Re: Adding a cumulative total line in a multi line chart in Domo
You can use a beast mode to add all three values together and plot that as your fourth value
Re: What is the best practice to show my dashboards on DOMO?
Hi @Ulzii, there's currently no Domo public profiles set-up for people to upload their work for show. Depending on the purpose of wanting to share your work with others, you can:
- Send cards/dashboards as an email [https://domohelp.domo.com/hc/en-us/articles/360043437873-Emailing-a-Visualization-Card]: highlighting the numbers and features while retaining the layout but not having any interactions)
- Use Public embed [https://domohelp.domo.com/hc/en-us/articles/360043437993-Sharing-Cards-and-Dashboards-Outside-of-Domo-Using-Domo-Embed#h_01ESKWJ8QEVSRKQBQVQA9P65QP]: You can showcase your dashboards/cards for others to view if you have any other public page, for example a website, that allows embedding links.
amehdad
Re: Empty plug in top left
You can look at these articles [https://domohelp.domo.com/hc/en-us/sections/360007296314-Business-in-a-Box] to get a better understanding and also how to enable them in your instance.
amehdad