GrantSmith Coach

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.

@user045611 You can run it so the dataset will update the name (It's still the same dataset). After it's been run once you can then go back in and add the renamed dataset as your input and then change your output back to the correctly named version.

Hi @user007952 , You might be able to accomplish this using an ETL to calculate the national average since you can't do this as a beast mode as filters would affect the number. Take your data and calculate the average. Then adding a constant (Call it "join column" and set the value to 1) on both your calculated average…

Hi @Akhil Have you tried making sure your date field is all formatted as a date or a date with time (not mixing formats but a consistent format)? If you're only using the date and don't care about the time have you tried just formatting your data as a date? Another option might be to split out the date and times into two…

Hi @user08788 You can't use like and IN together. You'd need to split it out to separate logical checks. Try this: SUM(CASE WHEN (`Budget Segment` LIKE '%REL%' OR `Budget Segment` LIKE '%SMB%') AND `Advertising Line` = 'Non Working Dollars (NWD)' THEN `ApprovedAmountUSD`END)

Hi @user030892 , 1) You should try explicitly casting your date string '01-01-2019' as a date: cast('01-01-2019' as date) 2) Your data isn't getting grouped because you're not specifying an aggregate function for your fields. You need to select SUM, Average, Min, Max, Count etc for the fields you want to summarize and…

@jaeW_at_Onyx - That's how my data is formatted, it's utilizing the Type column to determine if it's either a projection or an actual number. I'm not tracking historical projections (it's forward looking only) so I'm not comparing old projections (It's simply just multiplying the YoY % over the last X weeks and then…

Hi @user06979 How I've done graphs like that in the past was to have two different lines plotted on the same graph and color code them differently while labeling one Actual and the other Forecast. To get around some odd graphing issues I had the actual stop at the current day (I was graphing on a by day granularity - you…

Hi @Whimzyy Assuming you're wanting the % based on all of your records and you just need the data summarized: SUM(CASE WHEN `Secondary Paid` > 0 then 1 ELSE 0 END) / SUM(1) This is assuming you don't have any groupings in your data (i.e. you only this % number only, once you add additional dimensions it will change for…

Anyone who has access to the dataset should be able to create an alert based on the dataset, anyone who has access to the card should have access to create an alert off the card. Sorry if I wasn't clear earlier. Here are some helpful knowledge base articles: Alerts + Data Sets:…

Anyone who has access to the card should be able to subscribe the the alert.

Hi @KJRowe6 If you have one incident per row then you don't need to have the MAX in your beast mode - It's always returning the highest date with your incidents. Try this: CASE WHEN DATEDIFF( CURDATE(), `created_at`) > 30 THEN 'Aged' ELSE 'Not Aged' end

Hi @user095063 How many input data sets do you have? Do you only have the one data set? Are you attempting to do a recursive appending data flow?

Hi @user022825 Domo currently can't handle sending alerts to a dynamic e-mail address. You'd likely need some external process (like a python script) to pull the data and send the emails based on the list.

Hi @user017636 You need to drag it from the data section not the data table section from either the dimensions or measures sub sections. Click on Data to display this section.

Hi @user046467 Short version: I used a python script interacting with the Google Ads API and then used the Domo API to upload a dataset. Long Version: I've had the same problems and ended up not using Google sheets entirely as the timing of the Google script to populate the Google sheets and the Domo job to pull in the…