-
Removing gridlines from stacked bar chart (but keep the x-axis)
Hi, I am looking to remove the gridlines from the stacked bar chart, but keep the y and x-axis (the 0 grid line) Does anyone have experience with this?
-
Y axis disappears for a grouped and stacked bar with line chart
Hello, I have a grouped,stacked bar chart with Line. On the X-axis, i have 5 columns grouped and stacked along with a line date wise . Issue is when i have nulls in all 5 column for a particular date and i filter to see the card only for this date, only the date appears , y axis is not visible any more. Is there a Way to…
-
HELP PLEASE - Add Subtotals into Mega Tables Domo
Hi All, I have the following data: OwnerAccountAmountRandalA10 A10 A2 A Subtotal22 B3 B7 B9 B Subtotal19 C5 C10 C10 C Subtotal25Randal Total 66 I need to be able to show subtotal at both Owner & Account level all within 1 visualization. I'm able to show the subtotal at the Owner but I can't find a way to show using…
-
Does filter via slicer on Stories carry on towards Drill Path?
Having a bit of trouble with a drill path I've created. On a stories dashboard, I have a slicer shown below. The card (call it Card X) that the slicer applies to shows the following columns: "Project Name", "# of Instances" So, depending on the bucket chosen using the slicer, we may see "Project Ritwik", "27" vs. "Project…
-
Why I am facing this issue while saving my cards?
I am facing this issue while saving the HTML table card I have created 4 beast mode and they are having code from 500 to 1000 lines in case statements. But they are not giving any error while dropping them in the column and getting validated properly. although the card is taking so much to save and after some time it is…
-
Color rules for gauges
Is there a way to change the color rules of the filled gauges so when one calculated value it is greater than the target calculated value then its green and red if less? the color rules only allow me to put a static number like greater than '10' but i want the target calculated value from beast mode Thanks alot
-
Getting a total for group and stacked bar graph
Hi- Probably a simple question, but for the life of me I can't find an answer. I have a group and stacked bar graph with 2 data points on the left bar and 4-5 on the right. I want to sum up all the data points per bar (ie the # on the top of each bar will be the sum of the parts) and not show any of the individual #s for…
-
Lat/Long Map Not Filtering Correctly
I have a dashboard that I've built that includes 4 cards. For sake of this, I'll focus on 2 of them. One is a table and the other is a Lat/Long Map. The Lat/Long Map has the right circles in the right spots. In the analyzer view, it appears to be working correctly as well (i.e. Quick Filter does what it's supposed to do).…
-
Clickable hyperlink not working
Hello - I'm trying to have a text box export a clickable hyperlink. The data source is correct, but the textbox only populates the link url text, it's not a clickable link. Same issue when it's exported via powerpoint or pdf. Any idea how to make this work correctly? Thanks!
-
Slicer, Checkbox, and Radio Button Cards for page with cards with multiple data sources
Hi all, me again.
-
Top 3 cards to build for a newbie - please suggest
Hi All, happy to be here! We just started to use domo for the business and I wonder what would be your advice on first 3-5 cards that an online ecommerce business would must have? Happy to hear any suggestions or oppinions! Thank you in advance
-
Conditional Formatting One Column Based on a Different Column's Value
Hello, Working with a table and attempting to change the color/format of "Column A" based on the value of "Column B" . I understand that I am able to change the format of the entire row or only Column B based on Column B's value, but not one specified column. Are there any settings in "Chart Properties" that I am missing?…
-
Multiple Nested Case Statements Help
I'm trying to nest multiple conditional clauses together and having trouble. Based on the campaign_name, I want a specific calculation completed and value output of 'Good' or 'Bad.' This formula works properly when only specifying one campaign_name: CASE WHEN SUM(case when `campaign_name` = 'VALUE1' AND `Abandon_Time` > 15…
-
Color Formatting Pivot table
I have a pivot table that shows the sales by location for each month. I need to highlight the maximum sales month for each location. I have used Html conditioning formatting on a single column, but since this is a row-level comparison I am not sure how it can be done. Here's what I have Here's the desired output I am…
-
Change Time Period for all cards on a page
I have a few pages that are all similarly setup. They each have 8-10 cards working off of the same dataset, and are showing are showing week-over-week data for the last 8 weeks. I have a page level calendar filter that I can use to change the data range, but I was wondering if there was also a way to change the time period…
-
Dynamic textbox hide unless filtered
I have created a dashboard that has a US map with about 20 single values cards and dynamic textboxes surrounding it. The value cards all show the sum total when no state is selected, which is great. However, the dynamic textbox that shows the first state in the dataset when no state has been selected on the US map, which…
-
Trouble Creating Custom Chart from Stadium Map SVG
Hello, I am having trouble importing an SVG file into a custom chart *properly*. We are trying to get a stadium map down to the seat detail and am not having any luck getting the stadium map into DOMO. I am NOT a web dev expert by any means and this is my first time using a SVG file so any assistance/direction is greatly…
-
Swapping A field On Multiple Cards At The Same Time
Hello all, I was wondering if it was possible to replace a field (lets call it field X) with another field (field Y), to all cards that use field X at the same time. Currently have the need to do this for over 100 cards and it would be great if there was a way to do this all at the same time. For additional context, this…
-
How to make a chart with two columns on the x-axis?
I have 3 columns: Sales, City, and Country. Sales is a number, while City and Country are Text. I want to make a bar chart, which has Sales on the Y-Axis, and City and Country on the X-Axis. It would look something like this: Each city will only fall within its own country. Any ideas if I can do this on Domo?
-
Limiting Pivot Values
I have a pivot table that I am creating with rows broken down into 2 dimensions and values as the count of a 3rd dimension. I would like the output only to display the top 3 Dimension B's for each Dimension A. Below is a screenshot of my current table (intentionally blurred). I would like to display only the highlighted…
-
Multi Line - Grouped Bar Chart
Hi, I am new to Domo. Does Domo Allow Multiple line grouped bar chart? For example using the table below as example... I want the Month to be on X-axis, Category as the group/series, Sales amount showing up in the Bar (grouped for category) (left y axis) and rates as multiline (one for each category) (right y-axis). Is…
-
Dashboard save error
For the last few days, if I make more than one or two changes to my dashboard, I get an error when I try to save it. I end up having to refresh the page and lose all the changes since my last save. It is getting very annoying, any ideas what might be causing it? Error message: "Error Saving DashboardYour Dashboard couldn't…
-
Negative value as 0
Good day, I have a chart that based on the data, it can sometimes display a negative value in the percent trend line. I want this value when negative, to be set up as 0. Specifically, because of this week's situation in particular: Any ideas on how can I make the negative be reflected as 0? Thanks!
-
Show Total in Donut Chart
Hi All, I am new to Domo, and I am trying to build a very simple donut chart. My problem is that I can not place the total into the middle of the donut. The total shows up on the right side of the card, the same way it would if it were a pie chart. But the whole point of having a donut chart is to be able to show something…
-
View last 2 weeks of data
Hello. I know there is an option to view Previous Week data. But how can I manage to display a week before the Previous, JUST AND ONLY the week prior. Example This week is 16 of the year Previous week was 15 Pior to that, it was 14 I want a chart to display only data for week 14, and ANOTHER chart to display only Previous…
-
Concat + Round
Hello, I need a text card that has a specific text concatenated to a beast mode, which is a percentage value. Currently I have the syntax as: Concat(TEXT, Round(BeastMode*100,2)) But it returns this And my scrap values is of 2.09% (0.02089 in the beast mode before multiplying by 100) Any help provided is appreciated.…
-
Trigger Multiple Drill Downs On a Page At The Same Time
Hello all, Is there a way to trigger multiple drill downs at the same time on a page? The idea here is to have a kpi page where we can see things on a daily, weekly, and monthly level. So if the page were to start with a daily view to then be able to drill to weekly, then drill to monthly, but when triggered to also drill…
-
Multi-Period Projection by Week
Hi everyone, I have a scenario that is stumping me. I'm trying to use the Multi-Period Projection in chart properties to project the next 3 periods. Projection Period Count: 3 Project Using: Linear Regression Recent Periods Projection Controls: Show The calendar is set to current year. When I set to graph by day, it will…
-
Remove 0s from data labels
I want to remove 0's from data labels (i.e. only show data labels when it is not 0). Any idea how I can do this? I've attached a picture of the card I'm seeing. As you can see, there are a lot of 0s in the data labels.
-
how to set up filter for the last day of data set in the new text card for summary
I want to use this new text card to insert the summary numbers. It worked fine with most scenario, but I am have difficulties to report the last date and to set up the filter to get the last date visits of my dataset. for example, 3/31/2020 is the last date in my dataset, then I want to show: "On 3/31/2020, total 5023…