Best Of
Re: MapBox - No Background
The map background may not appear if the map is not centered or zoomed into a relevant location. Try adjusting the zoom level and center of the map to ensure you're viewing the correct area.
var mapCenter = [longitude, latitude];
var zoomLevel = 10;
You can debug with console. If you add console commands, then right click on the page and go to inspect > console. Clear the console, then run code, look for errors or your debug statements.
var mapStyle = 'mapbox://styles/mapbox/streets-v11';
var mapCenter = [-74.5, 40]; // Change to your dataset's center point
var zoomLevel = 10; // Adjust based on your data
var accessToken = 'your_mapbox_access_token';
mapboxgl.accessToken = accessToken;
var map = new mapboxgl.Map({
container: 'map',
style: mapStyle,
center: mapCenter,
zoom: zoomLevel
});
Re: Connect Intercom Surveys data to Domo
Their API is a little weird. Looks like there is no way to just retrieve survey responses. You either get them at submission via the webhook or you can do an export. The problem with the export is that you must create it, wait for it to finish, then download it. In Domo, this would require you to setup a script somewhere like Workflows with Code Engine or Jupyter Notebooks. So, I would instead suggest you use the webhook. The webhook event you'll want to use it content_stat.survey.
brycec
Re: Transfer Street Address to Geo Latitude and Longitude Using Python
Hello @Chuqi_D,
Yes, it is working with Domo Jupyter Notebook. Here is the result for some random addresses I picked from Google Maps:
Re: Transfer Street Address to Geo Latitude and Longitude Using Python
Dear @Chuqi_D,
As far as I know, you can't directly call APIs through Domo's Magic ETL. You may use Jupyter Notebook within the Domo environment for that purpose. I tested your code, but it doesn’t seem to be working correctly. I'm investigating the issue and will update you if I find a solution.
Re: Setting up a rolling sum based on date
Hello @Katrina_Burns,
First, check this video from Mark Snodgrass.
You can use a Variable to showcase the Rolling Average for all customers or just a selected one. I went a step further and created three variables and now I can see the Rolling Average by country, product, or industry, whether I want the full picture or just a selection.
If you need further explanation, please let me know.
Re: Zip2Fips - map card issues
I just wanted to follow up on this incase anyone else has a related issue. This was not a bug. The problem was that I was prefacing the columns with "zip2fip." I followed the advice below it it resolved my issue.
"I will provide some clarification. The US map is unique in that it really could be one of several different maps. The actual map loaded is inferred from the column name / alias (Data Label) of the first column. We first look to see if the column name includes "zip", if so we try to use the zipcode level map of the US. If it doesn't include "zip" then we look for "fip" or "county" in the column name, and if either of those are present we load the county level map of the US. We then do the same tests for the alias or "Data Label" for the column. Finally if the column name includes "st" short for "state" then we load the state level map.
So in this case, because you have set the column name in the ETL to be "zip2fip"... it picks up on that column name and determines the map to use should be the zipcode level map.
Two easy fixes.
1. Have the column name in ETL not include zip or fip as part of the name, but include "st"
2. Create a beast mode that references the ETL column where the beastmode name does not have zip or fip in it, but does have "st". EG "State_bm" = zip2fip.donor_state_troubleshooting"
Jbrorby
Re: Bullet chart color rule
ArborRose's approach works on most card types, but not on the Bullet Chart. For whatever reason, Bullets won't accept color rules like this. If I were to guess why, it's that the philosophy behind a Bullet Chart is to show progress against targets using the relationship between the bar and the target marker, so a color would be redundant, but it is limiting.
If you want a pop of color when you meet/don't meet the target, you could use unicode characters in a tool tip (hat tip to ArborRose's fake data):
Case
when Price* Quantity >= Budget then '🔵'
when Price* Quantity < Budget then '❌'
END
You can see this highlights a second annoying limitation of Bullets in Domo, in that you can't control what the data labels appear on (Actual Value vs. Target vs. everything), so you end up with redundant marks on the graph.
If you're willing to ditch the Bullet (I usually do!) another approach is using the Symbol + Stacked Bar:
To achieve that, I broke up Total into Total (over budget) and Total (under budget):
If you used the Symbol + graph, make sure to check the option to "Sync Value Scale" in the general properties, which is off by default.
And to go even farther from your original request, IMO changing the color of the whole bar can be a bit busy. You could take a similar approach, but color-code the budget icon instead, giving you more control over what draws attention on the chart:
Re: Dashboards Filter API Behavior Discrepancy with App Studio (Removing filters)
Hi @Saaisathish,
We recently encountered similar behavior in one of our apps while using domo.onFiltersUpdate(). After failing to find a solution, we contacted the Domo Support team. I was informed that there were some related bugs that have since been fixed. You might want to reach out to Domo Support as well, it could be a similar issue.
Re: Hubspot Writeback error
@joebenz it looks like it might be an error with the Hubspot user you're using to connect the Hubspot writeback connector. Is the user an admin in Hubspot? I'm guessing you'll need to be an admin in the instance.
ellibot