ColemenWilson Coach

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

Yes, but it would require some ETL work. The way I have done this in the past is create 2 new fields: Max value and Min value . Then plot those on your line chart the same way you have plotted the HIGH LIMIT and LOW LIMIT.

These are currently the options for where to show data labels: This is a great idea and I would recommend putting it in the ideas exchange: https://community-forums.domo.com/main/categories/ideas You can of course see the max and min values by making sure these are uncheck in the chart properties:

Hi Larry, It will work when the conditions are met, when they are not it will be completely null. The solution here is to account for when the holds do not = 'Y' by adding ELSE to your case statement: CONCAT( CASE WHEN New Logo Hold = 'Y' THEN 'New Logo Hold' ELSE '' END, CASE WHEN My Product Customization Hold = 'Y' THEN…

So per 100 is the same as a % (25 per 100 = 25%). So basically all you need is a count of readmissions divided by a count of discharges on a bar chart with provider on the other axis. Then display this as a percentage. Is this what you were thinking?