MichelleH Coach

@Matt_DAlto Can you please share the other settings you have configured on the job? The error appears to be related to mis-aligned ranges, not necessarily nulls

@ncelis Try changing the double quotes to single quotes around 'Active' and 'Unpaid Leave'. Domo expects string fields to have be surrounded by single quotes.

@SayyedHussain This tends to happen if a (non beast mode) field with the same name has been added to the dataset. Do you know if a field has been added to an upstream dataset that the datasets you're using may have inherited?

@ncelis It looks like you're not using the correct syntax for the count distinct function. The word "Distinct" needs to be inside the parenthesis like below: COUNT(DISTINCT CASE WHEN (Team Member status = 'Active' OR Team Member status = 'Unpaid Leave') AND Date BETWEEN 'start_date' AND 'end_date' THEN Team Member ID END)…

@learnDomo By forcing null values to 0, the stages with nulls are likely being converted to an integer. Try changing the 0 to a blank string ''.

@learnDomo Can you please share all your beast modes for the various stages? Also, do you have formatting applied to any of the columns in your table?

@deona720 I suggest using the Dynamic Unpivot column in MagicETL to accomplish this. You can read more about how the tile works here: Edit: Grant beat me to it!

@DeclanCPS What fields do you have available in your dataset?

@DeclanCPS Is there a column in your dataset that indicates whether they have accounts in the previous question? If so, try adding that column as a filter in your card so that you don't have to change a beast mode calculation.

@CR123 It appears to be listed as "Coordinated Universal Time" in the time zone drop-down under "Formatting"

Hey fellow Cincinnatian! I was wondering about your Musketeer avatar

@yogesh_1 Is Fiscal Year a column in your dataset or are you using the native date range selector in the card/dashboard? If you don't already, I would look into setting up a Fiscal Calendar on your instance.

@Charlie Bantoft Total rows and columns will use the same aggregation as the "Values" field by default. In other words if the other values are being summed, then your totals will also be using a sum. You could try swapping a beast mode with a fixed function into the values field like this: avg(sum(`value_field`) fixed (by…

@jtrollinger Since you're using two beast modes with different definitions it's not realistic to expect them to match. Unless they were written using assumptions specific to your business, they don't seem to be comparable.

@jtrollinger Can you please share some more details on how your cards are set up? It's difficult to give suggestions without understanding your data

Number 7 is too real…

@jtrollinger Total rows calculate based off of values in the source dataset, not the aggregated values in the table rows. In this case it means that there were 47 unique values in the SalesOrderNo field, some which have records for multiple Assigned Plumbers.

@Victoria_G1 "Blank" typically means there is a null (i.e. no value). They empty square is most likely an empty string, which is a text value with a length of zero. Can you share a little more about the formula challenges you're experiencing?

@leaflove Beast modes generally work best when the aggregate function is outside of the case statement instead of inside like this: count(distinct case when `customerID` > 0 then `customerID` end)

@ColinHaze What type of freight are you interested in? We've built some custom connectors for our use cases, but many data sources require API access as part of the contract.

@damen I agree with @MarkSnodgrass' suggestion. Out of curiosity, what are you trying to represent by taking an average of a date?

@damen Does AVG(`Date`) work?

@random_user_098765 You'd likely have to take the same approach as the previous post, however I would not recommend building your chart this way since you have so many lines and timestamps. While you could technically build it, it would be way too busy and difficult to interpret. I suggest using this guide to determine a…

@jimsteph I'd recommend using a Heat Map card: You'll have bucket your data into 15-minute intervals and use diverging colors to show red vs green.

@Dverdon Pivot Table charts don't have a native way to calculate the variance between dimensions (in this case months), so I typically calculate them using beast modes in a Mega Table. Can you show a mock-up of how you want the card to look?

@BethW You could use a formula to add a blank string link this: CONCAT('')

@liminlu Where are your excel files stored? If they are stored on a local network/machine then you can use Workbench to look for a file with that name and upload it to a dataset. There are also connectors for cloud services, such as SharePoint and Dropbox if you use those. Any of these options can be set on a schedule so…

@TC1199A You could also use the following in the formula tile to only keep the characters before the second comma, if there are multiple: IFNULL(left(`city`,SUBSTRING_INDEX(`city`,',',2)-1),`city`)

@emmanuelfabre_1 You can do this using a Group By tile by setting ID as the Group by field and calculating the first non-null value of Source. Then you can join the Group by tile back to the original dataset by ID and replace the original Source field with the one from the Group by tile.

@D_Markley34 I'd suggest setting up a default Filter View to show only active statuses, but users can change that filter if needed