-
Alert Error on Dataset
Hey all, some of the alerts we set up are getting this error: 2 or more rows have duplicate values in columns designated to track unique rows We have unique row values but they keep breaking giving the above error. Any suggestions how to fix this? Thanks!
-
% Change Question
Hey all, I have a questions. I would like to be able to show day over day, week over week (different table cards) and highlight a 10% increase and 10% decrease in values. Is there a way to do that. Ideally I would like to just highlight with a color that field that holds the value. attached is an example of what I want to…
-
Variance Calculation Question
Hey All, I'm trying to calculate variance on some usage data with multiple calculations. I need to be able to calculate the average of the 5 prior same days of the week. For example for the date of 8/16 to find the variance I would need to compare the average of 8/9,8/2,/7/26,7/19,/7/12. I also need to pull in average and…
-
Tableau formula Conversion to domo question
Hey all, I am trying to create a formulas in my ETL but keeps giving a syntex error. I'm trying to translate this tableau formula: if ([Prior 5 Days Avg]) > 0 and sum([Current Day]) > 0 Then (sum([Current Day]) - ([Prior 5 Days Avg]))/([Prior 5 Days Avg]) elseif sum([Current Day]) = 0 then -.99 else .99 end Into a DOMO…
-
Beast Mode windows function
Hey there I am trying to do a 5 day rolling change in value based on usage. I want to show previous five days compaired to the newest date. I have tried this beast mode: ((Lag (`QUANTITY`,5) OVER (Order BY `TimeStamp(use)`) +Lag(`QUANTITY`,6) OVER (Order BY `TimeStamp(use)`) +Lag(`QUANTITY`,7) OVER (Order BY…
-
Create Data that does not exist
Hey all, I am working with some usage data for some of our products. What I am trying to do is be able to flag if there is zero usage on a account. our daily files only include usage but not if there is no usage. I have contract End dates that I can use to say something like if contract is active with no usage pull that…