Godiepi Coach

hi @SteveBrownlee thats a great question, unfortunately there is not a field in the governance datasets that tell us where a card or dataset is certified. you should submit this post as an idea in the Dojo. count with my vote for it

Hi @Ashleigh you can do it through Admin>Company Settings>Company Page Settings

Im not sure what are you trying to get but those 2 datasets allow me to build reports like this one in the screenshot

Hi @guitarhero23 your case is very very interesting and I decided to give it a shot. take a look at the screenshot for the explanation of the process that might work in your case. It would be easier for me to jump on a quick call if you want to. I hope it helps

Hi @user11159 you should see a "Survey Details" that would get you the tittle and question categories and another report called "All Survey Details" that would have all responses to the questions. you can join the 2 reports by SurveyID, QuestionsID and Title

@WorldWarHulk you need to remove/change the date/time first column if you need a distinct count by day then the first column should be Date(`Corrected Test Started`) if you need a distinct count by month then the first column should be your 'Year-Month' like Concat(Year(`Corrected Test Started`), '-', Month(`Corrected Test…

How are you loading the data into Domo ? if using a connector, change the setting from Replace method to Append. That will create an automated field that tags every row with the Batch Last Run Date which referes to the day your data is appended. That way you can look at what the data looked like in the past compared to the…

Take a close look at your calculation , All are showing Approaching because you have the condition of >= for approching and > for Over. it happens to be that passing 90% , 100%, 110% applies to the Approching cal. I recomment adjusting it by setting another piece that said >= 90% but <= 100%... same thing saying between…

Awesome !! well done, congratulations @ST_-Superman-_ @TheDean @JesseK 

Hi @robertc This might be a silly question but in the connector settings are doing an append or replace of the records ? if you are doing an append, you can look at the last batch id or batch last run date to differenciate each pull

have you try adding `revenue` to the filter as 'is greater than' 0 ?

Hi @JennWhite You have multiple options and each one has its pros and cons. it also depends on how big your staff is we distribute score card metrics for all our reps in our company and we have done it different ways. When we started distributing these metrics, we did not have our reps as participants, they were all social…

Hi @user16640 If only you want to check for that in AccountA then the 1st beastmode would work, if you want to check for those conditions in all accounts you'll need to remove the condition for accountA using the beastmode number 2 below BeastMode to check only on AccountA case when `Account` = 'AccountA' then case when…

awesome @swagner !! you are quite a youtuber , I always watch your videos , very well done. Love the Stretch Armstrong you throwed in there ?

Hi @user11351 if all you are trying to do is tag today's date as "Today" and Yesterday's date as "Yesterday" then do this Case when Date(`call_date`) = Current_Date() then 'Today' when Date(`call_date`) = Date_Add(Current_Date, interval -1 day) then 'Yesterday' end you might have to adjust for UTC time but I dont know what…

Hi @StyLe this workaround is very silly but I think it works ? can you create a beastmode to reverse the percentage so that the positive change becomes negative ? just multiply your value times (-1) `Your Value` * (-1) see screenshot below

Hi @swagner , hope you are doing well Take a look at this example, you will need to add some HTML code to your summary as well as aggregated (SUM, COUNT etc) I have a field in a table that tells me the score of a soccer match the code below bring the score and turns green for the winning team either on the left or the…

@Jeffsnake / @ST_-Superman-_ A good way to evaluate dataset schema changes is by using the "Domo Governance Datasets" connector available in the app store. You can download the report called "Dataset Schemas" wich downloads a list of All datasets present in your Domo instance along with every single columns/fields info for…

Have you try building a dataflow SQL in Domo doing something like this below Select concat(a.`user_ip_access`, '_' ,b.`ip_address_country`) as 'user_ip_access_plus_country' , a.`user_id` , a.`user_name` , a.`user_ip` , b.`country_code` From `Table1` as a Left outer join `Table2` as b on a.`user_ip_acces` between…

@user02631 oh that looks a little different from the prior description of what you are trying to do, but focusing for now in the second picture you can have a table card with 3 columns: 1st column = Group 2nd column = Beastmode, lets call it "Count of Negatives" code would be as simple as ifnull(Count( Case when `Try 1` <…

There might be some Nulls that are causing the calculation to break so try adjusting your calculation for those Nulls like COUNT(DISTINCT Case when Sum(`Total On Hand`) - SUM(CASE when `Planned Shipment Date` < (CURDATE()+ 21) then ifnull(`Outstanding Quantity`,0) else 0 end) < 0 then `Item No` end)

Yes you can add images to table cards using some basic HTML code you will need the URL where the image is located to make it visible in the table trhough a beastmode calculation. Here it is an example: we are running a contest in our company just for fun with the current Women's Soccer World Cup and I built a dashboard…

Try This one COUNT(DISTINCT Case when Sum(`Total On Hand`) - SUM(CASE when `Planned Shipment Date` < (CURDATE()+ 21) then `Outstanding Quantity` else 0 end) < 0 then `Item No` end)

@LardnerPete Awesome , I'm glad I could help you ??

You can do that using the DataGovernance connector to be able to see all dataflows and datasets as well as what is attach to what. it will take some work though to build the flow that puts everything together. Take a look at this post below to have a better idea of how to do it…

@JonavilCello if it still available in the website and you are the website content admin, just remove the code.

Yes you can write a beastmode using Replace() , hopefully your values to remove are consistent. you will need to replace within replace meaning one value at a time to replace all occurrences for example start replacing the 1s , then a replace of 2s within the prior replace here it is the code for your example , notice the…

Hi, Ideally if you are loading the spreadsheets yourself, you could fix it in the spreadsheet before uploading it so that the feed is cleaner. with the spreadsheets already in Domo in this case, you can also use the excel plugin which allow you to download the spreadsheet from Domo into your computer, make changes and…

Hi @Kellerry , I have used Domo since 2014 already and currently using several connectors, not all created by Domo. to your questions : 1) I haven't gotten notified of updates but in each connector overview in the app store you can see the update version and the updated date. for instance the google sheet conector shows…

answers in RED below @user06488 wrote:That looks like a great solution to my issue, Godiepi (thanks!), but I can only see Measures, not Dimensions, in the "Field & Function" list when configuring the Summary Number "That is correct, it depends what you would like to show, for example the radial value is a meassure coming…