ColemenWilson Coach

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: https://domo-support.domo.com/s/article/360042933754?language=en_US You could also utilize variables to do "what if" calculations: https://domo-support.domo.com/s/article/7903767835031?language=en_US

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 https://community-forums.domo.com/main/categories/ideas 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…

This is a great place to start: https://domo-support.domo.com/s/article/360055259234?language=en_US 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 https://domo-support.domo.com/s/article/360042934614?language=en_US on one dataset (their account data) but not on the anonymized data. Then just create the visuals you want…

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: https://domo-support.domo.com/s/article/360043428813?language=en_US

Pages too!

You can accomplish this in Magic ETL. You can use the Domo Dimensions calendar dataset and join that to your data which will then allow you to group your data by day, week, month, quarter, etc… Then you can match up your periods for the billable hours vs hours paid. If you are using custom periods that don't align with…

Do you, or someone on your team, have access to Workbench?

Hmmm if you are doing a join based on the start and end dates, I think that may cause some issues. But if you just want a formula to check to see if a date is within the range you could use the formula tile and do something like: CASE WHEN `date` >= `Start Date` AND `date` <= `End Date` THEN 'Within Range' ELSE 'Not Within…

Awesome @MichelleH !!!

HTML easy brick would work! https://henryscheinone.domo.com/appstore/details/1EE8C50F3003F2324307CF9A7D89389D2536935BC504EF1706E6016BABAA1C32?origin=search

@david_cunningham thank you! Needed this today!

You can use a formula tile in magic ETL before your Alter Columns tile and use the below to remove the $. Then your alter columns tile should work:

ETL is just a series of tables you are creating. With each tile you are creating a new data table. You can apply the logic you need in a formula or filter tile and then from there create another formula/filter tile and so on. For the join data step in #3, you'll need to provide more information about the problem you are…