Best Of
Re: How to Calculate Averages Across Two Different Columns
You may be running into issues because of aggregation within a case statement. You can also try the formula below to bypass the case statement.
avg(AVG(ifnull(`Chat Duration`,`Call Duration`)) FIXED (BY ifnull(`Chat ID`,`Call ID`)))
Re: Customize email address in DataSet via Email Connector
We need this to be more user friendly.
Svilen
Re: Customize email address in DataSet via Email Connector
This idea is fantastic!
Over the past two months, I've configured more than 10 email connectors. While there are rules for file names or email subjects where possible, applying them to every connector is challenging due to business specifics. Unfortunately, this increases the risk of errors, especially when dealing with a long list of emails. My experience, even during testing, has shown that a simple copy/paste mistake can result in sending data to the wrong email or, in the worst-case scenario, loading data into the wrong dataset.
The proposal for user-friendly names is excellent, it would significantly reduce the chances of such mistakes. Domo, I'm thrilled about the idea of adding this feature. It wouldn't just decrease the chance of errors but also greatly enhance the process for all users, making it smoother and more efficient.
Nade
Re: Calculate Number of Employees Over Time (using employee hire & termination dates)
I mocked up an example in the Domo Community instance using the Domo Dimension calendar dataset and the DomoStats People dataset as my "employee" table. The ETL looks like this.
The formula for the filter to actives tile is this:
dt >= DateHired AND dt <= IFNULL(DateTerminated,CURRENT_DATE())
Re: Line Chart- Missing Values Show Gap Instead of 0; Bonus: how to deal with many lines
There is a free calendar dataset available for download in the Domo Dimensions connector, you can search for it in the Domo appstore. It will allow you to create 0 values for days, weeks, months, quarters, or years so that when you plot the line chart there will be 0 values to show on the card. The steps are:
1. Create a new ETL with your data and the calendar data as inputs
2. Aggregate your data and left join it to the calendar on Date = termination date
3. Use a formula tile to populate a 0 for any dates with a null value.
Another option is to just use an excel file or Domo webform to create 0 values for where you are missing data and then append it to your dataset.
Re: Dataset Tabs appear to be hidden for some datasets
I went ahead and submitted a support ticket, I will reply here once I get an answer. Thank you for the help @jessdoe
Jmoreno