-
Series counts
All, I have a data set of accounts that are considering some of our future products. The account list has a multi-valued field, <product>, and I'd like to show the number of accounts considering each product. Is there a beast mode that can split this out and count the products or should I just bite the bullet and create…
-
Does the Date Range Field not show up in cards that are in the drill path?
I have a card that has a Date Range Field but then when I create a drill path the card in the path does not show this date range. Nor is it the case that the date range from the top card is being applied to the drill path card. Why is that? Am I missing something? By not having that date range in the drill path card, my…
-
Are word cloud cards possible?
I would like to create a word cloud based on the text entries in a column in my data set. Intuitively I tried using the "textbox" card but I'm stuck. Are word clouds possible in Domo? Is there a tutorial for creating one? Searching the community hasn't turned up anything so far.
-
Last Value Projection using Specified Value
When using the Last Value Projection - Specified Value in a card, the hover text names the specified value as projected. It would be great to be able to specify the term you want to use and not have to use projected. For example, since the specified value I am using is a budget number, I'd rather the label read Budgeted as…
-
Display decimal numbers as fractions?
I want Domo to display decimal point numbers as fractions. For instance, instead of 0.655, I want to see 5/8, or better (without the large space below the 5): 5 _ 8 Excel has a fraction formula for this. But I don't see that in Domo.Can Domo do this? Thanks.
-
bar card with threshhold line
I'm trying to create a bar chart displaying a line for the threshold for each category on the x axis, so I have 7 categories(x axis) each with a value(y axis) but want a line across the chart for the threshold each category is supposed to meet, which is a separate field in itself but cannot figure how to add this in by bar…
-
Viewing/Conversation on Cards
We've noticed that if we were to start a conversation in a card, the filters reset. For instance, if someone asks me about last month's sales on a card that is pre-set to a one week view and I bring up the month to talk about it, they would have to do the same filtering on their end in order to see the same data as me. Is…
-
drilldown data ordering
I'm working within the drilldown design. the default last level of the drilldown is the Dataset Table View. When i drill to that view, the columns are ordered differently than in the dataset or dataflow. is there any way to force the order of these columns in this view?
-
extract domain in beast move
Has any successfull extracted the domain out of an email address using Beast Mode?
-
building pie chart with colors from formula
I'm trying to build a pie chart where I have a list of rows with different dates('transfer date') and am trying to for that date and the number of rows display a color of green, yellow, or red on the sections of the pie chart green being when 0-3 months after the transfer date yellow being 4-9 months after the transfer…
-
How do I create a table where I can sum groups of values in a table?
I can't seem to figure out a way to sum up pageviews by slug (second column) across multple dates in my data. How do I go about doing this? With the data below, I want to see a single instance for each slug (second column) with pageviews summed.
-
How to address gaps in date ranges in visuals?
I have a few cards trying to show activity of sellers on a weekly basis for a rolling last 13 weeks by week. However as I drill down more and more granular (by region, by rep) I'm finding that rather than have weeks with 0 but a column placeholder showing, I get instead a skipping of that week entirely! This presents the…
-
Change default color of Group Total in nested bar graph
I see where I can select different colors for the various series contained wihtin a bar graph. My question is on the ability to change the default grey used with the Group Total in a nested bar graph. Can I do that, and if so, how?
-
Can't get This Quarter card filter to work as desired
I'm having an issue with my card where I want to reference information that is only within Quarter without using the date range field. I have multiple date columns that all have different meanings in the data set. I have date fields for: IO Start Date IO End Date Campaign Start Date Campaign End Date Revenue Period I want…
-
Is there a way to replicate an Excel combo chart in Domo?
I have some charts in Excel I'm trying to replicate (as best I can) in Domo. One of the charts is a combo chart that shows data on the Primary and Secondary axis. Is this possible in Domo? I'd like to have a vertical bar and a line on the same graph.
-
Drill-down / Card / Switch labels to something else?
My question concerns drill-path view and how I should set it up. Everything went well when I created my 1st card where I chose TIMEGROUP as a X-axis, avg(VALUE) as Y-axis, and again TIMEGROUP as Series. In the bar chart, I get my 3 TIMEGROUPs in 3 different columns with VALUEs aggregated between them. Now, I need to create…
-
Always show labels
Hey there, Looking for a way to set the labels to 'Always Show' mode instead of 'Show when Hover', or to export the card with labels that are there. Thanks, UPDATE: %_VALUE - found it
-
Choose "Year" in Page Level Filter - display Year and Prior Year
I have a brain bender (at least it has been for me). I have a card I want to display "Sales vs Prior" - if the user chooses a "Year" (2015, 2016 or 2017) in the page analyzer I want this card to display the year they picked, and the year prior to that choice as well. Any ideas on how to approach? I have attached sample…
-
Widen the Scale on a Line Card, and leave it dynamic (not set values)
In the card displayed below you can see that the default scale is displaying the values in a very tight grouping. I would like to widen what is displayed (reduce to range of the scale). I know I can do this by setting the scale values to specific numbers, however this causes issues when filters are applied for business…
-
Second line on line/grouped Bar Chart
I want to be able to ping in a second line into a mixed line/grouped bar chart, is there a way to do this?
-
How do I add multiple values to a bar + line chart?
Hi! I'm trying to build a bar+line chart with 2 y-axises(marketing spend + output) and a X-axis(date). How do I add 2 values to the Y-axis? Kind Regards /Noa
-
How do I set the card date range end date in the future?
I have a complex beast mode calculation that determines YOY (currently 2016/2017) revenue gaps by customer. It automatically calculates through the end of the current month. However, when I try to set the card date range to "1/1/2016 through 12/31/2017" it automatically changes the end date to the last date for which we…
-
grouped bar with multiple symbols
Is there not a way to create a grouped Bar chart with multiple y-axis symbols? I have 3 divisions (x axis) and i want to show grouped bar (Rev, Margin, Operating Exp) and symbols for (Rev Budget, Margin Budget, Operating Exp Buget) It would provide a quick summary of divisional performance to budget
-
Domo cards - Add a title to a card's legend
Happy Dojo day! I would like to know whether or not it is possible to add a title to a card's legend. For example, currently the legend of a pie/donut chart only shows the pie or donut slice name but it would be really useful if a title to legends could be added (in order to provide more information about what the card…
-
Comparing against a series
Happy Domo Dojo day! Does anyone have any suggestions on how to dynamically do comparisons on a series? For example, let's say you have a grouped bar graph that shows Net Sales on the Y axis, months on the X, and the series is 2017 and 2016. I can see the 2016 and 2017 sales easily enough. I can do some basic math to get…
-
Tree Map - "Other" Drilldown - Filter Defaults to Arbitrary Value?
I have a tree map which shows the top 20 Business Units by value plus an "Other" category. When I drill down into the "Other" category, the drill card places a default filter on an arbitrary Business Unit. Is there any way to avoid that behavior?
-
Beast Mode Sums not working, leading to strange sorting.
Hi there! I have 3 series made with Beast Mode: Series 1 = sum(`a`) + sum(`b`) + sum(`c`) Series 2 = sum(`d`) + sum(`e`) + sum(`f`) Series 3 = sum(`a`) + sum(`b`) + sum(`c`) + sum(`d`) + sum(`e`) + sum(`f`) I have Series 1 and Series 2 (blue and green) stacked on top of each other, and I'd like to sort by their combined…
-
First Occurrence of Combination
I have date that includes (something like) the following DateIDClientRegion1/20/201711111AEU1/20/201711112AUS1/20/201711113BEU1/21/201711114AEU1/21/201711115BUS1/21/201711116CUS I am looking for assistance on a beast mode (or ETL Data Flow) that will pull me the name of client + Region combination that we first received…
-
How do I consolidate data from GL?
I am trying to summarize data based on a database table that contains thousands of GL entries. The problem I am trying to solve it summarizing the data based on part of the GL. For example: I have a GL that is 16 numbers long and I want to summarize data based on numbers 1-10. Is this possible? So any record with a GL…
-
Sumo Cards are not included in the PPT publised. Anyone knows why and how to fix it?
I have 3 cards on a page, 2 of them Sumo card. When I choose to "View pages as SlideShow", I see all of them. But when I downloaded as PPT, only the non-Sumo card was there. Anyone knows why & how to fix it? Regards.