GrantSmith Coach

Hi @user077529 How is your raw data formatted? Do you have a single column for the service type and multiple records for each order or are the different services separate column values and you have one row for each order?

Hi @micheleb You'll need to put everything in the same format and then convert it to a date. You can convert the date strings using a REGEX_REPLACE function in a formula tile: REGEXP_REPLACE(`Date`, '^(\d{2})\/(\d{2})\/(\d{2})$', '$1/$2/20$3') This will check for a 2 digits / 2 digits / 2 digits format and then put a 20 in…

Hi @User2021 There's nothing you can do as the card will interpret the beast mode but the export doesn't. I had posted an idea specifically for hyperlinks in the past but it was closed so I logged a new idea for it (https://dojo.domo.com/discussion/53947/format-as-hyperlink/p1?new=1). Typically what I would do is have a…

Hi @lvtrujillot Currently this isn't something you can change. I'd recommend logging an idea in the idea exchange as a potential enhancement.

Hi @JoeR_PSIT You can use the LENGTH function to get the number of characters in a string CASE WHEN `Serial Number` IS NULL OR LENGTH(`Serial Number`) > 7 THEN 'Error' ELSE 'OK' END

You could utilize a custom date dimension with offsets to calculate the current date's count and also the count for the same day in the prior month, then you could utilize some window functions to calculate a running total for the current month and compare it to the same time as last month or alternatively just calculate…

Hi @user031170 There's a 25k row limit on most card types except for Histograms and Box Plots (100k limit). See https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs Have you tried using a Sumo Table to do your pivot? Those have a higher row limitation and may allow you to chart your data properly.

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.