MichelleH Coach

@Ankur If you are joining on Country List and still getting more output rows than expected, then the Country List field is not unique. You will need to remove duplicates by the Country List field.

@carthur On your second formula, you are getting an error because the logic needs to be within a case statement. I'd suggest doing this instead: case when YEAR(`ORDER_DATE`) = YEAR(DATE_SUB(CURDATE(),interval 1 year)) and ORDER_DATE <= DATE_SUB(CURDATE(),interval 1 year) then 'Include' else 'Exclude' end

@Ankur You will want to do a left join in MagicETL with Employee Headcount as your left table so that you keep all employee headcount rows but not all country mapping rows. If your output still returns more rows than what exist in the Employee headcount, then there are likely duplicates in your country mapping table. You…

@nmizzell You can enable a secondary y-axis for the cart under Value Scale (Right) > Show Right Scale. Then you can use the Lines on Left Scale to specify which series will appear on which scale

@Dheeraj_1996 If you only want to keep positive variances across multiple rows, then you'll need to restructure your data to include a column to include the previous days' records value. You can do this by using the LAG function in the MagicETL Rank & Window tile. Once you have added this column you can use a single…

@Dheeraj_1996 I see. Based on the example in your original post it sounded like you wanted to simply add them. In that case, the issue has to do with the ELSE 0 your outer case statements. I'd suggest changing your formulas to be structured like this: Today: SUM(CASE WHEN event_date = CURDATE() then records else 0 END) -…

@Dheeraj_1996 You should be able to use @nmizzell's logic if you change the aggregation from COUNT to SUM

@DavidChurchman I don't see anything in your beast mode that would be causing the issue. Have you changed anything under the Trellis settings?

@DavidChurchman I'd suggest removing your sorting for now and looking at the the beast mode in your Y-Axis. How are you aggregating your measures?

@kodonnellLT If you want to create calculations for the first 6 months an last 6 months of the year, you will only need to compare whether the month number is greater or less than 6 like below. Jan-Jun SUM(CASE WHEN MONTH(`Period`) <= 6 then `a_amount` else 0 end) July-Dec SUM(CASE WHEN MONTH(`Period`) >= 7 then `a_amount`…

@AFrancis0219 Since you have single quotes around your numbers, they are actually being read as text and being sorted alphabetically. If you remove the single quotes and the ELSE, then they will be read as numbers instead

@StuM To keep the text, just add ELSE `Certification` to your case statement for any rows without a URL

@StuM I'd suggest using a case statement to only include the HTML formatting if the Program Guide URL like below: case when `Program Guide URL` is not null then CONCAT('<a href="',`Program Guide URL`,'">',`Certification`,'</a>') else `Certification` end

@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