ArborRose Coach

It shouldn't have a problem with spaces if they are in the correct place. Beware of leading or trailing spaces. Many languages are picky about case sensitivity. Make sure you match the correct spelling and case. And check data types of your filters.

Similar to other languages would be: student_courses.course_type is in (English, Science, Math)

Can you provide a small example simulating your data? Aggregate Daily Data to Monthly Level Use the transformation capabilities in Domo to aggregate the daily labor hours and wages data to the monthly level. This involves using the Group By function to group the data by month and then using the Sum function to sum up the…

How about this? COUNT(`Orders`) / (CASE WHEN DAYOFWEEK(`Order Date`) = 2 THEN 5 WHEN DAYOFWEEK(`Order Date`) = 3 THEN 6 ELSE 7 END) The CASE statement checks the day of the week of each order date: If the order date falls on Monday (DAYOFWEEK(Order Date) = 2), it means your team worked for 5 days in that week. This is…

These are not basic questions. I think you are already way ahead of me. Here's another exploratory test with bricks. In this example, you can enter a comma separated list into an input field. The data then sorts based on the list first, then the rest alphabetically. You could also modify it so it only shows states listed…

https://community-forums.domo.com/main/discussion/comment/91185#Comment_91185 Whatever helps you get an adequate solution. If I were tackling this as a problem of my own, I would try to explore using more than one dataset. Something that builds a dataset that acts as the sort order for the other. Grant is a much better…

The following example works as follows. Select a state such as New York, it sorts with New York first…then the others. Select a second state like Colorado, it sorts by Colorado, New York…then the rest. Select Ohio, it sorts Ohio, Colorado, New York, then the others.

Mark is absolutely correct. I forgot that was there.

I'm not sure if you are filtering or sorting. Here's an example of a dropdown selection that filters data (using Domo sale example data and a Blank Brick.

Having the sample dataset helps. I understand what you are trying to do. But I'm also not seeing it sort as I think it should. I'll look further when I have a chance.

I think you need to create a calculated field. Something like Total Sales, where the formula is SUM(VALUE). Put that in the sort.

I think your "FORECA…" series needs to be in the sort In my sample if I move value 2 to the front (blue), I get this sort.

Is it possible your series is affecting the sort?

The difference in widgets and visualizations might impact how they interact with the filters. Some things like maps, might not integrate seamlessly with the filter bar. The underlying data sources might influence the behavior with filtering. For example, one might rely on real-time or dynamic data while the other might be…

Hmm… • Make sure all parentheses are properly closed and all function names are correctly spelled. • Make sure the data fields you're referencing exist in your dataset and are named correctly. • Make sure Current Week Index is a valid reference. • Division by Zero: Make sure denominators are not zero, as division by zero…

@MayaU_01 - I think you should look at my response to another recent question. I showed the way I like to do what I refer to as trends. Comparing year to previous year and the year before that. I use the same calculation formula to compare previous quarters across multiple years. Using this calculation, add another line…

I'm a little unclear what you are referring to. When creating or editing a dashboard in Domo, there are specific settings related to filter visibility. Dashboard creators have the ability to control whether filters are displayed to end users or not. This setting can be toggled on or off based on the preferences and…

Consider using coalesce for months with no value. Coalesce lets us get a value such as zero, when the condition is null.

I'm about to be configuring the same thing. A few things you might try… Check your IAM role for permissions. Since you are trying to load files with ".json", set the file name field to "*.json". Make sure files are truly formatted JSON. Make sure your files are not being overwritten or deleted.

I do year to year, month to month comparisons using formulas. The results can then be easily added to a bar chart or table chart. Or a bar chart with the numbers below. Each day the numbers move based on the data. Today March is empty. When the end of day numbers come through, March will start to appear. Filters that are…

I'm suspicious of any code that isn't my own. But there's a site that can help with the Base64 conversion if you can't make it happen in your own code. https://www.base64encode.org The following may be useful… To get the client id and secret for your instance go to developer.domo.com. Steps for getting the Client ID and…

I hope I'm not including any of my private values in this. {cringe} The comment box reacts to the # symbols and such. So I will paste images. This code will download a file using the dataset's id set in the variable dataset_id. Id is found in the URL when you open a dataset in your browser. This code uses a Base64 version…

I don't have code to do a merge. But I can show you code for pulling down a domo dataset. And another for sending email. Generically its supposed to be something like this for pulling down a dataset. import requests Set up authenticationclient_id = 'your_client_id' client_secret = 'your_client_secret' base_url =…

I don't believe Domo has a direct API or method specifically for accessing its email notifications. I have sent emails using pydomo. I downloaded the information from a dataset to do a mail merge with my body. But as you are trying to avoid, it had to use my own smtp server.

If you are bringing the data in via API, you may have options to change the data type in the API settings. I use the NoCode oAuth connector, which has a schema definition. If the auto-detect does not recognize the data type you need, you can set it.

https://community-forums.domo.com/main/discussion/comment/90763#Comment_90763 I concur with MarkSnodgrass. It is supposed to indicate an error, which you should see if you look under history.

I would consider truncating long responses to a shorten text with (…) at the end. You can then put a tooltip or hover functionality that lets someone see more text when hovering. Or…create a drilldown. Instead of showing the full text, set a drilldown to see more details. Excel should be a better export solution, instead…

I think it depends upon the type of brick. My page with blank bricks allows me to add more cards with their own datasets, but I can't add more datasets to each card. However, the DDX Form and Dataset brick seems to have an icon to add datasets.

Perhaps there's another way to approach the problem. Can you provide a few sample rows of test values and a description of what you need?

I had this same thing happen to me last week. It turned out I miss typed single quotes rather than a back tick. I would have suspected order of operation but your parenthesis look right to me. Remove the space after the second occurrence of sum. Check column names for spelling and back tick quotes. If your first worked, I…