-
Beast Mode - Checking data from a different row to generate result
I'd like to create a Beast Mode that takes a value and checks it against another row in my table. I have a bunch of human annotation data. I want to look at a content_id and then flag if that content_id has been in the QC job. I've made a rough sketch of how the data looks (apologies for the formatting. This is my first…
-
Scatter Chart
I would like to create a card that shows the revenue we make from each customer in a scatter chart where the size of the bubble depends on the profitability of each customer. i am very new to Domo so please bear with me
-
Unable to Display Stacked Bar Due to Partition Beast Mode
At the base, my dataset is broken up by employeeID, months, and planID. For each of the employees, month and plan; the employee receives a $ value based on performance, called "Earned" and they also have a column "Funded" that indicates what they were funded for the plan and month. I am trying to create a card that…
-
Stack-Bar Line Graphs
Hello, I'm trying to create a Stacked Bar Line Graph where I am able to have a the below bar graph broken out by month with an additional line graph, that graph consists of revenue numbers split by whether they fall under one of two catagories. The line graph I am trying to add would be a count of all the opportunities…
-
Best Way to compare Events
Hello! im trying to make a flexible card that is able to compare two points of time based of events that might have happend. For example this current period vs the school holidays fortnight. Or Event A vs Event B where the events are easily changed to different periods
-
Any way to get text value from one column based on text value of another column?
I've got a data set that is a series of user and assistant responses. I'm trying to build a table visualization that will show me all user questions where the assistant did not have an answer. My thought was that I could search for the default “no answer” response in the assistant response columns, but am stuck at how to…
-
Display volume bar and 100% stacked bar chart as 2 options for a same card in a page
Hi I want to reduce the clutter in the dashboard page, hence I would want to see the bar chart and the 100% stacked bar chart in the same card when each of these options are selected as slicers at the dashboard level. I want to avoid displaying 2 separate cards as it consumes more space. Is that possible?
-
Percent Change Beast Mode Calculation
I cannot figure out how to do the beast mode calculation for this. I would like a percent change column for the most recent month to the current month? How would I do this? I've tried watching videos and this data seems to be set up differently then those videos.
-
Breakdown of Yes or No Values
I am looking to create a graph or table that shows a breakdown of who answered yes and who answered no in a specific state. E.x. in GA 100 people took the survey, 45 answered “Yes” and 55 answered “No” in FL 50 people took the survey, 20 answered “Yes” and 30 answered “No” What graph/table would you use to display this in…
-
Multiple Events aligned on a single Calendar Card
Hi, As the title suggests, it would be good to be able to add more than one Event field and date field populating the same calendar card (even if they have different date fields) and to be able to control what the output of the data label on each day of a calendar looks like in a month view instead of having to force a…
-
Need help with Date Range/ Period to Date
As you can see top right, Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update date dimension to current Week to Date, Month to Date, Quarter to Date. I'm trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date…
-
Checkbox Selector not showing all values?
Good morning, While trying to create a Checkbox Selector to use as a filter, I've run into an issue where the card is only showing some values instead of them all. It's not even a massive data set; it's 15 values. However, when creating the card I see the dreaded "Warning: Not all data is shown" message (14 of the 15 are…
-
Single Value Card - No numeric abbreviations
Is there a way to turn off abbreviations of numbers in Single Value card? I have a card that has the value of 1023. It shows as 1.02K (I have it set to 2 decimal places). I can't find anywhere to tell Domo not to use the abbreviation on this card. (ether in the card settings or the value display settings).
-
Editing Capabilities
Hi, I'd like to have a bit more freedom to edit some of the visuals I work on when it comes to creating a report. For this one specifically, I would like to be able to make the font size in the legend bigger and it sounds like there isn't a way to do that.
-
Can I change the font size?
I am having trouble changing the font size on the legend of a generated report. Is there a way to do this? Do I need to do it in the card? Or do I have to use the PDF editor?
-
How to Include Subtotal Percent in Pivot Table?
When in the analyzer, I selected a pivot table Next, Chart Properties --> Subtotals --> check the box for "Show Subtotal Rows" This gives me the subtotal for each subcategory. Is there a way I can also show the percent total for each subcategory?
-
Roll up rows in table chart with similar fields
I have a dataset of brands and corresponding data. I would like to have any rows with the same ID and device to be summed up and in one row. I don't want to use ETL for this because there is another column that distinguishes these rows so they may need to be filtered separately at times. Thanks
-
Show a 0 instead of "No Data" on Map Cards
It would be great to add a feature to map cards to show a 0 instead of "No Data" on map cards. It would look a lot cleaner and save a lot of effort having to build out an ETL solution every time. If that's not doable, changing the formatting for "Hide No Data Items" would be helpful. Being able to keep the state name in…
-
Replace "No Data" with a 0 on Map Cards
How do I change a map to show a 0 instead of "No Data"? The only option I've been able to find is "Hide No Data Items", which is unusable. I couldn't find anything in the card settings, and I'm hoping it doesn't involve an ETL solution. Thanks!
-
Line chart formatting
How would I go about making one of these lines a dotted line and keep the other one how it is? Would it be in chart properties? if so, where? Thanks
-
How to change column font color
Hello! Please I would like to know if it is possible to change the font color, just the first column of a pivot table in Domo. I invested some time trying and searching the web, but I couldn't find it, if anyone knows and can share this knowledge I would be very grateful! Thank you very much
-
How can I format the date in a YOY chart
Hi all, Is there a way to format the date in a YOY chart? The tables in domo allow for you to customize the dates (1st picture) but I am working with a YOY chart and it doesn't want to let me do the same thing. (2nd) I am trying to take the year off of description at the bottom of the Y-axis and just have the month display…
-
Numbers disappearing on bar charts with small bars
Hi, I have a dashboard with a Grouped and Stacked bar chart. Oftentimes when one of the bars is very small, the data label disappears and only shows when hovering over the bar or legend. Default: Hover: Ideally the data labels need to appear by default. No matter how much fiddling around with the chart properties I do I…
-
Filtering null values on a card
I have beastmodes to calculate change in margin over years and I am trying to filter out when all three columns are null to keep only active fields. ( If one column has a change then all three columns should show) only filter when all three are null. I made a beastmode but it seems to be giving me some trouble.
-
How can I edit this card to only show one column's data label?
Hi all, Below is a visualization that shows three different data labels. Is there a way to only include the data labels for the "variance" line? We already keep the production numbers in a different table on the same dashboard so being able to clean up the visualization a little bit and only include the variance number…
-
how can i create a calculated field based off buckets?
Hi all, Recently I created pricing buckets for the amount of loan a borrower took out. This works Right now, we have two different visuals that show 2021 vs 2022 This is ok but we would rather be able to see both of these graphs in one with the different years in different colors. Is there any way to do this? The only way…
-
Trying to Count the number of Appointments in my data
I feel like this should be simple but I'm struggling with how to write the beast mode to where I get a whole number and not an average. I'm trying to count the total number of appointments in my sales data. This is what I've written: Count(`Bay Text`)/(COUNT(DISTINCT`Invoice #`)) I've attached a photo showing what the data…