ggenovese Contributor

In Magic ETL you can write a REGEX expression to strip out everything that's not a number or number-related, REGEXP_REPLACE(your value,'[^0-9,.]','') however an additional problem is that 5.76% would get turned into 5.76 which is a totally different number. So I think your idea to turn bad data to nulls is safer. You can…

If you add a RANK() beast mode then you can filter your card on RANK < = 7 RANK() OVER (PARTITION BY `date` ORDER BY `pie value` DESC)

If I am understanding correctly, you should be able to do the following steps using Magic ETL: add a filter for Types IN ('Survey', 'Cutover and Test', 'EPIK','Greenix' ) add a Group By and group by Site and count distinct types add a filter and filter on count = 3 join that back to the main dataset on site

The most simple method of achieving this would be to self join your list of conference attendees to itself, joining on person id. This will create a lot of rows, but I've found that Domo can handle it. If you want to figure out how many rows it will create in advance you can group by person and count the number of…

In your configuration there is an "Allow Leading Digit in Column Name" option, if it's not checked then every column name that starts with a digit will be prefixed with the letter "C"

Hello - If you want to take an entire row from one dataset and add it to another then you need to Append rather than Join. If you're concerned about alterations to the existing ETL I would recommend making a copy of the ETL to test the logic and then incorporating your changes into the original ETL when you're satisfied…

FYI - FROM_BASE64() and TO_BASE64() are MySQL functions that will not validate in the Beast Mode editor BUT if you save them they still work even with the error. It would be nice if these functions would pass the validation though!

I think this is a factor of whether the timestamps provided by the Five9 connector are in UTC and also what your company time zone is set to. If the time stamps are in local time and Domo is assuming they are in UTC then Domo will try to convert the time stamps to your local time defined in the company settings. Take a…

I'm having a little trouble following the logic, it might be helpful if you shared your excel formula. Is the case statement you shared supposed to produce the New Fee A value, and you'll have another for New Fee B? Also, should this part of the expression: (Charge(Proceeds A/(Proceeds A+Proceeds B))+Proceeds A) be changed…

Having an export button would be great, until then as a workaround you can select all the tiles in your Magic ETL and then click "copy to clipboard" this will give you the json of your ETL that you can paste into a file for version control purposes

You can do this with period over period charts without the need for a specialized beast mode

@Arthi Annadi - I'm not sure if any table cards provide hover text out of the box. You may want to look into DDX Bricks, or search the app store for custom pivot table apps. Another option would be to pivot your data in an ETL so that you can use an HTML Card instead of a pivot table but this has limitations as well. In…

Glad that worked for you! Pivot Tables do not provide a method for adding hover text so I think color coding using color rules may be your best option

The values section is meant for aggregation, because it is possible that when your Rows and Columns intersect that there may be more than one value present. When you place your text field in the values section you're only provided with Count as the method of aggregation, however, if you create a beast mode with the value…

One option is to select the options you want to be the default, and then save it as the default filter view for all users on the page

A couple things to note from the knowledgebase article on drill paths that may be root cause of the issue: Calculations you create using Beast Mode are inherited when you drill from one view to another using the same DataSet. However, calculations are not inherited when you drill to a different DataSet. You cannot create…

Anything you create manually will not interact with the Date Range filter, keep that in mind because it could cause issues. It might be helpful to uncheck "Allow Global Date" filtering on your cards. If you go this route, I would recommend creating a variable and then have a beast mode that uses the variable and then place…

There's a LAST_DAY() Function that gives the last day of the month for a given date: LAST_DAY(STR_TO_DATE(CONCAT(`Year`,`Month`),'%Y%m'))

It looks like your Month Number is "0" and that's what's causing the issue. Do you see any records in your data that might have a Month Number = 0?

You may want to look into Flex Tables as an option, but usually what I end up doing in these situations is use an HTML Table so that I can customize the Arrows, Colors, Rules, etc. Below is just a basic example, but you can see how the beast mode can get very complex with even simple examples: /* Growth Indicator */…

You could try to bring in your data with the eMoney API using a JSON No Code connector https://developer.emoneyadvisor.com/

You can use this formula and filter for 'INCLUDE' — First Saturday of the Month for the Last Six Months CASE WHEN DAY(`dt`) = DAY(DATE(DATE_FORMAT(`dt`,'%Y-%m-01'))+7-WEEKDAY(DATE(DATE_FORMAT(`dt`,'%Y-%m-01')))) AND `dt` >= DATE_SUB(CURRENT_DATE(), INTERVAL 6 Month) AND `dt` <= CURRENT_DATE() THEN 'INCLUDE' ELSE 'EXCLUDE'…

Another option might be to create a beast mode to rank each traveler and then use subtotals to collapse the rows for the travelers whose rank is greater than 25. Assuming you have a field named `Traveler` and a field named `Spend`, first create a beast mode called `Top 25 Ranking` — Rank Each Traveler up to 25 and then…

No problem! The REPLACE() function would work inside of either a Magic ETL or in a Beast Mode inside of a card. The function will strip out the pipes "|" and replace with SPACE and strip out the periods "." and not replace those with anything. If you want to go the ETL route you'd use an Add Formula tile, name it the same…

If you just remove the pipe symbols then you'd end up with a mix of "Company A", "CompanyA","Company B", "CompanyB" etc. so you'd need to replace pipe with a space. But if you replace the periods with a space then you'll have trailing whitespace. So I'd suggest you have two nested REPLACE() functions so that you can handle…

I don't think that it's possible, however a work-around might be to place your translated value column in the tool-tips so that when one hovers over the bar they can see the value in their home language.

If you make Following = 0 then you will get a running sum, it will sum all the preceding records in the partition and none of the following records. If what you were wanting was no frame at all, so the total for each partition placed on each row in the partition, then I find it's best to use a group by and join the sum…

Yes this is also really annoying for JSON connectors, so many options to reconfigure when all you should have to do is change an endpoint!

Hi @Arthi Annadi - You can view the impact of the policy, the knowledge base article I shared demonstrates that. Also, as an Admin, you can also view the impact of the policy by clicking the badge looking icon at the top of your dashboard and select the policy to preview. One note however, is that this functionality…

I reviewed the knowledgebase article and it looks as if you've set up everything correctly, have these datasets ran successfully since the update method was set to append? That's the only thing I can think of that might cause this. KB article I'm referring to:…