MichelleH Coach

Hi @ColinHaze there is also a setting in Bar/Line charts to create running totals under General > Number of Running Total Lines (Bars)

@BSovers It has not been removed, but it is a report in the Domo Governance Connector, not DomoStats.

@Canio I have used outer joins in Magic before. What challenges have you had with them?

@Marie_Serrano Each row/column combination used in a card are treated as a "row" from the perspective of the Limit Rows function. If you are using both rows and columns in a pivot table, then I suggest adding a Rank column in the MagicETL using the Rank & Window tile and filtering by that rank instead. The only drawback of…

@Canio Coalesce is very helpful for null handling, but it cannot add new rows to your data. Some chart types (like bar charts) have an option to fill in missing dates if a date field is used in the X axis. Otherwise, you will need to create a separate period mapping dataset to join or append in a dataflow and add the…

@Marie_Serrano Your logic is sound, but it is likely not working because Domo does not allow you to filter by beast modes that use window functions. I suggest sorting your card by COUNT(DISTINCT `SHIPMENT_NUMBER__TKNUM`) and using the Limit Rows function in Analyzer to only show the top 10

@ST_-Superman-_ I've run into this a few times before. I have been able to resolve it by clicking the X to close Analyzer and it will work when I re-open it. Unfortunately, your changes will not be saved and you will have to redo it.

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

@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

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