MarkSnodgrass Coach

@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…

You can use the dynamic textbox card to change the color of the value, but there is not an option to bold just the value. That would be a nice enhancement and worth submitting in the ideas exchange if it isn't already in there.

You should be able to do this by going to the Chart Properties and choosing General and selecting the Font Style and Font Color that you would like. Here is a screenshot:

Have you tried adding a filter in the analyzer of "# of users > 20"? This should keep those smaller ones from showing when other filters are applied.

You can avoid even doing a beast mode if you put your date column in the pie name and then adjust your date range filter to graph by year. This will group all of your dates by year and do the work for you. See screenshot.

When you click on Add Filter and you go down to your Name column, do you see an arrow pointing to the right at all? Or is there no arrow? In the screenshot below, you can see the Acc Year column has an arrow pointing to the right. Do you have that in your instance? Are you using any PDP policies or other security policies…

Try deleting the filter and then see if you have the choices when you go to add it back again. When you are adding it back again, don't immediately click on the column name, look for the arrow to the right and click on that.

I think I had the same problem as you a while ago. When you click on Add Filter, click on the arrow to the right of the column you are wanting to filter on. Then click on Select All. Here are some screenshots to help you. This should make your filter apply to all the datasets on the card. Hope this helps.

I like to use the Bullet chart type for this type of visualization. It allows you to have a different goal for each month (or names as it is referred to in the Bullet chart). Here is a link to the KB article. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Bullet_Chart

I think that screenshot is from an earlier release of Domo as I notice the total is not to the right of the Donut in that screenshot, like it is when you create a donut card. It is an interesting display option and you could submit it in the ideas exchange to see if they can add that functionality in the future.

I think there are a couple Domo features worth pointing out before working too hard on a beast mode formula. First, Domo offers a Fiscal Calendar feature. You just need to e-mail Domo Support to get it enabled and provide them with your fiscal date information. You can read about it…

Assuming you want to group by month and client, I would suggest adding a CASE statement to build the labels. It would look like this: SELECT Reporting Month, Client , sum(balance) as Clientbalance, CASE WHEN SUM(balance) < 10000000 THEN 'Less than 100m' WHEN SUM(balance) < 20000000 THEN '100m - 200m' ELSE 'Greater than…

Try this CASE WHEN `invoice number` = 325940 THEN 'CS10003' ELSE `customer code` END

What I have done when I need to anonymize names like this is create an Excel file that contains the client's real name and then another column that has a fake name. In my case, I needed to change last names, so I googled most popular last names, copied the list from the table and pasted it into my Excel file next to the…