-
Quarterly Snapshots of Data
Hi gang! A two part question where answers that a newbie like me can understand are very much appreciated please :) I need to build some cards consisting of quarterly snapshots of a dataset. The dates aren't fixed, and I would like to have control over when the snapshots are taken. What's the best way to go about this? In…
-
Is there a setting to stop Legend partially hiding?
You can see in area of the card below that I've highlighted, that the top value of this Legend vanishes when I interact with the card. Can I stop this behavior? Thanks
-
Show only 2024 costs
My usual disclaimer: I am not a programmer, and usually need an ELI5 for this :) I have a version of this code working that is intended to show the total PlannedCosts when summing the 5 FinancialCategoryName types I have listed. Basically the same thing without the YEAR(Month,2024) AND piece. That works. Now I'm trying to…
-
3 Key Features Missing in Gantt Charts
Vertical Scroll Bar. Currently, when we have a lot of data to display, we are forced to have huge Gantt Charts so that the text is readable, or we are forced to keep the Gantt Charts smaller, but accept that text will not be readable. The ability to add additional columns to the left of the Gantt Bars. It should be…
-
Chart Showing only Projects with Cost; how to show all projects?
Hi all, I have a simple Table Card with only two filters, one for project number, and one for project phase. 97 projects meet this criteria. One piece of information I'm displaying in the Table Card is the planned project cost. At the moment, only 50 projects have a planned project cost. The chart is only showing these 50…
-
Start Date End Date Filter? Date Selector or something else?
Is it possible to have a card that's a simple two box date range filter? Click Start Date, calendar popup appears, pick the date. Click End Date, calendar popup appears, pick the date. The Range Selector is too cumbersome when there's a lot of dates over many years, which is why I prefer not to use it in this case, and I…
-
Dashboard Order
Within Manage Dashboards, I've ordered my dashboards in the order I want them to appear for all users. I just had a user log in, screen share, and they're in a seemingly random order. Any ideas why? Their permission level is Participant.
-
Custom / Manual Sort Order
Is it possible to have a custom sort order on a chart when none of my attributes provides the sort order I want? Or alternatively, I know I could force the custom sort order I want with an alias in a beast mode, but then could I change the bar labels to what they were originally?
-
How to wrap a DATEDIFF around this?
As always, I probably shouldn't be allowed near Beast Mode :) Can someone explain how to fix my code? I assume I'm not adding DATEDIFF in the right place, as I'm always breaking it. BatchTimestamp is the date the Phase was set to the respective value. I just need the number of days between the two. CASE WHEN `Phase` =…
-
Date Slicer - Years Only
I'm looking to add a Date Filter Chart to my dashboard. I want to use the Slicer, and have one button per year, 2022, 2023, etc. I'm basing this on my record CreatedOn date, but in doing this, it shows me every date that a record was ever created. I've seen the Date Selector Chart Type, but this seems to be a full calendar…
-
Table Chart Average Row
Is it possible to have the last row of a table be the average of all values in the respective column? I see options for Totals & Subtotals, but am not seeing a way to make these an Average instead of a Total. Thanks!
-
Rename Filters? Persistent Filter Selections?
Hi all, Two questions today: It it possible to rename filters as they appear at the top of a dashboard? Some of the attributes I'm using for filters have ugly names, and then Domo also adds on the "_p" to the end, so the filters area doesn't look very good visually. Is there some way to have the selection options within…
-
How to reference a Beast Mode in antother Beast Mode
I've seen this in Ideas Exchange, and it sounds like it's coming, but it's not here yet? What's my alternative for now? In my database, I have an attribute that contains values from 1 to 10. I need to invert these in Domo, and I have a simple beast mode which does that (1=10, 2=9, 3=8, etc.). I now need to reference that…
-
Default Setting to Pin Dashboards Side Panel for All Users?
It's not entirely intuitive that it exists for new users, so I'd like it pinned by default for all users. If this is possible, could someone direct me to the setting for it please?
-
Understanding Gantt Chart Dates, and Date Filters
I'm struggling with this more than I think I should be, but as always, I probably need an ELI5 version :) I have a Gantt chart where my Start/End Date is my Project Start/End Date. My first question is simple; how do I have my Gantt chart start at today, regardless of what the Start date is? I want today to the last end…
-
Default Dashboard instead of Overview?
Hi friends! Is it possible to have users open Domo to a specific dashboard each time, rather than to the Overview? Thanks
-
Can I add users to a group without them getting an email notification?
I'm not entirely sure if I'm doing this the correct way, but in preparing for the launch of a dashboard, I was adding users to the Default group via Admin > Groups > Default > Add People then check mark next to their name, and Save. This is automatically sending out an email notification to the added users, which I don't…
-
Various issues with Scatter Charts
Hi all, I have 4 key issues that are holding back some Scatter charts from being finalized, and visually appealing. Not all bubble labels are shown, even when a bubble is by itself, and there's plenty space for a label without it infringing on another label or bubble. If I turn on Allow overlap, I can see all labels, but…
-
Count Attribute Instances instead of Projects
Hi everyone! In our system, a project can have up to 9 go-live dates. I am comparing our 2023 planned go-lives to the actual go-lives, to determine if they were on-time (with a 25 day allowance) First, I use this BM to determine if the go-live was in 2023: case when Year(Actual Business Go-Live 1 Date_p) = 2023 then 'Yes'…
-
Look for text within multi-selection value
Hi all, I currently have code like this, which converts some selection values to a shorter display value when Business Division_p = 'Biologics' then 'Bio' The problem is that the attribute is multi-selection, so when there is more than one value selected, there is no match. How can I change this line of code to look for…
-
Scatter Card Quadrant Lines in Wrong Place
Not really understanding what's going on here. I have a Scatter chart with 1-10 values on both axis. If I set the Quadrant Lines to appear on 5 for X & Y, the horizontal one for Y appears correctly on 5, but the vertical one for X appears on 8. Any idea why this would be? Thanks
-
Please add a Vertical Scroll Bar to Gantt Charts
This is available on other Chart types, such as tables. Thanks!
-
How can I get vertical scroll bars on charts?
For instance, I have a Gantt chart, with let's say 100 rows, but I want the card size to only show 20 at once, then have the user scroll vertically to see more. Is this possible?
-
Beast Mode to Compare Dates with IF
Hi again, This might be my last piece to finalizing my current dashboard. Each project has three types of go-live dates: Initial Adjusted Actual For each of these three types of go-live dates, there can be 10 instances, so 30 date attributes in all. They're numbered Initial 1, Adjusted 1, Actual 1, Initial 2, Adjusted 2,…
-
Adding extra budget condition in Beast Mode
Hi team! This is my first post here, and I'm very new to this. I've built some incredible dashboards in Domo, but when it comes to code, I struggle a lot. I have this simple Beast Mode working well (although it won't paste those funky apostrophes): case when Actual Costs > Planned Costs * 1.01 then 'Over Budget' when…