ColemenWilson Coach

Gotcha, if you give the output a name and then run the dataflow it will appear as what you have selected in red in your screenshot.

I'd work to find a better unique identifier than name for the future. The best place to do this is the source systems. Otherwise maintenance could be a headache.

This means that the step right before the output has not been properly configured. You may (and I can't know without seeing how that tile is configured) not have selected a right or left table, a right or left join key, or something else. To switch to a different output, just drag the line from the new dataflow path to the…

You said it's for multiple names in the dataset - I'm interpreting that as not very many and you know which they are? I would suggest just cleaning up the names on the dataset in the ETL using the formula tile: CASE WHEN `FirstName` = 'Fred' AND `LastName` = 'Johnson' THEN 'Frederick' ELSE `FirstName` END Because even full…

To get the the x-axis on top go to Properties > Category Scale (x) > Position > Top Playing around with Inner Margin and Balanced Distribution should get you the format you are looking for in regards to fixed width. These are in Properties > General

You can bulk change the departments using the User Management Toolkit in Governance Toolkit. This is a premium feature that you may need to reach out to your CSM to enable if you haven't already. You can also bulk change departments using the Bulk Import option. Just make sure to select "Add new people and edit existing…

There is a Domo Governance dataset called "Pages and Cards". You can access this in the appstore by searching "Domo Governance Datasets Connector". Each card has a unique Card ID as the identifier. Note that a unique card may exist on multiple pages simultaneously.

Once removed from all users in Domo, that department will no longer appear in the drop down list. It will remain if it is the department of any user in your instance.

Hmm the way I would do this is still in MagicETL. I would convert the timestamp using a formula tile with the following formula: CONCAT(DATE_FORMAT(`Date`,'%m/%d/%y %k:'),(CEILING(DATE_FORMAT(`date`,'%i') / 5) * 5)) Then follow the same process I mentioned earlier, but use this field instead of your date field. What this…

Using MagicETL you could use the group by tile and choose your create date as the column that identifies the grouping. Then select "Add Formula" and use GROUP_CONCAT(`Company`). The output will be a comma separated list of companies for each create date. It would be helpful if you could share what kind of output you are…

Classic gap and island analysis. Here is an article introducing the topic and how to accomplish what you are trying to do: https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/introduction-to-gaps-and-islands-analysis/ An alternative way in MagicETL would be to use a lag function and have…

Love the Office reference 😂

I've had this issue and solved it by creating an entirely new alert. You can copy and paste the message, but it's kind of a bummer you'll have to recreate the rule.

Continuing with what @ArborRose is saying, you would create a beastmode something like this: DENSE_RANK(Number) OVER (ORDER BY Number) Then, in a color rule you would set the rule using the new beastmode field above and the condition would be less than or equal to 5.

Well that is a huge bummer

Gotcha. Have you looked at using Magic ETL and/or Datafusion to speed things up and prevent a timeout?

Yeah it may have to do with you not having Manage DomoApps.

Hmm. Could you try not selecting which page the DDX brick will be saved to and just keep the default "Overview" and see what happens? Also, do you have the appropriate grants enabled for your user?

Pretty sure you'll have to re-run the entire dataset. Is there a reason you are against doing that one time to cleanup the account owners?

What is the issue you are having? It's working for me.

I just compared the result of CORR() in a beastmode and it matches what I am getting in Excel/Google Sheets with CORREL(). So it definitely works.

@carthur What PDP new update are you referring to? Column level permissions or custom attributes? Or something else? We have Nested Beastmodes enabled in our instance and it generally works pretty well. We had to reach out to our CSM to get it enabled, as @GrantSmith suggested.

One of our users had this issue last week. They were able to resolve it by logging out, clearing their cache/cookies and logging back in. Weird, but it worked!

Hey @ColeStuart, I helped you with the previous post you referenced. Here is my checklist whenever I get these errors: Did the file somehow get saved locally and is no longer in OneDrive? Is the file still shared with edit access with the service account/Integrator account in OneDrive? We have a dataset that runs that…

Are you using numeric values? It won't work with dates, text, or any other dimension - only numbers.

Hmm I am not getting the same error and I've applied the same settings as you. Can you share your beastmode? Also, if you switch the chart type to a table card and then do no aggregation and use CORR(field1,field2) do you get the value you are expecting?

Hmm I didn't realize you wanted to see the correlation coefficient change over time. For that you'd need to use fixed by. Something like this: CORR(Field1,Field2) FIXED (BY Date)

It works. Give it a try and let me know how it goes! Example: CORR(field1,field2) There are many functions that work in beastmode that are not displayed in the functions list in beastmode editor.

There is a CORR() function you can use in a beastmode. Example: CORR(field1,field2)

If you are doing this in Magic ETL you would use the Group By tile and group by `Country` and then choose SUM as the aggregate. If you are doing this in a table card, all you have to do is bring the 2 fields into the table card and then sum the `Value` field and it will auto group by unique instances of the other field. If…