Best Of

Re: sum based on distinct in another column

I added an indicator in the dataflow. Every code when it is the first time presneted in the data, the indicator is 1, then I sumed up based on this indicator.

sum(
case
when `code_indicator` = 1 then `mc_spend`
else 0
end
)

WizardOz

3

Re: Is there a best practice for a visual indication that a card has a drill down configured?

If you are on Windows OS, then:

Windows Key + Period will open an emoji keyboard and then you can enter it inline as text.
👇

🔻

👆

Data_Devon

2

Re: Unable to export card in .CSV format

What is the name of the DataSet and card? Is it all cards on this DataSet that are experiencing the issue or just certain ones? I've run into issues exporting when certain characters are used in the name like brackets.

Domo often has more helpful error reporting in the API response than is displayed to the user. Can you look at the API response and see if there is a more helpful error message? You can do this by opening developer tools (right click in your browser, then click inspect), going to the network tab, repeating the export action on the card in Domo, then looking for the API request and response (it'll be from /api/content/v1/cards/<card_id>/export and might be highlighted red).

brycec

1

Re: Beast Mode Editor - Comment Out Lines

You can comment out blocks of code with "/*" and "*/".

Not as easy as highlighting a block of code but much faster than having to comment each line out individually.

TheLookout

2

Re: Allow manual refresh of Cloud Amplifier / Federated dataset schema

This is so much needed. We would appreciate the Domo team enhancing this or providing an alternative solution.
I often fix tables in Databricks, and I want those changes to be reflected in cards. I cannot find a way to refresh manually other than waiting until it refreshes itself.

daniel_echeverria

1

Re: Stacked bar + line chart doesn't stack

So I was able to make this work by making the beast modes part of the data set - for some reason that did trigger the values to stack

Thanks everyone for your help!

Jon

JonFass

1

Re: Checkbox Selector not showing all values?

That's great to hear @Joe_M . If you have the option to accept answer on my response, that will help others in the community.

MarkSnodgrass

3

Re: View as user or view as role

@JasonAltenburg great idea! I have a testuser@domo.com account I use for this specific thing, but it's limited. Would be so much better if we could do as you describe.

swagner

2

Re: MapBox - No Background

@Data_Devon maybe try one of these styles and see if it renders

ellibot

1

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

});

ArborRose

1