Comments
-
Apologize for the confusion. I was referring to Domo’s native library. I captured this in the DOMO appstore: https://amro-asia-org.domo.com/appstore/details/2FF0546ED3BE62B56BAA98A96188FEF2755B4A37C77A4077B7170B5CACC04904?origin=search
-
Thank you very much, Arbor. Apologize first for this following basic question, but do you know how to do it using the Phoenix brick template?
-
Hi GrantSmith, thank you for getting back so quickly. The format is very … numeric. They are just pure number, such as 4, 1116, 846984. It ranges from 4 to 846984. I also guess that somehow the function thought they are Date Number …. Let me try this TO_UNIXTIME
-
Hi GrantSmith, thank you for your suggestion. So I am still not sure why my data is catagorized as Date; but I have tried to convert back to numeric using Magic ETL. However, somehow the ETL returned an error suggesting that the date format cannot be converted to numeric. Do you have any suggestions for investigate? Thanks!