-
Re: Display a zero value
You would need to create the zero entry in an ETL. You could do this with a join tile so that every location has a row for each type of value you want to report on.1 -
Re: Date formatting in ETL
You should be able to use the CONCAT to add a day on the end, such as 1 and then convert it to a date. Like this: DATE(CONCAT(datefield,'-01'))1 -
Re: Concat Formatting
you can add a TRIM() function around the entire concat function and that will remove trailing spaces. You can also do it around each field, which may help.2 -
Re: how do you add the remarks in DOMO beastmode?
You can also use this: /* my multi-line comments go here */2 -
Re: Counting nulls/blank cells in beast mode
If your value isn't null but empty or blank, you might need to consider a different option. Another option would be check the length of the value of the field and also use the sum operation. Lik…1

