-
Top 10 for multiple Categories
It is easy enough to build a card that only gives a Top 10 based on the criteria and the sort. I would like to get a report that lets me show all the sales people and their top 10 accounts without building a separate card for each sales person or without making the Manager have to filter to each sales person individually.…
-
How to export totals row in Excel?
When I export in excel, the totals row does not show. It will show if I schedule the report or export as a presentation. Please let me know if there is any workaround that. Thank you. Best, Harleen
-
Alert Functionality - Referencing the data or referencing the card?
I built a KPI card that looks at a clients email data from two days ago. The client asked that we look at the data from two days ago, so that we get a complete 24 hours of data collected on an email. However, that required me to exclude yesterday - which i created a beast mode for. The card functions beautifully - But they…
-
Data Labels
Hello all, Simple question: Is there any way to type specific labels for different bars in a card? I'm trying to tag bars with percentages, and don't think I can build a beastmode because the denominators are different for each bar. I'm looking for a way to do it manually; just do the math myself and slap the percentages…
-
Color Rules for Visuals but not Tables
When I apply color rules to a data set I'd like to be able to have those rules apply to all card types except tables. I think it's silly for 1 column or an entire row to be color coded. It's distracting to say the least.
-
Interactive Filter limitations
Can we get interactive filter options that work like quick filters do? For Dates I'd love to be able to just type in the date range as opposed to having to use the current option. Range selector is just not very functional. For lists that could be in the hundreds, it would be nice to have search functionality Also I'm…
-
Filter to Identify records that fall between two dates
I have a dataset that includes an enrollment date and a disenrollment date. The users need the ability to select a year and see anyone who was active during that year. Participants can be active for up to three years. I'm trying to create a filter card that allows the user to select a year and have that filter the data to…
-
Convert an image into a banner containing several dynamic metrics
Greetings All. I have this idea that I'd like to make a reality. Its a slightly more advanced take on the standard metric banner many of us use, but instead of using cards I'd like to use an image that conveys movement. I've attached the image I have in mind. In this chevron image, I'd like to replace the words with…
-
New Pivot Table: Showing highest number per row
Good Afternoon, Experts! I am enjoying the new pivot table in Analyzer view. I am creating a card where you will be able to show week over week period of sales data listing out all the stores in my data set (see table 1.1). What I am trying to do is: * For the given week, have a condition to look for the best week ever for…
-
Data labels on Line Chart
I have a card that shows YoY comparisons of sales data for our business. Previously, the legend showed the current week and the previous year's week in mm/dd/yyyy - mm/dd/yyyy format. After applying a filter last week, my new legend shows "0" for this year, and "1" for last year. I can't figure out how to get it back to…
-
Change color in flex table
Hello, I try to find a way to change color in flex table, just turning green to red and red to green because in this chart positive value are not a good thing
-
Annotations on cards with PDPs
Hi all, I added annotations to cards that apply to the card in total, but do not apply to specific users at an individual pdp level. As a result, the viewers with a pdp are seeing an annotation that doesn't apply to them. Is there anyway to make it so the individual pdp users do not see the annotations?
-
Beast Mode Calculation Help
I'm working with data that was imported from an Excel spreadhsheet. This is a spreadsheet that will be pulled, then updated every month in Domo. I need to run a calculation that I was able to figure out in Excel, but would like to replicate in Domo. I could make the argument that I could just do that calculation every…
-
"best" way to find out which field name changed to break card...
When the name of a field changes on the underlying dataset and "Breaks" the card... it just gives you the orange box indicating that a field is missing... but doesn't tell you which one. Has anyone figured out a "good" way to identify which field is the problem field? thanks, Jeff
-
Card alert output
I have a horizontal bar card set up that ranks salespersons by their volume of sales. I set an alert to let me know when anyone on the card reaches certain milestones e.g. $1Million, $2Million, etc. What I have run into is that everyone that has already hit the milestone is listed on the email and it goes from the highest…
-
Stories layouts as publication view
Our team is really taking to Stories. One thing we've found lacking is the publication of Stories to a URL. We use publication slideshows all over and now want to be able to view Stories as they display in their pages, with multiple charts/images/cards. Does anyone know of an in-product way to do this? I haven't found one…
-
radio button
Hi, Is there anyway to make a radio filter card to have a default radio button checked? thanks in advance for any suitable solution
-
page drill down?
Hello, I wonder if anyone has some ideas on how to do this: I created a campaign dashboard that presents overall campaign performance at high level across all departments. I wanted to do this: if user click on a campaign, it will bring to another dashboard that shows all detailed KPIs, metrics for this aprticuar campaign.…
-
Multiple metrics in Dynamic textbox
I want to create a text summary that contains multiple metrics that exist within the dataset as shown below: The ##%s come from the same dataset, and I want them to be green when a positive number, and red when it is negative. Right now, it looks like I can only have 2 metrics at a time. Is it possible to have 3 or 4…
-
Layout subject : using thumbnails pictures in cards or dashboards
Hello, I would like to know if somebody find an easy way to create card or dashboard with pictures/thumbnails instead of text (for example using android and iOS logo) ? Thank you, Philippe.
-
discrepancy between chart percentage and Sumo card percentages. ?
Hello , We have a multi line series chart on which percentages are caluclated using custom fields instead of using percentage function. When doing data validation percentages on sumo card on same data set does match. Also the drill path from chart to the data set is not matching. Seems like filters are not getting carried…
-
Scrolling Windowed Card
Is it possible to zoom in or create a windowed card by clicking and dragging, and then scroll through the rest of the data with that same scale? For example, if I have a card with a single bar graph with company names in the Y axis, and revenue in the X axis, and 500 company names total, is it possible to change the scale…
-
Calculated field in the Filter
no_of_weeks. CASE WHEN `JobDeliveryDate` > CURDATE() and `JobDeliveryDate` < CURDATE()+28 THEN '4 weeks' WHEN `JobDeliveryDate` > CURDATE() and `JobDeliveryDate` < CURDATE()+56 THEN '8 weeks' END I want two quick filters within 4 weeks and within 8 weeks. I created the above no_of_fields calculated field. And I am adding…
-
Beast Mode Syntax Questions
Hello All, I am having some issues with my BeastMode. In plain language as I can muster here is what I am trying to accomplish. I am trying to have a logical test run two different calculation methods in the same beast mode. Logically I want it to do the following IF ID = 1 THEN ( ###ID ONE CODE###) ELSE( ###ID TWO…
-
Move a Company Sub-Page
Is it possible to remove a Sub-Page that is under a Company page and make it it’s own Company page? I've seen this discussed in the Domo Community before but it was just noted as a suggestion and given to the development team. Has there been a solution to this? For example I have Page 1 and Page 2. Page 1 is a Company page…
-
Average for Nested Bar instead of Total, or another option?
Good morning. We'd like to show the average of the two bars in this card, and ideally it would be using a Nested Bar chart but open to other suggestions (currently using a Grouped Bar chart). CURRENT: NESTED BAR: The Value is a beast mode, which takes into consideration the actual sale amount less the valuation, divided by…
-
Table Card - Only total displayed rows
I am trying to create a table card which shows the top 20 highest value opportunities. I can't mark them in the dataset as 'top 20' because the values change everyday; but I need the 'Grand Total' row of the table to only show me the 20 rows displayed - not the full value of the data. Is there anyway to do this?
-
Replace part of string with another value in Domo Cards
I have a data set showing some page names and paths of my website, a part of which has to replace with another in the domo card. Can it be done using beast mode, using any functionality similar to 'Replace' in mysql. Example: Original Value: 'Site1::LandingPage > Site1::My Cart > Site2:Checkout Initiate:Checkout' Required…
-
Data bars in table view
please guide me by giving some reference link or any resource which can help me create data bars in domo tables. I did search for that and found a few hints in this link but didn't get any useful information. I am trying to achieve something like this. Thanks in Advance.
-
Excel file upload can not generate header
Hello, did anybody meet question when uploading excel files and choosing generate header but doesn't work sometimes? Emergency question thanks Lu