GrantSmith Coach

Hey @MarkSnodgrass Any time I'm doing date differences I like to utilize unix_timestamp. It converts everything to an integer of the number of seconds since 1970-01-01. This makes working with the data easier. DATEDIFF is returning your difference in the whole unit you specified so you don't get the fractional aspect of…

TIMESTAMPDIFF(MINUTE, ...) calculates whole minutes that have passed between the two timestamps so it makes sense you're seeing 10 (essentially it's truncating instead of rounding) instead of 11. If you want to round to the nearest minute you can just utilize the ROUND(..., 0) function

Hi @Khan_Naziya I've found unix_timestamp function to be great in cases like this. If you convert two datetimes to unix timstamp it'll give you the number of seconds since 1970-01-01. Simple math would get you the number in unit of minutes. Here's a BeastMode function that will calculate time between timestamps in minutes…

Hi @hamza_123 You can utilize unix_timestamp function to calculate the number of seconds since 1970-01-01. With some simple math you can get the difference in seconds. (UNIX_TIMESTAMP(`EndTime`) - UNIX_TIMESTAMP(`StartTime`)) I wrote a more advanced summary of this you can read…

Hi @AttuAk What type of card are you utilizing? HTTP links are only usable within a table or HTML table card otherwise it'll treat it as filterable text. Your beast mode will also only ever take them to the same wikipedia page. You'd want to incorporate your URL dimension as part of the link. (this is assuming you're…

Hi @MLAstuto You'd need to pre-aggregate / pre-calculate your data via a data flow since you're partitioning based on the beast mode field. Because of how you're computing the grouping via the beast mode it no longer is part of the collective but that specific group. You'd essentially need to have 2 records for each. One…

@user11651 For clarificaiton, after you convert the string to a number you'll need to convert it back to a string and then use the string operations tile to do a left substring to get the 1st character. This will get you the first number to check against. There are other options utilizing a regex which are a bit more…

Hi @user11651 Regular Expressions were made for scenarios just like this one. I'd recommend you do a Google search for regular expressions to learn more about them in depth if you're not familiar with them. Another good resource is https://www.regular-expressions.info/ As for your specific case Domo does allow regular…

Hi @Whimzyy Domo is breaking out each rep because that's the column you have on your x-axis. Depending on the format of your actual data and how you want the final presentation to look like dictates which card you'd need to use and how you'd define your x and y axis values. Can you provide some scrubbed example data for…

Hi @user048672 Are you an admin or do you have the "Manage All Cards and Pages" role associated with your account? You need to have one of those in order to move pages around. If not I'd talk with your instance Admin to get your pages moved. You can reorder your own pages within a parent page but can't move it outside of…

Hi @user084060 Single Value cards don't support different font sizes. Are you able to utilize a Text Box card instead?

Hi @user096813 Does the field names that you're working with in the filter card exist in the other cards? Are you using the same dataset?

The first line is to prevent a divide by zero error.

Hi @user046467 The example I gave assumed each visit was it's own record. Since you have the number of visits for each page as a record you just need to make a minor tweak to the beast modes. You just need to swap 1 for your column containing the number of page views - `Unique Pageviews` CASE WHEN SUM(CASE WHEN `page` LIKE…

Hi @JonavilCello , I'd highly recommend looking into the Command Line Interface (CLI - see https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool) tool. It interacts with the API for you and you don't have to write a custom app to do it. There's even a specific command to do…

Hi @user02674 Domo doesn't handle the average of date objects with a simple AVG function. You'll need to convert it to a unix timestamp (number of seconds since 1-1-1970), grab the average and then convert it back. DATE(FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(`start_date`)))) This is assuming your data is recording a record for…

Hi @user038587 The easier option is to take that excel file upload it to Domo and utilize a dataflow with a join to filter on those values. One caveat to this though is that it will remove the other values and you won't be able to filter on those values any more in your card. There isn't a way to filter on a giant list via…

Hi @user046467 Try this: CASE WHEN SUM(CASE WHEN `page` LIKE '%/page1/%' THEN 1 ELSE 0 END) = 0 THEN 0 ELSE SUM(CASE WHEN `page` LIKE '%/page2/%' THEN 1 ELSE 0 END) / SUM(CASE WHEN `page` LIKE '%/page1/%' THEN 1 ELSE 0 END)END

Hi @user014481 Preview won't display all of the records because it's just that, a preview. If you're wanting to see data from each step you can filter the data you want and then output it to different dataset(s) along the ETL path.

Hi @AvinashK Right now now, there isn't a way to determine if a card has a drill path or not. Domo hasn't made that data visible with the DomoStats or DataGovernance datasets. You can post the idea to add this to the datasets on the Idea Exchange.

You can try something like: DATE_FORMAT(DATE_SUB(DATE_ADD(`Submit Date`, 27), DAYOFWEEK(`Submit Date`)-1), ,'%m/%d/%Y') Alternatively you could just do a new beast mode for the addition DATE_ADD(`Submit Date`, 27) and graph by week allowing Domo to display the date (You may need to change the company settings on how weeks…

@Simon_King It's a behavior of the ETL process. It requires tiles to have the unique names. Even though the names are different it's still treating it as the same dataset. The name of the tile changes but the underlying data set stays the same. Refer…

Hi @Whimzyy Do you have some example data showing what you want the final output to look like? Right now your beast mode is attempting to pass 3 parameters into the date_format function which takes 2 (the date and format string). It's not clear what your expected output is based on your current beast mode.

Hi @user32470 You're getting bluish text because you have a hyperlink tag (<a href...) surrounding your text causing it to default to blue. Try taking out the <a> tags. Are you wanting the background to be red or the text to be red? Typically I've done the following to make the text red: CONCAT('<div><span style="color:…

Hi @AnkeshJain If you hover over the warning icon is there any warning message displayed?

Hi @tstimple , This is because you can't use a beast mode as a summary number unless you're using aggregate functions (SUM, COUNT etc) I'm not certain exactly what you're trying to show as a summary number but if you're looking for the total across all your rows you could do: SUM(`calendar_duration`/3600)

Hi @user32470 For your custom sort for the day parts - is your beast mode actually returning different numerical values or are they all the same?

Hi @Shumilex Have you tried changing your input range to be 0-9 instead of 0-1? You may be attempting to graph values greater than 1 in your chart and it's complaining about it.

Hi @user053351 You'll want to report this bug to Domo support for them to take a look at.

Hi @MartinB You're correct in that it's not possible with the Pareto plot. Because you want it to be dynamic and ETL likely isn't going to work for you and you'd need to do it on the card itself. You might be able to do something similar with a Line + Bar chart and calculate the Pareto value via a Beast Mode for the line…