ArborRose Coach

I use the Json No Code Connector all the time. What is the error you are getting? With the Json No Code Connector, you setup an account with access. Then configure with your URL, which should be the end point for the API call. Start with no parameters or something that limits your dataset length as a test. At that next…

Oh….I misread. Domo Dimensions Connector. I'm not familiar with it. I have some learning to do. Thanks.

Something like this maybe? CASE WHEN WEEKDAY(appointment_date) IN (2, 3, 4, 5, 6) AND CONCAT(MONTHNAME(appointment_date), ' ', DAYOFMONTH(appointment_date)) NOT IN ('January 1', 'July 4', 'December 25') THEN 'Working Day' ELSE 'Non-Working Day' END

If I comprehend the suggestion correctly - create a month of working days. Exclude holidays and weekends. So you have from 1 to however many useful days exist in a month. Use rank to number them. And chart those in comparison? So for this month, March 2024, we would have 21 working days. I'm not sure what the Domo…

@MichelleH - I'm not sure what you mean. Can you explain further or point me to some kind of example?

@marcel_luthi. Oh….what's your name preference?

Use a beast mode calculation that subtracts the amount desired. If you want to compare to previous 10 days, it would be DATE_ADD(CURRENT_DATE(),-10)). The number of days could be selected from a static filter.

If you use something like (SUM(units) OVER (PARTITION BY person) / total_units) * 100 It should keep the % constant regardless of filtering.

For filters, make sure all cards use the same dataset and have a common field. Example, if "Sales Rep" is your filter, make sure all cards have "Sales Rep" and that its the same data field in the set behind. It can also be part of a subset. In my case, I have a main set of transactions. If I join transactions with another…

I like the ability to delete a comment. But does it have to be so cryptic?

I agree. And something to do with indexing and prepping that data. I think many of us have this issue. We're used to environments like SQL where we can deal directly with the data. And in Domo, we find ways to bend it to our will. @Elibot - thanks for the info on the repair parameter.

I asked Domo advisers to workgroup with me to help me do what you suggest. After explaining what I wanted to do…I was told we couldn't. That's doesn't mean its not possible. It means between me and the other knuckleheads in the work session, we didn't know how. I really like what @Elibot is selling, but I'm not familiar…

I'm not sure about using a histogram. I'd use a bar chart. Note - my fake data does not exactly match yours. :) Creating SizeAsInteger with the formula : CAST(RIGHT(Size, 3) AS Integer) You can create bins (show above). Which seems customary for histograms and sizing.

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…

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 source to give guidance on this.

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…