-
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…
-
Mexico city zipcode map in DOMO
I am looking to add a custom chart for the city of Mexico on Domo based on zipcodes (supported file format - svg, GeoJSON, kml) . Please share if anyone has any reference links. Thanks in advance.
-
Choosing first and last month in BM
Is there a way to use fixed functions or something else to grab the first date that appears and the last date that appears? I am trying to calculate yearly attrition. I have it by month but adding up or avg the monthly % is not mathematically correct. I need to get the first month and last month's values within a certain…
-
Can't seem to sort the dates on the X-axis
Hello, I have 2 cards next to each other. One has a date field in the dataset already and another one date is calculated like this DATE(STR_TO_DATE(LEFT(Date + hour, 8),'%Y%m%d')) where the field "Date + Hour" field looks like this Even though the calculated field shows as type "Date" the chart sorts it as if it was a…
-
HTML Table Cell: Space Between Image and Text
I have a linked image of a video and the title of the video in one cell in my HTML table. How can I put space between my image and text in that single cell? I would like the text to just have a small space between it and the image. Here is my beast mode now: CONCAT('<div><a href="', Front End URL,'", "target="_blank"><img…
-
How do you set a table to automatically go back 2 fiscal weeks for a report?
I have a client with a custom fiscal calendar. I have a report that automatically returns data from the previous fiscal week (Sunday to Saturday). I need a second report that will return the same data from two fiscal weeks ago. Does anyone know how I can automatically have the fiscal week updated for this report?
-
Update table function throwing error in SQL transform
-
Org Hierarchy and Sunburst Chart Limitations
I'm working on a Sunburst Chart to show organizational hierarchy. I'm running into some issues where I've got 3 levels to my hierarchy and I'm only able show 1 of these without the visual disappearing. I've attached the sample data I'm working with and here is the setup on the card: Is this chart just not capable of…
-
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
-
Multi Value columns Displaying wrong %
Hi, Am I missing something here? I have this card that compares last month % to this month %. However, It is not adding up correctly and I cant seem to figure out why. The 19% is the correct value for this month. Last month the value was 23%, I am not sure where 14% is coming from. If I switch it to a table view you can…
-
Legend includes colour rules
Hi folks, The legend on a link chart is including the rules set for the colours. How can this be removed to just show the label Thanks
-
Displaying Zero value fields in charts over time
We have a chart based on data that is updated daily, however it only updates if the value has changed. We want to see the flat line, i.e. if there has been no changed over time. I've tried changed the chart types and even change it to year to date, it displays nothing i.e. no data Any ideas?
-
Multiple Values for Data science Chart
Hi, I am wondering if I could also display the low below the low Line in this chart as well. Thank you
-
Average Nested Bar
Good day everyone. I was trying to build a nested bar, but wanted the gray at the back to be determined by whatever aggregation we use for the calculation. So for example in the following graph, rather than showing me the bar in the back as the SUM of all the individual bars, it'd show it as the actual average of the…
-
Bargraph for Employees/Hour when I only have start and stop times
This will probably be obvious in retrospect, but I cannot figure out how to generate a chart based on the data I have. I have data in the following format: Name Store Date TimeIn TimeOut Alice 0001 1/5/2024 6:00 12:00 Bob 0001 1/5/2024 7:00 11:00 Charlie 0001 1/5/2024 7:00 9:00 Denise 0001 1/5/2024 8:00 12:00 What I need…
-
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?