GrantSmith Coach

I'd recommend formatting your data with a date dimension offset so you can calculate YoY and MoM more easily and have them displayed on your chart. You can then sort those percentages and see which clients require the most attention. I've done a write up of how to do this here:…

Have you looked at the activity log or the activity log DomoStats dataset?

It depends if you're deleting a beast mode that's saved to the dataset or not. If you delete one from the card that isn't saved to the dataset then it's just that card. There isn't a simple way through the UI to get the duplicated beast modes however you can utilize the DomoStats / Data Governance datasets to get the cards…

Have you tried re-authenticating with the connector and re-pulling the data?

Apologies, it should have been the Domo Governance connector and not the DomoStats connector that would have the Cards and Pages dataset.

Are all the fields metrics / numerical fields or are some dimensions / strings? You could try and multiply each value by 1 to force it to become a number: (`Total Bounces` * 1) / (`Total Contacts` * 1)

It lists the card and page on each row in the dataset so you can go card -> page and page -> card you'd just need to filter on the appropriate column.

You can use the DomoStsts connector to get the Cards and pages dataset which will tell you all the cards on a page

Do you have your BeastMode code you could post? (Anonymize the field names if necessary)

@jaeW_at_Onyx - Correct. It will share the dataset with all users of that group. @yli_2596 - You can multi-select datasets in the Data Center and then click the Face with the plus icon in the upper right to share multiple datasets with users or groups.

Those functions are aggregates, are you grouping your data on your other columns? Have you tried just utilizing a MagicETL dataflow after import and using the group by tile and selecting to combine values with commas?

You can do clustering via a Magic ETL tile however it requires you to have the Data Science package add on which is a premium feature. You can read up more on it here: https://domohelp.domo.com/hc/en-us/articles/360045259294-New-Magic-ETL-Tiles-Data-Science#4.

Currently there doesn't appear to be a way to reorder subpages for everyone. There were several posts asking about this in the past but not appears to have come from it. I'd recommend logging a new idea on the Idea Exchance section of the Dojo for this specific request. Here's some older reuqests:…

You could utilize a simple linear trend slope calculation however you wouldn't be able to do it in a beast mode because you'd need to aggregate some aggregations. sum((x−avg(x))*(y−avg(y)) ) / sum((x−avg(x))*(x−avg(x))) This will give you a larger number for faster increasing trend and smaller numbers for slower increasing…

Sounds like Dom is storing it as a non-integer data type (DOUBLE or DECIMAL) so there's not much you can do on the way in. What you could do is run it through an ETL and use the Alter Columns tile to change the datatype to a LONG / Integer to remove the .0 at the end of the values. Alternatively you could set the data type…

It will filter out all rows in the dataset that have an order date that doesn't fall within that week It will only filter based on the date field being used in your selector not all the date field in your dataset

To add a bit more flavor, the M you see is for "Modo Corp" which is a fictitious company Domo uses for their demos.

Do you have a date field being displayed on your card?

You've got a limited space because of the canvas the card is displayed in. You'd need to utilize some JavaScript to allow your menu bar to auto-scroll instead of attempting to display the entire menu. This way it'd have a fixed height but still allow you to scroll through all your options.

Can you just use the Date Selector in your drill path chart to select Last Month?

To fix the sorting create a new beast mode and then have it return as specific numerical value (1-4) and then use that to sort your pie chart. That will reorder the legend in the order you define. To remove the Total under your chart properties - Hover Legend - Title Value set that equal to None

You can use a beast mode to classify the different buckets or alternatively you could use an ETL and pivot your data in there before displaying in the line + bar chart.

Looks like your python script is failing because of bad / missing certificates. Have you tried installing the certifi package to install additional certificates with pip and then running your python script? pip3 install certifi Additionally the pydomo package needs a client_id and client_secret which you can configure from…

You can use a line + Bar chart to get what you want. If you have your data formatted with option one the first field you put a at value will be the line and all others will be the bars. If you want more than one line you can change the number of fields used in the general section of the properties.

@grace Great! I'm glad it worked for you. If you could accept my answer as a solution so others could find it more easily I'd appreciate it.

What is the value that is being sent up to Domo? How are you generating your data value? Is it possible that when it's being generated before it's sent to Domo that it's getting the .0 added?

You can utilize a rank and window tile within Magic ETL to do this with the LAG function. Partition by SNO and MMODEL and Order By your date field with a lag value of 1. This will give you the prior record's date where you can then feed it into a formula tile or a date tile to calculate the number of days between the two…

CASE WHEN `Intro Call Held Date (Cleaned)` IS NULL THEN FALSE ELSE TRUE END Null is a special value and requires the IS comparator instead of = when checking to see if a value is null or not.

You can find it on the connector settings. As Excel has the row limit you'd be limited to 1M for each file upload because of Excel but it would append those records to your dataset which wouldn't be limited

How is your sort table defined? Can you just make sure you're sorting the values in ASC instead of DESC?