ColemenWilson Coach

If you used variables or segments then set the card to be adjusted by variable/segment and set the smart text to be the variable or segment value, which you could set to be month name for example, which would set the title to "July # of completed tours…"

The group by looks fine, although I am not sure what JT158_WTNumber is and if it should indeed be included in the grouping. Have you inspected the data table that is the output of the ETL and the input to the card? I would open that up, filter for SO# 0024812 and see if the data looks correct for that SO#. I would also…

Okay, are the number of SKUs each store sells fixed? I have a solution that is a bit hard coded, but works. It involves using lead functions with beastmodes. It wouldn't work if the # of SKUs each store sold was always changing.

To replicate what you are doing in excel, you could keep the source data in excel for any or all of the tables, connect them to Domo using the OneDrive for Business Connector, upload them using the file upload connector, use the Email connector to have the files sent by someone to Domo via email, setup SFTP, or use the…

This worked for me (only difference is I omitted the single quotes around 3): Here is the data I used: And the card with beastmode applied: Are other filters or sorting applied to your card?

Is this the complete data table for this retailer?

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:

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: If you mean they change as in the actual structure of the cards change then you would want to use variables as dashboard "Controls":

@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. 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?