Hello, I have a sales pivot table that I want to highlight when sales are decreasing. Is there a way to highlight a cell if it is less than the previous cell (basically if cells are decreasing month t…
I created a dataset with the following SQL query 6/1/24, and on 8/8/24 I began getting the following error: The dataset is currently locked and cannot be executed right now. The likely cause is the Jo…
Grateful for any guidance. I'm seeing the syntax error below and I can't figure out why. New to MySQL Transforms as my previously relied upon python scripts are to be deprecated. Objective To take a s…
I have created a job in the Domo workbench with the following SQL query, but in my resulting dataset, "Transaction_Date" and "Transaction_Time" are not splitting into two columns, one with just the da…
There are multiple lines (column titled: PO Number, one on each line) for a given item number in my data. I want to combine all of the results for PO Number so they appear on one line, separated by a …
I want to convert a char value to number using TO_NUMBER function in Adrenaline Dataflow. The KB is given as below. What is the string pattern to be provided in the function to avoid decimals ? TO_NUM…
I have a really quick simple question I am using the field "item Number" but I need to omit any Item Numbers that contain the characters "A, B, C, P" I tried using the filter tool on the analyzer and …
Hi I am trying to get the first letter in the product number field. I have created a test field to remove any extra white spaces the product number field would come with and here is the calculation: T…
My first post so apologies if I have dropped this in the wrong forum. I have a slightly more complex dataflow than Magic ETL will handle and I am hoping I can manage this with SQL, however my SQL is a…
I have a dashboard which has filters by semester term and college. There is a column for type of housing and a metric in the dashboard. The metric should display upon the filter on college as a whole …
