GrantSmith Coach

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.

Hi @Khan_Naziya , There's been several posts like this in the past, specifically I'd look at https://dojo.domo.com/t5/Card-Building/Current-Year-Prior-Year-and-Budget-on-Same-Card/m-p/49142 which talks through the steps on how to do a customized offset like you're asking for. Once you have the offset configured you can…

Hi @user025644 Right now, no. Domo only does a "soft" delete (mark the user as deleted but keep the record around). This is because if they completely removed a user it would break all of the auditing tables / user activity that domo records to see what a actions a user has performed. If an admin was terminated and you…

@user053351 - To my knowledge that's not a possibility out of the box. You could utilize a text card to put on the dashboard and read from the DomoStats or Domo Data Governance datasets to pull the description programatically and display it. You'd need to change the display settings on your existing card to not display the…

Hi @colinr You'd likely want to configure a recursive dataflow with some additional steps to summarize your data before storing it. There's a good writeup in the knowledge base on how to do this. MySQL ETL Version: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow…

Hi @user053351 In the detailed view of the card, click the card title. It'll show the description and any pages the card is on. On a dashboard you can hover over the card title and it will display the description as the tool tip.