GrantSmith Coach

Hi @johnmurphy11 Welcome to the Dojo! Sadly you can't filter on a column in one dataset and then cause Domo to filter the page on a different column on the page. To get around this you'd likely need to create a Dataset View (Beta, talk with your CSM to get started if you don't have it) - Alternatively you could do this is…

Hi @GuitarMan2020 Have you tried utilizing a Beast Mode to calculate the Hour of the day: HOUR(`Date`) And then using that as your x-axis which selecting last week from your date range selector and then just doing an average of your total tickets? Since you have multiple priorities for each hour you might need to…

Hi @user095063 You could write this as a beast mode on your card as it can support window functions (assuming you have the feature enabled - if not talk with your CSM).

Hi @user084060 I'd recommend simplifying your beast mode so you don't have so many nested case statements. You can have multiple WHEN statements in your when clause. You don't need to create a new case statement in each else clause. Try something like this: case when (sum(case when product='nx' then `score` else 0 end) /…

The abbreviated beast mode is doing the SUM already for you and adding in the M (if it's in millions). Because it's adding in the extra "M" it's treating the resulting data type as a string. You shouldn't need to select the SUM aggregation from the column as it's done inside the beast mode.

Hi @Shumilex You can use a Magic ETL to join the two dates together using a Join tile based on the two dates to get a resulting dataset. After the join you can use a Select Columns tile to only select the columns you want and to rename them appropriately. You could also do this with a DataSet View if you're familiar with…

Hi @AJ2020 Here's a link to how I've done textual abbreviations via a BeastMode. https://dojo.domo.com/t5/Card-Building/Textbox-formatting-using-Concat/m-p/50397/highlight/true#M7284 You'll want the bottom example.

Hi @user084060 Here's a helpful summary from someone at Domo which explains the issue in greater detail. Permalink Also, here's a link describing the issue from the knowledge…

Hi @user12621 I like to use the UNIX_TIMESTAMP function on both timestamps and some simple math to determine the number of seconds between the two different timestamps. I wrote a prior answer on this and how to format it into days hours minutes and seconds.…

You can create custom column calculations using a Beast Mode / Calculated Field. Here's knowledge base article with some more information on those. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode If you're wanting to know how to do it across the entire data set then…

Hi @user069636 Try using a Group By tile before your Rank & Window tile to group by the product and store and use the SUM aggregation on your necessary fields

Hi @user069905 What are the file types of the two files? Have you tries saving your scan in an image format (GIF, JPG, PNG) instead of as a PDF and using that?

Also to clarify this also gives you the give you the flexibility to do a "Starts With", "Ends With" or "Contains" depending if the percent sign is at the end, start or both ends respectively. For example of the Contains column: Starts With: Prefix% Ends With: %Suffix Within: %Contains% (as shown in my prior example)

Interesting scenario! We can solve this by still utilizing a web form and utilizing a DataSet View (could also do similar logic in Magic) Your webform would look something like this: ContainsValue%AMC%Auro Medical Center%SYS Sol%Syndia Solutions%Benjamin%Benjamin Research Group So now you have your two datasets. What we'd…

Hi @swagner Have you tried the connector with a zip file that doesn't contain a CSV with a space in the file name? Alternatively have you tried escaping the spaces in the file name with a backslash ("\ ") to see if that will resolve your error? Spaces in file names notoriously cause issues...

Hi @Khan_Naziya I'd recommend using a webform to maintain the list of clients and then utilize a Magic ETL or Dataset View to join your original dataset to this client list dataset to filter out any non-client data. If you're looking to do some special calculations based on which client is which you could attempt to pull…

Hi @user027022 Currently this isn't possible as the UI doesn't function this way as you'd have to do each ID one at a time to find in your filter list, select the checkbox and then search for another ID. This would be great product feedback for your CSM as I think it'd be a great enhancement to automatically split a search…

@Victor You need to use an HTML Table. It won't work within a Mega Table.

Hi @user02319 The date range field determines how much data you wish to have displayed on your card so in your example it would show just the last 30 days worth of data. Compare To says I want to take a given time period (in your example days) and compare each of those to 180 days ago. So on your graph it would compare the…

Hi @Shumilex You can utilize a Magic ETL 2.0 data flow with 3 different input data sources, then join the data sets together using a Join tile bsaed on the date and username fields. The resulting dataset would have all of the columns in the same dataset. Alternatively you could use a Dataset View (in beta, talk with your…

Hi @user062862 If you want the order date to be before status you need to call datagrid.addColumn('Order Date'...) before the Order Status. Because you're adding Status column before the date column is what you're getting your current result. Could you just add all 3 columns to start and then just add a null value (this is…

As a minor tweak I'd recommend not including the wildcard at the end as it might cause incorrect matching. For example if your domain was "google.co" it would also capture "google.com". CASE WHEN `emailaddress` LIKE '%@mydomain' THEN 'Yes'ELSE 'No' END

Hey @SLam What other columns do you have in your chart? Would it include the error message that isn't aggregated? It sounds like the grouping in your chart (non aggregated [count, min, max etc] fields) might be causing some issues as the summary number is looking across your entire dataset but depending on the fields…

Hi @user02319 Yes, this is possible however you'd need to structure your data in such a way that you'll need to calculate your YoY in a beast mode instead of using the period over period type graph as that'll support only a single metric. @jaeW_at_Onyx has a great video of this concept which I recommend…

Hi @SLam You could use a Min or Max function on the ErrorDecription field to display only one value on your drill path if you don't necessarily care about all of the different Error descriptions. That'd restrict it to a single value for each OrderNumber. If you're interested in combining all the the error messages then…

Hi @user073741 You can use a beast mode to calculate the number of distinct topic / card IDs if you're grouping based on the user ID with a simple COUNT(DISTINCT `user_id`) however you aren't able to filter on an aggregate on a card. There is an alpha feature which enables this however I don't recommend it as it's doesn't…

Again, I'd highly recommend you configure an offset dimension to setup a week prior and 2 weeks prior custom offsets and structure your data as such. @jaeW_at_Onyx did a great video explaining this whole process as well: https://www.youtube.com/watch?v=CDKNOmKClms 

@user028686 If you absolutely must use a beast mode you could utilize the DAYOFWEEK function to get the end of the prior week and then subtract the number of weeks you're interested in. DAYOFWEEK returns values between 1 (Sunday) and 7 (Saturday). Subtracting that value for the number of days will return the end of last…

Hi @user028686 Whenever I typically need to do some period over period comparisons I actually restructure my data so that I have a report date and a "comparison date" (the actual date the metric was recorded on) and calculate it as necessary. This allows you to have custom defined periods (like 2 weeks ago and a week ago).…

Hi @Aymeric Really it's going to require more training for your users. When selecting Delete there is a dialog box that pops up which warns users of the consequences and that it will delete cards from this and all other pages. This action cannot be undone. Similarly the Remove option has a dialog box outlining what exactly…