-
Todays Date
Is there a way to create a card that would only show todays date?
-
DOMO Variables - Color Coding for Diff Dimensions
Hi everyone! I wanted to create a color coding for a chart that uses a DOMO variable. It is a stacked bar chart with fix x and y values, but the series/categorization changes. For example, it could be a plot of number of people in the world (y) for a given age range (x), and the series/dimension is geographic region (North…
-
How to select which Metric should go on Line in a Line + Bar Graph?
I have a chart where one Metric is $ and rest all is Numbers. How do I graph it in a way where the $ shows as Line and other show on Bar graph. (Like how in Excel we do a secondary axis) In the picture below, its taking the 1st one(USB requests) as Line while I want to show the Red Bar as Line with $
-
Bigquery service account user roles/ permissions
I am trying to add a bigquery data source to domo via service account key. What permissions / user roles need to be added to the service account in order to work with domo?
-
Unable to Display Stacked Bar Due to Partition Beast Mode
At the base, my dataset is broken up by employeeID, months, and planID. For each of the employees, month and plan; the employee receives a $ value based on performance, called "Earned" and they also have a column "Funded" that indicates what they were funded for the plan and month. I am trying to create a card that…
-
Ability to Suppress Duplicate Value Headings
In the pivot table card type, there should be a way to surpress the value column heading if there is only one value being presented in the table. This can appear very messy.
-
ダイナミック日付範囲フィルターに何の単位を選択してるかをBeastmodeで判定したい
皆さん お疲れ様です。 Domoのダッシュボード上の右上のダイナミック日付範囲フィルターにて単位を四半期とかヶ月に選択してるかをBeastmodeで見て判定でコントロールしたいですが、方法はございますでしょうか。 よろしくお願いいたします。
-
Value from yesterday
Hi guys, Im trying to pull in the value from yesterday to fit into a broader formula. The value is followers (social media). Pulling it in from yesterday gives me the latest total followers figure. Here is my latest attempt: SUM(`Followers'), DATE()-1) And broader formula is to achieve daily client account engagement rate…
-
filter large datasets
Hello Domo ! I have a problem that I have a dataset which consists of "reports". I want to visualise the reports with cards in DOMO. The are say 10,000 or more reports. Is there a way to load one report at a time into DOMO and the browser? We have a database with all the reports in it but the only solution seems to be to…
-
How do I create a calculated column based off information from another dataset?
I have two datasets: 1- contains the rep name and the number of sales they closed for each date. 2 - contains the rep name and the number of calls they made for each date. In a report, I'm summing up the total number of calls made each week by all reps and dividing it by the number of setters for that week. A rep is…
-
Is the KB article for Time Zone not yet updated?
This is regarding support case where customer is requesting to add Mountain Time Zone. The customer was unable to find required time zone as the drop down does not contain all time zone. One needs to manually enter the name of the time zone to get related time zone, which customers are not aware of. I am sharing the KB…
-
Beast mode for dates
I have a dataset that looks like this: Date. Customers Jan 01. 20 Jan 02 22 Jan 03 26 Jan 04. 29 What I would like to do as a beast mode filter is to only include the first day of each month. So I want a filter that just filers Jan01, Feb01, March01, etc. Is this possible? I would assume it would be some data beast mode…
-
Use an existing dataflow as a template???
I'd like to automate the creation of a dataflow as a copy of another dataflow, then change the owner. The new owner would then change some of the input datasets, rename the output dataset and alter a few of the tiles within the dataflow. Looking to simplyfy the intake of hundreds of files from different sources with…
-
Exporting Report to SFTP Server
There's a particular table-style report that we need to publish to an SFTP server on a weekly basis. Currently, we have to email the XLSX or CSV file and then manually upload it to the SFTP server. Is there any way to use Domo to schedule and submit files to an SFTP on a regular basis? I see that there is an SFTP writeback…
-
Charts/Graph by
I want to display a bar chart with X axis = location and Y axis = total hours for each location but I want be able to view the data by month, week and day. I do have a date column. what is the best way to do this, the graph by option is not working.
-
Distinct List_Agg
Hi Folks, In Magic ETL, I'm grouping by a key and defining a new column using the formula: List_Agg(customer_name, ' / ') Is there a method to generate a distinct list of customer names by key? I don't want the repeat customer names in this value. All support appreciated Kind regards,
-
write_dataframe fails to write output of pd.pivot_table having Nulls
Domo python tile fails to write the pivoted dataframe with pd.pivot_table if it has nulls while converting - even if you add 'fill_value=np.nan'. See below: The pivot function works perfectly fine - it does generate the df, however, when you try to write it, it fails - see below if I write the unpivoted df, it works fine…
-
Dataset Email Connector
I have a dataset that updates via email connecotr. When the data is sent to the connector the dates turn into integers. Is there a way to fix this? Thanks
-
Is it possible to create a table showing appointment availability in Domo?
I have a list of appointments scheduled with their start and end times, I've created a pivot table showing all appointment start times as the row and closers are broken out into columns. Through an ETL, i'm able to count the number of appointments scheduled at that start time but what I'd really like to do is mark off each…
-
Adjust position of Filter Icon
I feel like this image says it all: I don't want to change the justification of my values to center or left, because values are easiest to read when place values lign up. However, it would be great if I could read what the total was.
-
Hiding of filter funnel and pdp shield
is there a way to hide the filter funnel and the pdp shield? i have several cards where these icons block the bottom left cell in a data table. If there is not is there a way to justify the data in the data table to the left?
-
Remove answered questions from the list of unanswered questions
Why are answered questions coming up in the unanswered questions link? Can we get those removed from that list?
-
Please help me write this filter formula:
How can I write a filter formula where I want to exclude everything that says 'INTERCOMPANY' from 'CUSTOMER TYPE' Column except this one scenario where we keep 'INTERCOMPANY' where there shows 'X' in 'COMPANY' Column. Similarly, how to write a filter formula where I can exclude everything that says 'ENDUSER' from 'CUSTOMER…
-
Make Appendix Cards smaller on Auto width Dashboards
I've noticed that dashboards tend to show the same number of Appendix cards per row regardless of whether the dashboard's display mode is set to Fixed width or Auto width. When dashboards are set to Auto width, the Appendix cards take up more space because of the additional space available, and in some cases are more…
-
Excel like calculations on dashboard data
One of the great things about excel is that you can quickly create ad hoc calculations on data or extend some analysis with addition calculations. When looking at dashboards, I often want to do ad hoc calculations using data points on one or more graphs as part of a deeper root cause analysis or data exploration. Today, I…
-
When will the new MSOffice Plugin be available for download directly from Domo?
I have a customer asking When will the new MS Office Plugin be available for download directly from Domo? So that their customers can get the plugin the standard way.
-
Time to Number value
I have tried to find a few answers on this but nothing has come up - is there a way to take a time column (00:02:01) and SUM ALL the values for the total Hours? I have tried SUM(HOUR('TALK TIME')) but that is not giving me the correct summarized number of hours. I also tried to do in the ETL but the column keeps coming up…
-
Partition BY, filling missing values
Hello, I have sales data and want to do some calculations on reference quote numbers assigned to those sales. Sales data have unique 'docnum' and there might be 5-15 rows assigned to the same 'docnum', depending on how much equipment is being ordered. If there is a quote behind an order, then 'Quoteref' will have the…
-
Function for renaming cards
A common Workflows use is governance related tasks, and a common governance related task is cleaning up old cards. I created a workflow that goes through, identifies cards that haven't been viewed in XX days, and then changes the title to indicate it's flagged for deletion. This is a common pattern of looping through…
-
How to make bar or column chart colors dynamic when changing dates?
I have this chart where I have several categories on x-axis so I'm finding a way around for the least cost to be blue and the highest cost as red whenever it changes dates and the rest say gray