GrantSmith Coach

You can use a formula tile and the STR_TO_DATE function STR_TO_DATE(`Month`, '%Y-%m') Alternatively you could just use LAST_DAY to get the last day of a month to get the month of your date / timestamp field. LAST_DAY(`RRDAT`)

Currently this isn't an option with how Domo works. You'd need to either use a contains filter and have the user type in the filter value instead of a selection filter or have one record per person and subject.

More auto-formatting issues. Try this version for your procedure definition. /*Dynamic Reverse Pivot*/ CREATE PROCEDURE Pivot() BEGIN SET @cols = (SELECT GROUP_CONCAT(DISTINCT CONCAT('MAX(IF(p.`Target` = ''', `Target`, ''', p.`Target Value`, NULL)) AS ', `Target`) ) AS Base FROM `preformat`); SET @sql = (SELECT…

Looks like my copy and paste was bitten by the forum formatting. Remove the first line and it should work. /Dynamic Reverse Pivot/ Alternatively you can change it to what it should be /*Dynamic Reverse Pivot*/ the /*…*/ just represents a commend to add some contextual information but doesn't do anything to the actual code.

Have you looked at the domo.filterContainer() method? https://developer.domo.com/portal/e947d87e17547-domo-js#domofiltercontainer

Microsoft does have a Planner API (https://learn.microsoft.com/en-us/graph/planner-concept-overview You might be able to write a custom connector to pull in the planner data instead of having to write it to a SQL database and then import into Domo.

There isn't anything out of the box that would potentially allow you to replicate this specific visualization. You might be able to do it with a Domo Brick but that's a more technical route.

@Ashleigh I'd recommend logging a ticket with Domo Support. Certification should work with groups and I've successfully used them in the past. This sounds like a potential bug.

Hi @NathanDorsch, I was able to get some time this weekend to dig in a bit deeper to your issue. You'll want to use the following code to do a dynamic pivot using a MySQL dataflow. Replace the nathandortch_pivot_table_example in your code to the name of your input dataset name. The first transform you'll have is a table…

@user045907 - Have you thought about using a Magic ETL dataflow to have your dataset as an input and then filter the data so you don't have historical then output it to another dataset making it update on a daily schedule? Once that's in place you may be able to extract the dataflow definition with the Java CLI, change the…

Beat me to it as I was going to suggest pydomo to do this. Here’s more documentation for future users https://github.com/domoinc/domo-python-sdk/blob/master/examples/stream.py

Create a new beast mode to return an integer based on the order and then use that in the sort of the card: CASE WHEN `Year of Tour` = '5 Years Ago' THEN 3 WHEN `Year of Tour` = '3 Years Ago' THEN 2 WHEN `Year of Tour` = 'Current' THEN 1 END

The company settings - language setting may allow you to change the display type of numbers for the entire instance by selecting your variation of English. I wouldn't use a formula in the ETL to do the conversion as it will convert it to a string instead of a number and you'd lose all of the numerical aggregations. You may…

This is likely a Domo infrastructure backend issue that you'll need to reach out to Domo Support to get resolved.

Do you have any trailing whitespace in your email names? You could wrap your column name in a TRIM function in the formula.

Try this in a formula tile: CASE WHEN REGEXP_LIKE(`EmailName`, '^.*(\d+)k$') THEN REGEXP_REPLACE(`EmailName`, '^.*(\d+)k$', '$1') * 1000 END It's surrounding it in a case statement to make sure the field will match your regular expression if it does then format it otherwise it'll return null.

Thanks for the clarification - how is the formula not working? Is it because the original values aren't null or are the fields you're expecting to be converted not being converted to numbers properly?

Do you have a transform in your Workbench job? Domo assumes UTC when pulling in the data and will then convert to your company time when viewing the dataset in Domo or in a visualization. If your source dataset is something other than UTC you'll want to configure a transform in your Workbench job to convert your timezone…

To make sure I'm understanding your request - what should the output values be for your Circ Value column after applying the regex? What about the value of campgear1k? How should that be processed? Value 504? Value karaoke?

'^(\d+)k$' ^ - Start of the string \d - Digits + - one more more k - The character 'k' $ - End of the string If you want to plug it into just the number value: REGEXP_REPLACE(`column`, '^(\d+)k$', '$1')

Complex filtering as you're asking isn't currently possible. If you're wanting to select specific values from the list then I'd recommend restructuring your data so that each animal appears on it's own line in your dataset and use a multi-select filter.

Is your data being pivoted? What does your raw data look like? How many records do you have per month? What are you grouping your data based on? You'll likely need to utilize a LAG window function to get the prior month's value to calculate the difference in a beast mode.

Where does your A58 supplier exist? In both input datasets or just one?

Swap the two datasets you're using in your join. You're basing all of your dataset from the suppliers which have rejected records and not all vendors from the received records. TEST Received Qty should be on the left of your join, not the right.

It appears your join is only on the month. If you have multiple values in the supplier code codes it will cause a cross product join creating duplicates. Try and include the supplier code in addition to the month in your join.

Currently, this isn't an option and you'd need to set this for each dataset job in Workbench. I'd recommend adding this to the idea exchange as I can see others finding it useful.

How are you combining your data? Are you using a join in Magic ETL? What kind of join are you using? What are the values you're joining? It appears you may have an issue with how you're joining your two datasets together. Make sure you have all of the key fields in the join to avoid duplication of data.

What is the structure of your data? What type of visualization are you utilizing? What do you want the output data or visualization to look like? You may need to utilize a window function to calculate the category. CASE WHEN SUM(SUM(`Aantal`)) OVER (PARTITION BY `Your Grouping Columns`) <= 5 THEN 'Why' ELSE `Opzegreden` END

group_concat won't remove duplicates like in your example. If you need to remove duplicates you'd need to feed it through a remove duplicates tile first, then do a group by based on account id and date and select the "combine columns with ," option. I typically try to avoid combining values into a CSV list though as it's…

In my experience, the Simple API doesn't allow for nulls with numerical values in JSON. This is why I typically use the dataset or stream APIs to upload a CSV value and just have an empty value in my CSV to process a null. This last document should have a better example of uploading CSV with the Content-Type of text/csv: