-
Dynamic colors in bar chart with semi-transactional data
Hello, I am attempting to create a horizontal bar chart that shows the variance between the sales and sales forecast. A secondary requirement is to be able to filter down by our marketing channels. I have attached the image below of the bar chart I was able to create. The two field used are the Sale Date Time and Sum of…
-
Table card cut off when published
I've built a card that displays an inventory list for our sales team. The goal is to publish this table for them to retrieve whenever they need it and know that they're receiving the latest data. I'm using a table card in order to conditionally format some of the cells. Unfortunately, when that table is published, it has a…
-
Filter a column with distinct values
I am trying to display the results only for distinct values in a card. The structure of my code is as follows: case when `column1` in ('textvalue1', 'textvalue2', 'textvalue3') then 'result1' when `column1` in ('textvalue4', 'textvalue5', 'textvalue6') and `column2` in ('textvalue7', 'textvalue8', 'textvalue9') then…
-
Concatenate a summary number to show an actual and target value
Hi, is there a way to create a beast mode to show a summary number that will actual consist of text. The text I'm hoping to display would be a target value and an actual value. For example I have a Bar chart that has 3 different sets of bars. Let's say Value A, Value B and Value C. Each item would have a Target and an…
-
How do I sequence the Series in the legend of my card exactly the way I want?
I have a bar graph card with a legend showing the series being plotted. I'd like to sequence the series in the legend based on a certain hierarchy that I want, not in alphabetical order or some other "pre-built" way. For example, I want my sequence to be as follows: Software Network & Integration Devices Equipment…
-
Single Value Card - Thousands Separator Issues
Hello, I was wondering if anyone has come across this issue. Not sure if I am doing something wrong or if it needs to be reported. As an example when I create a single value card and the value is over 4,000, I'd like to display the full number, 4,233 and not 4K. As you can see in the image below, even wih "Use thousands…
-
Week Granualrity
In the last release it was mentioned how weekly reporting would change. Instead of Week 43 or Week 52 the first day of the week would should up like 10/4/15 or 05/21/14. Is there a release date for this change?
-
Last full day only
Hello, I would like to create cards that show data for the past 7 full days only ( without showing today's data) and have that card update it self automaticly as the day ends. Right now the only way i can do that is through creating a new data set that allows me for this manipulation. However, that forces me to creat…
-
Current week data is showing when date rate is set as last x weeks
I have a couple of cards where I set the date range for "last 4 weeks". However, data from current week is still showing up. Anybody know what I can do to make sure the current weeks' data doesn't get pulled in? Thanks.
-
Grouping date field in table view
I want to group sales by month. I can get this view to populate with single bar chart, but when I try and convert to a table view it groups by invidivual day not month. Thanks, Rob
-
MONTH ON X AXIS NOT IN CALENDER ORDER
The month on the X axis is not in calender order.
-
Waterfall Graph - ordering
I am having some trouble with the ordering of the bars in my waterfall graph. I am using the same data set to create two different waterfall graphs (Filtering by dept.) and although the information is portrayed in the same format in my dataset it switches the order around in the two different graph. I am reconciling sales…
-
how do i schedule cards or a slide show to be sent automatically each week?
I would like to schedule a link, or the cards themselves, to be sent automatically each week. I can see how to manually do that, but not automatically. Thank you.
-
How to reverse the items on category scale
-
Sum as an aggregate within a Sumo card
I've created a Sumo card however when I trying changing the aggregate type for the value date I'm only provided with the following options: Unique, Count, Min, Max. What I need is to summarize the column with the grand total value. Suggestions? Thanks, Beau
-
Counting Dates on a date rage
In my business we sell a monthly service. A customer is either acivated or deactivated. I have a dataset that has 2 date columns (activation date and deactivation date). I can easily create 2 separate cards that show the number of activations and deactivations every month. The activation card would have the activation date…
-
How to trigger an emailed link to open in DOMO's mobile app
I'm emailing out a link to a page in DOMO via Outlook. Right now, if I click on the link from my mobile device, it takes me to a web browser (Safari, Chrome, etc.). Ideally, I want the link to open up my DOMO app. Is there some way to modify the URL so it triggers the DOMO app to launch and go to the correct page within…
-
Washington DC does not exist in US map
Hi I have a quick question. I cannot find Washington DC in United States map. Am I wrong?
-
Display of graph + text/commentary
Hi - I'm new to Domo and wondering if there are options available to present information in the form of graph/charts plus summary comments/key insights. Our current solution is a PPT deck that contains a handful of visuals along with a few (2-3) bullet points for each that summarize key insights via text. Basically, is…
-
Can I email a card that is a table?
When I choose Send/Export on a card that is a table, the 'Email' option is not there. It works for other chart types like bar graphs. However, the help center says it should work for tables too: http://knowledge.domo.com?cid=emailkpi "You can email a KPI card from either the card page or the Details view. If you email a…
-
Is it possible to drill down by city in the U.S. map?
I know that there is no specific map to choose from, but is it possible to drill down by city when using a U.S. map, with a beastmode, dataflow, etc?
-
How do I specify different geography level joins for a map card?
I've uploaded a dataset in Excel (sample below), that includes the following geo markers: * State (postal abbrev.) * State FIPS code (individual) * County FIPS code (individual) * Consolidated FIPS code (concatenation of State and County) My map automatically structured at the state level which is great, able to build one…
-
Current Date Filter
Can you filter date to be less/greater than today without manually updating the date range filter?
-
Waterfall Card for Pipeline
Has anyone had success in building a pipeline waterfall card in Domo? We want to track the inflows and outflows of pipeline value based on pushed/pulled/lost/won/value changes between pipeline snapshots, but can't get the format to work such that users can drill through to the specific deals that accounted for the changes…
-
Summary Number to show last month's value
My data source is only updated once a month (at the end of the fiscal month) to show the value for that fiscal month. I want to show this value in my Summary Number, but when I use current values, it shows 0, because there is no data for the current month (as it has not yet closed). My Date range needs to be year-to-date…
-
Display Bars in different colours
https://merit.domo.com/kpis/details/1105954111 - is it possible to display the following card Bars Red if >0 and Green if < 0 thanks
-
Is it possible to drill into a calendar while using a Year View by MONTH rather than Day?
I am using a calendar view to show events for the entire year, however I can't drill into a month to get a month based view, I can only drill into the days with events, within that month.
-
Series Order
When I build grouped bar charts, I'm created a 2015 v 2016 series to split values. In some cards, 2015 comes before 2016 and in others, 2016 comes before 2015. How can I ensure they are consistently in the same order?
-
How to track specific data changes?
Is there a way to track specific pipeline (or data) changes in Domo week over week or day over day? For example, we already have a data source that takes snapshots every week, that allows us to see how pipeline changes each week. But is there a way to see what exact changes happened? What was added to the pipeline or…
-
Manipulating cards in a Drilldown
It would be great to be able to change a card inside a drill down. Right now you currently have to go to the mother card and follow the edit drill path path to edit a card.