TheLivingBubba
Cloud Apps
Joined 11-07-2024
User Profile
User Widgets
Contributions
Grouping based on text field values
I have a list of companies in my data model (fake company names used in this example). In our industry these are grouped in certain ways. Unfortunately this data in not in our data model. I've been given it in a spreadsheet. Even more unfortunately, there's no way to add this data to the data model in the timeframe available. To create bar charts, I've been using a formula to create each bar independently. Something like: (Count ([Profit]), Company Name) and then using the filter within the formula to filter on the companies in each Group. It's cumbersome, slow, & prone to error, so I'm wondering if there is a better way to go about this? Essentially, I'm looking to create bar charts & pivot tables that look like the examples below where I can easily use 'Group' as a field. Thank you in advance for any help or assistance you can offer.Scripting Issue - second script prevents first script from working
A colleague is having a scripting issue where one appears to stop the first from working. The first one (const columnsToRenderAsHTML = [1];) renders the field as HTML while the second one changes the cell color depending on the text. Each works fine on its own, but when the two are together only the second one functions. Excuse my ignorance if this has a simple answer, but I'd genuinely appreciate the Community's assistance here.Filtering on a specific range of hours
I have a colleague who needs to filter a dashboard on a very specific time period - from 08:00 yesterday morning to 08:00 this morning. They don't need/want all of yesterday before 08:00 or any of today after 08:00. I've tried playing about with the custom code functionality, but haven't been able to make it work & would be very grateful for any help that might be offered.
