I have a table with some cells that are blank. I would like a zero to populate in the cell instead of them being blank. Is there a simple SQL formula someone could share with me to change the blank cell to a 0 number?
I am trying to have a pivot table that shows weekly plans vs actuals. Is there a way to add a top layer of that to group the value columns into the top three pillars? Supply, demand, revenue. Thanks
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…
Hi Team, I am trying to create a MySQL Data Flow using below SQL Transform which will have a UPDATE statement. Some How it is not updating the Column in the output table which I want to update. Can you please check what am I missing ? ====================================== CREATE Procedure GetAllDates() BEGIN DECLARE l_cnt…
I have a series of tests that run to determine a pass or fail. All the formulas work but this one is giving me problems - CASE WHEN Critical/Major= 'Common' AND No>= 2 AND Critical/Major= 'Major' AND No>= 1 THEN 'Fail' Any one know why this would not be returning a Fail?
I have a dataset that updates via email connecotr. When the data is sent to the connector the dates turn into integers. Is there a way to fix this? Thanks
Hello, I have an ask where I need to split lines when there are multiple Users working at the same time in order to accurately count how many users are working together during a certain interval. If I have 3 users working each one during different periods I want to split the Initial rows as per below picture. If I am able…
Can Domo's mysql handle more than 500k records? It shows the import can only go to 500k but I'm assuming that is for previewing data not actual processing. I attempted to output only five rows from a million record dataset and it ran for 30 minutes before I cancelled the process.
Hi, A client has asked if we will be updating to MySQL v8 soon as we currently only support MySQL version 5.6.37? Thanks!
Hi I am trying to use a case statement with a When and Then clause inside it. The formula I am putting in is basic and has worked for other tables but not working for the one I am currently working with. I have tried these formulas: 1. CASE `SeasonalDescription` WHEN 'Easter' THEN 'Spring and Summer' ELSE 'Other' END 2.…
It looks like you're new here. Sign in or register to get started.