GrantSmith Coach

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.

Hi @user077529 How is your raw data formatted? Do you have a single column for the service type and multiple records for each order or are the different services separate column values and you have one row for each order?

Hi @micheleb You'll need to put everything in the same format and then convert it to a date. You can convert the date strings using a REGEX_REPLACE function in a formula tile: REGEXP_REPLACE(`Date`, '^(\d{2})\/(\d{2})\/(\d{2})$', '$1/$2/20$3') This will check for a 2 digits / 2 digits / 2 digits format and then put a 20 in…

Hi @User2021 There's nothing you can do as the card will interpret the beast mode but the export doesn't. I had posted an idea specifically for hyperlinks in the past but it was closed so I logged a new idea for it (https://dojo.domo.com/discussion/53947/format-as-hyperlink/p1?new=1). Typically what I would do is have a…

Hi @lvtrujillot Currently this isn't something you can change. I'd recommend logging an idea in the idea exchange as a potential enhancement.

Hi @JoeR_PSIT You can use the LENGTH function to get the number of characters in a string CASE WHEN `Serial Number` IS NULL OR LENGTH(`Serial Number`) > 7 THEN 'Error' ELSE 'OK' END

You could utilize a custom date dimension with offsets to calculate the current date's count and also the count for the same day in the prior month, then you could utilize some window functions to calculate a running total for the current month and compare it to the same time as last month or alternatively just calculate…

Hi @user031170 There's a 25k row limit on most card types except for Histograms and Box Plots (100k limit). See https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs Have you tried using a Sumo Table to do your pivot? Those have a higher row limitation and may allow you to chart your data properly.