I am fairly new to DOMO and below are couple of issues while working.
1. I was working on getting the Week number from Date Timestamp column. I could see that Date formula and Date function in ETL are considering date Timestamp from 4 AM.
For Eg :- Week 45 is from 12 AM of 1st Nov 2020 through 12 AM of 7th Nov 2020 but DOMO calculates Week 45 from 4 1st Nov 2020 4 AM through 8th Nov 2020 4 AM.
2. I am using DOMO workbench and pushing Excel file in DOMO server. For one of my column, DOMO is reading half of the cells as empty or null even if the cells has data.
Could you please assist me on this.
Thanks in advance!