MichelleH Coach

@Laura_M1 I think we need some more information about how your data is structured and what you want the card to look like. Could you please share some mockups or screenshots with any sensitive data hidden?

Also can you show an example of how you are trying to subtotal your beast modes, along with the formula you're using?

@Laura_M1 Yes, you can add as many conditions as you want as long as each one is preceded by "WHEN" like this: case when A then B when XYZ then 123 when blue then red … else 'Other' end You can find more about Case statements in the Logical functions section of this Knowledge Base article:

@calvert_schaefer The absolute value option is likely the simplest way to do what you're describing. You could also add a request to the Ideas Exchange to add a "Not Between" option to quick filters.

@jrtomici If you are using MagicETL, try using a Group By tile to condense your table. Set ID and Name as your columns to group by, and add a formula grouping for MAX(Source). Note that this will keep the source that is last alphabetically since your example includes "A" and "B" as your values, but you may need to use MIN…

@Rick I'd recommend adding a customer rank column to your dataset using the Rank & Window tile in MagicETL. Then you can filter your summary cards to Rank <= 20 to show the total of the top 20.

@khuebsch I have not tested whether the reports will keep running if you delete the user first, but I would recommend changing the owner first to avoid disruption. I am not aware of a way to bulk change the owners of scheduled reports

@khuebsch The user can re-assign the existing scheduled reports by opening the Scheduled Reports page and selecting Change Owner. That way you do not have to recreate the reports from scratch

@HowDoIDomo This is certainly not an elegant solution, but you could download each batch uploaded from the dataset history and manually add the updated date to the file to create your historical dataset. You would have to start with the very first time the dataset was uploaded and work your way forward.

@Yadhuveer It sounds like you will need to take the average quantity in a dataflow first. You can do this using a Group by tile in MagicETL and grouping by A, B, C, D, E,Quantities,part no 1, part no 2,A_part no 1, A_part no 2, M_part no 1, M_part no 2, E_part no 1, and E_part no 2. Within the same tile, take the average…

@HowDoIDomo Is there some sort of identifier in your dataset that you could use to determine the date or month?

@Ashleigh What if you tried a Waffle Gauge and set your symbol as a star with a target value of 5?

@ColemenWilson Great minds think alike!

@Andy_A You can add a title for your target under Chart Properties > Target > Label. That label will appear above the grey target value inside your dial

@D_Markley34 The main issue appears to be due to the syntax of your distinct counts. The Count function only expects one argument, so it does not know how to interpret the Training ID and Employee ID within the count. In order to take a distinct count of a combination of values from multiple columns, you will need to…

@pauljames I noticed that you're using a spreadsheet upload as your input dataset. Depending on how often you need to upload the file, you could try using Excel's text to columns function to break out the columns before uploading to Domo.

@qzqzqzqzqz There is an option under General Chart Properties called "Auto Zoom to Data". If you check that box, it will adjust the map area based on whatever filters you apply

@dnewc What connector are you using? Many have more options on the "Advanced" tab under Scheduling.

@Ajita If you haven't already, try manually running the jobs to see if they are successful. If they still fail then I suggest the following: Verify that the Workbench user is still logged in. If that user recently had a changed or expired password, then you will need to re-authenticate in Workbench with the new credentials…

@Samuel. Can you show a screenshot of how you set your color rules?

@A_Benincasa Here is an example of what this would look like. I actually used the "Dataset Details" report from the Domo Governance Connector instead of the DomoStats connector since it already includes the Owner Name instead of just the Owner ID. Note that if you want to only include datasets with the "Delete" tag in your…

@Sbhatia If you add an Alter Columns tile to the ETL you can change the data type of your date field from text to date. You can read more about this tile in this Knowledge Base article:

Good catch @MarkSnodgrass!

@NathanDorsch Does the card you created have a beast mode that references the variable yet? The dashboard variable control will likely only show variables that are being actively used in the cards.

@NathanDorsch Have you tried using Domo Variables? If you create a numeric variable for reduction percentage, you can use that variable as an input to your beast modes on the dashboard.

@afieweger If it is always the same character that is showing up, then you can wrap your entire statement in a REPLACE function to remove all instances of the '>' character like this: REPLACE(RIGHT(`Sent Email`,((LENGTH(`Sent Email`))-(INSTR(`Sent Email`,'@')))),'<','')

@A_Benincasa If you create an ETL to join the Dataset Tags report to the Datasets report (also available in the DomoStats connector) you can pull in other details from the dataset, including owner

@Deepali_Chaudhary That's currently not possible. I'd suggest adding an enhancement request to the Ideas Exchange.

@RayRay_H (A AND B ) OR (A AND C) should work for what you want to achieve, as will your case statement with multiple conditions. Grouping different conditions using parenthesis is generally best practice if you are using just one line to avoid ambiguity. We need a little more information about what rows your want to…

@Deepali_Chaudhary I suggest starting with this Knowledge Base article about how to add hyperlinks to table cards. I am not aware of a way to navigate to certain page sections using a hyperlink, so I'd suggest organizing your content into different subpages that you can navigate to