-
Solution: Beast Mode & Pivot Table Aggregation Error
Use Case: This chart uses a Beast Mode code for the Rows and Values in a pivot table chart. The results provide an error that is hard to understand without knowing what is causing the issue. Based on the results, we can also see the Cases is not calculating as expected. The dataset only has 5 rows of data. The Rows column…
-
Future Date Filter
Hi, I have an App Studio app that I would like to add a quick future date filter to. This is similar to the presets in the Date Slicer Filter, but I want to allow users to select Week to Go, Month to Go, Next 2 Months, Year to Go, etc. I considered using a Beast Mode, but "Week to Go" would not be included in "Month to Go"…
-
Beast Mode: Why am I not getting the correct number of enrollments per academic year?
I created a Beast Mode calculation to extract the academic year based on term codes. For example, to derive the academic year 1955-1956, I identified these three term codes: 1555, 1561, and 1563. 1555 is Fall 1955. The 2 digits in between are the year. (The last digit ‘5’ represents Fall). 1561 is Winter 1956. (The last…
-
Need to Comparison Single Value Chart
This chart should be changed based on any date range selected by user and compare the value based on the date range selected by user. For exampale if user selects 10days it should compare with prior 10 days; if 30 days prior 30 days. Is it possible to do in Domo?
-
Missing dates - but not
Hi everyone, We have a few cards that have quite a bit of data to them. Over 1m rows in this case. When we open up the card view and try to find the date in the scroll menu, it doesnt show up. The saving grace is when we type it in, it works and is there (plus it shows in the card it self.) I am wondering, is there a way…
-
Pivot Table Date Range
Here's my pivot table setup: Rows= Project Name, Financial Category Name Columns = Financial Month Values = Actual Cost Works well so far, but what I'm now looking for is to only show the date range of the projects included in the pivot, so Financial Month would be the way to go. However, in the Date Range Selector, the…
-
Replicate Spreadsheet P&L in Domo
I am hoping for help in recreating a simple P&L generated by my finance team in Domo. Attached is the concept in excel format. I'm looking for help on the following: What is the best way to structure this data? I have the data for the revenues and costs in a table where each row has the Period amount (i.e. Jan 2024), and…
-
Why is my grand total a negative?
I am trying to find out why the total is -$379,041. If you add up Week Ending Dates for the Test 1 Forecast, it should equal $710,766. What am I missing?
-
Date Selector Filter Card: default selection?
I have a date selector filter card on an app (no calendar view, just preset view) & I would like to force a selection 'Last Month' on this card so when someone open up this App, this filter is already selected like this:
-
CYA, LYA, and Budget, Oh My!!
BLUF: Can you change "Previous Year" in PoP charts to just be the actual year? I.e. Instead of "Previous Year", it would just say 2024. Second, can you have Current Year, Last Year, AND this year budget all in the same single chart? My gut response is no - but I know it's the first thing my end users will ask so I want to…
-
Why I cant aggregate my summary number in domo table chart
I am trying to show "flag"number in summary number based on the card i created. however it seems that this column "flag count" doesnt have a aggregation option. I am seeing 0 in the summary number. Even I tried to use the beast mode to aggregate it tells me there is a syntax error. (See attached beast mode screenshots) The…