-
Set the default value of date type Variable to current date or today's date
A date type variable needs to have a functionality where the default value can be set to today's date
-
Display Range on Multi-Value
Currently, the multi-value gauge can be used to compare two values & display the %change. It will be beneficial if we can add a way to show a range of values like min & max on the multi-values gauge The only way to do this currently is to use a text box & use the concat function on two different values.
-
Expanding Beast Mode to formula
With the new nested beast mode feature, we can use an existing beast mode in another beast mode. But sometimes it is helpful to see the formula of the old beast mode, and not just the name. Adding an option to expand a beast mode field back to the formula by double-clicking the name could be useful in some cases, and can…
-
Can we set the default value of date type Variable to current date or today's date?
Hi all, I created a date-type variable and I wanted the default value of that variable to be currdate() or today's date. Is there a way to get this done?
-
Multiple instances of same week numbers
My dataset has a date field that has 2022 running data on it. When I'm trying to create a line chart using that date range, it is repeating those weeks. I want to have only one instance of that week. How to resolve this? In the attached ss, you can see Week-6 getting repeated 3 times. I only want to see that week or any…
-
How to remove columns with Null values?
Hi all, I have a dataset with 100+ columns. There are many columns with null values. I would like to remove all those columns without manually selecting those columns using the Select Columns tile on Magic ETL. Is there a way to do this?
-
How to remove empty columns from a dataset?
I am using a DOMO connector to import Salesforce data. The imported data has 30+ columns with no value. Can a query be written to remove all the columns with no values? I know I can write a script using Python/R but we don't have a scripting tile in our package.