GrantSmith Coach

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?

I'd try and use some URL encoding for your pfilters value as that's likely what's causing the issues with the quotes not working. You can refer to https://domohelp.domo.com/hc/en-us/articles/360043430113-Sample-Beast-Mode-Calculations-Miscellaneous-Transforms#5. Also you can use a website to do the URL encoding of your…

Hi @ahobson Case statements are evaluated from a top down approach and will only evaluate the first true condition it finds. In your case it'll return 'canada' first as that's the first condition that was met to be true and it won't ever return growth.

When using the file upload you should be able to set the Update Method on the settings as Append so when you upload a new file containing the new rows it should put it at the end of your dataset.

What does your HTML / beastmode code look like?

It doesn't support aliases. The beast mode you're creating is essentially the alias for your calculation

Hi @Kervin Your code should work to pull the value from the COLUMN column. If you're needing to select from a different column name based on certain criteria instead of COLUMN then you could utilize a CASE statement inside your CONCAT:…

We just need to add another match group () to the regular expression and surround the entire IP address to match the entire IP address. CASE WHEN REGEXP_LIKE(`ip_address`, '^.*199\.15\.([0-9]{1,3})\.([0-9]{1,3}).*$') THEN  REGEXP_REPLACE(`ip_address`, '^.*199\.15\.([0-9]{1,3})\.([0-9]{1,3}).*$', '$1') ELSE '' END $1 will…

It is a bit odd why your Rent Last Changed field won't take the substring as it appears correct. Here's a few other options for you to try: Utilize LEFT in a formula tile: LEFT(`dRentLastChanged`, 10) You could try to utilize a formula tile to convert it to a date: DATE(TIMESTAMP(`dRentLastChanged`)) Alternatively you…

Hi @dylang91 First thing I would simplify your beast mode. If you go in descending order of your buckets so that the largest bucket is first you can remove the secondary conditions on each of your cases because the CASE statement will evaluate the first and only first condition where it's true so future conditions are…

@JunkDoom Embed permissions are configured on a dashboard level however multiple users could embed the same dashboard. If you're worried about dashboards being shared publicly or who's embedding them you can revoke that permission in a custom role and make sure your users are set to that role.