Comments
-
HI @GrantSmith , Rank-Window functions dont work like the MULTI-ROW function works. Let me give you an example, we have following rows, Here we want value = value(row-1)+1 where row= row-1 else value(row-1) - 0.1 This should bring incremental values in MULTI-ROW but doesnt in our rank-window or windowed function. Expected…
-
Would it work if you set password expiration from 365 days to 1 days. that way all users would need to reset their passwords and log back in?
-
Domo has been Gandalf to us Enthusiastic, Curious and Passionate Data Analyst and Scientists who have embarked on the journey of solving real world problems using data analytics. I wish this fellowship of {Awesome interface, Great ETL Features, Wide range of connectors, World class support structure, Amalgamation of…
-
Use following formula: CONCAT(FLOOR((round((sum((`hours worked`))),2)*60)/60),' h ', round(MOD((round((sum((`hours worked`))),2)*60),60),2),' m') where `hours worked` is a column containing values like 1.77 hours. Here we are converting these decimal hours into minutes and then getting output in form of 'X h Y m'. You may…