ColemenWilson Coach

Do you mean can you make a summary number green? Or how do you create a summary number? The green part is showing already, do you want it to show somewhere else?

((Last Value - First Value) / First Value) * 100 I don't know the structure of your dataset or what represents your first and last values, but you'll need to create the above logic in a beastmode.

To show a % change in a summary number, you'll need to calculate the % change in a beastmode (calculated field). Once you have created the beastmode, you can select it as your summary number value.

Interested in this as well. With GA4 I've not seen a way to identify who in our org is taking and completing trainings. I know @Ashleigh has made some progress but still not successfully accomplished this.

Check your PDP policies to see how they affect those users.

And the "Manage all users" grant could be removed for the users you don't want to edit the department field as this grant is required to edit the Department field for all users.

This can be done using the ASCII() function in a SQL dataflow. Doesn't work in a beastmode or Magic ETL.

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: An alternative way in MagicETL would be to use a lag function and have some logic that if the previous value is not the current value minus one then that current value must be a new start to an island…

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!