GrantSmith Coach

Hi @Salmas Your beast mode isn't working because you're attempting to compare a single value to 4 multiple values at the same time. If Name is A it will never be B, C or D so your result will always be 'Pending' If you're doing this across your entire dataset you could do something like this to check them all individually…

Hi @ndldty You can do something like this with a case statement (assuming superb and outstanding are separate value columns): CASE WHEN `Superb` < 0.10 AND `Outstanding` < 0.10 THEN 'Below' WHEN `Superb` > 0.35 AND `Outstanding > 0.35 THEN 'Above' ELSE 'OTHER' END As for the Superb can't be more than 5% that doesn't really…

Hi @Saketh You're attempting to aggregate an aggregate which isn't possible within the beast mode and summary number. If you want the average of the percentage you'd need to pre-aggregate your data with a dataflow to then be able to take the average of the percentage.

This is the webforms connector I was referring to: https://domohelp.domo.com/hc/en-us/articles/360043436813-Webforms-Connector. Just search for WebForm in the connectors dialog box.

Hi @Kris_delosangeles That dataset ID doesn't exist in your instance so it's throwing an error. You can create a simple testing dataset using the WebForm connector and putting in some sample data if you want to test it before using real production data. You can get the new dataset ID from the URL when you're viewing the…

@Tsharma8724 - Also depending on Tableau's architecture / APIs you may be able to write a custom connector to pull data from Tableau but very likely it'll be difficult as they're competitors and don't have any incentive to allow cross product communication. Another alternative may be to write your own script using a…

You may want to think about restructuring your data and using a date dimension to calculate the current day, last year, two years ago etc for your data points. Then you can use a beast mode to pull only the offsets to you want. This will then allow you to be able to calculate the current year from a year or two years ago.…

Have you tried doing the pivot in a Magic ETL dataflow with a pivot tile?

Hi @jeff_patrick Can you see records for those NPIDs in your dataset? Did it change at all? If it's being modified by a dataflow - has that dataflow been changed?

@hqu It doesn't. It's a simplistic model. As Mark said you'd need to pull in the Domo Dimensions - Calendar Dates dataset into an ETL. It's a bit more tricky with Magic as you can't do a conditional join with between or less than / greater than. You can do this with a MySQL dataflow but it will run slower than a Magic ETL.…

Hi @hqu I've posted previously an article about adding business days to a date with a simplistic algorithm. You can read about it here: https://dojo.domo.com/discussion/52678/domo-ideas-conference-beast-modes-add-business-days#latest

How is it not working? What are you getting? What are you expecting? Domo will convert your TIMESTAMP fields when a card is displayed to whatever time zone your instance is configured to.

Hi @User2021 Instead of CST I'd recommend using the country/city name like this: CONVERT_TZ(`DateTimecolumn`, 'UTC', 'America/Chicago') You can use this in either a Beast Mode on a Card or a Formula Tile in a MagicETL 2.0 dataflow. Here's a list of timezone strings: https://timezonedb.com/time-zones

@ibtisamyyy Since you're wanting to do it by week you'll need to calculate the week number or the start of the week as a new column and then partition by that value in your Rank & Window tile so you are ranking per week. You can use a formula tile and the following formula to calculate the first day of a week:…

HI @user047019 You won't be able to do it in a beast mode but you'll need to use a Magic ETL. You can have your original input dataset and then filter through two filter tiles. One filtering where Parent_ID is not null (children) and the other where Parent_ID is null (parents). Then you can use a join based on the…

Hi @Seth you’d need to have your website handle the report selections and then dynamically change the URL of the embedded report for the last step

Alternatively you can also use a formula tile to remove the first character by using RIGHT and LENGTH RIGHT(`field`, LENGTH(`field`)-1)

REGEXP_REPLACE(`field`,'^\$(.*)$', '$1')

Hi @dylang91 You'll need to use an ETL unpivot your data such that your data is in the following format: CaseID | Date | Type 243339 | 2/10/2021 | Submission 243339 | 2/10/2021 | Approved ... Then you can use a beast mode to calculate your percentages per month: CASE WHEN COUNT(CASE WHEN `Type` = 'Submission' THEN `CaseID`…

Here's a Beast Mode that is doing what @amehdad is describing: DATEDIFF(LEAD(MIN(`Date Ordered`)) OVER (PARTITION BY `Account Number` ORDER BY `Which Order Number is this`), `Date Ordered`) This will calculate the difference between each order based on each customer.

Because of how the underlying architecture of Domo and data storage in general it's not like a Database where you can just simply run a DELETE FROM type command. What you can do is do a dataflow to input your dataset, filter out the rows you don't want and then write it out to another dataset.

Search for the Domo dimensions connector then use the calendar report https://domohelp.domo.com/hc/en-us/articles/360042931454-Domo-Dimensions-Connector

Hi @leeloo_dallas I'd recommend reading in your list of URLs as a dataset and then doing a left join from your dataset (on the URLs) you want to filter to this URL filter data and then use a filter to say where the URL is NULL . This will make it much more manageable and easier to maintain moving forward.

@Gus You need to pass your API token in under the X-DOMO-DEVELOPER-TOKEN header variable (assuming you generated it under More - Admin - Authentication - Access Token) not the Authorization header. curl -v -H X-DOMO-DEVELOPER-TOKEN:'{access-token}' "https://[INSTANCE].domo.com/api/content/v1/cards/<card_id>/export"

Ah I misunderstood the request. There is an export-data option with the CLI to export a dataset which can take a query so you could attempt to replicate the query your card is using and pass that along through the CLI but as @MarkSnodgrass mentioned you may need to watch the traffic to get the exact query it’s using

Hi @Gus Card definitions are stored in JSON format. You can utilize the Java CLI (https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool) and the backup-card command to export a card definition to a file. It also gives you the ability to backup the drillpath as well.

Hi @abarrie23 This is a limitation of Domo excel plugin. If you want to download the dataset you have to go directly to the dataset in the UI and export it from there to get the entire dataset (Excel has an internal limit of 1M rows). See https://domohelp.domo.com/hc/en-us/articles/360042926134-Exporting-DataSets…

Another alternative is to use the HOUR function on your timestamp and put it in the corresponding bucket: CASE WHEN HOUR(`Time_From_Column`) >= 7 AND HOUR(`Time_From_Column`) < 15 THEN '7 AM to 3 PM' WHEN HOUR(`Time_From_Column`) >= 15 AND HOUR(`Time_From_Column`) < 23 THEN '3 PM to 11 PM' ELSE '11 PM to 7 AM' END

Hi @rishi_patel301 Instead of using STR_TO_DATE just use your time string you're wanting to add to your current date `Time_From_Column` BETWEEN ADDTIME(CURRENT_DATE() , '00:06:66') AND ADDTIME(CURRENT_DATE(), '00:07:05')

@Ashleigh based on the resulting HTML code on the cards it doesn't appear that you can center the summary number in relation to the chart below. I'd toss an idea into the idea exchange for it.