-
How to append data from S3 Bucket into Domo
I am going to recieve one file daily into my S3 bucket, which I need to bring into Domo through the S3 Advanced Bucket connector. I have to keep historical data in Domo, which means that I have to append mydataset in Domo everyday with a new file that is coming into the S3 bucket daily. I do not understand how to do this.…
-
Can we schedule a PDF or a Powerpoint?
I know that we can schedule reports in Domo, that come in the form an email with images in the email. However, does anyone know if we can schedule PDF or Powerpoints? Like PPTs or PDFs attached to a scheduled email via domo Thanks!
-
How to Export filtered dataset?
I have a 1 million row dataset in Domo. I want to filter the data, and only export that data in a CSV. When I filter the data and export, Domo exports the whole 1 million rows, which does not run on my Excel. Anyone know how I can download the filtered dataset>
-
How to change Text Color in table, but not Cell Color
I want to change text color in a cell in a table based on a certain condition. But when I go to color option, it colors the whole cell and not just the text. Can anyone tell me how to do this?
-
How to change timezone of a column in Magic ETL based on another column
How do I change timezone of a column in Magic ETL based on the input of another column. e.g. I have a column called Datetime, which has date-time values (e.g. 2020-12-07T00:00:00). I have another column called Timezone which has a timezone (e.g. 'UTC') I want to convert the datetime column from America/New_York Timezone to…
-
Unsupported SQL type '{columnType}' for column 'VARBINARY'
I want to assign NULL values to certain columns in a SQL transform: SELECTNULL as 'column_x',NULL as 'column_y',column_zFROM Table_1 The dataflow gives the following error: Unsupported SQL type '{columnType}' for column 'VARBINARY' This is because from what I understood from another post in Dojo: you cannot assign NULL…
-
How to calculate different in seconds between two timestamps in Beast Mode?
I am using the DATEDIFF function in the beast mode but it gives me a value which is not in seconds. Could anyone please explain how to calculate the difference ins seconds between two timestamps
-
Anyone know how the dropdown filter card was made in the Domo Covid-19 public dashboard?
(Picture attached) We're trying to make this card in our dashboard, as the UI seems vert clean. I could not find this card type in analyzer. Anyone knows if we can use custom web development to make this card, and then embed it in our instance dasahboard, and if yes then any resource to look at?
-
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.
-
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?
-
How to make a chart with two columns on the x-axis?
I have 3 columns: Sales, City, and Country. Sales is a number, while City and Country are Text. I want to make a bar chart, which has Sales on the Y-Axis, and City and Country on the X-Axis. It would look something like this: Each city will only fall within its own country. Any ideas if I can do this on Domo?
-
How to calculate week numbers based on custom week start day
Question Summary: I want to calculate the week number from a date based on a custom week start day. How can I do this, either in Beast Mode or SQL data transforms. Explanation: My company Domo settings have Weeks defined from Sunday to Saturday. However, one of my internal client team records weeks from Friday to Thursday.…
-
Remove 0s from data labels
I want to remove 0's from data labels (i.e. only show data labels when it is not 0). Any idea how I can do this? I've attached a picture of the card I'm seeing. As you can see, there are a lot of 0s in the data labels.
-
Flex Table with only one column
How do I make a flex table with only one column? I don't want more than one columns, but it seems that the flex table input needs at least two columns to work. Could anyone help? If not, then I was thinking of using a Comparitive Guage as an alternative. However, I cannot make the beast mode calculation as per my needs to…
-
Changing a day week start to Friday
I want to change the start of week days to Friday only for 3 cards on my dashboard. Can anyone tell me how to do that? I know I can change this in company settings, but I only want to apply this rule to 3 cards and not the entire company I know that I can change the start week day in a date filter card, but that does not…
-
Changing owner for Account in Domo
I want to change the owner for an Amazon S3 Bucket License/Account. However, Domo does not allow me to do that (it allows me to change credentials but not owner). I do not want to create a new account/License. I am currently going to 'Account' in Datacenter, and seeing/trying-to-edit account owners over there.
-
Subtotal (subtraction) Rows instead of subtotal (addition) Rows in Pivot Table
Right now there is an option to include subtotals in pivot tables. Can we include subtration of rows instead of subtotals? I have two rows: Current Week and Previous Week. I want to add a subtration field in the rows. Can anyone help
-
How to make a chart which shows weekly values along with percentage change?
I want to make a chart which shows the weekly value of my sales, along with the % change every week. This % change can be in the form of a bar, a long, or a symbol (along with % value). Anyone knows how to do this? and whats the best way to do this?
-
Remove columns with a sum of 0 in Grouped bar graph
I'm making a grouped bar, and I want to exclude columns which have '0' as a value/sum. I'm not able to filter because these columns are beast mode calculations and Domo gives an error (or crashes) if I use these columns in the filter (only greater than 0). Can anyone tell how do I remove the columns with a sum of 0?
-
How to know if a dataset is being used in a dataflow?
I have datasets which I want to delete. However I am not sure if these are being used in a dataflow. I have hundreds of dataflows so I don't want to go into each one of them to check. Is there a way to check which dataflows is a dataset used in?
-
How to remove access of an admin user from a dataset?
I have a dataset of which I only want to give access to some people. Right now, all admins can access this dataset (even though I have not given access to them, I believe this is how admin rights work). But I want to remove a few admins from being able to access the dataset (as it contains confidential information not…
-
How to use partition by clause in Domo SQL
I have following columns: Kingdom, Animal, Age, Weight Each row can be repeated multiple times. I want to sum values on the kingdom level in another view/table: My code is: SELECT 'Kingdom', SUM (MAX ('Age')) OVER (PARTITION BY 'Animal') AS 'Age', SUM(MAX ('Weight')) OVER (PARTITION BY 'Animal') AS 'Weight' FROM 'Table'…
-
How to enable child pages filter in Domo
I want to have a main page (on a division level). If we click on that page, I want to see different pages for departments. If I click on any department, I want to be able to see the different pages/dashboards for that department. Right now I can only go down one level, and not two. Is this possible through the children…
-
How to add color to hyperlink in beast mode?
CONCAT('<div style= ""><a href="https:`,' "target="_blank">',`id`, '</a></div>') I'm using this code in beasrt mode. How do I add color to my font?
-
Drill down a range of data rather than a single point
I'm making a drilldown path in a timeseries card (days on x-axis). The problem is that for drilldown, I have to click on a day, and I can only then drill down into that day. However, I want to be able to drill down into a range of days, rather than just one. Any idea how I can do this.
-
How to remove header of a table card
How do we remove the header of a table card? I just don't want to show it, but I can't remove it. pls help me.
-
Create a dynamic hyperlink without having to put it in a table
I want to insert a hyperlink in my page which changes based on the selection made in the filters available on my page. As of now, I can either insert a fixed hyperlink, or link something to a page within Domo. For now, I've created a column using beast mode which inserts a hyperlink in a number. The code is something like…
-
New changes to the DOMO UI, any way to see the changes myself (as administrator) before making them?
I still have not made the new changes public to all my company's users (available through the last update). This is because I want to see how the changes will impact the UI before I amke them public. Is there anyway to see this beforehand? For Example, I have many pages under a broader category of pages. But there's only 2…
-
Create cards with charts where you can change columns on the X-axis through a filter.
I want to create a card (bar graph) where I can change the columns being shown on the x-axis through a filter. For instance, I have 4 columns: Revenue, Profit, Costs, Date. I always want Date to appear on the X-Axis. Whereas the columns on the Y-Axis should be any of the 3 (Revenue, Profit, Costs), depending on a filter…
-
How to put default filters at the top of a page?
I've made a dashboard which has many cards. There is also a date filter at the top which can allow users to choose the timerange they want to see the data in. In the data at the backend, there is data for many years (from 2000 to 2019). I want to set the default date to current year. So when users log in to the dashboard,…
