GrantSmith Coach

Currently no. You’d need a separate page.

It depends on how your company wants to define success but I'd recommend 'Invalid' and 'Success' SUM(CASE WHEN `Status` IN ('Error', 'Invalid') THEN 1 ELSE 0 END)

You can't use aggregates in the formula tile. It's processing data on a record by record basis. You'd need to break out your different component's you're aggregating into separate columns then feed that into a group by to do the aggregation (sum) and then do your final subtraction and divisions. Total `Amount` +…

Hi @Fadem What's your beast mode? Is it using the same column(s)? Are you getting any sort of error message?

-- This is a comment SUM(`Column`)

Use an ETL to group it based on the ID and the status and then count the IDs. This will break down your dataset based on the statuses and give you a count. You can filter out then for specific codes Alternatively if you're using a beast mode you could do a conditional sum: SUM(CASE WHEN `Status` = 'Failed' THEN 1 ELSE 0…

Hi @ankt84 You can find this information using the DomoStats connector and pulling the DataFlow History report. It'll list all the executions for all your data flows so it'll show if it failed and when it failed. https://domohelp.domo.com/hc/en-us/articles/360043433813-DomoStats-Connector#4.6. has more information on this…

As a note of clarity CONVERT_TZ will convert a time based on the current day's UTC offset and not when the date actually occurred. So if you have a date from 6 months ago affected by Daylight Savings Time (an extra hour off of UTC) and you try to convert it today it will be off by an hour from what's expected (It'll…

This seems to be a bug. I’d reach out to support to have them take a look.

LAG is available as a beast mode however you need to talk you your CSM to get window functions enabled.

Hi @RB1 Page filters are only known within the page. They can't be applied across multiple pages. You could create a duplicate dashboard and add the filters to your cards so they won't be unfiltered by the page filters however each page would need to be filtered separately. If you duplicated all of your cards on the same…

Hi @afoote4 I've done some prior write-ups about formatting text with an HTML table card and inserting commas or writing your own summary numbers here: Those may help shine some light on how to tackle your problem. I'll also be doing a video on this and many other beast modes at Domopalooza 2022.

Hi @NathanDorsch I'd recommend restructuring your data to have multiple different periods in the same graph. I've done a write up in the past on how to accomplish this here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

You should be able to just set the color using color rules in to color settings on your card. You can select your beast mode you’re using for the line and tell it to always be a specific color. with the line + bat chart you have two separate y axis. The left one is for the line and the right one is for the bars. Your graph…

You can use a formula tile to splice out the different parts and assemble it as a timestamp: TIMESTAMP(CONCAT ( LEFT(`Date Hour and Minute`, 4), '-', SUBSTRING(`Date Hour and Minute`, 5, 2), '-', SUBSTRING(`Date Hour and Minute`, 7, 2), ' ', SUBSTRING(`Date Hour and Minute`, 9, 2), ':', SUBSTRING(`Date Hour and Minute`, 1,…

For reference here's a beast mode I like to use with LAST_DAY to determine if the date value is in the current month. CASE WHEN LAST_DAY(CURRENT_DATE) = LAST_DAY(`date`) THEN 'Current Month' ELSE 'Not Current Month' END LAST_DAY returns the last day in the month for a given date. CURRENT_DATE returns the current date

Hi @Katie_Forrest_2022 you can set it to the last 13 months and then use a beast mode to calculate if any dates are doing the current month and exclude them with a filter.

@Afolabi @user023583 Domo doesn't provide a dataset containing the MagicETL transformations in a dataflow at this time.

Great to hear @elvarliiv . If you could mark my answers as accepted so others could more easily find it I'd appreciate it.

@mhouston Thanks for the detailed write up of your solution!

Hi @elvarliiv have you tried using a beast mode to take the MAX of your dimension field?

@Ashleigh It's likely an issue with how the connector was written and didn't take into account sub questions. You'd probably need to write a custom connector to handle subquestions or reach out to Domo to see if they can make the necessary changes to the Survey Monkey connector.

Hi @keeeirs10 Is this query being done in your output section or as a transform?

@CarolineRogg1 If you go into Analyzer on a card do the color rules still exist on the card or are they completely gone? Did the values that you're applying the color rules to change at all? I did have some issues recently where a dashboard decided to move some cards to the Appendix without any user input recently. If you…

Hi @D-Rab There's a limit to the amount of rows able to be displayed in the card. Box Plots and Histograms have a pre-set limit of 100,000 rows of data. Other chart types have a pre-set limit of 25,000 rows (although the charting engine may limit the data further depending on how many series are represented). You can now…

I’ve seen Cards get cut off during display before. I had to reach out to Domo Support log a bug ticket with them. You could try and resize the card in the page layout to see if that will reset the text or if it will display all of the text if it is a bigger card

You could utilize the DomoStats connector and pull in information about cards and pages then use a table card to filter and display all of the input dataset on your given page. You could even set up hyperlink beastmodes to go directly to the dataset.

You'd want to split your data so you have two columns, one for customer and one for country. You can use SPLIT_PART to split the strings based on a specific character and which part you want: Customer (get the first part when splitting the string into sections based on the - character: SPLIT_PART(`field`, '-', 1) Country:…

Hi @Crystal_Z Currently it's not possible to dynamically change the dataset on a daashboard dynamically. You can use a drill path to display a different card with a different dataset but that would only apply to that single card and not your entire page.

Change the way you store your data such that each action has its own row date action 1/1. A 1/1. B 1/2 a 1/3 b etc. You can utilize the calendar dataset from the Domo Dimensions connector to left join your data set t twice based on the ever a date and based on the event b date and append those two together. You may need to…