-
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…
-
How do you change the field used for the date range on a card?
I need to make a table with two date fields (report_date and report_sent_date). Domo used to allow you to choose a date field that you used in the Date Range, but now it longer lets me do that. If I just have report_date, that is the date field used on the card. But whenever I have both, it changes the date field to…
-
Previous Month Last Year
I'm trying to make some companion comparison cards so that I can display, for example, on one card the top 10 PDFs downloaded last month this year versus another card with the same month last year. I have the data by month already, and I need to have this for each month, moving forward. Is there an easy way to set some…
-
Last Year To Date formula
I need to measure sales at the Year To Date and compare sales to Last Year To Date. What is the date formula to get Last Year To Date?
-
Issues with Average Function
I have detailed biweekly pay data where I am looking for the average hours worked in every region per week (using a basic calculated field). This functioned well for 6 months but became an issue at the start of the year. Rather than finding my typical averages, suddenly the data is showing me trillions of hours in every…
-
Is it possible to create a tooltip for one column in a table/card?
Say I have a column "Masked PhoneNo" that shows ***7890. Is it possible to hover over this text (usually a column in a table) and display the full PhoneNo (123-456-7890) which is a different column in my dataset?
-
How to get 2 decimal places only
Hi, I am using a beast mode calculation that results in a ratio for forward to manager : hire CONCAT(Sum(CASE WHEN To Step = 'Forward to HM'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number)) , ':', Sum(CASE WHEN To Step = 'Hire'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number)) ) The result is this: How do I get…
-
start of the week in the date filters
Hello! I have the date filters as presets in a dashboard, and I have already chosen 'Monday' as the first day of the week. However when I choose 'last week' in the date filters, the data are shown from Sunday to Saturday throughout the whole dashboard. Is there a way that I can have the daily data from Monday to Sunday…
-
Pivot table: Change Subtotal to Average
Hi everyone, I am facing a problem of presenting averages as the 'Subtotal' instead of the sum as subtotal in pivot table. The following picture is the context of this issue: The columns are working days and the rows are monthly data for shop 1,2,3…. The source data is daily data. However, for this table, each cell is…
-
Customizing Pivot Table columns
Hi All, I have created a pivot table from a data flow. The current setup is "Months" in the columns and "SUM of Sales", "SUM of LBs", and "SUM of Cases" in the Values. The output gives me columns of January Sales, January LBs, January Cases, February Sales, February LBs, February Cases, and so on. Is there a way to switch…
-
Radio Button Filter Card - Set the default selection?
Hello, I have a Radio Button Filter Card on my page. I'd like a default value to be selected on this card. However, I can't seem to find a property that enables that. When i use Page filters to set a default selection the user can clear the filter, or filter on multiple values (which defeats the purpose of the Radio Button…
-
Adding Sort to Custom Values
Hi, I have a card that identifies days since last activity date: Days Since Last Activity Date: DATEDIFF(CURDATE(),Enrollment Initiative: Last Activity Date) And I made a bar chart with a custom range using this beast mode: CASE WHEN Days Since Last Activity<7 then '<7' WHEN Days Since Last Activity<30 THEN '7-30' WHEN…
-
How to visualize survey responses - 4 statements, 5 possible answers
We collected survey responses from customers for multiple programs, where they submitted their disagreement/agreement rating for 4 statements. An example of how the data is collected is attached. I would like to have a drill down that shows the distribution of those answers for each statement for only one program (bonus if…
-
Multi-period projection not working with my dataset
I'm new to using multi-period projections within card properties. The good news: I was able to successfully utilize this multi-period projections feature with a nearly identical card, except I selected "fall" terms in my filters. However, when I "Saved As" to create a new chart and simply changed to "summer" terms in my…
-
Pivot Table Collapsing
Hi all, I used to have this card setup so the pivot table was expanded out one level and it worked fine up until a month ago. When I view the card all levels are collapsed in the dashboard view. If i go into the card to expand it out and click save, it keeps defaulting back to a fully collapsed view. This didn't happen…
-
Showing min, max, and average lines for chart with Series included
Following up from discussion here: This has been closed. But my suggestion is to offer this as a feature / option: Create min, max, and average lines based off of totals. A second option can be to create color-coded min, max, and average lines based on each individual Series, but unless there are a very small number of…
-
Is there any way to incorporate search within a table?
I have a table in my dashboard (see attached image) that I would like to incorporate search into. Is this possible?
-
Hi , Am getting the error while saving the card
This error " There was a problem saving your card, If the problem persists, contact Domo Support Team. Please assist on this.
-
How do I save my card when it throws" there was an error while saving your card'
I have tried troubleshooting the issue by refreshing, creating the beast mode calculation again, validating it , saving it and saving the card, still the same issue
-
Expand/collapse rows only working for first level of pivot
Hello. I have a pivot table with 3 values for rows. I am able to expand/collapse based upon the first value, but not the second. When I click on the "+" next to the first value it expands to out all three values … but when I click the "-" next to the second value, it collapses everything back to the first value (i.e. how…
-
Different time zone
Hi! I'm trying to configure the time zone in ETL but my query is resulting in different times when the function calculates the difference, for the same column. ETL time zone function: Imported table from SQL Server: Result after time zone changes: The date range of the table is from Feb 24 to Mar 12. From Feb 24 to Mar 8…
-
How To increase the size and change the Card title font
in the above visual , How do we format( resize , Change color etc ) of the card title "APP DOWNLOADS &INSTALL BASE |By Month"
-
How do you get rid of the max, avg and min in a chart
-
How to calculate Average
-
Shows in Analyzer but not in dashboard
Hi, I've created a YoY comparison chart by month and it shows up fine in the Analyzer mode. But when I 'Save & Close' it doesn't show up on my dashboard or through the PPT plug in. This is the view in Analyzer: Then this is what I get in the dashboard: I'm certain it's Operator error! Thanks!
-
Force a filter selection on filter card
I need (and have often needed) a way to force a selection on a filter card for a dashboard. I know I can set default values, but I need a way to ensure at least one selection is always made. Anyone found a workaround here?
-
Have a row displayed with 0/NULL when filtering by date when there's no data
Tried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting the data into a Pivot table and have campaigns as a Row. I'd like to have every campaign show in the table even when it has no data to report for the selected time frame. It essentially would the the row for the campaign and…
-
Disable the collapse option
Hi, Is there a way to disable the collapse option on a table so users cannot collapse a table. I want all rows to be visible. Thank you
-
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
-
Fixed symbol color on latitude-longitude maps
Hello, I'm using a latitude-longitude map chart type to display my different programs across the U.S. map. Each program is automatically assigned their unique color for the plot point (which is fine) but when I filter the data to show single program data, the plot point color changes automatically (from green to red). Is…
-
Comparing weekly data
Say I want to compare 2023 and 2024 March data. In 2023, March starts on a Wednesday. In 2024, March starts on a Friday. If I chart day of month, I can visually see the weekend gaps. I'd like to find a way to compare weeks to the previous year, that executives could easily understand. But because of the movement of the…