-
Filter multiple months by specific days of the month
Hi - I'm looking for a way to take a card with a date range of the previous 13 months and have the ability to filter it for certain days of the month so I've got more of an apples-to-apples comparison. Ex., if today is July 15th then I want to filter the exact days to include so that other months on the card only show data…
-
Card Data
Hi Guys! I have a warning about not all data being shown in my card although i have selected all rows. Does anyone know how to fix this issue? Thank you!!!
-
Card Alerts
I'm working on setting up some alerts, however i can only choose the card summary number to set the alert up on. I've watched the tutorials online and they show that you can set alerts up on multiple card variables. Does anyone know how i can set the alerts up on multiple variables for one card?
-
group by and sorting by date
I have daily data (years of it) that will be grouped by category (columns summed by group), but also need it to happen within different date ranges. Last week, MTD, QTD, YTD etc. The only way I can think to do this is maybe in the ETL creating a new column with case statements for each category/date possibility, but this…
-
How specific can I get with dynamic scale markers?
Hi all, I'm working on a year-over-year card where I want to add a goal line that represents a 10% reduction from the previous year. However, this is a card that I have a slicer for, so I want that line to be dynamic as the data changes. Is that possible? The furthest I was able to get was to create a percentage scale…
-
Pendo connection: how to add a date column to a dataset?
Hello! I have created a Pendo connection to domo but a date column was not pulled over with the data. I was wanting to add a column to the dataset and put the date that the corresponds with the data but am struggling to do so. Does anyone have any ideas on how to do this?
-
% Change Columns in Pivot Table
Hi Dojo Community! My team is trying to create a card for a customer that allows them to select a range of years and/or months to compare (they will most likely view one month at a time), apply additional filters as needed, and drill into the table. The card should be structured like the screenshot below. There should be a…
-
Error Message trying download a card into PowerPoint Slide
Hello, has anyone had an error when using Domo PowerPoint add-on to download a simple table card into PowerPoint? When I clicked on "Choose Card" and selected a card from "Domo Choose Card Wizard" window, the Error message popped up - "Error fetching card from Domo. Please try again. An item with the same key has already…
-
Give different filter values to different cards, same column Campaigns?
Is there a way to specify that a campaign distribution list filter only applies to certain cards? All the cards have the same column (same data source) but trying to display two different time frames on some of the cards, and thus need the filters to only apply to select ones. Not seeing anything in the documentation for…
-
How to build card
-
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…
-
Limit Date Selector Card for User Interaction
I have a dataset that has multiple report dates with each value summing up total for that day (each row has its own value to sum for the day). I have a date selector card as a calendar format but need to limit the user to only choosing one day at a time since choosing more than one will make the data inflated and not…
-
Adding a cumulative total line in a multi line chart in Domo
Hi everyone, Does anyone know how to add a cumulative total line chart in a multi-line chart? I have 3 different lines that I want to show on the same line graph and I want to sum up the 3 lines and put that line on the same graph so a total of 4 line on a single graph. For example, Blue = 1, Yellow = 2, Red = 3, and I…
-
Domo Role "Admin" Can't see dashboards by default - why?
If I put a user in the "Admin" role, I expected them to be able to see ALL dashboards by all users. It doesn't appear this is true, and they must be in a group that has access to shared dashboards/cards. Is this normal behavior? What's the best way to truly have a user that can see everything in our instance?
-
Interactive table function
Is there a function/card that would allow you to add in columns that can contain text and be updated and saved? For example, we have a Sales Funnel and this shows all prospects across the globe, with start dates, values etc (this information is taken from a CRM platform to DOMO), we would like to review these prospects on…
-
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.
-
Report to show how many cards use the same specific dimension
Hi Dojo - Good Day! Just wondering how I can create a report in DOMO to show how many cards use the same specific dimension in one dataset. for example, I have a Employee Information Dataset and I want to know how many cards use the dimension employee ID Thanks In Advance!
-
Dynamic Target Based on Current Date
Hello all, I am currently utilizing a gauge card with a target metric. What I would like to do is have the target be dynamic based on a date. For example, we have a different target for each quarter in our fiscal calendar. Depending on which quarter we are currently in, I would like the target to reflect the correct data.…
-
Moving one column under another
I have a table with 5 columns: column 1 is an ID, columns 2 and 4 are codes, and 3 and 5 are corresponding names. I need all the codes in one column, and all the names in one column. These means each ID will now have 2 rows, one for each code/name. How would I go about moving data from one column to another in Magic ETL?
-
Take large text input as field for filtering?
I have a slicer card to filter zip codes for a large data set. There is a search bar field for finding zip codes to filter by, but say I had a large list/string of zip codes and I wanted to select all of them for filtering. Is there a way to paste this list into a search field to filter them all, instead of selecting each…
-
How to size/fit cards to slideshow
When I share or publish to a slideshow or PPT / url, The cards to not fit on the page, and I have no way to resize them. How do you customize the report/PPT so that you can see the entire card, which is sometimes a table?
-
How to reorder variable categories in legend and how to remove the total section in a pie chart?
I feel like I've tried everything... could really use some advice! How to reorder variable categories in legend? The sorting function is not really working and I would want to avoid renaming the variable categories (this issue is also prevent in other cards). Also, does anyone know how to remove the total section in a pie…
-
has anyone had any luck creating dynamic columns in mysql
what I'm trying to do is for sql to check and see if a column missing, if it is then i want sql to create the column. I've done several attempts with no luck. the alter table add column sql works but it fails when i add it to the if condition. any thoughts? CREATE PROCEDURE addcol() BEGIN IF NOT EXISTS( SELECT * FROM…
-
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…
-
Fill In Missing Dates option in Grouped Bar Chart
Hi the option Fill in missing dates is available on the X scale in the non grouped bar chart , but i cannot find it in grouped bar chart . its generating a scale that i do not want in the grouped bar chart option. can some one tell me where to find this option in the grouped Bar chart. i am assuming the attributes for all…
-
Is Certified Field
Hi Team, It would be great if we have a field to track if a card and Dataset is Certified or not? Thank You, Kiran Cheruku
-
How to group rows and make columns that count specific values?
Hi! This is a difficult one to give a title but basically, here is what I am trying to do: I have a dataset that combines a dataset of user profiles and a dataset of our assets that are assigned to each user. What this does is make it so every single entry for a user's individual assets gets its own row. So basically, if…
-
Card Drill
Hi guys! Do you know of a way to arrange the columns for the drill view? I know you can arrange the columns as a user and an admin within the drill view, but it does not save, so I am looking for a permanent solution. Thank you so much!
-
Dimension/metric selector for Cards
Hi, I wonder if there is a way to build a table card with an option to switch between dimensions/metrics to display. Let's say there are Revenue and Sold Items metrics, so I'd like to have a table card providing a break down by regions and an option for end users to choose which metric they want to see (I need just one).…