-
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…
-
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…
-
Domo Everywhere- Embed Card- Change Background of card to black.
Hi guys, When I embed a card using Domo Everwhere, I would like to have a background color to be black. But by default I guess it is White. Is there a way we can change the background color of the card.?
-
Centering a Summary Number
How do you use HTML formatting to center a summary number? I tried using a center tag and '<div style="text-align:center"> and neither worked
-
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
-
Period Over Period Nested Bar
Hey guys, I'm trying to create a week over week bar graph that shows the next 7 day production vs the last 7 day production. That is the easy part, I'm also trying to group the bars by our different locations. Below is an image of what I have so far. Is there an easy way to split up those total production amounts into our…
-
is there an easy way to not show zeroes??
I have a table that consists of inputs from 3 different sources. What I am running in to is more of an esthetics issue that I am hoping to clean up. I have areas where a zero appears, and other spots they don't appear. The data are all integers so i understand why there would be zeroes showing but confused why it shows up…