MichelleH Coach

@aarguijo I'm glad you got it to work! Please be sure to mark my response as the answer so that others can find answer more quickly

@chrissy You will need to sort by the sum of the “Total Activity” field from your card (descending)

Linking to Ideas Exchange post requesting to add these definitions to the KB documentation:

@chrissy Does it sort correctly if you change the order of your sort fields (i.e. drag “Number Sorting” above “Sorted Day of Week”)?

@aarguijo Does it still return no values if you change it to this? case when DP Response 2 LIKE ‘DP: Sorry%’ then 1 end If you see 1s populating, then that means there's not data in the User Question 2 field. If not then there's something wrong with the condition, for example there are extra spaces in the string you're…

@aarguijo The apostraphe is likely what's causing the syntax error. Instead of CONTAINS, you would want to use the LIKE operator like this: case when DP Response 2 LIKE ‘DP: Sorry%’ then User Question 2 end

@chrissy Since you're using a pivot table with different dimensions in the rows and columns, you will need to add the ranking in MagicETL using the Rank and Window tile. Then you can filter the card to only include rows where the ranking is 20 or less.

@chrissy I agree with @RobSomers that it is not sorting correctly because it is viewing the field as text. You can also sort by HOUR(`virtual_checkin_date`) since that is already a numeric field.

@Salmas I apologize, I read that too quickly. I don't see anything in your formula that would cause it not to work. Can you give some more details on the output you're getting vs expected?

@Salmas The best way to rename fields is by using the Select Columns tile in ETL

@ALCIIAAZV That's good to know. Is there another card or visual you could add in the chart area?

@zgranperc If your report is only going to be sent out on Fridays, then you can set your card date range to Last 8 Days and use this beast mode to filter out today's data: case when DateField = CURRENT_DATE() then ‘Exclude’ else ‘Include’ end

@lb1234 How are you planning on visualizing this data? If you don't need to display the rank number then it would be simpler to graph count(distinct Opportunity Id) the data by the week of Project.SaleDate then sorting high to low by COUNT(distinct Opportunity Id).

@akki My understanding is that once a Workbench job is scheduled, then it needs a valid dataset destiantion. If the dataset is deleted, then it no longer knows where to load the data. The cleanest way to resolve it this issue is to rebuild to job since creating a job will also create a destination dataset in your Domo…

@akki If you deleted the dataset, you may need to recreate the Workbench job. In the future I'd recommend overwriting the original data by setting the update method to Replace, instead of deleting the dataset.

@ALCIIAAZV I'll have to think about the best way to handle the user filtering. To hide the chart from the dashboard, you can uncheck the Chart option under the card's display settings when editing the dashboard.

@chrissy Depending on the chart type you're using, that should work as long as you also have your data sorted. Can you please share a screenshot of the analyzer (hiding any sensitive information) so we can help troubleshoot?

@ALCIIAAZV If you change User ID to MAX(`User ID`) in your beast mode you don't have to select an aggregation in the Summary Number

@Clinton Your logic should work, though for future reference you can simplify it using an “is null” operator like below: case when Parent Carrier ID is NULL then Carrier Name else Parent Carrier Name end

I'd also love option to choose whether or not to include the “Duplicate of” prefix in the names of copied cards in this step!

@NickMcGraw Are you using MySQL or MagicETL? Also, is it possible for the metrics_searchImpressionShare field to have a value of zero? If so you may be encountering an error when it tries to divide by zero.

@ttronson As far as I'm aware, Domo does not log the specific filters that users select. I'd recommend posting this to the Ideas Exchange as an enhancement to the Activity Log or DomoStats.

@NathanDorsch You can use a beast mode to filter out the current month like this: case when MONTH(`Date`) = MONTH(CURRENT_DATE()) and YEAR(`Date`) = YEAR(CURRENT_DATE()) then ‘Exclude’ else ‘Include’ end

@ArborRose Have you tested whether it will work when exporting to PowerPoint? If that works, you could always re-save the PPT as a PDF once it's downloaded.

@JenHarrison If you are presenting from a dashboard I suggest opening it in the Full Screen view, which will hide unused icons. If the dashboard icons aren't important, but you need to view a card individually, you can open it in a pop out view directly from the dashboard (as opposed to opening the card details page),…

@ArborRose That makes sense. You can also limit which columns you need to load from your input dataset to reduce the amount of time to takes to load. That said, I've found that MagicETL v2 can handle some fairly complex transformations and is generally more efficient than MySQL. Ever since Domo upgraded from the previous…

@ArborRose Although you are limiting your rows in the transform, Domo's SQL-based dataflows still need to load all rows of the input datasets before executing any transforms, which explains why it is taking so long. For something as simple as what you're trying to do, I'd recommend using a Dataset View or MagicETL instead…

@ALCIIAAZV Have you tried adding the link to the summary number instead? Then you can hide the chart from the dashboard and only show the summary.

@NateBI I don't believe this is a feature that's available, but if you need to manually center it I suggest adding text boxes above/below the table and adjusting those layouts so the table is centered.

@ArborRose Yes, the 500k limit is just referring to previewing the data. According to this best practices article, MySQL dataflows are best suited for transformations where the inputs are under 100 million rows. It's not out of ordinary to have MySQL run times beyond 30 minutes, but you should be able to optimize the…