-
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).…
-
Colour Rules while comparing two columns.
Hi Team, Your support is highly appreciated in advance. Could you please advise/suggest how to apply colour rules based upon dynamic targets in 'Line Grouped Bar Chart'? Thanks Rabia
-
Domo Buzz notifications
Hi In Domo Buzz you can start a conversation about a dashboard. But, having tested it, no one who the card is shared with gets told about the conversation unless each individual is @ mentioned in the chat. Is there a setting which alerts all of the people that a measure in the dahboard has been updated? Thanks Ian
-
How to remove Scale Marker
Hey Domo family, I added scales on my graph, but I couldn't remove it or reverse it back to the original one. Is there any way to get it off from my card? @GrantSmith @MarkSnodgrass
-
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…
-
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…
-
Trying to condense / group rows to remove nulls, any help appreciated
Hello, I am working on a data flow that needs to perform various substring functions to isolate data from a large xml string. I have gotten it close, where the data is linked to the log / time / user in in the sql database, and i am able to separate values into appropriately named columns. I would like to know if/how to…
-
Beastmode YoY Variance Calc
Hi All, I am working on a beastmode that I thought would be relatively straight forward, but is giving me some issues. I am trying to do a YoY variance calc starting in 2022. The problem I am running into is that the 2021 numbers are not being subtracted out of the 2022 numbers. When I look at the previous year info, it's…
-
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…
-
Domo and GitHub
Hello All, We have recently bought Domo and they gave us one instance of it.... Trying to see how can we use GitHub and do PR etc to deploy stuff.. Does Domo has something like this to manage deployments. If I have one Page with 5 cards, Can I have production copy of it and somehow get dev version of it to do future…
-
How can I plot values that are in the time format mm:ss on a graph
I was able to use the SEC_TO_TIME function in DOMO to get my metrics on time duration in the format hh:mm:ss. However I am only able to see this data in a Table format. When I go to plot this on a graph it doesnt work. Any help in enabling this visualization would be great as we have many call center operations related…
-
window.addEventListener("message") does not trigger when card is clicked
Hi experts, I have successfully built and ran the sample. My card is loaded. Now I want to watch the event of card clicking and get out the selected data. With the help of Domo, the event of message will be just work when card is clicked, or filter is changed, but nothing happened. I also tried to change column&value of…