MichelleH Coach

@NFerna When using the LIKE operator, be sure to use the % wildcard so that it matches values that that contain the letters "TVS" but don't match exactly. It should look like Variety LIKE '%TVS%'

@Dev_ Subtotals of ratio calculations can show an unexpected result if the beast mode does not specify the aggregation. So, if your beast mode is Labor Cost / Labor Hrs it is calculating the ratio for each row individually and the subtotal aggregates the results. If you want your subtotal to represent the ratio of the…

@PJG You should be able to replace YEAR(Month,2024) with YEAR(Month) = 2024 to get the results you need since the YEAR function returns the year of the date field in parenthesis and you only want to consider rows where the year is 2024.

@pauljames What do you have set as the Data Selection on the input tile and Update Method on the Output tile? Is it possible either dataset is set to Append?

EDIT - @RobSomers' suggestion will work best for this case since the Benchmark Value and Name are columns in the dataset. I will keep my comment below for reference on the syntax in multi-condition case statements. @NFerna Your thought process is correct, but you just need a few adjustments to your syntax. You are likely…

@pauljames I agree with @DomoDork that blank values are likely the culprit. Are you using IFNULL or NULLIF? The former checks whether a value is null, the latter forces certain values to null. Try this formula for your filter to check for nulls and empty strings: `fieldName` is not null and trim(`fieldName`) <> ''

@JasonAltenburg Yes, I've tried on multiple browsers and devices. I was finally able to see it on my phone, so I suspect it is something with our Firewall as you suggested.

Thanks Grant. I've tried that as well, but still no luck.

Same here. I still only see CSV files on Scheduled Report attachments.

@MisterJimenez What chart type are you using? Is it the standard bar?

@MisterJimenez Could you please share a screenshot of what you see in Analyzer?

@jtrollinger Assuming you are defining the last invoice as the record with the most recent InvoiceDate, then you will need two steps to accomplish this: In the same Group by tile, include this formula to identify the most recent date having an invoice with "A" in the number: MAX(case when `InvoiceNo` like '%A%' then…

@Gavatar That does work the first time, but when additional data is added to a card with collapsed subtotal rows, the new data is not automatically collapsed. For example, let's say today I created a card that includes YTD data with subtotals by month. I can use the icon in your screenshot to collapse the subtotals so the…

@SamanthaC I'd suggest adding a file upload/webform dataset that includes a list of all profit sharing customers and their respective profit sharing rates. You can then join your source data to this table on Customer Name/ID in a MagicETL, then use a formula tile to add the following calculations: Profit Sharing Flag: case…

@art_in_sky By overlapped, do you mean there are duplicate rows? Would you be able to share some screenshots of what you're seeing (hiding any sensitive information)?

@art_in_sky I'd suggest using the Unpivot Tile in MagicETL to restructure your data into 3 columns: Chapter, Date/Month, and value. Then you can create a card with Date/Month as your dimension, Value as your measure, and Value as your metric.

@scpradhan Yes, here is an article on how you can add images (and links) to tables:

@ArborRose Have you tried using Color Rules to highlight columns/values?

@Jones01 The rank is likely what's causing the issue here. Since beast mode is dynamic, it is having trouble ranking a dimension while simultaneously also defining that same dimension. Here are a couple options you could consider instead: Change your chart type to a bar chart, where you can use the native "Max Number of…

@Jones01 Is there any sorting in your card? If there are, try removing the sort fields to see if that removes the duplication.

@KristinDavis I agree with @ArborRose about the format of the data. To get it into that format, I suggest using a Dynamic Unpivot tile in MagicETL to add Program as its own column. Then you should be able to create a card off of that output dataset with Date in your X axis, count/distinct count of user in the Y axis, and…

@rmbourne It looks like you are missing the % sign at the beginning of your second DATE_FORMAT function, so your second date is not being properly converted to a date

@scpradhan Could you please share some details of how your ETL is set up?

Completely agree! There have been multiple times I've had to add a tile to an input before appending and not notice that the Append Rows tile setting changed until after it ran.

@VictorLuiz Once you find out which time zone the instance is set to, you can change "GMT-8" in your formula to the corresponding IANA time zone name (e.g. "America/Los_Angeles").

@VictorLuiz What about your Domo instance time zone in Company Settings?

@VictorLuiz Is your instance set to a time zone that respects daylight savings? Daylight Savings Time began on March 10, so I suspect it is related to that.

@Sbhatia As long as the "Hide Date on Card Details" box is not checked, the user will be able to view data from previous months if desired.

@Sbhatia You can filter it to "Current Month" using the Date Range filter in Analyzer, as you would any other card

@TheScotsman To start, I would suggest learning more about SQL (specifically SELECT statements). Here is a good tutorial to get you started on the basics: . You can also learn more about MySQL Domo dataflows here: While knowledge of SQL is definitely helpful, unless you have a pressing reason to use MySQL dataflows…