MarkSnodgrass Coach

Does your organization use Google Analytics? If so, you can add the Google Analytics Quickstart App to your instance and it contains a pre-built card with beast modes that might be helpful for you. I have the quickstart app in our instance and there is a card called Average Visit Duration. They have a beast mode for…

Not sure if this will work since I don't have the data to work with, but might get you closer. Basically, I made a subquery that gets all the users and their survey data if they have it. I then left join it to the date table and moved the where clause information to part of the left join criteria. I am also hoping the…

@Cartergan Do you mind re-posting your SQL with a table alias for each column? I'm having trouble discerning which columns are from which table and that will make a difference when it comes to your WHERE clause, etc...

I have struggled with this at times as well. I assume you are trying to move these pages through Admin - Pages. What is not immediately clear when you are viewing the pages listed on this page is that it doesn't show you all the pages just by scrolling. In order to move pages not initially shown, you need to find them by…

@Cartergan The first thing that jumps out to me is that you need to change your table listing in your FROM clause. In order to get all of the dates from the dates table, that table needs to be listed first. Your FROM and LEFT JOIN syntax should look like this: FROM `date` D LEFT JOIN `qualtrics_responses` ON (D.`Date`) =…

You might also want to check to see if the access token you are using is expired. You can check on this by logging into your Domo instance and then go to Admin - Security - Access Tokens and look for the access token that is used for the workbench and the expiration date.

@Moberling I wonder if there are spaces in that field rather than it actually being empty and that is why it can't convert. Try bringing in a String Operations tile and use the trim spaces function to eliminate spaces. Then try the Set Column Type. You could also use the Combine Columns tile to try and expose what is in…

I can testify to the fact that this something Domo has implemented on all instances. I am involved in about 17 different Domo instances and any instance created in the last year or so has this notifcation in the corner and it won't go away until I do all of the things it says. On older instances, there is no notification,…

We have the Redshift SQL enabled in our instance and are able to use this SQL line to calculate a running total: sum(paymentamount) over(partition by ClaimNumber order by dateofeventyear,all_monthsofdev rows unbounded preceding) I'm not seeing this exact syntax available available in MySQL, so maybe you can get Redshift…

I think there a couple ways to solve this. First, in the State Value, choose No Aggregation. This will keep your phase value from summing. I would then add your Phase as a quick filter to allow users to choose which phase to look at it. You can use the Hover Text Settings and the Ranges to control the color and text that…

It doesn't look like stacked bar is an option in the period over period charts. There are about 7 different charts for period over period. I would try each of them out and see which one fits your need the best.

I would suggest the Period over Period cards. You could use the bar line, for example. You can then use the date range filter to compare it to the previous week, or much earlier, if needed. Here is a screenshot example: CORRECTION: The variance bar line would be a better choice as it shows the percent change. Apologize my…

Yes, dropping the Program Title from your select and group by statement will definitely help.

@DrGWright What constitutes all three being complete? Do you have a 'Program Enrollment Status 1' and 'Program Enrollment Status 2' fields as well that say Complete or Not Complete? If so, I would add to your WHERE clause that WHERE `Program ID` IN ('16','12','64') AND `Program Enrollment Status 3` = 'Complete' AND…

Without seeing the actual data (or a mockup of it) it is hard to give complete guidance, but here are a few things to note, followed by a cleaned up SQL statement: 1) Any field this in your select statement that is not aggregated, must be included in your group by clause. I noticed Program Title was not included in the…

Have you tried starting a new File Upload connector and uploading your file to that and just call it test? If that works, then it sounds like your existing connector is somehow corrupt and might require a call to Domo Support. 

Assuming your output dataset contains something like the following columns: Fiscal Week Number Registered Count Budgeted Count You can create a grouped bar chart by putting the Fiscal Week Number in the Category field and add the Registered Count to the Value field and the Budget Count to the Series field. Set both of…

I didn't have a Google Sheets file to work with, but I did have a SharePoint Connector Excel file to test with and see that it is doing the same thing. Subtracting 5 hours. It could be worth a call to Domo Support to see if it is a bug with these connectors, or understand their reasoning for not adjusting the time to your…

@user01804 in the Admin section, under Company Settings - Company Overview, there is a Time Zone setting. Make sure that is set to Eastern. Domo should be looking at this setting for imports.

It looks like a tootlip does show up if you add a description on the schema page of the dataset. This first screenshot is from the schema tab showing the added descriptions: And this screenshot is from the Analyzer. Notice that there is a "i" icon next to the field that has a description. If you click on it, it will show…

In the Subtotals Chart Properties, if you scroll down there is the option to Show Subtotal Columns. If you check that, you can then collapse the columns as well.

You need to have two fields in the Rows section and then you also need to turn on Show Subtotal Rows in the Chart Properties - Subtotal properties. It won't show unless both of those are in place.

Since comparative gauges only read the first row in a dataset, I have found building a magic ETL dataflow to calculate the previous value and put it in the same row as the current value, the best way to power the comparative gauge. You can calculate the previous value by using the rank and window tile in the ETL. Here is a…

I would suggest using the Select Columns in the ETL dataflow. This will allow you to rename your columns to friendlier names. You can select just a few columns or select all columns and then just rename the ones that you need,

If you are able to use Magic ETL, you can use the Split Columns tile to eliminate the extra information and just give you the date. Add a Split Columns tile and choose Comma for the delimiter to split on. In step 4 of the tile, name this first column Day, then add another column and call it Date+Time. Next, add another…

It's unfortunate that there is not a time-to-serial function that would convert a time to a numeric value like there is for dates in other languages. I would divide your minute by 60 so that it becomes a properly calculated decimal value. It would look like this: ABS(CONCAT((HOUR(TIMEDIFF(`lte_donation_phleb.stop_time`,…

A couple options for this. At the bottom of the card, it shows when the dataset was last updated. It looks like this: You can also create a beast mode field and make it display in the summary number area. Your beast mode formula would look something like this: CONCAT('Last run at: ',MAX(`_BATCH_LAST_RUN_`)) And it would…

I have used the preset date filter and it worked for me. I would re-check the interaction filters if you are using a story page. I have found them to be a little glitchy and not save everything every time.

Great post by @GrantSmith . You can also nest your CASE statement if that would cut down on your long term maintenance and in thise case just have one filter to check Yes to if you wanted see results for sunshine and mountains. It would look like this: CASE WHEN lower(`field`) like '%sunshine%' THEN (CASE WHEN…

Domo has a mega table card type that you can ask to get activated in your instance. It is still technically in beta, but allows for scrolling and a number of other features. Excerpt from KB article https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Table_Chart : Mega tables…