GrantSmith Coach

Hi @Steve-DOMOnoob Just remove the <br> HTML code in the CONCAT function

Hi @nj-John-mirc Depending on how many dashes you have and if that number will be consistent you can utilize the Split Column tile and split on a custom character '-' to get the different parts of your value.

In that case no, the quick filter is only available on the card detail level and not the page level.

Hi @user049145 , There's actually a beta out right now called Page Filters. You can configure filters for the entire page and have predefined filters saved as well. Talk to your CSM to get it turned on. It's not exactly filter cards but will allow you to do filters across the entire page.

A single beast mode won't work for how you're wanting to process your data. You're wanting to include a single record into multiple buckets which isn't possible as a single value is returned for each row from a beast mode. You could try and create separate beast modes for each bucket.

Hi @user056243 This is because the order in which your conditions are being evaluated. If you had 400,000 it compares to the first expression (>250) which is true so it returns '250k'. When doing a beast mode like this you need to start largest and go in descending order. CASE WHEN `employee` >= 350000then '350k'WHEN…

Hi @user039888 The Python SDK doesn't export the Card Management endpoint so you won't be able to delete the cards using that SDK. You could possibly utilize the Java CLI (https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool) to delete the cards using the 'delete-card' command.…

Hi @Sweep_The_Leg Have you tried looking at Graph Settings -> Show Scales -> On Bottom?

@MarkSnodgrass Alternatively you can utilize DATEDIFF but by default it includes the current date as a whole day so depending on how your business rules are you may want to -1 day from your date difference to not calculate today. Week: DATEDIFF(`EndDate`, `StartDate`) / 7 Days: MOD(DATEDIFF(`EndDate`, `StartDate`), 7)

Hi @user14900 , @user096813 , @user044663 , @Khan_Naziya It sounds like a systemic issue. I'd recommend reaching out to Support or your CSM.

Hey @MarkSnodgrass Any time I'm doing date differences I like to utilize unix_timestamp. It converts everything to an integer of the number of seconds since 1970-01-01. This makes working with the data easier. DATEDIFF is returning your difference in the whole unit you specified so you don't get the fractional aspect of…

TIMESTAMPDIFF(MINUTE, ...) calculates whole minutes that have passed between the two timestamps so it makes sense you're seeing 10 (essentially it's truncating instead of rounding) instead of 11. If you want to round to the nearest minute you can just utilize the ROUND(..., 0) function

Hi @Khan_Naziya I've found unix_timestamp function to be great in cases like this. If you convert two datetimes to unix timstamp it'll give you the number of seconds since 1970-01-01. Simple math would get you the number in unit of minutes. Here's a BeastMode function that will calculate time between timestamps in minutes…

Hi @hamza_123 You can utilize unix_timestamp function to calculate the number of seconds since 1970-01-01. With some simple math you can get the difference in seconds. (UNIX_TIMESTAMP(`EndTime`) - UNIX_TIMESTAMP(`StartTime`)) I wrote a more advanced summary of this you can read…

Hi @AttuAk What type of card are you utilizing? HTTP links are only usable within a table or HTML table card otherwise it'll treat it as filterable text. Your beast mode will also only ever take them to the same wikipedia page. You'd want to incorporate your URL dimension as part of the link. (this is assuming you're…

Hi @MLAstuto You'd need to pre-aggregate / pre-calculate your data via a data flow since you're partitioning based on the beast mode field. Because of how you're computing the grouping via the beast mode it no longer is part of the collective but that specific group. You'd essentially need to have 2 records for each. One…

@user11651 For clarificaiton, after you convert the string to a number you'll need to convert it back to a string and then use the string operations tile to do a left substring to get the 1st character. This will get you the first number to check against. There are other options utilizing a regex which are a bit more…

Hi @user11651 Regular Expressions were made for scenarios just like this one. I'd recommend you do a Google search for regular expressions to learn more about them in depth if you're not familiar with them. Another good resource is https://www.regular-expressions.info/ As for your specific case Domo does allow regular…

Hi @Whimzyy Domo is breaking out each rep because that's the column you have on your x-axis. Depending on the format of your actual data and how you want the final presentation to look like dictates which card you'd need to use and how you'd define your x and y axis values. Can you provide some scrubbed example data for…

Hi @user048672 Are you an admin or do you have the "Manage All Cards and Pages" role associated with your account? You need to have one of those in order to move pages around. If not I'd talk with your instance Admin to get your pages moved. You can reorder your own pages within a parent page but can't move it outside of…

Hi @user084060 Single Value cards don't support different font sizes. Are you able to utilize a Text Box card instead?

Hi @user096813 Does the field names that you're working with in the filter card exist in the other cards? Are you using the same dataset?

The first line is to prevent a divide by zero error.

Hi @user046467 The example I gave assumed each visit was it's own record. Since you have the number of visits for each page as a record you just need to make a minor tweak to the beast modes. You just need to swap 1 for your column containing the number of page views - `Unique Pageviews` CASE WHEN SUM(CASE WHEN `page` LIKE…

Hi @JonavilCello , I'd highly recommend looking into the Command Line Interface (CLI - see https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool) tool. It interacts with the API for you and you don't have to write a custom app to do it. There's even a specific command to do…

Hi @user02674 Domo doesn't handle the average of date objects with a simple AVG function. You'll need to convert it to a unix timestamp (number of seconds since 1-1-1970), grab the average and then convert it back. DATE(FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(`start_date`)))) This is assuming your data is recording a record for…

Hi @user038587 The easier option is to take that excel file upload it to Domo and utilize a dataflow with a join to filter on those values. One caveat to this though is that it will remove the other values and you won't be able to filter on those values any more in your card. There isn't a way to filter on a giant list via…

Hi @user046467 Try this: CASE WHEN SUM(CASE WHEN `page` LIKE '%/page1/%' THEN 1 ELSE 0 END) = 0 THEN 0 ELSE SUM(CASE WHEN `page` LIKE '%/page2/%' THEN 1 ELSE 0 END) / SUM(CASE WHEN `page` LIKE '%/page1/%' THEN 1 ELSE 0 END)END

Hi @user014481 Preview won't display all of the records because it's just that, a preview. If you're wanting to see data from each step you can filter the data you want and then output it to different dataset(s) along the ETL path.

Hi @AvinashK Right now now, there isn't a way to determine if a card has a drill path or not. Domo hasn't made that data visible with the DomoStats or DataGovernance datasets. You can post the idea to add this to the datasets on the Idea Exchange.