GrantSmith Coach

@User2021 How are you able to relate the child to a grandparent or great grand parent? You data appears to show that the parent (numbers) never being in the child column (letters). What you're asking to do, If I'm understanding you correctly, is to have Domo recursively go down the "family tree". Domo can't exactly do this…

Hi @user000253 Are your values blank meaning an empty string '' or are they actually NULL meaning no data? To handle both cases you could add an additional clause to your case statement with a COALESCE function: CASE WHEN TRIM(COALESCE(`Flow Velocity (ft/s)`, '')) = '' THEN 'BLANK' WHEN CEILING(`Flow Velocity (ft/s)`)<= 10…

Hi @User_32265 Regular expressions are a great tool for this use case when you're trying to parse our text from another with variable length or positioning. You can utilize this regular expression in a formula tile: REGEXP_REPLACE(`url`, '^.*/([^/]*)$', '$1') ^ Says start at the beginning of the string .* Match any number…

"There's an API for that" ™  😂 api/identity/v1/users/search You can submit a POST request to that endpoint and it'll return user information. It defaults to 200 users. Sample body:…

For those of your coming to this looking for an answer you can find more information on a newer topic here: https://dojo.domo.com/discussion/54163/export-card-data-using-python-pydomo#latest

Those are some nice links you have there @MarkSnodgrass :) You can leverage the logic outlined in the links he's provided to calculate the difference in the number of full days in between your two days, then multiply those days by the number of hours in your day (8) then add in the number of partial days (hours) from your…

SUM(1) / SUM(SUM(1)) OVER () SUM(1) will get you the total number of within the grouping defined on your card. SUM(SUM(1)) OVER () This returns the total for your entire dataset after filtering has been applied. This version is simply counting the number of rows for each group and the total number of rows across the entire…

@JR_Iron The data is returned when you call the render endpoint. You can pass in your filters / query overrides as part of the PUT request. Inspect the network traffic for the render endpoint when you go to a card and that'll show you the request it's making and the data points from the card in the returning JSON.

Thanks @Anna Yardley and @Richard - It was a great session. Looking forward to more.

Hi @Trumpetbob You can look into window functions to calculate rolling averages or percentages. I've done a writeup on this previously here: https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages#latest This will take into account filtering as well as a beast mode.

If it's returning the string value of 10.0% then it shouldn't be doing any formatting. When you select it in your column list in analyzer is it listed under dimensions (blue) or metrics (green)?

Can you post some anonymized sample data or screenshots so we can better understand the issue you’re having?

If you’re looking to calculate the number of months based on what data you have in your dataset you could do COUNT(DISTICT LAST_DAY(`date`)) last day returns the last day of a month for the given date. It’s a shortcut I use instead of extracting the year and then the month for a date. This won’t count a month if it’s…

Hi @dacorson You're correct in that you'd have to calculate the total in a dataflow / ETL first and then use that value in your beast mode. Segments are another option they won't work for your specific use case.

If you look at the raw data is it showing 10 or 10.0? Are you able to click on the field in the card, select format - percentage and then set the percentage decimals to 1? What type of card are you utilizing to display your 10%?

@StefanoG So there isn't a "supported" API call via the CLI or pydomo that will do what you're asking. I'm assuming the connector has a start / end date that you're wanting to call but essentially you'd need to make two API calls, one to update the connector definition via JSON request and then another to run the…

Hi @Matt_Umolac93 You can use the ROUND function to specify the number of decimal places you want in your resulting value. ROUND(`Percentage`, 1) This would get you one decimal place. By default if you don't have the second argument it defaults to 0. If you're wanting to truncate you can use the FLOOR method to drop…

@NevilleMills Is this dataset configured with an upsert key? There may be an option with the CLI if your dataset is configured with an upsert key

@JunkDoom My understanding is that they do not as it's not actually storing any rows.

Hi @KristiKovacs You need to utilize the skip url parameter to tell it how many users to skip. This is typical with API implementations to prevent requests consuming all the resources. It defaults to 0 if it's not supplied. Try a URL like: url = 'https://api.domo.com/v1/users?limit=500&skip=500' to get the next 500. (you…

@thwartted If you go into Admin - Company Settings - Company Overview the 4th option down should have your timezone listed. Is this set to MST / a nearby city in the same timezone?

Sorry @Crisocir, Had too many windows open answering too many questions at the same time. That was meant for a different post. I don't think they have the recordings posted yet. @Richard - any update on the videos from the virtual user group?

@JR_Iron Are you wanting the data exported after it's been processed by the card? You could attempt to mimmic the logic the card is doing using the DataSetClient.query method and query the dataset. You may need to inspect the network traffic to get the exact logic it's using to filter your dataset. Alternatively you could…

@Crisocir @john_stevens posted it here: https://dojo.domo.com/discussion/54131/how-to-clean-up-clutter-user-conference-jan-2022-notes#latest

Hi @JunkDoom Domo does have DataSet Views which function similar to database views. You can read more about them here: https://domohelp.domo.com/hc/en-us/articles/360046074774-DataSet-Views

Group by your log start time and logged in user and take the max values

Hi @Brad_Kempnich There is a DomoStats connector dataset for the Activity log which will allow you to query certain events to see when a card was last viewed. One note to this though is that it's only counted if the card details are viewed and not just viewed on a dashboard.

@Culper_Jr - Yes, it's included.

Thanks @JasonAltenburg ! For those interested here's a link to my Dojo post outlining my solution I covered dealing with custom date offsets. https://dojo.domo.com/discussion/53481

@Douglas_Digon They still haven't implemented this. The current workaround is to utilize a beast mode to display an error if not all the filters are selected (you can use a COUNT to check for duplicates / unfiltered data). You could do this on a page or possibly as the summary number to display "SELECT X, Y and Z filters"