Property_Ninja Contributor

Hello, Have you tried to sort by total value, so the labels show the most populated countries first? Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

Hi mfaas, I believe you may want to use <span> instead of <div> The <div> element is block-line, which is equivalent to having a line-break before and after it. Here is an example of something I have written using HTML in beastmode. I use <span> but when I actually want a line break I use the <br> element.…

My original thought was the csv format was automatically converting your columns but even when I uploaded an xlsx file I received the same result. It seems like the file uploader in Domo converts anything that looks like a number to a number and anything that looks like a date to a date. You can use the google sheets…

Hello, Could you provide a little more detail? Like how are you currently loading in this data (ie: Domo Workbench, google sheets, etc.)? Brian

Hi, You can create a beastmode to bring into your filters to eliminate the current month from showing. Something like the below. case when `your_date` = DATE(DATE_FORMAT(CURRENT_DATE,'%Y-%m-01')) then 'TRUE' else 'FALSE' end Then you can just filter for "False" and it will show YTD minus the current month Best, Brian…

Hello, I don't believe you can plot both ranges and points to the same map card. The closest you can come to doing this in one view is using the World Lat/Long card type. This card will plot all points in each country but will change the plot circle size depending on how many customers are in each country. This card allows…

Hello, I don't think you'll be able to get what you are looking for in a radial guage, unless you are willing to create a beastmode to show percent to goal (this will dynamically change for each region and you can keep your max value set at 100%). If you want to show sales vs goal with actuals, the closest you will be able…

Hi, I am not entirely sure what you mean by combining the maps but designing a custom Domo app in Adobe Illustrator is very simple. I started with no illustrator experience and have created multiple apps using the Domo plugin. Below is a link to the tutorials where Domo walks you through the process.…

One thing you can do is group the datediff into buckets using a beastmode case statement. Like for instance if I was looking at the date difference from when a customer clicked a photo and when they edited a photo and I knew my average was 30 days, I may group the number of times the action happened into buckets and look…

Hi Prajwal, Could you please provide a little more context to your problem and maybe an example? I am hesitant to say just create a beast mode using the DATEDIFF() function then bring that into your Y Axis, changing the calculation to "Average," if your problem happens to be more complex than that. Thanks, Brian **Please…

Hi Karel, What you will have to do is set up two filters in the app. You will have to add your secondary filter to the "WIDGETS TO FILTER" section of the primary filter and choose "Display Name" as the Column to Filter. So when you make a selection on your primary filter it will cascade to your secondary filter. An example…

My only other recommendation in this current card would be to add Start Date and Briefing Center to the sorting section. If that doesn't work I would try selecting a new chart type (grouped bar) and if that doesn't work. I would start from scratch and create a new cards because it could be some sort of bug. Best of luck,…

Hi, I honestly think it may be your rolling calculation in the filter causing problems. Try removing that and changing your date range to Last 14 Months by Month. Then create a beast mode to exclude the current month. Something like ... (CASE WHEN ((Year(`start_date`)=Year(current_date())) AND…

Hello, You can achieve this by using a "Period over period" chart type. Choose "Variance line bar." Input your time period in the x axis and then your value in the y axis. Go to your date range and choose last x number of months graphed by months. Then input a 1 into the "Compare to x month" box in the date range to…

Laurette, I do not have much experience with transforms but it looks like calculation builder only has specific available functions, none which will calculate a date. Are you able to write the convert code directly in the source instead of using the calculation builder? Brian

Hello, You would probably have to write 5 different beast modes and they would look something like below. You still have the ability to use all five calculations in the same chart if you drag the beast modes into the card "Y Axis" and "Series." --Stage 1 Conversion COUNT(CASE WHEN Status = 'won' then `Deal Title` end) /…

Hi Laurette, Did the above help out? Additionally, you can do the same with DATETIME as I see that is referenced in your subject. (CONVERT('YYYY-MM-DD HH:MM(put colon here, it kept making a smiley face when I used one in this post)SS', DATETIME) ie: CONVERT('2018-01-01 07:22:45', DATETIME) **Please mark "Accept as…

Hi Laurette, You can use the convert function in the workbench. I just tried, CONVERT('2017-01-01',DATE) AS date and it came through as a date format (1/1/2017) in Domo. Let me know if this helps. Thanks, Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the…

Hi John, In ETL you can input your detailed dataset, then your next step would be a "Group By" under "EDIT COLUMNS" where you select what columns identify the grouping (agent and date), then name your new column in step 2, choose which column you would like to aggregate (commissions paid), then lastly, choose how to…

Unfortunately, beast mode does not currently support this functionality. Please see the below post for more information. https://dojo.domo.com/t5/Card-Building/Using-date-dropdown-to-manipulate-a-card-that-aggregates-using/td-p/28532 Thanks, Brian

If I am understanding your problem correctly, you could create a beastmode calculation with sum(forecast1) - sum(forecast2) and use it for the vaule. Then all the user would have to do is pick the date field to filter by and choose "is between." - Brian

I completely forgot about the stream API. We actually have created an in house .NET service for pulling from different datasources and pushing the data to other locations like DOMO. I was worried about performance and having to store overly large chunks of data in memory before sending it over to DOMO, but it looks like…

Thank you @AS for the response. After doing some additional digging, I realized that DOMO provided some code snippet examples with their latest Workbench 4.5 download. Along with the code snippets they also included some documentation for creating the plugins. These can be found inside the SDK directory of workbench…

@Hua are you using the DOMO's http client to make the request and using the correct HTTP method? example: ar res = httprequest.get('$myURL'); You may also need to add auth to the header of the request as well before making it. example (for basic auth): httprequest.addHeader('Authorization', 'Basic ' +…