-
How do I change the data from being horizontal to vertical using a calculated field?
My data is currently horizontal so each column has a different month with the totals below (example below). I would like the data to be vertical so that it is easier to display the data visually within domo. I have placed an example below. I am not sure how to make a calculated field to display the date and totals…
-
Period over Period - Specific Date Field instead of Current Date
We want to use the Period over Period charts since they make comparisons between different periods very quickly. As you know there are some requisites to build a PoP chart and one of them is the "Date Range". We noticed that this field takes into account the current date so, for instance, "This Year" today it will give the…
-
Analyzer - Filters get rearranged alphabetized after saving.
Hello, I noticed recently that after I save a card and go back in the analyzer all the filters used to filter my data to build the card are getting rearranged alphabetized. I rearrange them and hit save..BOOM! rearranged again. This is not how it always has been and is becoming very annoying. Is there a new option that I…
-
Unique Count based on Revenue Amount
Hi All, I am working on a beast mode to count the number of contacts that have generated greater than $100k in revenue. I've tried the beast mode below, but it's only pulling null values. I kind of expected this to not work, but had to give it a try. (CASE when `Revenue Amount (Global)` > 100000 then COUNT(DISTINCT…
-
Top 10 by Sales
I would like to create a bar chart with the top 10 customers ranked by sales. This question has been answered elsewhere but i do not know if the interface has been changed because in my view, there is nowhere to limit the rows to top 10 in the Data Table page. I have included a screenshot.
-
Sorting Year date Filter in Ascending order
Hi All, I have a beast mode created as CONCAT(YEAR(`pickupDATE`),'-',MONTHNAME(`pickupDATE`)) which in turn returns values such as 2020-April, 2020-june and so on...When I try to display this as a quick filter I get the values displayed in the quick filter in my card in random order -such as 2020-April 2020-August…
-
Set default formatting for a field (on cards) on the dataset
I hate adding currency fields to cards in DOMO, super frustating.. EVERY time I have to do this: format Set currency to $ remove decimal places I'd like to set this once (as a default) at the dataset level.. then be able to override in card if I need to.. Save so much time..
-
Creating a constant value for each month
Hi all! I want to build a Pivot Table Card with columns being each month from start to current date , rows as IDs and each value to be a constant number. However, in the dataset there's one row per ID showing start date, its status and the constant number (ID-1 ; 01/01/2016; active; 150). So, when building the card the…
-
Is there a one-letter abbreviation for month?
I am aware that I can use %b for the abbreviated month (three letters) and %M for the full month, but is there a way to have a one-letter abbreviation for month? For example, "J" for January and "F" for February.
-
New Descrition format
Hello all, We use to format our descriptions with some information and was formated in a easy to read format, but in this new version was all tranformed in a 1 row, no spaces, bunch of data. we went from this.- to this.- is there any way to apply formating to this new feature?
-
Beast Mode to add two values from the same column
I have a column that is showing different periods. the column breaks them out in 0-10,11-30, 31-60. Then there is a column called 'values' with the correlating value for those periods. What I am wanting to do is just add together the 0-10 and 11-30 periods together using a beast mode.
-
How do I filter on two dates?
Long time lurker, first time poster here. I need to create a metric within either the ETL stage or directly in the dashboard (I suspect it will need to be don at dashboard level) for meetings attended. It is calculated as: Count of Marked as done date within date range AND Due date within data range So for example if the…
-
Scatter Chart - Drilling Down
Good morning, I've attached an image of a card a user has built using a scatter chart. The X Axis represents the day of the week, the Y Axis is the amount of hours it takes for blood products to go from collected to labeled, and the bubble size is the count of products that land in that hour time period. When we want to…
-
Can I nest a Select Distinct function in a beastmode?
Relatively new to all of this, but I'm working on a beastmode that calculates the average tenure of active employees within my company. The data I'm pulling from includes a lot of duplicate system id's (employee id's). I need to filter out these duplicates in order to get an accurate average. I've written the formula in a…
-
Best option for YOY comparison showing where we are now to that same period last year?
I am trying to show a comparison for total revenue for where we are now compared to where we were end of February 2021. toying around with different graph options isn't allowing me to slice and dice the way I want. It either is a line graph YOY by month or a progress bar that is using all of Last year and comparing it to…
-
Adjusting a decimal to be used as a summary number
I have a column that calculates a %. in the dataset it reflects like 94.965, 97.245, etc. which works great in any card. Now that I am trying to use it as a summary number I am running in to this issue: I can't seem to be able to get it to reflect 94.39%. it just shows this big ugly number. This field is a calculated using…
-
Dashboard question
Hi, I'm new to Domo dashboard and want to know whether there's a way if you click on one bar in the bar chart it will switch the dashboard to a new dataset. Like here if I have a dataset that is the overall of the months(2010-Jan ~2010-Dec), and I have separate dataset with more detailed info about each month.. I want the…
-
How to create dynamic X range from backend or Beastmode?
At my index chart I would like to create a dynamic index when comparing 2 products. I need to sum the value sold from each product index and plot as a grouped and stacked bar chart. Sometimes I can have much more volume on "<70" that I would like to see, but to have this today I created at the backend a fixed range.
-
Adding multiple series in Grouped and Stacked Chart
Does someone know how can I create a grouped chart with 2 series? I would like to sum value from 2 products filtered and compare it on the same graph. But it's a index view, so I have to calculate the index (done at the backend of the data) and sum all value from each range I've got, like this image So I choose product 1…
-
Average
I have created a Card for volume by hour. Now the department wants a card Average volume by hour. COUNT(`Case Number`) OVER (PARTITION BY HOUR(`Created Date`)) I'm not sure if I'm doing it right as it's creating duplicate Hours and Volume. I have done it in ETL and getting the result but then I cant do filters as It's a…
-
Card Level Interaction Filters
This is a pretty straight forward question. When interaction filters are enabled on a card does it only work on cards that are running on the same dataset with the interaction enabled? For example I can 1 card that I want to filter other cards, some cards are on the same dataset, some are not. I thought that similar to…
-
60 days since last pmt beastmode
I have a payment column called LastPmtDate, it exactly what it sounds like. What I am wanting to do is write a beastmode to be used as a filter to filter on only those that our 60 days or greater from that payment date.
-
Hide Legend on Funnel Cards
On the funnel card, there is currently no option to hide the legend completely. This would be a useful feature.
-
Trying to add percentages in a pivot table
Hi, Would anyone be able to help me with the following: I'd like to have my pivot also show percentages of these two columns, I managed to get it to look like the bottom part however when I add a new column in the pivot it says the processing has not worked. Not sure how to add in the percentage? Thank you!
-
Drill Path from same Dataset returns zero value
Hello Dojo! Basically, I have a page that shows the most viewed pages, what we want to see in the drill path is when we drill down, the most viewed cards on those most viewed page. when I do it from separate cards, I can show them fine, one card has the most viewed page the other the most viewed card. they are using the…
-
Possible To Update All Cards On A Dash At Once?
Hi - seeking recommendations on a faster/better way to update datasets and dimensions for all cards on a dashboard. Currently clicking through each card (80+ on one dash) to update to a new dataset, and also to remove a filter. Going to add a dash-level filter once all the card-level filters are removed, but wondering if…
-
Displaying a single row on a card
I'm in the process of building a drill down report. At the bottom I'm looking for a single page of Column names and text. Ex: Order #: 8675-309 Customer: Jenny Order Date: 2021-04-07 Any help would be appreciated.
-
How to add percentage in the pivot table?
Hi, I'm new to Domo. Is there any way how to add a percentage in the pivot table? So, besides the total, I would also like to know the percentage of each category. Thank you.
-
Birthday calendar
Looking for a way to put team member's birthdays and anniversaries onto a calendar card for the team to see. Thanks in advance
-
Aggregation by month with segmentation
Hi there. I am breaking my head about something that just feels so easy to get. Is there somebody who can help me out with this please? I want to show a bar chart grouped by month (please see example below). The bars then should be segmented into categories. The data is coming from the user activity in a tool. The idea is…