ColemenWilson Coach

You could use a filter on your card like this: CASE WHEN DAYOFMONTH(CURRENT_DATE()) = 1 AND DateField < CURRENT_DATE() AND DateField >= CURRENT_DATE() - INTERVAL 1 MONTH THEN 'In' WHEN DAYOFMONTH(CURRENT_DATE()) != 1 AND DateField >= LAST_DAY(CURRENT_DATE()) + INTERVAL 1 DAY - INTERVAL 1 MONTH AND DateField <=…

Yes you can do it in a beastmode. LEFT(`FSJ No.`,4) Then bring that field into your table twice, once without modification and once as a count aggregation.

If I were asked to do this, I would append the data in Magic ETL and create 2 new fields: A date column that contains both sales and return dates A flag to indicate if that row is a sale or a return Then in a beastmode you could do your calculation: COUNT(CASE WHEN `NewFlagField` = 'Return' THEN `Reason` END) /…

In MagicETL you are only previewing 100 rows. I see in the second image that there are 1,737 unique values for the BMI Work Number in your final output data. It appears that the data is there and that there are also null values for that field.

You could normalize the data: Or just divide by a thousand, or ten thousand and then use a chart type that allows for multiple axis labels (left and right) and be sure to label the axis that has been adjusted to read "In thousands" for example.

I am pretty sure it is one of the "Domo Sneaks" things coming but not yet available. The product release yesterday was just for the AI Service Layer. You can use Domo GPT in models in Domo. Chat is coming in the future.

Just create a beastmode field that references the field you are using to filter. Example below: Then use this as your filter for the right side. You can also use filter exceptions.

I've checked the Alpha, Community and my personal instance and it isn't available in any of them. It may require a feature switch. I've reached out to my CSM to see if this is the case.

No, you would use two columns to identify the grouping as shown below:

You have the right idea. Group By tile grouping by Employee ID and Month and aggregating max date. Is that what you've done? Could you share a screenshot of your group by configuration?

Yes you can use inline editor for this: You could also utilize variables to do "what if" calculations:

No what I am saying is that when they are the same, you will get the result you pictured above. The idea of a nested bar chart would be, for example, to have products as bars and product categories as nests. If a product is both the bar and nest it will look like what you have pictured above.

I believe it may be because your x-axis and series are the same field. Or perhaps that your y axis aggregation is the same as your series or x axis. I was able to replicate this by having the x axis and series the same field.

This is not currently possible natively in Domo. You could suggest this as a new product feature in the You can apply a color rule to an entire row, which would apply the color rule from the beast mode to the other column, and every other column in that row. Otherwise you would need a way for the output in the other column…

This is a great place to start: If you provide some sample data I could help out. You can modify sensitive data as needed. The part I'll need is how you split up (what the delimiter is) the Impacted Business Division field.

Yes. In analyzer view, click the v and then check "Hide subtotal" as shown below:

You'll need to split the values out in an ETL so you can count them for each occurrence of the key word. You can do this using the split columns tile in magic ETL. Then you can unpivot your new split columns into rows using the unpivot tile. Here is an example of what this would look like: Before: Impacted Business…

I don't believe this is currently available. I am sure it will be coming, new App Studio features have been included in each release. For now they could open the card details and start a buzz conversation there.

You can use the SUBSTRING_INDEX() function in a formula tile in Magic ETL: SUBSTRING_INDEX(String, ':', -1)

That is beyond my skillset. Perhaps @ellibot, @GrantSmith or @ArborRose could help.

Are you using the Oracle Database Writeback Tile? How are you getting the data from Domo to Oracle

Well, you could narrow it down by filtering to Type = DataSet via Email in the Domo Datacenter. Then you can see the email being used in the settings of each dataset. Hopefully there aren't too many and you can find the correct one. I'm sure there is a way to do it using the Domo API but hopefully this will get you there…

You can use the DAYOFWEEK() function to identify and remove weekends - days 1 and 7 (saturday and sunday) CASE WHEN DAYOFWEEK(`YourDateField`) NOT IN(1,7) THEN Your beastmode END

You can use the input multiple times, just drag lines from the input to additional tiles. You could then join the data as needed.

Do you have a sort applied to your card? Remove it and see if it groups properly.

You could use filter exceptions on that card so it is not impacted by the global date filter.

I've done something like this before. You'll need to display the two different data sources side by side on a dashboard or app. You'll need to use PDP on one dataset (their account data) but not on the anonymized data. Then just create the visuals you want and then duplicate them all for the full customer base and swap out…

My next steps would be to calculate the variance between budget and actual - this would be your y axis and then choose how you want to view it - by location, by account, by doctor, by date - whichever you pick would be your x-axis. If you want to view by each of these you could create a variable and the end user could…

You can accomplish this in Color Rules. Here is an article explaining color rules:

Pages too!