-
Burndown chart
I am trying to create a card that shows a burndown representation of my data. My data has to do with Courses, estimated time to Complete (Duration), and Actual Hours to complete. I think to create a burndown I need a new column that gives total Duration per year of all courses due that year and then I want to be able to…
-
Identify percent of people attending current event
I am currently trying to gauge how many consistent event attendees are attending our upcoming show. For context, we have 2 events every year and every registration for an event is on a separate record which I have categorized by year between 2021-2024. I am trying to roll this up into a table that gives us a percentage of…
-
Dynamic Weekly goals
We have 2 tables: OrderDetail - which stores order info like date, sku, quantity, price, ect SalesGoals - DateWeekStart, DateWeekEnd, SkuQuantityGoal, etc Is there a way we can do a visualization that dynamically shows the weekly sales against weekly Goals? I am new to this, so I am not sure the best way to set up the sql…
-
Filter on Total Column?
Can you filter on a total column? We are using a pivot table to calculate our selling capacity per areas, per therapist discipline but hoping to remove any that have a TOTAL less than 5 for all of the disciplines in an area combined. Wondering if I am missing a simple filter options vs adding a few more beast mode…
-
Heat map totals to use AVERAGE instead of SUM
Hi folks. I have a heatmap with the values as averages of values within the data. I've asked domo to add a 'Total Row' and a 'Total Column' (red outline below) but rather than these also being averages - domo is totalling the rows/columns. I need them as averages. Any ideas? Thanks
-
percent change is showing a large #
I created this beast mode which has the logic (current value- previous value)/(previous value). however when I show it in the summary and change the format to percentage it gives me a large percentage number. I'm trying to calculate the difference between 2.88(prev) and 2.2(current) (avg(CASE WHEN created date >=…
-
How do you show % increased or decreased in the summary label?
-
Is there a way in Domo to show/hide columns in a table type of card ?
so I have a table card which has 10 total columns (i.e. column 1-10). I want to give an option on my end application (where I would embed my dashboard) to user to see only selected columns dynamically in this table. So a user can select that I don't want to see column 5 and column 8, so this table should hide those 2…
-
How do I change the calculation on my chart
I'm pretty new to building dashboards, and have mainly done front-end organising and stuff. I'd like to change the calculation of my chart, currently it is showing % of total respondents, but I want it to change that calculation to be % of players who answered a specific code in the previous question. e.g. instead of the…
-
How to Sort by ASCII (caps first)
I have a user complaining that their pivot table column sort changed recently. It used to sort capital letters first. For example, it used to sort DOMO before David, but now it sorts David before DOMO. Now it ignores upper/lower case when sorting. I prefer ignoring case when sorting, in general, but is there a way to sort…
-
Heatmap - Configuring Display
Two questions… is it possible to have the X-Axis labels at the top, rather than the bottom? Is it possible to set a fixed width to the columns as is doable in a standard table? Have been searching, and evaluating Properties, and have not found solution to either of these two.
-
Defining Custom Color Palettes
It would be nice to be able to define custom color palettes to choose from. I don't mean the ability to set color rules on datasets or cards, or the white label features in embedded analytics. I mean adding your own palettes to the color picker for internal dashboards. Right now, having to use hex codes for everything is a…
-
How do I get future data being populated to current year?
I have a requirement to show Next fiscal Year data into Current chosen fiscal year. So if user choses , FY 23, it should show data for Fy24 in 1 column. Please see below: If FY is selected, then monthly data is shown for current fiscal year. and similarly NextFy data (Fy+1) is also displayed like below. Please suggest.…
-
Spreading out labels so it's easier to read
Hello, I am trying to spread out more the following labels that come from a Lollipop chart so it's easier to read, but am having trouble finding the setting in analyzer. Thanks for the help!
-
How to change color of bar charts (top 5)
Hello. Can someone help me if there's a way to use a different color to indicate the top 5 items in the bar chart dynamically?
-
% of Total Using Distinct Count
I need to show a % Total of Accounts in the below card. I used the following to get the below % of Total accounts. However, there are multiple rows per account name. The # of Accounts column is calculating a Distinct Count, but the % of Total appears to be calculating of the # of rows, not a distinct count of the Account…
-
Page Filters - Use a text value in "Contains" on filter and save as filter
Hi there, I think this is a feature request.. but just asking a question in case I missed it.. When using a filter on card on a text field, you can use a contains "blah" as a condition. Great.. But then when you go to a Page filter, you can only select literal values (I know you can search and click "all" to get a similar…
-
Hamburger button on top left not working in edge.
When I move my mouse in EDGE to the button nothing happens. No fly out window… sometimes it blinks like it tried to work but never does. It works perfectly in CHROME. Any ideas how to fix?
-
Dynamic Columns Line Chart?
Hey everyone, does anybody know if there is a way to either convert this to a line chart using the code in this brick or if there is a seperate brick?
-
Calculated line on Bar Chart not the same as Summary Average
I am trying to figure out why the calculated line for a bar chart I am creating is different the the Summary Average of the same metric. Is this a rounding issue or something else? Thanks in advance.
-
Can I show 2 values as a stacked bar and other values as single bars?
I've been asked to create a bar chart that shows 4 values: Prior Year, Actual, Forecasted, and Goal. The request is that the Actual and Forecasted amounts would stack on top of each other for easier comparison but I'm struggling to find a chart type that will support this. I looked into the Grouped & Stacked bar chart…
-
Case Statement Help
I'm trying to write a simple case statement, but it isn't working as intended. My data set has an attribute for Customer ID. When populated, this indicates that a customer was attached to a sale transaction. It populates with zero if no customer was attached. I want to count the unique customers that were attached, and…
-
Getting x axis sorted correctly
Hi, Any idea on how to fix this so that its in the correct order? The last two columns just need to switch. Its sorted by year and week right now.
-
Display a zero value
How do I display a zero value for a location which has no data. I have 7 locations with only 6 displaying because the 7th location has no data. How do I get the location to display in the table an show a 0% value?
-
Updating Color Rules on Symbol Line Chart
Hello, I am trying to do exactly as was asked in this forum question below. The only difference is that I have multiple lines and many timestamps on the x-axis. Given that this question was asked a bit more than 3 years ago, is there a better way of doing this?
-
Displaying up and down periods over time in a chart
We are tracking internet down time at our stores. Basically every 15 minutes we receive a list of all stores that are currently up. I then process that and for every store that was missing in the list I store a record in a dataset with the store and a timestamp. We need to show over a 24 hour time period what stores were…
-
Cumulative Sales between December and January not calculating correctly.
Hello, I'm trying to create a table with daily net sales by date and also cumulative sales up to the current date (1/3 ATM) between two years: For the "Date" column, I used a beast mode to create date index formatted as %m/%d value: CASE WHEN YEAR(`created_at`) = '2024' AND DAYOFYEAR(`created_at`) <= DAYOFYEAR(CURDATE())…
-
MoM Variance in Pivot
Hi All is there a way to display the MoM Variance values in a pivot? for context i have data per day for Company, Division, Subdivision hierarchy, i can easily display the values at the end of the month in the hierarchy state but what i would like to do is calculate/display the monthly movement with the ability to drill…
-
Company Overview Chart Color Picker
Hey all Just found this in company settings and didn't have it enabled. I was looking at cards and colors and I see no difference. Anyone know what this does?
-
Supress Zero Value rows in Pivot table
Hi, Do we have an option to suppress complete zero value rows from pivot table. Thanks