ArborRose Coach

Unless it came out in a recent update, I don't think Domo has an option to disable the collapse functionality. But you could set to display all rows by default. That should prevent collapsing.

I don't recall seeing an option to force all entries to show. Then again, I don't normally see them hide. Can you reposition the legend to give more room to the legend?

How about this: SUM(CASE WHEN COUNT([PhoneNo]) OVER (PARTITION BY [Location.ID], [PhoneNo]) > 1 THEN 1 ELSE 0 END) / COUNT(DISTINCT [PhoneNo]) * 100

This might help. I did some testing a while back with pulling user info. I believe this is how I did it. The domo api can retrieve user information about the currently logged user.

Apologies for not following up. I got hit with Covid and I'm barely functioning. If you were able to get a preview, then your account should be working. I would look at how the paging is setup. You can try to debug using Postman, but I'm not familiar enough to help you. The browser also has a console which can be used to…

@marcel_luthi - I pondered that issue about a weekend action. In the data I'm working in today, it's not an issue and I can throw it out. But you could put some condition in your calculation. I haven't been able to look back on this formula as my day is getting crowded with other projects. But here's where I was last on my…

Oh..btw…I have gotten that error when my values were not wrong. Clicking the icon is like a refresh. Once or twice it was just a hiccup.

Assuming your account works….big assumption btw. You should see data selection. Enter your URL. There's an advanced link but it probably shows way over on the right. You can set parameters in advanced. Based on your comment, I am guessing the account part is okay. At that point you get to pagination, where the error is…

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…

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.