-
Sharepoint lookup id field
I'm hoping someone in the community has done this before. I'm using the Microsoft Sharepoint Online Rest Connector with the List Items report to pull a list of files and their metadata from a document library. One of the fields is set up as a "People and Groups" lookup field in sharepoint, and in the Domo Dataset, I'm just…
-
Historic Timesheet Analysis
I'm working on an analysis of our historic timesheet data and trying to calculate our employee utilization (actual hours per day/8), so that we have a historic benchmark and can compare to projections for future utilization. The challenge I'm running into is actually cleaning the data. It's generally well-structured - in…
-
Calculating percent of total with values that count in multiple categories
I'm trying to develop a card for diverse business participation reporting. A single business may have multiple diversity classifications, and can be counted towards each. However, when we are looking at the total, we are looking at the total of distinct businesses. Example data: I want the card to have flexibility to…
-
Creating an "unassigned" row for gantt chart visualization
I'm working on a gantt chart visualization for resource assignments, and trying to add an "unassigned" bar to the chart for any time periods when a resource is not assigned to a project. My dataset is generally structured as resource name, assignment name, start date, end date: I've pulled in the domo dimensions calendar…
-
Dynamic Goals by employee title
I'm trying to set up a card to show employee performance against a corporate goal that is variable based on the employee title. Certain employees need to submit a report, and the # of reports they have to submit is either a certain number per day, per week, or per site visit, depending on their title. I have one dataset…
-
Governance - partial activity log
I've brought the DomoStats datasets into our instance and have seen that they are quite sizeable (the activity log dataset is currently taking up 40% of our row space). Is there a way to limit the number of rows this connector brings in? I'd like to keep the activity log info, but I really only need the past few months,…
-
Tag Manager
It would be really helpful to have a tag manager (similar in concept to the beast mode manager) where you could see all the tags used in your instance and what they are used on (Dataset, dataflow, dataset column). This would allow for easier updates and deduplication (i.e. ensuring all tags are PROD instead of prod, PROD,…
-
Microsoft SharePoint Online Rest Connector - Download all files in a folder
I've gotten the Microsoft SharePoint Online Rest Connector connected in our Domo instance and have been succesful pulling in individual file contents using the "Download Item Contents" report option. However, we have a sharepoint folder where users will drop multiple files, and I need to bring the contents of all of these…
-
Add monthly options to dataset/dataflow controls
I have several data flows that only need to update on either the last of the month or first of the month, but these are not available options in the settings of the dataflow. It would be extremely helpful to have a monthly option to define what months to run and what day of the month to run (i.e. first day, last day, first…
-
Value mapper tile - allow multiple columns in single tile
The value mapper tile should allow you to create rules for multiple columns - ideally a matrix of rules like column A - rule 1 and column b - rule 2, but should at least let you apply the same rule to multiple columns. An example of this is replacing null strings in all columns with 0 - similar to the pandas function…
-
Settings for Magic ETL - only owner & admins can edit this Dataflow
I just saw that the redshift and mySQL dataflows have an option under settings for "Only the owner and administrators can edit this DataFlow". This should also be available in Magic ETL 2.0