Automatically update the column value by current month and year in Magic ETL
hi guys, I got a table on below and some columns using month/year as column name. i would like to make an automatically Magic ETL and set a logic condition like below: if the date(column name) < current month and year (let say 08/2022) then all value would be clear as 0 value under the column (01/2022, 02/2022,…
calculate percentage difference between 2 values which is in a column
hi all, i am new to domo and would like to seek your kindly advise regarding on my question. i make a ETL and the structure is like below. and next step i make a pivot table and segregate the "monthly_balance" by "source" (actual and budget) the next step is i want to calculate the "monthly_balance" percentage difference…
Created rounding function to show number in pivot table card
It seems in Domo - Pivot table there is no function to change the column value(number) rounding. e.g.: value under column 20,580,307 ===> display as 20,580k or 21M please vote it!!!