-
Help in Pivot
Hello, Requesting help on how to resolve this and appreciate your assistance. My data in the table has Year, Quarter and all the measures. But user is requesting the report to be in the below format. Measures/Metrics on he left side while Timeframe on the top as columns. I am unable to do this in Pivot table view in the…
-
Question on acceptance rate calc
Hello, I am trying to calculate total accpetance rate of the students. I have 2 calculated fields Accepted Students: case when (acceptance_flag = 1) then count(students) Total Students: count(students) I am having a table format and calculation for acceptance rate: (case when (acceptance_flag = 1) then count(students)…
-
Dataflow failed
Hello all, I get the below error after running my dataflow. As this consists for multiple inputs, I haven't still been able to trace the exact field causing it. But I do have a formula tile with this calculation.. " Failed to convert value '-3--3-01' from type 'String' to type 'Date'. " Some days this data flow runs…
-
Append Output dataset help
Hello all, I have an Magic ETL (A) that with a output dataset - say OUTPUT_1. What I am looking for, is when every time I run the ETL, I need the output results to be appended. At the same time it should not create duplicate records. I created a new Magic ETL (B) with this OUTPUT_1 as input dataset and outputted to…
-
Question on Domo SQL syntax
Hello all, I am trying to do Magic Transform using SQL option. I have embedded a SQL query but it is erring as it is not compatible with Domo syntax. Appreciate your help in this regard. DATE_PART('WEEK',CAST(TO_CHAR(TO_DATE(TO_CHAR(PRODUCT_KEY),'YYYYMMDD'),'YYYY-MM-DD') AS DATE)) AS "SaleWeek",…
-
Aggregate and ETL question
Hello all, I have the below workflow in my Magic ETL. Just posting a sample version below. My question is - I have a ProductID that I join from both the data sources and then do a group by and output to a file. But I also need to know Total count of Product ID or row count from TEST spreadsheet source. Is there a way I…
-
Date format question
Hello all, I have a snowflake i/p data source. One of a column is a date field and it showing up as floating decimal in Domo. This field has value -3 (even in data source) if it is a null else it is a date.. As this is floating decimal type in domo, under configuration I changed to Date type. When I try to join with…
-
Multi-tab input
Hello, I have a input data set that is a multi-tab spreadsheet. I used File upload option to import that to Domo. When I am using this in Magic-ETL, I am unable to specify the tab that I need.. What is the way to specify the exact tab I referring to in that spreadsheet. I need to use different tabs for different joins in…
-
Number format
Hello all, I am trying to replace the Number format in Card/Dashboard. For example: Number is displayed as 21K but I need it to be full number with comma separator. Or 1.19K should be displayed as full number instead of 1191? I tried all ways but it does not seem to change the format. Can someone help me with this?
-
Restricting Dataflows
I am admin for my instance.. I have shared input datasets to a specific group with a role. But I notice that they automatically get all my dataflows access that include those above shared datasets and they are able to edit the dataflow as well. Is there a option to restrict the access of dataflows (ETLs) though those…
