Best Of
Re: how to show a duplicate in a table graph
https://domohelp.domo.com/hc/en-us/articles/360056318074-Domo-Governance-Datasets-Connector is the KB article about it. It should be just the Domo Governance Connector. It was called the Domo Governance Thirdy Party Connector at one point.
https://[INSTANCE].domo.com/appstore/connectors/com.thirdparty.connector.d14c2fef-49a8-4898-8ddd-f64998005600 should take you to it. just replace [INSTANCE] with your instance name in the URL.
Re: Dataset upload by sending email attached excel file
Hi @eriena, have a look through this article [https://domohelp.domo.com/hc/en-us/articles/360042931954-DataSet-via-Email-Connector] before setting up and you should be good.
amehdad
Re: Dataset upload by sending email attached excel file
Hi @eriena
You can use the DataSet via Email Connector (KB Article: https://domohelp.domo.com/hc/en-us/articles/360042931954-DataSet-via-Email-Connector).
You can either search for DataSet via Email in the connector search or you can go to:
https://[INSTANCE].domo.com/appstore/connectors/com.domo.connector.emailer
Replace [INSTANCE] with the name of your instance.
It'll setup a unique email address you can email to. You can configure the subject, body, from email address etc to make sure someone else can't accidentally email in a dataset you're not expecting.
Re: How to SUM working days correctly?
Thank you everyone! I went with @MarkSnodgrass solution and it seemed to work great. Thank you!
pstrand2
Formatting Numeric Values within CONCAT functions to Currency
Hi there!
In one of my graphs, I have created a few beast modes involving nested CONCAT functions so I can capture many fields in a hover text. Some of the fields in the CONCAT are numeric but I would like them displayed as currency. After running the beast modes, the numbers are displayed as a long integer with no thousand separator etc. I understand that using my quantitative fields in this way means that I cannot use the 'Display as' format option in the Analyzer. I was wondering if there is something I can do prior to the Beast Mode CONCAT, such as an ETL node or mySQL code?
Cheers
amehdad
Re: Formatting Numeric Values within CONCAT functions to Currency
Excellent! Thank you for sharing @MarkSnodgrass and thank you for writing up the exchange articles @GrantSmith. Have a great rest of the day y'all
amehdad
Re: Dojo Contest is LIVE!
Dojo is a great forum to find inspiration for a new card, dashboard, beast mode or ETL setup or search for answers to annoying questions during one's build. I love using Domo, and I appreciate this space to collaborate and learn off one another.
amehdad
Re: I need to calculate cumulative backlog in card for the data filtered by various categories and date
Hi @mahee84, in order to get that graph view, follow these steps:
- Select 'Line + grouped bar' in Chart Types
- Drag in your 'Cumulative Backlog' field in the X axis and then either Daily date fields in 1st Series spot and then the other Daily date field in 2nd Series column
- At the moment, it'll show as one bar and one graph so then you'll go into Chart Properties -> General -> Series on Left Scale and type in '2'
- Once applied, it'll show as 2 lines which then means you should add in your 'Ticket No' field to the 3rd Series column, resulting in a bar with two lines
- Afterwards, it's tidying up the y-axes in Chart Properties -> Value Scale, and other elements to match your Excel report.
amehdad
Re: How to build card for DOMO?
@bhakti, hope you've had a chance to look through the introduction videos and attempted to build some card. If you have any specific cards you are looking to create and you are unsure, make a new post as the Dojo is always happy to help.
amehdad
Re: Beast mode calculation for aggregating data
Hi @Lashes, could you please share your code and the full error message?
Here's a start:
SUM(CASE WHEN 'days until due' >= -9 AND 'days until due' <= -1 THEN '1-9 days'
...
END)
amehdad