ColemenWilson Coach

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…

Can you just type out the logic you need? I am confused when you say combine logic from 1 and 2 because there is some conflicting logic like Company name = MR and at the same time not = MR.

You can create a custom drill path instead of going to the default table view. In your custom drill path, just aggregate a value with email address as the first column and there won't be duplicates.

Do you mean a beastmode? Or a new column using a formula tile? Either way, here is the code for it: COUNT(DISTINCT CASE WHEN (`Company Name` NOT LIKE ('MR') AND `Destination` IN( 'MR', 'TC', 'L', 'NP', 'PP')) OR `Company Name` = 'MR' THEN `ID` END) You can't have logic that says

Correct!

I would assume that when I click the check box next to groups in Admin that a trash icon or delete option would appear, and articles I've read support this, but this is not the case for me. Similar to within the "People" tab, when I click the check box, I get this blue bar. However, unlike in "People" where a trash icon…

You could solve this by creating a beastmode that references the field and use that for the filter card. It would look like this: Be sure to save the calculation to the dataset. This is an easy quick work around to your problem. Default selection is not possible with checkbox selector unfortunately. You can only apply…

Not sure I understand what you are trying to do. Could you perhaps provide a sample data table of what you would hope the output would look like and identify which columns are from which dataset? Sample data from both datasets would be helpful as well.

There is a beta you can participate in by reaching out to your CSM. It is the Column Masking PDP beta. It will allow you to hash data in Domo. Disclaimer: beta participation is not guaranteed and is by request.

Agree with what @MarkSnodgrass has said. I would add that you could use color rules that when the value is under 25 it is green and when it is above it is red, etc…

You can also switch the axis to be displayed as a date by going to: Admin > Company Settings > Company Overview > Cards > Week display > Week Dates (1/15/2001) This will change all cards graphed by week to show as a date instead of week number. If you don't want to do that, you can change from Week number to a custom date…

Gotcha! App Page/Tab get used interchangeably and it can be confusing. For hiding tabs, it seems like that should be something doable, as the Tabs editing interface is almost identical to App Pages. As @TOccon said, submitting this to the ideas exchange would be best. I will upvote for sure!

You're welcome!

Yes. Go to your app and then: Edit > Pages and navigation > Order > (select the app page) > Page settings (the cog icon) > Include page on navigation This will keep the app page, but hide it from users viewing the app: Before: After: Pages and navigation view shows hidden icon:

Hey @cookx775 , This is currently an idea in the ideas exchange. Please upvote it here! It has 87 upvotes currently, so there is a good chance it will happen, but every upvote counts!

In the meantime, you can "see" deleted reports by joining your activity log with your Pages domostats data. Anytime there isn't a match on Page ID, then that is a deleted report. If you have a deleted page you need to recover, it is possible (potentially at a cost) by Domo. Reach out to your CSM / AE for help on getting a…

This would be so very helpful. Thank you for posting this @ArborRose !

Unfortunately with that chart type you cannot plot an office location. You could, however, using the lat/long card. You can adjust the size of each bubble shown on the map based on a value, and in the below example, added the office location to the data with a value of 1 and then allowed the other location values to be…

Which map card are you using? The only map card chart type in Domo that allows for pinpoint locations is the Lat/Long map card. Alternatively, you could create a custom map card using a DDX brick.

Yes! Instead of Move/Copy, select "Save As" and then choose that dashboard as the location:

I think what others have said are more likely, but I am curious if this has anything to do with the ETL mini-map beta. Are you a part of that beta? You'll know if you are if this map pops up in the bottom right of your ETL:

Would love to collaborate on this with you @david_cunningham . I can get the rank of each customer by state in the beastmode, but I am having trouble with displaying them as a hover text. You'd need to use something like a group_concat() which I can't get working in a beastmode.

Hi @mcruz24 , I think what you are asking is can you multiply two fields together to create a new field, example: Value * Weight = Weighted Value. You can do this in an ETL or in a beastmode. For the beastmode, it would look like this (swapping out your field names): `Value` * `Weight` Then, you can use that beastmode as a…