Best Of
Re: Can DDX Bricks apps bring up blank outlook email?
Due to security concerns, Domo only allows the HTTP, HTTPS, and MAILTO protocols. As @ColemenWilson mentioned you can use the mailto and pass in different parameters for the different email parts.
Re: How to bring certain data from one Table to another Table
@Ankur You will want to do a left join in MagicETL with Employee Headcount as your left table so that you keep all employee headcount rows but not all country mapping rows. If your output still returns more rows than what exist in the Employee headcount, then there are likely duplicates in your country mapping table. You can resolve this by using a Remove duplicates tile on the country mapping before joining.
Here is an article that talks about the difference between the different types of joins and appending:
How can I access Views using Google Big Query Service Account connector?
I have an gbq service account connector in my domo instance to access tables of a gbq dataset. however, i cannot access the views.
Re: Bar chart years not in sequence
@Gunjan after you apply what Cole recommended, you could also plug your series/category field into the sorting as well. This will have all your categories in the same rank in each year.
Re: Unsync Scale for One Series in a Multi-Line Chart
@nmizzell You can enable a secondary y-axis for the cart under Value Scale (Right) > Show Right Scale. Then you can use the Lines on Left Scale to specify which series will appear on which scale
Re: How can I remove line breaks from a string column in an ETL?
You can use a formula tile and the regexp_replace function:
REGEXP_REPLACE(`field`, '[\n\r]', '')
[\n\r] - This is a selection of either types of newline characters (\n for mac/unix and \r\n for windows)
Re: Need help with Beast Mode for specific time period
@kodonnellLT If you want to create calculations for the first 6 months an last 6 months of the year, you will only need to compare whether the month number is greater or less than 6 like below.
Jan-Jun
SUM(CASE WHEN MONTH(`Period`) <= 6 then `a_amount` else 0 end)
July-Dec
SUM(CASE WHEN MONTH(`Period`) >= 7 then `a_amount` else 0 end)
Or if you need to calculate the totals for a rolling date compared to today, then you will need to use the DATE_SUB function.
SUM(CASE WHEN LAST_DAY(`Period`) >= DATE_SUB(LAST_DAY(CURRENT_DATE()),interval 6 month) then `a_amount` else 0 end)



