GrantSmith Coach

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…

Hi @MartinB Not currently. If you want to reorder the Total row you'd need to manually create your own version of a pivot table and then order the columns how you want to (it's not a very clean or ideal solution). This is likely a good idea for the Idea Exchange.

Hi @user053351 Have you looked into the Data > Cloud App > Google Sheets connector? Once you create the connection account and get authenticated you can use the Discovery type file selection and select it from the list that it populates. That's the easiest option to pulling Google Sheet data into Domo.

Hi @Whimzyy Try this: CONCAT(MONTHNAME(DATE_ADD(`Submit Date`,21 day)),(CASE WHEN DAY(DATE_ADD(`Submit Date`,21 day)) <= 15THEN ' 1st - 15th'ELSE ' 16th - EOM'END)) It's also helpful next time if you post your current beast mode you're having issues with to help get a better idea of what you're attempting to do and the…

Hi @user023295 , Another option is to structure your data a little bit differently to give you more flexibility over the differences / comparison periods. There's an outline previously done here: https://dojo.domo.com/t5/Card-Building/Current-Year-Prior-Year-and-Budget-on-Same-Card/m-p/49142 Once you get it configured and…

Hi @user084060 You could use a beast mode to create a new column to filter on using a CASE statement. CASE WHEN `signup_date` >= CURRENT_DATE - INTERVAL '100' DAY AND `signup_date` < CURRENT_DATE - INTERVAL '28' DAY THEN 'Yes' ELSE 'No' END Then just filter for 'Yes' and it should only show you your related rows.