GrantSmith Coach

Hi @user056607 When subtracting two dates in MySQL it should return a single number representing the day difference. So you can try something like: `Cancellation Date` - `Publish Date` <= 90 Alternatively you can utilize UNIX_TIMESTAMP to calculate the number of seconds since 1970-01-01 and then calculate the second…

Hi @JPeG You could create a beast mode to extract only the date parts you're interested in. CONCAT(LEFT(MONTHNAME(`Date`), 3), ' ', DAY(`Date`)) Left is just making a 3-letter month abbreviation of the name since MONTHNAME returns the entire name. Because this is now a string it will sort alphabetically rather than by…

@nj-John-mirc Interestingly enough the formula STR_TO_DATE is using a different formatting character set than the Beast Mode does. Instead of %-b you want %e. For a reference on the formatting characters you can look at https://www.mysqltutorial.org/mysql-date_format/ STR_TO_DATE(`Date As String`, '%e %b')

Are you doing this in a beast mode or in a query on your database bringing the data in (if so which DB type)? Do your dates actually include / or is that just from the error output text? Utilizing STR_TO_DATE in a beast mode seems to work just fine for me.

@nj-John-mirc How does it not work for the double digits? What's the formula you're currently using? %-b should handle single and double digit day numbers.

Hi @Crisocir Domo does have an Activity Log you can try and reference. I utilize it for some governance cards I have to determine when a card was last viewed. I inner join (to get only card activity information) the Activity Log dataset to the Cards (Third Party Data Governance dataset - could use DomoStats datset variant…

Try using %-d instead of %d. %dDay of the month as a zero-padded decimal number.03%-dDay of the month as a decimal number. (Platform specific)3

Hi @nj-John-mirc Have you tried concatenating the appropriate year onto your string and then using STR_TO_DATE? STR_TO_DATE(CONCAT(`Date`, ' ', YEAR(CURRENT_DATE)), '%d %b %Y') How is the STR_TO_DATE function not working? Does using the format string '%d %b' work in STR_TO_DATE (without concatenating the year)?

Hi @MartinB @What you’re wanting is a windowing function with a partition because it sounds like you only want to calculate the information within each specific group. I'm not exactly clear on how you're wanting to process your data but it sounds like you're wanting to calculate the total quantity that item has of the…

Hi @user02700 You can add the number of hours to your date using an interval. This will make it a DateTime instead of a Date. `Date` + INTERVAL `Hour` HOUR

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…