ColemenWilson Coach

Chart Properties > General > Hide Empty Values:

Do these files exist in OneDrive? If so you can use the OneDrive for business connector which is quite easy to setup and maintain: https://domo-support.domo.com/s/article/360043436753?language=en_US

You'll need to do some ETL work involving window functions. First, you will need to compute the average for each combination of year & assessment window. Here is how you would do it: Step 1: Create an average grouped by year and assessment window Step 2: Join the averages back to your data on Assessment Window and Year…

Using the Replace Text tile, do the following: The 2nd one is a bit hard to read in the screenshot, it is: \ . . * Be sure to check "use regex" for both as shown below:

Could you provide some sample data? I am trying to better understand the values you are working with and how your data is structured. For example is 'On/Above' a text value or a number?

Yes, if the data displayed on the 2 cards exists (or could be made to exist) within the same dataset then you could compare the values. Something like this: CASE WHEN school value < network average THEN 'Below' ELSE 'Above' END Then set the color rule based on above or below.

The cards have no way to communicate with each other in that way, you will have to set color rules based on certain values that appear within that card. You can, however, have a filter applied to one card from another card and then have the filter effect color rules. Here is a KB article on dynamic color rules, use case #2…

Thank you for sharing the sample data, that is helpful. What I would try is putting together a table of items and their associated prices per state (this could be done with a Domo webform or Excel File upload), then join that with your data provided above on item name and state (and date because I am sure the prices change…

Okay, so there is never a mix of items sold in a single row of data? It is always a single item, but in any quantity? Is this what your data looks like: So I sold 2 of both widget A and B, and you sold 1 of widget A and B. Or does it look like this, same sales activity as the previous table:

This sounds like something better solved in the source system. Is it possible to prevent this type of activity from occurring? Unless you know which items are included in the total revenue amount it would be very difficult, if not impossible to determine what items are included with only the total amount and number of…

Hi Dani, If you mean they change as in a filter has been applied, then you would want to either use the dashboard filter bar or a filter card: https://domo-support.domo.com/s/article/360042923914?language=en_US If you mean they change as in the actual structure of the cards change then you would want to use variables as…

@b_rad nailed it! Additionally, if the event is in-person, the ask an expert/genius bar booth that we've seen in the past would be awesome.

This KB article may give you a better idea of what is happening. Not sure it fully answers your questions. The way to prevent this from happening is by having content query the data, such as cards and dashboards. The nice thing is that if a dataset becomes non-queryable the data will still update and be used in dataflows,…

DONE

Drop this formula into your filter tile, be sure to select "Add formula rule" as the filter type: `date` <= `wipe_date` AND `date` >= `forecast_due_date`

Yes, it is possible. What problems are you having when joining?

I would recommend using the split column tile in magic ETL. https://domo-support.domo.com/s/article/360045402873?language=en_US It would look something like this:

You’ll need to pivot your data in Magic ETL so that it is not a single column but is instead rows of data for the 3 columns: month, sessions, total users. Once you’ve done that you will drag month to the x-axis, and sessions and total users as values.

That is correct. You can still control: Can Share, Can Edit and Co-Owner levels of access.

No you cannot. You would have to do: CASE WHEN `session_medium` LIKE('%Email%') OR `session_medium` LIKE('%email%') OR `session_source` LIKE('%Email%') OR `session_source` LIKE('%email%') THEN 'Email' ELSE 'Whatever' END I would recommend using LOWER() function so you don't have to have both Email and email in your…

The IN function is supported and your case statement looks correct. There may be an underlying data issue, capitalization issue, or something else.

If a connector has a date selector in the connector settings then you can set it to update only the last X days and append that to the full history data in an ETL and deduplicate with an optional rank function to keep the most recent version of each unique record. A unique field, such as an ID, and a system mod stamp or…

Okay, if your data is structured that way you can use the pivot tiles in Magic ETL to put your values that are currently rows as columns and then use the beastmode provided above. I also got it to work this way: CONCAT(MAX(CASE WHEN name1 = 'dheeraj' THEN name2 END),'<br>','•',MAX(CASE WHEN name1 = 'sandhanshi' THEN name2…

Wouldn't you just want MAX for both of the working days in month denominators?

Would something like this work: CASE WHEN DATE_FORMAT(`datefield`,'%m/%Y') = DATE_FORMAT(CURRENT_DATE(),'%m/%Y') THEN partial month logic ELSE full month logic END Basically, if the date if part of the current month then do a partial month calculation.

Try moving line 7 to line 15

How is your data formatted? If it is not formatted properly it could easily be reformatted to meet your needs.

This is something I have done both with a DDX brick and a standard text card. The text card is probably easier. Here is the beastmode: CONCAT(`Title`,'<br>','•',`Value1`,'<br>','•',`Value2`) There are a variety of bullet symbols, some can be found here: https://www.symbolcopy.com/bullet-points-symbol.html Additionally I…

If you have a table like the one you shared, you could join column B to your data on column A. Then you wouldn't need a formula at all and as new mapping is added by the other department the values in the reclass column will update dynamically.

Last 2 days: CASE WHEN Date >= CURRENT_DATE() - INTERVAL 2 DAY AND Date != CURRENT_DATE() THEN 'Include' ELSE 'Exclude' END Last 3 days: CASE WHEN Date >= CURRENT_DATE() - INTERVAL 3 DAY AND Date != CURRENT_DATE() THEN 'Include' ELSE 'Exclude' END