-
Re: Error joining data. The left input cannot include over 10,000 duplicates.
Hello All, I wanted to provide a little insight into why Domo will give you an error when your Left table contains many duplicates. ETL is a very easy-to-use tool and makes doing joins very simple. W…3 -
Re: Average if channel type statement beast mode
Hello @KVincent, You should be able to add this calculation into your previous beastmode. If you just replace the word "newcalc." with your new calculation it should show in your summary nu…1 -
Re: Date Calcs in Magic ETL
Hi! In the past, I have used the "replace" tile to strip out only the time of a data/time column. I have then converted the time to milliseconds, performed time difference calculations then…1 -
Re: Is there a way to discount French Guiana from France on World Map?
Hello @user18610 , The best way to do this would be to create a custom chart and define your own regions. Here is a link to the knowledge base that will walk you through how to create this. https://k…1 -
Re: Is there a way to show % change between periods?
Hello @MattGo, We can utilize beastmodes to find this. To find the current quarter we would use the following formula: SUM(CASE WHEN QUARTER(`Date` ) = QUARTER(curdate()) AND YEAR(`Date`) = YEAR(curd…2
