-
YTD graphs
I understand Date column is mandatory to create a YOY card. But the report coming in from quickbooks does not have a Date column in it. How can i solve this issue?
-
Two or more Fields on Summary
How can i show show two or more Fileds value on "Summary Number"? I tried creating a calculated Field to include 2 or more fields however it shows really weird format on the card i.e. without comma for Numeral values and large font size. See attached Screenshot of one of the cards.
-
Adding annotations to a line or bar graph
Hi, I have a line graph that I'd like to add an annotation / text bubble to for the purpose of giving an example of why there's a spike. I'd like to tie it specifically to that spike so that as the data continues to grow, the annotation will stick with the spike. The "annotation" option appears to be greyed out for me on…
-
summing 1st and 2nd row, and then summing 1st, 2nd, and 3rd, and then summing 1st, 2nd, 3rd, 4th
Using beastmode (or another method) is there a way to sum (in a new column appearing directly to the right of the values) the 1st and 2nd row, and then sum 1st, 2nd, and 3rd rows (appearing directly beneath previously sum of 1st and 2nd row), and then summing 1st, 2nd, 3rd, 4th and so on an so forth until a few hundred or…
-
Cloning drill-down cards
When you create a new domo card using the 'save as' of a previous card, it is possible to retain all the associated drill-down views for that card as well? It appears that when you 'save as' it only replicates the primary top-card. Similarly, it is possible save a drill-down view of a card as the top level of a new domo…
-
Copying Cards
It seems that whenever I try to Copy/Move a card from one page to another, the cards remain linked so that any operation on the original card or the copied card including delete or name change is kept in sync. Sometimes I just want to copy a card because there are many similarities but want to change just one simple…
-
Graph with Daily Total and Cumulative Total Bars
I am trying to recreate the below bar graph (from Excel) in Domo. In the below picture, the orange bar shows the 'Billed Amount' for that day (numbers along the bottom represent the day of the month). The gray bar shows the cumulative amount billed thus far that month (i.e. the second gray bar shows the sum of Day 1 and…
-
totals in table card
I added a grand total to a table card using the show total selection in the Total row chart property. Since it displays a total for all columns and I have a non-numeric column, I get a count for the non-numeric column which isn't needed and I'm not sure what it is counting since it isn't the number of rows. It would be…
-
Creating stacked bar chart from columns in data set
I would like to create a stacked bar chart that shows one stacked bar each for several columns in my data set, but not all of them. The number of different values contained within the columns would be the stacks. For example, say I have the attached dataset, then I want to make a chart similar to the one depicted in the…
-
Posting an SVG image file
I have an SVG image file that I would like to post to Domo using the pydomo API. Is this possible, or do I need to do some beastmode scripting?
-
Rename Column or Create New Column
Magic ETL's Join Data does not accept the join column from two different datasets if they have a different column name (even though the format of the data is the same). So I need to either rename a column in one dataset or create a new column that duplicates the data, but has a different name. Thoughts?
-
Extend x axis past the end of the data
Is there a way to extend the x-axis past the end of the data? I'm building a burnup chart to show progress on a release. The x axis is datetime values. The y axis is points completed. I'd like the x-axis to extend to the end of the release, even though there are only data values for dates up to today.
-
Is there a bug in adding pages?
There are some pages, that I have ownership of and are unlocked, that I'd like to add sub-pages to. BUT when I go to pages, the parent page does not show up on the list of pages for me to select and add a sub-page to. Is this a bug or am I overlooking something?
-
Custom Sorting Using a Field (Specifically Sales Funnel)
Not sure if this is possible or not. Basically I'm taking a a list of Sales Opportunities and putting them in a funnel by stage (Count) that way is shows how many opportunities are in each stage of the Sales Process. The thing I'm having trouble with is getting them sorted from beginning to the end vs alphabetical. The…
-
how to transpose a table?
Hello, I do have a table created and would like to transpose the data. Similar is done in Excel. Thank you
-
Pie Chart Conditional Drill Down
Hello, I have a chart with Open/Closed status and depending on the status that the user chooses, it's the custom table view they want as drill down. Example: if Closed is clicked, users want to see a Completion Date field. If Open is clicked, they want to see a Due Date Field. Is there any way to achieve this? Thanks in…
-
Card Views
My question revoloves around the page views within the Domo platform. As an Admin, and maybe other users as well?, you can see who is currently online in the instance. When clicking on that person, it will tell you the most frequent and most recent cards they have viewed. I am just wondering if anyone has an idea how to…
-
Configure alerts with comparing a recent value with the previous ones
Hi everyone, Is there any way to configure a card alert with comparing a recent value with the previous ones? For instance, I need to have alerts triggered when costs in current month increased by N % as compared to previous month (or avg costs for some period of time).
-
Min, Max and Average lines on Bar Charts
Hello everyone, I built a stacked bar graph with 1 drill down view which is a regular bar graph. According to the help documentation I can remove the max, average, and min lines that Domo generates by going into the grid lines setting of chart properties. I'm on the new version of Domo and I don't see those options…
-
Negative numbers (trending upward for positive direction, vice-versa for negatives??)
Not sure if this would be considered the same as/similar to this inquiry from a few years ago (https://dojo.domo.com/t5/Card-Building/How-do-I-add-a-trend-line/m-p/6573#M344) but we haven't been able to locate a Regression Line section in chart properties within Analyzer to try that (deprecated?). What we're looking to do…
-
Page Filtering on a Beast Mode
Does anyone know if you can setup page filters on a beast mode field? Most of my datasets contain a company identifier that I convert to a string of the company name. Doing this as a beast mode is faster than running the datasets through a dataflow. The downside I am seeing is that the beast mode is not available as a page…
-
Card content not displayed in Power point export
I filtered a page and downloaded the content to Power point and the content of the YOY cards do not display. The summary number does, and all other non-YOY cards display correctly. Anyone else having this problem? Any solutions?
-
Changing date from 2016-01-22 to 01-22-2016
Hi, I've seen posts that are similiar but not quite my same issue. My data is coming in like 01/22/2016 and DOMO is changing it to 2016-01-22. Can you please help on converting it to month-day-year format. I've used the below but wondering if there is anything in the ETL(Magic preferrably) to do it so I don't have to have…
-
How do I add a trend line?
I know I saw this at Domopalooza in one of the breakout sessions (even tried to snap a pic of the screen but wasn't fast enough), so perhaps a Domosapien or a Major Domo with superior math skills can help me figure out how to derive a Beast Mode formula to demonstrate a trend line over a particular metric. What I'd like to…
-
How can I take multiple columns and create new rows based on the data?
We input some data through a form that is very limited in how it organizes the data. It currently looks similar to this (these are the column headers): Date / Manager / State / District / Site / Type of Inspection / 1 - Category of Violation / 1 - Violation / 1 - Plan of Correction / 2 - (same 3 column titles) / 3 - (same)…
-
Timezone Settings - Need Assistance
We are a national company, serving customers from Hawaii to Maine. Our corporate headquarters is located in the Pacific Time Zone, our transaction servers record all transactions (regardless of point of origin) in Central Time Zone (timestamped), we have employees located in all four Continental US Time Zones. When I view…
-
Vertical bar and line chart
Hi, I am trying to build a card where my yearly data will be shown in vertical bars and yearly avg to be shown in a line like attached. Please advice. Available Sample Data: Product201620172018AvgWipes56856869Soap 27 27Sampoo1414 14Oil525511574Powder42655353 Expected Chart: Best Regards Bikash
-
Color Rule on Grouped Bar
Say you have a grouped bar X = Date/Month Y = Amount Bar 1 = Target Amount Bar 2 = Current Amount Each month has a different Target Amount. What I want it when Current Amount >= Target Amount then Color 1 else Color 2. Thoughts?
-
How can I display data up to the last completed month
While at #DP18 I learned that for the sake of the "Corporate Executives" there is the ability to only display data thru the previous completed month rather than up to date. For example, my executive only wants to see, by default, revenue $ for January & February since thoses months are completed. March information would…
-
Data Labels vs. Hover Text
Is there any trick that I'm missing that allows us to always show data labels on cards vs. the use of hover text? How do we typically solve for customers that want to publish their cards with data labels on all chart values?