-
Domo Global Data Lineage
I am looking to get a sense of the data lineage for all of our datasets/dataflows in an attempt to consolidate and properly organize. Is there a way get this in list form so I do not have to use the data lineage function in each dataflow individually?
-
Workbench Job Types (Workbench Excel v. Excel)
With the new Workbench all of our Excel job types are now named "Workbench Excel" and all of our jobs created previously are named "Excel". Is there any difference in how these function? Would it be beneficial from a perfomance standpoint to delete the old "Excel" jobs and recreate them as the new "Workbench Excel"?
-
Result of Date functions do not align in Transform
I am getting the wrong date listed when I use CURRENT_DATE() in a transform and it is a causing my data to display incorrectly. Why does it show the date at Dec 7 when it was actually Dec 6 as the NOW() function shows? How do I fix this?
-
Daylight Savings Fixed in Dataflow - Wrong when used in Card
I have a daylight savings issue where my "tranendtimes" are correct in the dataflow, however, when I use the field in a card it is off by an hour due to daylight savings time. What is the workaround for this?
-
Adjusting "Tomorrow's" date if tomorrow is a holiday
I have a dataset we can call 'jobs' which has one row for each job on our calendar. Row has a column that says if the job is occuring on a holiday or not. I want to filter on the individual card levels based on if there is a holiday tomorrow, 2 days from now, 3 days from now, etc. Job # | JobDate | Holiday 1 | 9/3/18 |…
-
Visualizing Tasks Done per Work Hour
Hey Dojo! I am having a hard time creating a dataset to allow me to visualize tasks done per work hour by an employee. The problem is I have two datasets to start with (tasks and daily schedule) which only have a single commonality being date. The tasks dataset creates a new row for each task done in our system which could…
-
Selecting from multiple tables based on conditions
I have the following code where I am pulling all data from one table, a. Then counting a column from a different table as a new column. However, I am getting a syntax error message. Can someone point me in the right direction? select a.* ,(Select count(DISTINCT b.Employee) as `Number of Distro` from `transform_data_9` b…
-
Error in dataflow transform
I am looking to store a couple values in variables, to avoid clutter, of my MYSQL transform and am running into problems. How can I set variables in a transform and then use later in that transform? Here is what I have currently and then I call these variables later in the transform... -- Variables of actions taking place.…
-
Suming Invoice Amount with Specific Criteria
I have a table with data that looks like the sample data below. I would like to be able to sum the total invoice amount on a per job # level and be able to attribute it to the Firm designated as the "Original" for that job #. As an example the Sum of invoices for job #1 would be 200 and it would be attributed to "Test Firm…
