Best Of
Re: Is there a way to control the colors in a Lat/long map for a series of values?
You can use "color rules" in a lat/long map. It doesn't appear in the "chart properties" panel they way it usually does, but you can open them using the button on top, then apply rules to the variable you chose for your "series for color".
Re: Any way to highlight current date on a line chart?
Currently there isn't an option to hide the others. As you can see there's a lot of great ideas coming from the community and more than one way to do something within Domo. Welcome to the forums!
Re: Any way to highlight current date on a line chart?
If you have data for every day of the year, you could utilize the data label settings and the tooltip to make a label appear on the current date.
First, create a beast mode that looks like this:
CASE WHEN datefield = CURRENT_DATE() THEN datefield END
Drag this beast mode into the Tooltip Field 1.
In the Chart Properties, go to Data Label Settings and in the Text, add Tooltip Field 1.
The result will look something like this as long as you have data for the current date. (I didn't have the right dataset to work with, so I made it show 10/1/2023).
Re: Any way to highlight current date on a line chart?
Domo doesn't have a way to display a vertical line as you're wanting.
You could utilize a beast mode to check to see if it's today, if it is return the value.
CASE WHEN `dt` = CURDATE() THEN `random_number` END
You can utilize a symbol line to display your values and then have Today being displayed on top of it like this:
Make sure you have your Today beast mode listed first so it will display on top.
Re: Drill Path - working in Edit Drill path, not working in pages
@Laura_M1 This is likely related to the same conflicting filters issue from before, and there are no Sales Locations left in the filtered data. As a side note, you don't have to Select All before toggling "Display as Quick Filter" - in fact I recommend you don't. In this case Select All does not include every possible Store Location, but it's actually including all Store Locations that are currently visible.
For example, if I only have sales this month for stores A, B, & C so far then the Sales Location filter on a month to date card will only show checkboxes for Store A, Store B, and Store C. If I choose Select All on the Quick Filter that means I will only see data for those three stores, meaning if Store D makes a sales tomorrow I will not be able to see it.
If you've been clicking Select All on all your quick filters then it's possible that you've got some data being excluded, which may also be contributing to data being excluded unexpectedly.
Re: Exception: Error retrieving a Domo API Access Token
Have you created a Client ID and Client Secret from developer.domo.com and are you passing those value into your Domo constructor?
Re: Single Value Card Number Formatting
@Laura_M1 It sounds like a granularity issue. Is your measure a dataset field or beast mode? Also, if you have any sort fields being used in your card I suggest removing those
Re: STR_TO_DATE
@RayRay_H It looks like there may be a space after the date in the error message. Try replacing the spaces with an empty string before using the STR_TO_DATE function
STR_TO_DATE(REPLACE(`Date`,' ',''),'%d-%b-%y')