-
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…
-
Selecting All in Filter Subset
Hey everyone, I am creating a dashboard with checkbox filter cards based on a column with a lot of unique entries. Is there a way to select all the checkboxes in a subset as opposed to individually checking in each box? For example if I type the string 'apple' into the filter by search bar in the filter card, the filter…
-
Filters for specific Drill Down?
Currently I have a list of outstanding loans grouped by state. Once a state is selected, the drill down will show individual locations within the state that make up the number. I want to have a specific group of individual locations show up when I click Utah (the main competitors), so in the drill down I have filtered the…
-
When "Graphing by Week", Can You Start on Monday?
Is there a way to adjust the first day of the week that's used in a card when you graph daily data by week? When I graph by week, it shows Week 1, Week 2, Week n, and setting aside the conversation on getting the date to show instead of the week number, is there a way to dicatate the first day of the week that Domo uses…
-
Add a row number in cards using table chart
Hi! has anyone being able to add the rownumber on a table chart ?
-
Dashboard Page Filter Customization by Card?
I want to use the same dataset in 2 different cards. In the first card, I want to show Quarter Anaylsis revenue (year over year). In the second card, I want to show the current month for different metrics. Date is common to both cards since they share the same dataset. So when I add Date as a Page Filter, my first card is…
-
DOMO Dataset : Adding new column to the existing schema.
Hi Team, Can anyone help me in adding a new column to the exisiting scheme, Important thing is my old column should not be deleted, I can only see a update option hope there is a option to add.
-
Viewing Date as a tree structure in the Filter
Hello Guys, I want to add a Date filter to a dashboard. This filter needs to be as a tree strucutre with hierarchical data. (Year->Quarter->Month) How to implement this? I know of a work around using 3 seperate filter to achieve the same functionality. but would be interested to know other approach as well. Regards, Rohil
-
Comparing multiple month-over-month metrics in table
I'm looking to create a table, where the date selection is set to previous month (only want to look at complete months). I'd like to look at metrics, such as website visits, pageviews, and conversions for that previous month in the table by traffic source. However, I'd also like to show % change compared to the prior time…
-
Card Details View - Links showing I didn't add
I have noticed that I have links showing up at the bottom of the Detail View that I didn't add there. Is there some other function in Domo that is doing this automatically? The only thing I can think of is that when I duplicate a card using the Save As function, is that what's making them show up as a Linked card?
-
How to display Y Axis scale as a Date Hierarchy?
Hello, Is it possible to Display the Y Axis label to cater to Date Hirearchy as in attached image? if possible, how to implement? Regards, Rohil
-
Using Separate Filters in a Dashboard as an OR type argument
Hi all, I have a situation in which I have a High Roll-up of States grouped together and then a separate State level filter and want them to work together. Example is: Region Filter: -East -West -South -Midwest And then a State Filter of all 50 states. I would like to have the have an option to pull in data that can…
-
Exporting the Predictive Analytics
I really like the predictive analytics piece that was recently added, and I was using a stacked bar graph to see various account spend and future spend. I wanted to export the future values to excel and it seems to stop at current values. Any ways to accomplish this without manually recording the data?
-
Plotting points on a map card
Hey all, I am looking for a way to plot store locations and radii around them on top of a zip code map card with customer count data like attached. Has anyone ever accomplished something like this? Thanks!
-
Correlation Coefficient in Beastmode
Has anyone successfully calculated a Pearson Correlation Coefficient in Beastmode? My idea is to create a scatter plot that graphically displays the relationship between two fields in a dataset, and display the Correlation Coefficient for those two datasets as the Summary Number. For example, if the card is filtered for a…
-
Pivot Table conditional format
Hello, I have a pivot table card where I need to compare if the value is greater than the goal, and paint that field in red. How is this possible? I can only compare it to a single value, but it is not the same over the timeframe I have. Thanks.
-
Error uploading assets via domo publish
Hi , Getting error while uploading to existing card via domo publish command Design can be found at https://pg-azure.domo.com/assetlibrary?designId=7ff12cbf-e2fc-4353-bb5c-93837234d762 X Error uploading assets error Command failed with exit code 1. P.S. This works when connected to Office network but not working when…
-
Prior year bar in YOY card adds an extra day for current MTD
I am working on a YOY bar card and the results for the prior mtd is adding an addtional day. For example, as of today, the bar for this month includes activity mtd to the 20th as expected, but the prior year bars are giving me information through the 21st. January and Feb. completed months are correct. Is anyone else…
-
How to access a particular column value in beast mode calculation?
I want to calculate Salience = This Year/ Total ( 500,000 / 980,000 ) and based on filters Total value will be dynamic is it possible to access 980,000 to access in beast mode? Please tell me how to write a beast mode for this.