froghunter Member

I did that in the actual code, but kept it general here. It's actually called definition_display_value because that's so simple and intuitive. :-)

Thank you. That looks promising. I've updated a little bit for formatting and added END. I'm getting a syntax error, but that may only be a matter of figuring out where it lies, so I'm replacing pieces with simpler elements to find the location. Here's what I have: CASE WHEN SUM(response = 'Good') = COUNT(*) THEN 'All…

That's related, but not quite what I'm looking for. What I would like to do is exclude everyone that is only happy, but for those that remain show all data, including happy responses. So, on a graph like this: I would like to exclude Bob, but keep everyone else exactly as they are, including the good parts.

Thank you. That's a clear answer.

Hmm… maybe I figured it out. sc_request has not failed yet… Fingers crossed. Edit: Yep, that worked. I'd like to thank me for the help. 😁

That is unfortunate, but is as I suspected. Thank you.

Thank you for the reply @jaeW_at_Onyx. Just to make sure I have the right idea, here's what I think I need to do, in very general terms. Since my org is using SSO, I am forced to use client ID and secret. Log in to Domo using client ID and secret acquired from developer.domo.com. This means using DomoDeveloperAuth. Once…

Thanks for the reply, and sorry for not responding sooner. I did try specifying url_manual_login explicitly, although I don't actually have a manual login to use. So, I did url_manual_login = None. That didn't help. The problem appears to be that I've not used set_manual_login and yet it is assumed. If you see my…

Thank you both for the replies. I'm checking out domolibrary now, as I would like to be able to back up offline and programmatically.

Thank you. I appreciate the response, particularly from direct experience. I'll explore this further… I look forward to this being a completely hands-off process. Out of curiosity, have you done anything like syncing data from within a Databrick or similar context?

Thank you. It makes sense that a Pivot Table would preserve filtering. It still isn't working, since for some reason the count of Group that I'm using as the Value is simply displaying the name of the group. But it's a step in the right direction. Update: All done! It required a little data magic to get a valid counter,…

Apologies for not responding sooner. I had to move to another matter for a while. This worked. Thank you for the clear help.

Thank you. That looks like it handles the data part quite nicely. Is there anything comparable for ETLs, Beast Modes, visuals, etc?

Thank you both @GrantSmith and @MarkSnodgrass. No, the idea of making a beast mode to produce the entire body of text never occurred to me. I can only plead newbness. For anyone else trying to solve a similar problem, here's what I came up with: CONCAT( 'On ', CURRENT_DATE(), ' there are ', COUNT(CASE WHEN active = 'true'…

Thank you. I appreciate the response. I hope that they continue. I generally try to optimize intelligence-presenting screen area, and I'd love to improve this as well.

As always, @DashboardDude has made an awesome tutorial. I've made a small modification that might be useful once I've figured out a small discrepancy. My datetime column from Excel has decimal values indicating a part of a day. Ex: 43655.9497453704. This means that it can't be used in the date tile that follows the…

Nice, that's good to know about. Thank you. I'll submit the suggestion.

@MarkSnodgrass thank you for the video. I'm still working on it. I ended up getting what I needed with the other suggested method, but this has enough interesting ideas that I'd like to keep at it. @DashboardDude, thank you. This worked very well, and with it laid out like you did it became pretty straightforward. I didn't…

Thank you for the reply. I am doing as you say: That makes the values appear in this order in both the table and the individual category column groups: This is what I'm calling a "category column group". There's probably a better name than that...