GrantSmith Coach

You could use a regular expression in a formula tile with something like this: REGEXP_REPLACE(`Name`, '^(\w+), (\w+) ((\w+) )?\w+.*$', '$2 $4 $1')

Hi @DuncanDomo This would be an idea / feature request as it's not currently possible in the platform. Feel free to log it on the Ideas Exchange. You could follow up with your CSM just in case but the likely answer is that it's not currently an option.

Hi @user18045 DomoStats doesn't contain the amount of rows. You'll need the third party data governance connector and pull the DataSets dataset. It'll have Row Count as a coulmn for you to use.

One minor issue with the prior beast mode, it's short circuit evaluating to only pull in the 2nd digit in the months. This update version should resolve that issue: REGEXP_REPLACE(`_FILE_NAME_`, '^.*_(\d{1,2})_(\d{1,2})_(\d{4})_to_(\d{1,2})_(\d{1,2})_(\d{4}).*$', '$1/$2/$3') REGEXP_REPLACE(`_FILE_NAME_`,…

If you want the 12 month turnover rate you'll need more than 1 year worth of data. When it's attempting to do the lag for prior months and getting 12 prior records it's returning NULL. When you use + and NULL the end result is a NULL so your data is blank for all of the prior months. The beast mode should work assuming you…

It's splitting the first part of your filename 'security/public/storage/account/time/range/report/11/1/2021' as the date. This of course isn't a format that Domo can understand for a date. For more complex cases like yours I recommend using a regular expression in a formula tile: Start Date: REGEXP_REPLACE(`_FILE_NAME_`,…

Hi @Fadem You can use a case statement to conditionally sum your numbers together: SUM(CASE WHEN `Department Number` IN (1,2,3,4) THEN `Value To Sum` END)

Hi @Fadem Do you have a beast mode you're using? How is the sum function not working? For your department numbers are you looking to get a part of the department name or are you wanting to conditionally add values together based on the specific department numbers?

That's correct. If you change it to a string then you won't be able to do a lot of different mathematical aggregates like SUM, AVG etc if you convert it to a string. You'll be able to COUNT the records. This is only a display issue. You can format your field as a number when displaying it on a card and tell it to not…

Hi @CarolineRogg1 this is a display issue. You can convert the field to be a string using the alter columns tile if you want it displaying without the commas. Alternatively you can make it a string on the input dataset tile configuration

@DavidLee Can you post your exact formula you're using? Also are you doing this in a beast mode or in a magic ETL formula tile?

@Abhijith You should be able to use multiple lag functions to calculate the total and average. This is assuming your data has been unpivoted and you have a single row for each month instead of a single column for each month as in your excel document. Part 1: (LAG(SUM(`Exits in month`), 12) OVER (ORDER BY `headcount as at…

Hi @eriena You'd need to generate Grape rows with 0 as the number of pieces for each date. To do this you'd need to do a cartesian join between your dates and your products. This can cause a massive increase in the number of records you have in your dataset so be mindful it will increase the dataflow execution time as…

Hi @Hiraayub When I'm dealing with date comparisons like this I use a custom date dimension to easily define offsets like "last year". I've done a writeup on this in the past: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest to get the value for the current date or the…

It's showing the thousands separator because it's a number but it likely doesn't actually have the separator in the value. It's a display enhancement to make numbers easier to read. To do a quick test you can view the data in a table card and they shouldn't show up there.

I'd recommend using a formula tile to input your CASE statements which are inside your SUM aggregation as two separate values. Then do a group by to get the SUM then another formula tile to do the outer portion of the beast mode (checking if your denominator is 0)

You're missing a single quote and a few back ticks (these designate column names). CASE WHEN `Journey-Pathway Content Progress` = 'Completed' THEN 'Completed' ELSE `Content Progress` END Doing this as a beast mode will create a second column in your dataset as that's how beast modes function. You can rename your column's…

Hi @micheleb You can use a case statement to conditionally set column B to completed if column A is completed CASE WHEN `Progress Column A` = 'Completed' THEN `Progress Column A` ELSE `Progress Column B` END If you don't want an extra column in your dataset from this beast mode you can use the same formula in a Formula…

You could just set your date range selector on your new card to be Last Month and then in the column aggregation (click the column name after you add it to your card) and select Aggregation > Average.

Hi @Kris_delosangeles I'd recommend reaching out to your CSM to get an official answer to this question and they can run it by their security team if necessary.

@Rvannoy Are you calculating the grand total yourself in your data / beast mode or do you have the total row on your table enabled in Domo? If you're calculating it yourself it's likely when you're aggregating your total you're not using the same level of granularity / you're not grouping by the same columns as your table…

You wouldn’t necessarily need a full outer join as the left join would work just fine. After your join just add a filter tile to say where shop is null and then feed that into another output dataset

Hi @user048760 Use a select Columns Tile to select your columns except for your delete after your filter so you don't include delete into your dataset. It's only used within the dataflow. You can look at step 7 on…

Can you expand more on what you mean by you just want a number? SUM and Count will return numbers. What does the number you want represent? If you’re just wanting the number when it represents a value then just do CASE WHEN `Column_1` = 'Value_1’ THEN `Column_1` END

Have you tried locking all the pages (upper left next to the title is the lock icon) shared with the whole company so that only admins or page owners can add, edit or deleted cards on the page but leaving the Overview open to others to allow them to add cards to it? But as @mhouston stated you can also use the landing…

Ha @MarkSnodgrass - Is there a badge for that? @Crisocir - Your beast mode appears to be correct. I have seen issues when there's too much data for the beast mode to handle in the card. What happens if you restrict your data to just this year?

An alternative beast mode is to use LAST_DAY (returns the date of the last day in the month) instead of MONTH and YEAR: CASE WHEN LAST_DAY(`Column A`) = LAST_DAY(`Column B`) THEN 1 ELSE 0 END If you're looking to count all of the occurrences and not just when the values are the same for each record you'd need to use an ETL…

You can also utilize UPSERT within workbench as well to update / create records so you only need to pull in the changes assuming your data doesn't get deleted out of your tables. If they do you'd need to use partitioning.

Hi @Ainash The two main options are writing your own custom connector within the Domo platform or utilizing a scripting language like Python and the pydomo SDK / package to import data into your domo instance after programatically pulling the data from the reddit ads API. Custom Connector:…

Hi @MosesWynn You can utilize a Dynamic PDP policy for a trusted attribute. I've done it in the past using an employee ID to dynamically apply PDP when they're looking at specific pages.