- Last Active
- Member, Domosapien
@seeitall00: I agree with the other answers here. Hopefully you find @btm's example helpful. But since @DaniBoy mentioned me, I also wanted to provide this direct answer to your additional request for clarification "Is there a feature in Domo similar to Tableau's level of detail expressions (LOD)" Yes, we accomplish data…
@josh-m: Great question, Josh! Here's a related post that answers your question: https://dojo.domo.com/t5/Card-Building/Domo-Online-forms-adding-columns-to-an-existing-webform/m-p/6387#M328 The short answer is no, there isn't currently an easier way. You should be able to copy and paste your data from one web form to the…
There isn't a Magic ETL transform action to simply add a new column. The Combine Columns is one of the shortcuts. You can also do an Add Constants step followed by a Set Column Value step depending on what you're trying to achieve. Adding a column would be a helpful tool. I'm not sure if there is an idea in the Ideas…
@bstephens: I was able to create a Magic ETL dataflow that joins on any compatible column from two different datasets. See the screenshot below which joins on Name column and Id column and outputs the dataset seen below. I believe that is possible. Maybe could you clarify what you're trying to do if this doesn't answer…
@iQuanti: Can you clarify what you're trying to do with the data? Right now it looks like the data has one row per day per product, and you're looking to get it to have one row per product that shows the current and previous day level as well as the percent change between current and previous day. Is that correct?