-
Calculating Percent Change in a Pivot Table
My goal is to have the variance shown as a percent change from Last Year's Revenue in the pivot table. Is there a way to do this?
-
Way to sort by hidden field
Is there a way to sort a table by a field that isn't in the table columns? I'm trying to sort time information chronologically like this: 1:00 AM 2:00 AM … 12:00 PM 1:00 PM But Domo sorts it like this: 1:00 AM 1:00 PM 2:00 AM 2:00 PM etc. I can have the time displayed as 24-hour but I'd rather not if possible.
-
Question on breakeven formula
I am trying to think of a way to structure a formula to calculate days to breakeven when the initial item fixed cost has multiple sales tied it. I made a quick excel chart to demonstrate what l I am trying to accomplish where the initial item cost of $1000 took 6 days to breakeven.
-
Is there a way to count all views of a card, including dashboard views?
I noticed that the Domo activity log counts card views only as direct interactions on the card. It does not include views through dashboards (pages). I figured out a way of joining activity log data and Data governance data to get the complete count I want, but is there a more straightforward way? Perhaps a category in the…
-
Multiple Values on State Map
I'm not really sure if this is a visualization question or a Beast Mode question. I have built a map showing profitability by state, that changes depending on what the user filters for. For example, if the user filters for the year 2023, the map updates with the profitability for that year. Now, I want to determine the…
-
Any ideas on how to show different table columns based on a dashboard filter
A use case would be to show different metrics on a table, fed by an ETL, based on a campaign objective for example. Anyone already attempted this before?
-
Multi Line chart
This should be a simple task… yet this is shockingly confusing (as usual with Domo). How do I create a simple multi-line chart, using the data below? Just month for the x-axis and two lines depicting sessions and total users. Month Sessions Total users 6/1/2022 224509 151443 7/1/2022 250178 174588 8/1/2022 235310 159992…
-
Displaying Data on HTML Table with Pre-existing Formatting
Ok. Here's a question for the community. Relatively new user to Domo, so maybe I'm missing something basic here. Situation We have data coming from our database that already has inline style in place for our data, so we don't need to use beast mode for conditional style display. I was thinking that the HTML table would…
-
Add multiple Hyperlinks in one cell
Hey there, I have been trying to create a hyperlink in my cell using Domo Beastmode. The issue is, if there is a string proceeding or following the link, the entire cell becomes a link. Which is problematic because some cells are have multiple links with string while others have multiple links and no string. Is there a way…
-
How to add option of graph by fortnight
Our DOMO instance has got graph by options as day , week , month , quarter & year but users want graph by fortnight (2 weeks) How we can add the option for graph by fortnight ??
-
Help with Grouped + Stacked Bar Graphs
Hello, I am trying to create a stacked bar graph that is grouped by facility. Metric 1 Metric 2 Metric 3 = Metric 1 + Metric 2 Currently, this bar graph is being used. I want to accomplish something like this for metrics by facility but for Metric 3 (which is composed of Metric 1 + Metric 2) and still show the Metric 1 and…
-
Drill down into table
Hi, I have a table and I'd like the ability to click on a field and open a new view that shows a more granular table. My table looks like this: Account | Dollars If a user clicks on an account in the table, it will drill down into a new table: Account | Media Outlet | Dollars How can I achieve this? Thank you.
-
Beastmode: Previous 7 Day Avg Comparison
I am working in a Mega Table transposing beast modes to get daily kpis. I would like to get the comparison of these daily kpis to avg for the 7 days preceding them: (current value - 7 day avg) / 7 day avg I'd like this beast mode to appear in a column next to the daily value for each day. I'm just not sure how to get this…
-
Colour Markers on Line Chart
Hi Folks, We are able to use conditions to highlight an entire row in a table using colour rules, but how do we achieve this when we want to highlight specific markers in a line chart - using the same conditional logic? I'm building an SPC chart from scratch to include more control lines - the controls are conditional…
-
Creating a multi category chart
I want to display column "l1_dist_value" within the same date. Meaning the values of Hyperion, Artemis and Foundation should come within a single date chart as provided in the excel snippet. How can this be achieved in domo?
-
Pivot Table Week over Week % Change
I want to show the WoW % change for my data but not really sure how to go about it. My raw data is daily and I grouped it into weeks in the pivot table. I want to add a column to my table where it will show the % change of sales from the previous week.
-
Top N items in tree map
I'm working on a tree map and its way too clutter due to the large number of items in the data. Is there way to limit the number of items showing in a tree map? I want the top N items based off sales.
-
How to stop a dashboard's background change from impacting charts
Our end users strongly prefer a dark mode layout on their desktops and mobile apps. We're running into a issue that sounds minor, but it makes the cards unreadable on the dash if we use any dark colors for a background. Here's the standard dash, white background, default backgrounds for the chart. When they hover their…
-
Beast Mode Fix?
Ok so I have a filter deny on a beast mode and I need it to be different but I cannot figure out the dimensions. The problem - each of the months below needs to equal 100% and within each month, we need a percentage of that 100% that are in the 'credit score buckets' Currently, the 6 columns add up to 100% and I cannot…
-
Can a card be in details view while on a design dashboard?
I have a dashboard built that contains a large graph that has several quick filters on it. Id like those filters to be visible while viewing the dashboard. I don't want the end users to have to open the cards details view to filter the graph. Does anyone know if this is possible?
-
Card Filter Issue
Hi All, This is regarding a Filter Chart. I just have two categories and I get a Warning message as 'Warning: Not all the data is show.' Limiting row helps but will that affect my data? How do I fix this? Can you help me, please? Thanks in Advance!
-
How do I only show one legend on a map card?
I know how to hide or show my legend but when I "show" it, it displays two legends when I only want one to show. When I press "hide" legend it hides both legends when I only want one hidden. How do I leave the legend on the right hand side and get rid of the legend on the bottom. Both legends have different information and…
-
Global date range filter in dashboard, have it compare to exactly a year ago in guage card type.
I have a dashboard that displays metrics from social media platforms, and I would like to apply global filters so the client can filter specific dates, but then also show what those values were exactly a year ago. Example: Say the client wants to see total impressions for April 12-17, 2023. I would like the card to filter…
-
Has anyone used Illustrator to create an SVG for custom filter charts successfully?
I have been trying to create a custom chart for a few weeks with little success. I have used this guide found on a forum here to help me. I initially tried Inkscape, but it was less successful than Illustrator for me. I have gotten it so close at this point but I can't figure out why some of the regions are uploading…
-
Faceted Bar Chart Labels
I'm using a Faceted Bar Chart to show a conversion metric for sales. It's probably my favorite chart I've used so far and really scratches an itch my end users have had. It's pretty basic, it has a sum of opportunities, a sum of sales, and the resulting conversion. My issue that I'm having is the label on the right side of…
-
Is there a way to enable chart annotations for a table card?
It says chart annotations are disabled for this type of card. Thank you!!
-
Hybrid Stacked Bar Chart?
Wondering if this is a "thing". I have 3 metrics for some call center reps. Available (blue), Talk Time (green), and Unavailable (pink). Our leadership likes to see a total of Ready/Working next to Not Working. X axis is the call center reps. First Version was a Nested Bar, and it's close: I'm wondering if it's possible to…
-
dynamic slicer selection on page
I have the following date slicer on the dashboard page and want the slicer to auto select the latest month. Is this possible?
-
Custom Combo Chart
Hello, I need some help adding a line to my chart and some calculations. In the chart below (first chart from domo), I have monthly KGPM (Kilograms per million), I want to add a line that will show the KGPD YTD (year to date), something similar to chart 2 below in excel. Now, in order to add the line I need to do some…
-
Best way to have months show as individual columns in a table
What I am wanting to do is list the months this year Jan, Feb, March, etc.. in a table. I assumed that the date filter for a table would allow me to graph 'This year, by month' in the same way it would for a bar/line chart but that doesn't seem to be the case. Is there an easy way to do this with tools in the analyzer or…