-
beast mode - counting text
I have a survey where the participants are able to select multiple options. For example: Why did you decide to not enrol? Answers: I cannot currently afford it I am not interested I cannot make the time Other When I try to visualise this, it does not group single answers with cases where there are multiple answer choices…
-
How to have multiple series for a trellis chart
I am trying to add multiple series to my trellis chart. I can add the second category with just the first Y-value, but when I add another series Category 2 dissapears and I cannot add a Category 2 unless I remove the additional series. This article shows a screenshot of a sample trellis chart that has several series…
-
Can we change order of columns in Pivot Table?
I want to bring values first and Columns after. I can't seem to do that.
-
Rearrange values on X axis
Hi, I am creating a view where I want to observe volumes base on a time of the day bucket. So have a variable: time_of_the day that I created using a timestamp variable. When I put the variable on the x axis, it starts with 10-11 AM first and and with the earliest value, 9-10 AM. I would like to organize the values in a…
-
How to fix the line to a particular filter selection element
Hello, I have a grouped bar + line card. there is also another Filter card that allows user to select inventory, gross sales, net sales.each of these needs to be shown as a grouped bar and inventory to be shown as line. This works fine when all of the filter elements are selected, but if user selects say gross sales and…
-
Multiple datasets in one card - Replicate from PowerBI
Hello potential helpers ! I'd like to build a card for my dashboard which shows the revenues of advertising placements against the number of sessions. What is tricky here is that the number of sessions is the same for each advertising placement. In fact,one visitor sees multple advertising placement during its session. So,…
-
Text analysis
I have a survey where the answer to many of the questions are open-ended. So I have hundreds of responses for each question. I created a word cloud, to see the responses, but I want to be able to do a sentiment analysis or a word analysis. For example, if the question is "Why do you want a career in nutrition?", there are…
-
Add a PoP % change data label to a Period over Period Chart?
Good afternoon, Is there a way to add the Year over Year percentage change to the data label in a Bar Line Period over Period chart? For example, in the screenshot below is there a way to add a second line so the data label reads something like:0 This year: 2020-Apr: 8,710,963 +71% Thanks!
-
Tiered Date quarter number change
How to change standard calendar quarter month number to business calendar quarter month number when using Trellis/Tiered Date settings.
-
Week Ending instead of Week Starting
Hello - I recently began transitioning our Finance group over to Domo but I've run into a big snag with their adoption with regards to the labeling of cards. Today all of our financial reporting is based on week ending. Currently in Domo - when you create a card in Analyzer using a Date as the x-axis and group by week, the…
-
Cards on main dataset are very slow when editing
Cards that are built on our main dataset are painfully slow to respond when editing. Even the simplest cards like guages, bar charts, etc. are extremely slow to respond. Any suggestions as to what may cause this?
-
Median Value
How can you create a summary value of the median of a dataset? It looks like average is an option but not median...
-
Count Distinct Customer Visits Without Showing Customers in Card
I am needing some help with a project I am working on where I need to report on how many customers visited in a given time frame. Attached is sample/dummy data of the dataset I am trying to analyze. Requirements: 1) Use Visit_Date as a filter (date range) 2) Report how many distinct Customer_ID visited during the filtered…
-
Mandatory Single Select Filter
Hi all, Is there a way to make Page filter mandatory (so no option to unselect), and only single select? Examples would be if you want to choose the currency to display it in, which target to compare the figures to, etc., but if multiple or none are selected the figures are duplicated. We've put in a radio button which…
-
Can I show a percentage of a Summary Number underneath the Summary Number?
Good morning, Is there a way to display a percentage of the whole Summary Number, underneath the summary number? For example, in the screenshot below, would I be able to display that 20% of Total Streams (the 8.7M number) came from Paid users? Thanks!
-
Top Survey questions
I have a data set with 30+ questions as columns. Other key columns are a user column and a topic column. The question columns are text based with values of either 'Yes', 'No' or 'N/A'. So basically each row in the dataset includes a topic and a user's answers to the 30 questions. I'd like to build a card that shows the 3…
-
Drill down on metric counts
I have several tables that are counting the presence of a date in a given field. Our end users are able to click on the grouping to see all loans in that group with one of the date fields present, but when they click on one of the count cells it returns nothing. I think conceptually I understand why this happens (there are…
-
Month over month Offset/Lineup
Hello, I want to build a card month over month offset or lineup. Example, if today is *May 1, 2020 Friday* then it would compare and align to *April 3, 2020* since April 3 is Friday. Then May 2 would align to April 4 (saturday), May 3 to April 5 (sunday) and so on. I use period over period charts.
-
Is it possible to set a default landing page as a user (different than company's landing page)
Trying to set a landing page as a user or admin, which is different than company's set default page. Is it possible or company setting will overwrite this and I can't select a separate page as landing page for myself?
-
Color Rules by Rank
I have a Tree Map Card for Top 10 Products and I wanted to have some sort of Color Rules by Rank for example; Top 1 should be Blue, Top 2 should be Green etc. Is this possible?
-
How to set default page level filters?
I'm trying to set default page level filters, by setting up default values and clicking "Save Filters" at the top of my dashboard. These filters apply for me, but not for other people who have access to the dashboard (they see the page without the default filters). Can anyone explain?
-
Set a default date filter to "today" on dashboard
Hello, I have a dashboard I'm building with a calendar card that can also function as a date filter. To get this to filter correctly, all of my other cards are scoped to "all time" on their dates. I would like when a user lands on the dashboard that it would defualt the filter to "today" instead of "all time." I'm unsure…
-
Bar chart with Fluid Target
Im trying to add a fluid target line from a column in the dataflow to a bar chart. It seems I have the choice of adding a target and losing my series, or vice versa. Is there a way I can do both? I have tried line bar, grouped bar, and a few others but still cant get the result im looking for.
-
Unable to select apply to selected cards in card interaction settings
I have built a dashboard with about 8 cards on it. I have a filter card that I just want to have it affect only 2 cards. However, when I go to Interaction Settings and try and change it to only apply to selected cards, the option is greyed out. See screenshot below. I have been able to do this before, so I'm unsure as to…
-
Delete an Annotation
Is there a way to delete an Annotation? I can see how you can hide them but if an Annotation was made in error, I don't see that we have an option to delete. Even at an administrative level, I don't see that this option exists.
-
How to select most recent data for bar chart
Greetings - I recently posted asking about defaulting to the most recent data for a single value chart and got a great solution; now, I'm struggling with the same issue with a stacked bar chart where I don't have the option to use the value from the last row of data. My data is usually updated around noon; until then, I'd…
-
Can we creat a custom sort for series in domo stack bars?
I try to creat a customer sort for series in doomo stack bars? but they only have sort by total or sort each category? can we create a custom sort for that?
-
Flex Table 'Change Value' Column
Hello, I am building a flex table card to track MoM change across multiple metrics. For all the applicable columns the numbes are shown with the designated value formatting (currency, number, etc.) I have assigned to the series. However, for the Change Value column it is only showing the value in dollars for all my…
-
How to View/Download large tables
Help, I need to know how to view and download large tables in Domo. I've been using the Sumo table but the downside is I can't download the pivoted data as shown in Domo. The new mega tables and pivot tables work, but there seems to be a data cap and only part of the data is shown, which is very confusing. A team member…
-
Removing gridlines from stacked bar chart (but keep the x-axis)
Hi, I am looking to remove the gridlines from the stacked bar chart, but keep the y and x-axis (the 0 grid line) Does anyone have experience with this?