guitarhero23 Contributor

Interesting thought, I hope someone here has done this already and can point you in the right direction. Some initial thoughts, Based on THIS it doesn't mention deleting files on the file system however if it can't be done with a plugin you might be able to leverage the fact that you can start a workbench job from the…

See if this helps, https://knowledge.domo.com/Visualize/Managing_Cards_and_Pages/Creating_Domo_Stories Their is a section for "Setting a Page Background Color or Image"

It does appear like something is different with this API. Couldn't even find documentation until I googled it https://developer.domo.com/docs/api-reference/buzz-integration-api-reference. I had a similar issue as you were I got a 403 Forbidden. I looked in the official Python SDK and buzz isn't mentioned anywhere in it so…

If one of use provided the correct solution can you mark it as the solution, if not can you post what you did to resolve it and mark it as the solution so other people who stumble across this can see what resolved it if they have a similar issue? Glad to hear you figured it out.

@DannyLewis Were you able to get this running as you wanted?

@user00472 did the above answer your question?

@user16945 were you able to sort this out?

Any updates? Did this work for your use case?

I'm not sure exactly how this would work well, having 3 dates that represent different things all in one column. Seems like it would be hard to re-use later on because I doubt it will even register as a date field probably just string. You can however use the "Combine Columns" ETL block to achieve what you're asking, but…

Can you give a little more information about what exactly you're doing? Perhaps a code excerpt from the authentication section without putting your real credentials in it of course. 

Interesting, I'll give it a shot.

Options that I see: * Filter all datasets to only show Salesforce datasets and export them all and combine in Excel to get a list of ALL fields being used. * If you're code savvy it would be better to use the Domo API get retrieve this. You can get a list of all datasets and their columns The endpoint for all datasets is…

I'm not sure if you can do it in a beastmode or not but you can achieve something like that you're looking for in an ETL. Use the Rank & Window block with a function of SUM based on your Total Revenue field and make it unbounded with a preceeding of 0. When I look just at those columns you can see it's a running total.

I don't have full knowledge of Tempo however we did test it out a few months back. I believe, like many other Jira 3rd party apps, that if supplements your data that Jira stores with data stored in their database. Sometimes addons add custom fields to your Jira instance which then you can pull into Jira with the standard…

Can you explain your use case alittle more in depth? Are you expecting/hoping you could open Power BI and click some refresh button and get data from Domo to update your current data in Power BI? Is this purely for doing Excel like actions on large data that Excel normally can't handle hence why you're using the ability…

Solutions are often heavily dependent on your use case and what people at your company want to see and how they want to see it but I'll throw some things out that might be useful to think about. * Use page collections to group together categories of the data being shown to make it easier for the end user to locate and…

Some variation of the following should work for you. Total Attendees: No beast mode necessary, just do a COUNT aggregation on any column (I used CustID) Last 7 Days %: SUM((CASE WHEN DATEDIFF(CURDATE(),`Class_Date`) <= 7 THEN 1 ELSE 0 END )) / COUNT(`CustID`) Last 14 Days %: SUM((CASE WHEN DATEDIFF(CURDATE(),`Class_Date`)…

Test this and let me know if it works. I thought I'd run into a similar issue to you and have to add some more but I'm getting promising results. Only difference was I used the Month function to match the name of months. (CASE WHEN MONTH(`ActivationCallStartTime`) = MONTH(DATE_SUB(CURDATE(), interval 1 month)) THEN 'Last…

@ST_-Superman-_ has made a helpful video on how to create custom SVG maps. Once you have the map as long as you have data points to support those regions you should be able to get what you're looking for. https://youtu.be/AWohsHhFFNc

Jeez that was a wild error for something as simple as that. We have had the file move without my knowledge and I remember the error being more straight forward

In addition to what @NewsomSolutions said, if doing it in a table or pivote table you might be able to leverage a formula like this. SUM((CASE WHEN `Session Duration` > 10 THEN 1 ELSE 0 END)) / COUNT(`ID`) I'm not sure exactly what sort of "Categories" you're talking about because you don't really mention it but here's an…

If you haven't already I'd recommend reaching out to support for this while you see if anyone here has encountered a similar issue. I use Quickbooks with Workbench and haven't come across this.

Since I don't have experience with this one I'm not sure if you can or cannot get this data from the connector but here is some info I found. Connector documentation Getting Azure Subscription ID Anoter source for Azure Subscription ID Resource Groups Another source for Resource Groups

Unfortunately I don't use Azure so I don't have credentials to go and test myself so best I can do is point you to some documentation and hope someone who has done this before can chime in. I'm still not clear exactly which connector you're using since you say it's in Azure and not Domo, unsure if that's just different…

Are you saying you built your own custom connector, your own custom API integration, or using a native Azure connector? If one of the first two I'd say go look at the Azure/O365 API documentation on how to retrieve that. If you're talking about one of the native Azure connectors I'm not sure one exists to get what you're…

You should checkout some of the announcements they made earlier in the year at Domopalooza around stories and embedding. I'm not sure that 100% of the features have been released yet but they have announced some things around this. https://www.youtube.com/watch?v=6SARdyCmsjA In the past everyone needed a Domo license if…

Hi not 100% which situation you're talking about. Are you talking about sharing a dashboard in Domo with another Domo user so they can utilize the page filters functionality? If that's what you mean, simply share the page in Domo with someone, they would have those abilities for page filters (if you enable) and interaction…

Aggregations aren't allowed as quick filters so you wouldn't be able to use count(file_id) as the beastmode as you experienced. Is the certain number of files static or is it something that is constantly changing or that you would be curious about and want to change freely? In an ETL dataflow you could get that by doing…

Sounds odd. If you don't figure it out and you're able to I'd recommend using SOQL (workbench would help write it https://workbench.developerforce.com/login.php) to create the same filters that are on your report and use "Query" as the how to select in the Salesforce connector settings. I've had no issues with this.

Do you know if they changed the date range at the PAGE level filters? I think those are the only ones that might save because if you view a single card, change the range (as a user, not as an admin changing the cards default), once you exit out of the full view it goes back to the default. Here you can see I have saved…