GrantSmith Coach

@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.

@Tow Have you tried using private embed instead of a public embed? Private requires users to be logged into Domo to view the report. When you choose the Private option, users will need to authenticate to see the embedded content. Because the private embed option uses authentication, filters can be personalized via PDP or…

I think I understand what's going on now. The activity log doesn't tell you which card is part of which page. Are you wanting to count a page view as a card view? Card Views are only counted when a user views the detail view of a card and not when it's displayed on a page. If you're wanting to count just the card detail…

Hi @user046467 You'll want to use PERIOD_DIFF instead of DATEDIFF: PERIOD_DIFF Returns the number of months between months in two date columns. For this to work, the date values must be months in the format YYYYMM. PERIOD_DIFF('Month 1', 'Month 2')

There isn’t a mass update for cards in the UI. The next simplest option would be to use the Java CLI to export your cards with the back-card command modify the resulting JSON in the files you export it to and the restore the card using the API. You could write a script to have the CLI run which would connect to your…

No worries. It's because you created this as a discussion and not a question. Glad it worked for you.

You might be able to hack it with something like what is outlined here: https://stackoverflow.com/questions/28876683/how-to-convert-a-timestamp-from-one-timezone-to-other I'm not certain of what database you use so your syntax may be different but the logic should work.

You' can't have a window function inside a window function. Have you tried partitioning by the company Id and then the journey type since it sounds like you're wanting to break out your average NPS by both of those categories.

Hi @WorldWarHulk When you're going into the drill path what are you clicking on? The drill path will add whatever you click on as the extra filter which is likely causing you to not have any results. I'm likely guessing that you're clicking on the Object_Name field for the page name and then when you're going to the card…

If you only show the order number and not the vendor or the service codes (making sure only one row per order is being shown) you could utilize some aggregates to a filter to work and then have the user click on the order number to go down a drill path to see the order details - alternatively you'd need to do your grouping…

Hi @dylang91 You can utilize Trellis chart options on a bar chart to get something like what you're looking for, https://domohelp.domo.com/hc/en-us/articles/360043428713-Applying-DataSet-Columns-to-Your-Chart#7.