GrantSmith Coach

@sides - Have you moved any tile or opened the settings on one of your tiles? Doing those will typically cause Domo to think something changed.

Those are the current options we have. You may be able to hack around it by calculating your buckets manually and then using color rules to automatically color those buckets. Not ideal. I’d recommend adding this as an idea in the idea exchange on the dojo.

You’re correct that it’ll return the same number from what I’ve seen in the past. If you want it more randomized for each row you’d need to run the random function within an ETL

You can create a beast mode in analyzer. On the bottom right there should be a button that says Add calculated field. It will also give you the option to save the beast mode to your dataset which will make that same calculation available for other cards you make with the same data set

Hi @jblecha You can utilize a beast mode conditionally set the value and use that as your series. CASE WHEN `field` = {"MODE":"Auto","Rule":"Tree"} THEN 'Point - Tree - Batch' WHEN `field` = ... ... END Alternatively you could parse your field values in an ETL or you could have a separate dataset with two columns, one for…

Hi @user10110 Domo doesn't have anything built in to calculate a normal distribution probability. You'd need to calculate it yourself via an algorithm

Hi @MysteriousDomo Currently this is not something we can change the user end. You might try talking to your CSM and see if Domo is able to change the format on the backend but very likely it will be an additional cost for the customization if it is indeed possible.

Hi @Alex_us This video may help explain the APIs and how they interact with Domo. It's a very technical aspect having to interface with Domo in this specific way and typically need to utilize some programming language to build a pipeline.…

Hi @user046467 I’ve run into this issue in the past. For me I had to tell it to import a single day, run it and then import the range I want

Hi @eriena Have you tried a different browser or closing your current one and reopening it?

Just a note you can utilize the regular expression I gave in an ETL using the replace text tile. You just need to make sure you select Use Regex from the gear menu on the search text field (middle one) Also for clarification [67] says any single character in the list to match to

Hi @hilsmith What does your regex look like? you can try something like this ’’’ regexp_replace(`subject`, ‘^.*(87[67]\d{4}).*$’,’\1’) ’’’ I’m on mobile so sorry for the bad formatting

Hi @dacorson How is your window function written? If your card has another field you're grouping by then the window function won't get interpreted correctly. You need to wrap your window function aggregate in another aggregate. for example: SUM(SUM(1)) OVER () I've documented this in another post of mine here:…

@nshively Can you calculate the CTR by taking the clicks / impressions?

Hi @kboudrie You can utilize case statements and window functions (you'll need to talk with your CSM to turn on windowing functions) SUM(SUM(`col_1`)) OVER (PARTITION BY YEAR(`Date` - INTERVAL '5' MONTH) ORDER BY (`Date` - INTERVAL '5' MONTH) / SUM(SUM(`col_2`)) OVER (PARTITION BY YEAR(`Date` - INTERVAL '5' MONTH) ORDER BY…

Hi @Alex_us There's likely a "lowercase p" public API endpoint to get a list of all of the embedded cards their their URLs to then parse our the ID. You'd just need to inspect your Domo Everywhere page list to determine which API endpoint it's utilizing. Note that as this is what Domo calls "lowercase p" public it's not…

An alternative is to utilize a Python script to use the pydomo package and export data from Domo and then utilize the package from Amazon to upload your data to Redshift (https://aws.amazon.com/blogs/big-data/using-the-amazon-redshift-data-api-to-interact-with-amazon-redshift-clusters/). This would be a free method of…

Hi @Fatias Currently workbench doesn't support this sort of querying. The only thing it supports right now is a lastvalue (or previewonly) type parameters which will track the value in the last row of your dataset from your previous run and allow you to insert that into your query. For more information refer to step 19 on…

It sound like a Facebook limitation and not much Domo can do but I’d be interested in hearing what support comes back with @RobynLinden

What about a single day or week? did the amount of pages drastically increase?

Hi @user082291 This sounds like a bug with the PowerPoint plugin, I'd log a ticket with support to get their input on it. Out of curiosity - have you tried restarting powerpoint? Does the issue persist? Have you logged out of the plug-in and back in again?

Hi @nbrx How many months of data are you attempting to pull? You might want to just try and pull a month, set your dataset to append and then pull the next month and the next until you get your entire dataset. I think it may be because you're selecting too wide of a date range. Do you have a lot of pages or actions?

What I'm suggesting is in addition to pulling the Ad Analytics report you have 3 more connectors, one for the Ad Accounts Report, Ad Campaign Groups report and the Ad Campaigns report. According to the linked in API it should also return with it the account ID. Campaigns should also include the campaign group.…

Hi @user027926 if you only want the numbers from your ID field then you’d need to remove non-digits from your field and then convert it to a number (assuming both fields should be numeric) Have you tried a replace text using a regular expression? ‘’’ [^\d] ’’’ Make sure you select the Use RegEx option from the config menu…

Hi @Jessica I haven't seen this issue personally, you might want to try and reach out to Domo Support as this sounds like a bug.

Hi @nshively It might be possible to use the LinkedIn connector to pull in the Accounts, Campaign Groups and Campaigns reports as three separate datasets and then use an ETL to join them together instead of maintaining a dataset in Excel. You can then join that dataset to your Ad Analytics datasets and combine them with an…

Hi @sky00221155 Domo will ignore those blanks when calculating the average. It depends on your use case and what a blank value represents. NULLs typically mean there is no data so there's no certainty as to what that value represents and is typically ignored when calculating averages. If you want the NULLs to represent…

Hi @liotsosa You can configure alerts to send to a user via SMS, email, App notification or phone call. The user will need to have a Domo account / license and have their information up to date in their profile so Domo knows where to send the alert to. When configuring your alert there are buttons on the bottom right for…

Hi @hilsmith You can change the filtering interaction of the other cards in the dashboard configuration to tell it not to affect your YTD card. On your dashboard click on the wrench in the upper right and select edit dashboard. Then select the cards you don't want to interact with the YTD card (hover -> edit content ->…

@MysteriousDomo How did it now work? Did it return something you weren't expecting? Not return anything at all?