GrantSmith Coach

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

Hi @Salmas Your beast mode isn't working because you're attempting to compare a single value to 4 multiple values at the same time. If Name is A it will never be B, C or D so your result will always be 'Pending' If you're doing this across your entire dataset you could do something like this to check them all individually…

Hi @ndldty You can do something like this with a case statement (assuming superb and outstanding are separate value columns): CASE WHEN `Superb` < 0.10 AND `Outstanding` < 0.10 THEN 'Below' WHEN `Superb` > 0.35 AND `Outstanding > 0.35 THEN 'Above' ELSE 'OTHER' END As for the Superb can't be more than 5% that doesn't really…

Hi @Saketh You're attempting to aggregate an aggregate which isn't possible within the beast mode and summary number. If you want the average of the percentage you'd need to pre-aggregate your data with a dataflow to then be able to take the average of the percentage.

This is the webforms connector I was referring to: https://domohelp.domo.com/hc/en-us/articles/360043436813-Webforms-Connector. Just search for WebForm in the connectors dialog box.

Hi @Kris_delosangeles That dataset ID doesn't exist in your instance so it's throwing an error. You can create a simple testing dataset using the WebForm connector and putting in some sample data if you want to test it before using real production data. You can get the new dataset ID from the URL when you're viewing the…

@Tsharma8724 - Also depending on Tableau's architecture / APIs you may be able to write a custom connector to pull data from Tableau but very likely it'll be difficult as they're competitors and don't have any incentive to allow cross product communication. Another alternative may be to write your own script using a…

You may want to think about restructuring your data and using a date dimension to calculate the current day, last year, two years ago etc for your data points. Then you can use a beast mode to pull only the offsets to you want. This will then allow you to be able to calculate the current year from a year or two years ago.…

Have you tried doing the pivot in a Magic ETL dataflow with a pivot tile?

Hi @jeff_patrick Can you see records for those NPIDs in your dataset? Did it change at all? If it's being modified by a dataflow - has that dataflow been changed?

@hqu It doesn't. It's a simplistic model. As Mark said you'd need to pull in the Domo Dimensions - Calendar Dates dataset into an ETL. It's a bit more tricky with Magic as you can't do a conditional join with between or less than / greater than. You can do this with a MySQL dataflow but it will run slower than a Magic ETL.…

Hi @hqu I've posted previously an article about adding business days to a date with a simplistic algorithm. You can read about it here: https://dojo.domo.com/discussion/52678/domo-ideas-conference-beast-modes-add-business-days#latest

How is it not working? What are you getting? What are you expecting? Domo will convert your TIMESTAMP fields when a card is displayed to whatever time zone your instance is configured to.

Hi @User2021 Instead of CST I'd recommend using the country/city name like this: CONVERT_TZ(`DateTimecolumn`, 'UTC', 'America/Chicago') You can use this in either a Beast Mode on a Card or a Formula Tile in a MagicETL 2.0 dataflow. Here's a list of timezone strings: https://timezonedb.com/time-zones