david_cunningham Coach

Yes - if you're always wanting to highlight category C and F, you can do that via color rules and just apply to the entire row. If you're wanting to highlight the highest category dynamically, you can create a beast mode to identify the highest category, and then use that in your color rules. To do this you'll want to use…

@Lu_zhang you could achieve functionality similar to this by using variables. What you would do is create a beast mode like this. CASE WHEN Margin < Var_Margin_Concern THEN 'Highlight' ELSE 'Do Not Highlight' END You would need to set up the variable Var_Margin_Concern. Then in your color rules, set it to highlight where…

I would recommend pivoting out your data in an ETL so that you have a row for each status. You can then calculate the difference between each status/step by subtracting the 2 columns.

@ColemenWilson - great idea! They even already have an appropriate icon they could add on that's currently an option in App Studio. Something like this for columns… or this one for rows…

@rupinderkaur87 - you misunderstood my response. I was saying that my question to you was probably silly. The one about if your source dataset columns have changed. I was not saying your question was silly… I was simply pointing out something to check.

This is probably a silly question - but have you double checked to be sure that the source dataset columns haven't changed? I've never personally run into Domo dropping columns before, but I have had cases where columns stopped showing up because they were removed from the source dataset, and the dataset in Domo was being…

Just as a update to this. I still haven't been able to get text to display in mobile, but I did figure out a workaround, which is to use Buttons and just adjust the styling.

@Jmoreno - I ran into this a couple of years ago, and if I'm remembering correctly, it was resolved by clearing out some caches. Please reach out to support to confirm before doing anything to though.

@Lucky21 - based on what you described. I would recommend looking into a bullet chart.

Are you sure you're aggregating your values? Also, check out if you are manually applying a sort, that can sometimes mess with how charts are displayed.

@mroker Sure - just use the row number function within the Rank & Window tile in MagicETL to create a consecutive unique id.

@Mojoe - @GrantSmith has a great answer to this question. You can check that out here. Another potential option that won't require you to restructure your data, is to just use 2 cards, one for open, and one for closed.

Unfortunately Mega Tables do not support HTML tags or style attributes. See the below documentation. If you have control of the images you are trying to use, your best bet is the change the source image size.

are you using an html table or mega table?

This is really cool @ArborRose - love that you're thinking about how to be as accessible and inclusive as possible!

If I'm understanding you correctly, you want to add 2 numeric columns (Spot & Fixed) when another unnamed column is equal to the value "GET". If that is true. CASE WHEN Unnamed Column = "GET" then Spot + Fixed END If you want to aggregate up, you can either do that in your card settings, or in the beast mode itself.…

Just to expand on what @Jonathan53891 is suggesting. You are able to use different columns in your display and sort. So you can display (Jan, Feb, Mar: the text values), but can sort on a numeric field to make sure they display in the proper order.

You should be able to schedule an entire dashboard via the following.

If you create a filter view for "Current Month" or "Current Month to Date" it will automatically update as you move into a new month. If you want to allow users to select prior months, they can either select "None" and then add/save their own filter view. Or you can use a filter card like I show below, and when they make a…

Yes, that would be the ideal place to make the change. Just cast the column as a date, and not a date time.

Ahh - gotcha. I was referring strictly to credits used from creating/updating tables. Domo does also charge for data storage at a rate of 1 credit per million storage rows per month. Since you are in the process of migrating, I think this might be worth reaching out to your Domo Rep to explore possible options. Another…

Yes, create a beast mode to calculate the % of total. Then use that as your value. SUM(value) / SUM(SUM(value) fixed()) Here is a reference on FIXED functions

It sounds like you have entirely separate new datasets powering your new data flows. In that case, you don't have to delete the input datasets to stop using credits, just have them stop updating in the same way that you have the data flows not updating. To directly answer your question though. If you delete the input…

@ABauman This is because Domo is applying a timezone adjustment. Domo assumes that date times are loaded in as UTC, and adjusts to your company timezone. In this case, you can fix this by changing the column type to be a date, and not a date time, and the adjustment won't happen. I'd also recommend checking your other date…

@Data_Dev - here is a link to the entire post.

SUM(CASE WHEN product code number= 83 and units= 'SF' then Quantity END) @Mvolkmann - here you go. You can use what's called a case statement to return quantity when those conditions are met, and then sum the results.

@Data_Dev, I'm suggesting the opposite. If you take your monthly budget values, and turn them into daily budget values (by either dividing by the number of days in the month, or aggregating up to the year and dividing by the number of days in the year), you will end up with daily budget and daily actuals. This will let you…

You'll need to do some mapping to create a way to join. I would also personally recommend aggregating up to a daily budget/actual amount in your ETL. You would then need to join to a date dimension table to fill in data for days where there were no "Actual" sales, but there was a budget. Together this will enable you to…

Are you using a Google workspace company account or a personal account? I haven't run into this issue with the Google Sheets Connector before.

Would all of the values that you wanting to use to populate the Word document be from the same row? Would you only want to pull in a single row at a time?