GrantSmith Coach

Hi @shamal Admins are a pre-configured role and have access to everything within Domo. If you're wanting to restrict users to not be able to see everything you'd need to create some custom roles and assign the users that specific role which would allow you to filter the PDP. One downside is that they'd lose access to…

Hi @user036002 , You'll want to look at either the Domo Governance Third Party datasets. They contain information about the different objects within Domo along with meta data. Specifically the Data Set Details dataset to see card count = 0. You'll also need to do some ETL magic to join the datasets to dataflows to see that…

Hi @user030238 Currently this isn't an option and each card would need to be updated individually.

Hi @Joe_M 1) If you have the card filtered to a relative time (i.e. Last Month) and not the specific dates themselves then it should be filtered only the last month and update each month automatically. 2) Correct, those are for scheduling only.

"Retail"MAX(CASEwhen `Loan_Originator_Type` = 'Retail' THEN 'Yes'else 0end) "Wholesale"MAX(CASEwhen `Loan_Originator_Type` = 'Wholesale' THEN 'Yes'else 0end)

Hi @user063136 A quick hack would be to aggregate these columns in Analyzer with a max() function which would cause Yes to override your 0 value. This is assuming the rest of the data you're displaying isn't unique or it's aggregated.

Hi @gbennett You're need to make sure you're selecting an SQL Table transform and select the columns you want from your table along with that code. SELECT `col1`, `col2`, DATE(`order_date`) - INTERVAL (DAYOFMONTH(`order_date`)) DAY + INTERVAL 1 DAYfrom `my_table`

Hi @gbennett If you have the ETL 2.0 beta you can utilize a formula tile and write a formula like (It'd be the same if you want to do it as a beast mode): DATE(`Date`) - INTERVAL (DAYOFMONTH(`Date`)) DAY + INTERVAL 1 DAY Essentially you're subtracting the day of the month from your date and adding 1 day to get the first of…

Hi @gotex You can do this with a beast mode and some HTML magic. You'd need to have the URL as part of your dataset (or could conditionally set it in a beast mode but that's not as clean and harder to maintain). CONCAT('<IMG src="', `URL`, '">') What beast mode were you using? What issues did you run into? 

Hi @user063136 Domo has some really good developer documentation outlining creating a custom connector. I suggest you review https://developer.domo.com/docs/custom-connectors/connector-dev-studio for additional information. 

Hi @MosesWynn Did you mean to have the trailing space in 'NPAC-CCS '? Doing a TRIM on your column and comparing it to the value with a trailing space will never match up.

Hi @MosesWynn Are all of your NPAC-CCS records still appearing or are some records being filtered / identified correctly (Essentially - are you getting into the first section of your beast mode)? Is it possible there's whitespace around the `Last Leg Product` field (did you try and wrap it in a TRIM function)? Have you…

Hi @JonavilCello There isn't an exposed public API that will easily do this for you. You could utilize the existing APIs for cards, datasets etc to get a list, filter for your old user and then issue update API calls for each of those objects using the appropriate API endpoints.

Hi @user063136 Looking at the Domo connector it appears like you'd need to connect each individual GTM account in Domo to pull in the data associated with each account. You'd need different account connections. Once you have all of those dataset configured you can utilize a Data Fusion to combine them all into a single…

Hi @user025702 It seems like a bug you might want to bring up with support where the data labels are being ignored when displaying the hover text.

Hi @Yogesh You might be able to utilize the Java CLI tool to download the dataset definition, export the dataset as JSON, manually change the JSON to add the additional fields and then re-upload the dataset using the CLI. Make sure you make a copy of your dataset first and use that for testing before you attempt to do this…

Hi @nj-John-mirc I've created some inventory pages utilizing the Data Governance datasets. Specifically I have a list of all of the dataset within our instance, show their name, description and the owner and direct users to contact the owner if they need access to that dataset. I've also configured a drill path to show all…

Hi @user045611 , An exclusion option isn't an option with PDP. Likely this is because of security reasons because it's better to not give access to all the data and have someone request more access rather than assuming they should have access when a new value gets added and they see data elements they shouldn't have access…

Hi @user08779 I haven't see that issue occur in my instance - have you tried reaching out to support?

Hi @MichelleH Have you tried closing out the app and restarting it or rebooting the phone? I might be a caching issue.

Have you waited 24 hours and checked your license count to see if it went down? I'm not certain how quickly the license count is updated but I don't believe it's instant.

Hi @dprc_BCI There is a beta for page filters that's currently in BETA. https://knowledge.domo.com/Optimize/Filtering_Data/Applying_Page-Level_Filters_(with_Filter_Views)_(BETA) which allows you to apply different filters to an entire page / dashboard. Talk to your CSM to get enrolled in the beta for this if you're…

Hi @Yogesh That's because it's the raw data you're seeing. Domo will take that raw data and change how it's displayed in the cards itself. If you're wanting to export the raw data as a formatted string you'd need to create a beast mode to return the date formatted. DATE_FORMAT(`Timestamp Column`, '%Y-%m-%d %H:%m:%S')

Hi @user082291 It's not quite possible to use a period over period chart when you're wanting to plot two different period intervals (quarter and year). I'm not a real fan of the period over period charts and prefer to do my own as I have more flexibility over the data than I do the chart. What you can do is create a date…

@GuitarMan2020 - You're close. ROUND is a function so it'd look like this (assuming 1 digit after the decimal) ROUND(SUM(`TotalTaskTime`*60)/SUM(`TotalTasks`), 1) A better way though would be to utilize the formatting options (blue link at the bottom of the summary number window to expand) under the Summary Number and set…

Hi @GuitarMan2020 Domo doesn't like your SUM(SUM()) without a windowing function which is why it's throwing an error. If you're looking just for minutes per task for the overall dataset you could do: SUM(`TotalTaskTime`*60)/SUM(`TotalTasks`)

Hi @user065584 Ones that I like that tend to be more interactive like: https://www.w3schools.com/sql/default.asp https://mystery.knightlab.com/ - More gamified learning

Hi @user097047 If I'm understanding your request correctly you're saying: -IF PPV is null use 0 in the comparison to the invoice value, otherwise use the PPV value. - If the resulting number PPV value is the same as invoice value then return 0 otherwise return the PPV value? With that assumption this should likely work for…

Hi @user046467 In MySQL (which Domo uses) LIKE is case INsensitive so you're seeing records with both uppercase and lowercase variants on your search string. Domo doesn't support the BINARY flag for LIKE searches either which is why you're getting that error. If you want case sensitivity you can utilize the INSTR function.…

Hi @Khan_Naziya First I'd recommend you utilize the Work Bench executable command line to backup your specific jobs you're working with. C:\Program Files\Domo\Workbench> .\Wb.exe export-job --helpWorkbench Console ToolCopyright (C) 2017 - 2019 DomoVersion 5.0.7460.37975Usage: wb export-job [option...] -f, --force (Default:…