GrantSmith Coach

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?

@Godiepi - It appears they don't have a closed at field as part of their API documention. The closest you can likely get is to check the updated_at field when a ticket has a status value of 4 or 5. This will cause the ticket to lose the resolved time if it ever becomes closed. You'll likely need to talk with Freshdesk to…

Hi @adithya You can refer to their API documentation: https://developers.freshdesk.com/api/#list_all_tickets (Search for 'Ticket Properties') Open: 2 Pending: 3 Resolved: 4 Closed: 5

You could leverage a scripting language and the web.exe executable to run the jobs and then determine if it succeeded or failed. To do that you’d likely need to read the JSON export (can do the export with the web.exe executable). Essentially you’d be writing another program to monitor workbench and have workbench kick off…

Just to reiterate I don’t recommend that method of permissions. PDP is the way to go when you need to filter data for specific users. Do PDP based on a specific group or groups and then add specific users to that group (or dynamically) Filtering and then sharing the dataset opens the possibility it could accidentally be…

They're just like any other dataset. PDP is the preferred method for restricting access but in theory you could filter the view and then only share it with that user.

Hi @technollygy the Magic ETL 2.0 Beta has a formula tile where you can just do a simple COALESCE function to default the values. The way you have it is the only real way to do it in Magic ETL 1.0. It's been in beta for a while. Talk with your CSM to see if you can be apart of the beta or you can wait until it's in GA.

You can use a beast mode to calculate the times and filter on results which return values within that result: CASE WHEN `Timestamp` BETWEEN CURDATE() - INTERVAL (24 - 7) HOUR AND CURDATE() + INTERVAL 7 HOUR THEN 'Include' ELSE 'Exclude' END CURDATE defaults to midnight that day so we're just subtracting a certain number of…

@AnwarBham Have you tried using the Domo Governance dataset for Datasets to do filtering? You can do beast modes / calculated fields on that dataset to do combo filters like you're asking about.

Hi @bdx You can do it with a beast mode which will be responsive to any filtering you apply to your card (the percentiles will be recalculated with respect to your filters) CASE WHEN SUM(SUM(1)) OVER (ORDER BY `Score`) / SUM(SUM(1)) OVER () > .2 THEN ‘Other’ ELSE `Name` END

Hi @Bianca_M There is an option to fill missing dates on the bar chart however it only fills dates between your first and last date. As such it won't exactly help in your case. You'll need to make sure the July date is included in your dataset. You can utilize the Date dimension data set from the Domo Dimensions connector…

Essentially yes. Domo does supply a Dates dataset in the Domo Dimensions connector which gives you a list of dates as a starting point you can modify with a view or ETL to do additional processing / adding of columns to.

Your best bet is to talk with your CSM to see if they can get an idea if this is on their roadmap or where it might fall since you’re looking for a product update from Domo.

Depending on when your quarters start you might want to think about using a date dimension table which has your quarters defined if it doesn’t start on Q1=Jan-Mar. You can use a view to join this date dimension table to your dataset and then pull in the quarter from your date dimension table.

Hi @bdx You'll want to try and import your data in batches if possible.

Hi @guilhermekido What does Teams expect the payload to look like? The webhook for alerts delivers messages in a specific payload format which isn't compatible with several applications (Slack in my instance). I ended up having to write a middle layer application which essentially took a JSON request and reformatted it,…

@user000253 Similar to your existing beast mode: CASE WHEN CEILING(`Process Temperature (DegC)`)<= 0 THEN 1 WHEN CEILING(`Process Temperature (DegC)`)<= 20 THEN 2 WHEN CEILING(`Process Temperature (DegC)`)<= 40 THEN 3 WHEN CEILING(`Process Temperature (DegC)`)<= 60 THEN 4 WHEN CEILING(`Process Temperature (DegC)`)<= 80…

Hi @user000253 This is because your bins are being sorted based on alphabetical sorting instead of numerical sorting (It's comparing each number one at a time in your value instead of the entire number). When I have bins like this I'll utilize a new beast mode which is similar to the original beast mode I used to create…