-
Make readily accessible a "Has Input" filter for Dataflows in the DataCenter
Currently, there is no readily accessible "Has Input" filter for Dataflows in the DataCenter. However, it can be created by viewing the "Overview" of a Dataset, and clicking on the "Dataflows Created" link — not the "Tidy Up This Dataset" link, though. Doing so creates a filter on dataflows shown in the Datacenter that is…
-
Sorting Day of Week on the X-Axis
Hello I'm working on a card where I want to represent the data by Day of Week, I've used the beastmode formula Dayname() to get myself the day of week of the date I require, however when I plot it with the days' names on the X-axis, I'm not sure how do I sort them so that it goes from Monday through Sunday.
-
Number of business days in the month
I am trying to write a beast mode that given a date can tell me the number of business days there are in that month. My company's hours are a little different so I want it to count days according to these rules: Sun: 0, Mon: 0.5, Tues-Fri: 1, Sat: 0.5 I can't seem to figure out how to loop through to do this calculation so…
-
Struggling to Find an overall percentage
Hi, new to domo and in particular beastmode, hoping someone can help. I have a KPI dashboard consisting of 30 plus customers and i want to find out the percentage of overall customers that meet or overachieve their KPI attainment each month. For example, if I have 10 customers and 5 meet or overachieve kpi then I'd like to…
-
Is there a way to add multiple scale markers to a graph?
My company has several different Branch's that each have different billing goals. I know that I can set up an upper and lower value, but we have at least 7 different branches. Currently we have a general total amount billed for the entire company but a looking to add a marker for each branch along with still having our…
-
Highlight Filter Functionality
Dear All I want to know wether DOMO has highlight filter feature ? When you choose spesific item via filter, rather than only showing the items that you are filtering and removing the other items not included in the filter, instead they keep all of the item, but highlight the item that you filter. PFA the screenshot.…
-
Read pfilters in DDX Brick
We have created APP in DOMO and we are using pfilters to load the dashboard as per filters passed like we are passing client id, date range. We had to create DDX Brick as we wanted some custom logic for one card so DOMO suggested to use DDX bricks. We have created a DDX Brick and added card in APP for this Brick.…
-
Changing the bar height and size for Spark Bar Charts
I have created spark bar charts as i wanted to indicate the percentage increase or decrease between two bar charts.However, The size of the bar is defaulted and is showing a huge variance between two bars with slight difference in the values Can someone please assist if i can change the size of bars or If I can show the…
-
Extra 0 bar in bar chart with beast mode
I have (using Beast mode )created 11categories in vertical bar graph card , but in the it shows up with extra '0" bar How can i delete this extra 0 bar?
-
Can someone help me with this Beast Mode using CASE Statement using FIXED(BY) Formula?
I am trying to create a beast mode that looks at different criteria to only sum certain data. I have tried multiple ways to write this, but I cannot get it to work the way I want it to. If I write it this way, the formula works however it only displays the data from the else portion and ignores the other criteria. CASE…
-
Tagging Non-existent Data as Expired
Hi All, I'm working on identifying and tagging orders that already expired given a particular period. Our dataset captures data from active orders based on contract end dates. What I am having issues on is being able to tag the orders as expired because those are no longer being captured by the dataset. Any thoughts?…
-
Automatic Upload of Local Computer Files
Is there a way for DOMO to automatically upload a file from your computer? I have a file that automatically gets added to my computer files every day, but I have to manually upload that file to DOMO daily in order to get the data into DOMO. Is there a way to allow DOMO to upload this file automatically from my computer…
-
Google Sheet Authentication Issue
I am running into an issue with Google sheets connecting after many years of no problems. Does anyone have any suggestions how to fix this? I tried on Firefox with same result. This app is blocked This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access.
-
Google (sheets) connect - This app is blocked
I'm receiving the following error when trying to connect Domo to Google Sheets: This app is blockedThis app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. I read only this has to be fixed by the developer as it doesn't meet Google's security standards. Is this…
-
Has anyone been able to pull historic data by day from the Meta connector?
We have a new data client that needs historic data pulled in and the connector doesn't have the data at an individual date granularity only by ad type.
-
NetSuite Connector Setup
Hi, I am trying to get the NetSuite connector setup with domo. I am wondering if I should use the standard NetSuite Connector or the NetSuite App TBA Connector. I learned that you can't connect an admin account because of the issue with 2FA but I am also wondering where I would find the below information. There are a lot…
-
How to compare to the entire dataset, and not just the filtered part of the card?
Hi, so I have a beast mode calculation in one of my datasets that looks like this: CASE WHEN SUM(SUM(1)) OVER (PARTITION BY TRACK: Title,LIBRARY: Name,TRACK: Version) > 1 and TRACK: Version = 'Full Mix' THEN 'YES' WHEN TRACK: Version <> 'Full Mix' THEN null else 'NO' end The purpose is to make sure that there aren't…
-
HTML Table Conditional Row Formatting
I have implemented some conditional formatting using this code in an HTML table: $(myTable).DataTable({ data: reorderedData, lengthMenu: itemsPerPageOptions, columns: colNames, createdRow: function(row, data, dataIndex) { var daysOld = data[0]; // Correctly reference the first column if (daysOld == 1) {…
-
Setting to place labels inside Donut Chart (and perhaps repair some spacing issues)
This looks silly, and there's definitely room to bring those labels to 'center': This looks even worse, and the labels interfere with the hover labels: This looks less silly, but doesn't have the nice interaction, showing the hover labels inside the circle: Also, notice how much nicer the spacing is with the pie chart,…
-
Dashboard - Overview/Favorites - Ability to add card directly to Collection
Currently, a user has to go through multiple steps to add a card to a Collection within Favorites or Overview. Instead, allow the user to select from existing collections or create and add to a new collection when adding a card to Overview or Favorites.
-
Drill to an existing card
Every time a user wants to add a drill path, they have to create a whole new card. If there was an option to select an existing card to drill to, it would make a HUGE difference! I am currently working on a page where most of the cards need to drill to similar detail. I have created a complicated solution with beast modes…
-
How to change app width in App Studio?
It seems like you can only change app width with 2 options: Fixed width or Auto Width. But both are still too wide for my App. I'd like to make the width smaller by entering a specific px for the width. Is there a way a can do that in DOMO?
-
Save ETL With Error
I want to be able to save my ETLs regardless of what state they are currently in. I am frequently in a situation where I can't resolve an issue in the moment but want to save the ETL so my other changes don't get lost in the meantime.
-
AutoFit Dashboard Screen - as per System Screen Resolution
We are facing difficulties in many dashboards as it is not adjusting as per System's screen resolution. Many times we need to adjust it manually from browser settings.
-
Map with GeoJSON coordinates
Hi - I have an CSV file with columns for identifying data (name, type, etc.) and then a column for GeoJSON polygon territory. Is there a way to put this into a visualization in DOMO?
-
One SKU has multiple mail date and trying to filter out all skus that have date greater than today
Hi, I am running into a problem with my visual I want to filter out any SKUs with a future mail date but since each SKU has multiple mail dates it is not recognizing the future ones it is going off the first mail date it sees. For example, the calculated field I have created is this "CASE WHEN MailDate > CURRENT_DATE()…
-
DOMO Workbench Log History Setting
Hi, My company uses DOMO Workbench to run several jobs, and I noticed that the logs for each job are stored on the local disk. However, I haven’t been able to find a setting that allows me to configure how long these logs are kept. Ideally, I’d like to set a retention period to only keep logs for the last 5 or 10 days. Is…
-
Delimiter issue
Hello Team, I am trying to do a ETL in domo but unable to get desired result please suggest. In my input, i have a few columns, the lowest grain in Employee id, I have a column called Value, In this values are given using delimiter "|". In my below example there are 2 instances on "|" but in my data it can come any no. of…
-
Is it possible to fill in missing dates at the card level | Fill Missing Dates button isn't working
I read the article linked above… Is there a way to do this sort of thing at the card level? The Fill Missing Dates option is not working. I'm having an issue with it dropping dates that have no corresponding values on almost all of my bar charts. My dates are all weekly and there's weeks with no data on every card. I don't…
-
How can I get the company names on a pivot table to show up on one line? One company is not.
I am using a pivot table to collect daily data on a sales funnel. I want to see what is in a particular stage of the funnel on a daily basis. I have one company that is showing up on two different lines, but the rest of the companies are on one line. The name is spelled correctly, so I don't understand the issue. Any ideas?