MichelleH Coach

@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…

@Kyle_Russell It looks like there are some spaces in the as well. If you wrap a TRIM function around it that should work: CAST(TRIM(REPLACE(`Amount`,',','')) as DOUBLE)

@Kyle_Russell It looks like the commas are causing the numbers to be imported as strings instead of numbers. Try this formula to remove the commas and convert the datatype: CAST(REPLACE(`Amount`,',','') as DOUBLE)

@Kyle_Russell Could you send some examples of values in those columns? If there are any extra characters, like dollar signs, in the original fields you will need to remove them before you can use the alter columns tile.

@deona720 You only need to include the word CASE once within a case statement, but every CASE must be concluded with the word END. I also recommend using the LAST_DAY function (which returns the last day of the month) over the MONTH function since it also accounts for the year. Your formula should look like this: Case…

@ScottLeeds I recommend using a beast mode with the IFNULL function to default to the Pre-Lease % Summer 2024 value when present, otherwise use Pre-Lease % 2024: IFNULL(`Pre-Lease % Summer 2024`,`Pre-Lease % 2024`)

@robdmitchell There are a couple different ways you could do this in MagicETL: Date Operations Tile: Use the Difference between dates operation, with hours as the unit of measurement Formula Tile: Add a field with the following formula: DATEDIFF(`DateTimeOff`,`DateTimeOn`)*24 +…

@haihoang According to this Knowledge Base article, FIXED functions do not currently work on federated datasets. However, based on your screenshot you do not need to fix by ent_name if you are already grouping by that field in the X Axis. You can just use a sum of intDuration in the Y axis.

@Jason Is Curious Are you using the same field for the color rules in the "Series for Color" spot in Analyzer?

@Jason Is Curious How many programs do you have? Would setting Color Rules by program work for what you need?

@Viswaja Do you have any fields in the Sorting section of Analyzer?

@Mendoooza Check out the DataSet Copy Connector, which can be used to transfer data between instances

@ArborRose That's correct. The reason I mentioned the Domo Dimension Connector is that the "calendar.csv" report includes fields to indicate whether each day is a weekday or holiday, which you could use to exclude non-working days from your ranking

@ArborRose What if you used the isWeekday and isHoliday fields in the Domo Dimensions Calendar dataset to create a "Working Day of Month" dimension that you use for the X-Axis in your cards? You should be able to apply a rank window function partitioned by month and year to all the non-holiday weekdays to come up with that…