GrantSmith Coach

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:…

Hi @Yogesh You can utilize SQL INTERVALs to do this. `CREATED_ON` > CURDATETIME() - INTERVAL '1' HOUR Here's a website that talks about them in more detail and lists all of the possible options for the units: https://www.mysqltutorial.org/mysql-interval/

Hi @user060040 Without seeing how your data is structured it's difficult to give an answer to your question as the format will dictate how you can solve this problem. Could you also post some pseudo data of how your dataset is structured? Is it structured like: LOBRequest TypeYearCount Or LOBRequest Type A CountRequest…

Hi @user060355 Without seeing your data - How is your budget structured? Is that a yearly, monthly or daily budget? You're likely comparing apples to oranges in terms of your unit of measurement. The numerator is likely on a daily basis but your budget is probably on a non-daily scale. You'll want to either utilize a MIN…

Hi @user056039 @Wills is referring to Windowing Functions. This is a feature switch you can talk to your CSM to get it enabled within your instance. Here's a webpage describing windowing functions.

Hi @Khan_Naziya You won't have visibility into the workbench job schedules via a governance dataset. Workbench jobs (including their schedules) can be exported from workbench using the wb.exe executable. wb.exe export-jobs --help That will give you usage details where you can export your jobs to a folder in JSON notation…

Hi @Khan_Naziya , You'd need to connect via an API Access Token and use the -t flag instead of -u and -p. You can generate a token under More > Admin Settings > Security > Access Tokens (assuming you have permissions to view / create those - if not talk to your Domo admin) You'd use that token that's generated as the -t…

Hi @user32470 , You'd need to have two records for each competitor in your data set. Assuming your data looks like this: DateCompetitorAmount1/1/2020ABC5001/1/2020DEF1231/1/2020Our Company987 You'd want it structured like: DateCompetitorComparisonAmount1/1/2020ABCThem5001/1/2020ABCUs9871/1/2020DEFThem1231/1/2020DEFUs987…

Hi @Crisocir You can do this utilizing a window function (If you don't have it in your instance you'd need to talk to your CSM to get it enabled). Essentially this beast mode is calculating the row numbers (within each invoice) and then checking to see if it's the first row, if so return the tax amount otherwise return 0.…

Hi @user07592, You could utilize a dataflow and append the datasets together (assuming they have the same schema) to then create an output dataset. Afterwards you could delete the dataflow as well if you're not interested in keeping it or the 7 input datasets around.

Hi @user013269 You'd need to format them as a string in the format you wish using your query before you pull it into Domo.

Hi @user057613 #1 is possible with a lengthy beast mode. #2 is not possible. Text cards don't support HTML markup. Only within table cards. CONCAT(CASE WHEN LENGTH(ROUND(SUM(`Number Orders`), 0)) = 12 THEN CONCAT( SUBSTRING(ROUND(SUM(`Number Orders`), 0), 1, 3), ',', SUBSTRING(ROUND(SUM(`Number Orders`), 0), 4, 3), ',',…

Hi @user093540 There isn't a simple way to do it but you'd have to add the cards to your dashboard and then move them back to the appendix in the order you want them in.

Instead of using COUNT try using SUM: SUM(Condition1)/ sum(count(distinct ID)) over (PARTITION BY `ID`)SUM(Condition2)/ sum(count(distinct ID)) over (PARTITION BY `ID`)SUM(Condition3)/ sum(count(distinct ID)) over (PARTITION BY `ID`)SUM(Condition4)/ sum(count(distinct ID)) over (PARTITION BY `ID`)

Hi @user016969 You're close but instead of using a window across the entire dataset you're wanting it across each ID / Name. Just a minor change to your beast mode should get you what you want. Count(Condition)/ sum(count(distinct ID) over (PARTITION BY `ID`)

Hi @user045611 If you're receiving text and app notifications - have you checked your spam folder?