GrantSmith Coach

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.

Hi @user08001 With what granularity are you pulling your data in GA and also when importing into Domo? Some metrics will be different if you're using different granularities as GA will dedupe data for certain metrics. Have you confirmed your Domo API request is the same as how you're pulling the data within Google? Have…

Hi @user090035 Typically to get information on your datasets or cards you'd want to use the respective DomoStats or Data Governance type datasets however currently these don't expose certification status. This would be a great request for the Idea Exchange. In terms of tags they only tags exposed to the governance datasets…

Hi @DannyLewis If the format is the same with LAST NAME, FIRST NAME then yes, you can utilize a beast mode to reorganize your names. Here's some examples using TRIM (trim / remove spaces from the start and beginning of a string), INSTR (find the location of a string inside another string) and SUBSTR (take a part of a…

Hi @MartinB The display options for the field can handle all of this for you. You can change your beast mode to be: 1-(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)) Then click on the Beast mode atop your chart to open the menu and select Data Format > Display as and select Percentage with 2 decimal places. You…

Hi @user32470 Have you tried utilizing a quick filter instead to view only the campaigns the user is interested? There isn't a default "collapsed" option (you could manually collapse all of them and then save the report but that'd be a weekly or daily process to keep updating the collapses)

Hi @user019875 , You'd likely need to write a custom connector (or a custom script utilizing the Facebook SDK and the Domo SDK) to pull the data how you want to out of the facebook API.

Hi @hamza_123 , Currently I don't think there's a way to do this but I'd recommend bringing it up with your CSM to see if they can customize something for you.

Hi @Canadian Out of the box no, there isn't a way to add custom user attributes however that's something you can bring up with your CSM to see if they can add that enhancement.

Hi @JamesCH Essentially when a user scrolls to the bottom of your table and there are additional rows to display it will pull in the next chunk of records and append them at the bottom of your table until there are no extra rows left.

Hi @BruceP , By default I don't think there's a way to do this but it's something you can talk with your CSM about as they might be able to customize your output.