- Last Active
Here is something I just made up. I have a timestamp column with todays net sales for example it only goes through hour to date. Then I have last years net sales. There is a goal column so if we can figure out what each hour percent total for the whole day was for last year then times that by the goal for today for each…
I did these in beast mode and it worked but its basically what I had before. I need to be able to take the percentage that each hour had Last year for the total day and times that by today goal column. What's the next step for that? @GrantSmith
Would these be in my beast mode or formula tile in etl? @GrantSmith
@GrantSmith I just tried it with HTML and yes the background is now working but the font color is still blue is there anyway to change that to something like black in my formula?
@GrantSmith 1st transform: SELECT `Date` ,SUM(`Sales`) As 'Sales' ,`Product` FROM `domo_test_csv` GROUP BY `Date`, `Product` 2nd Transform: SELECT a.`Date` ,a.`Sales` AS 'Current_Day' ,b.`Sales` As 'Previous_Day' ,a.`Product` FROM `domo_test_csv` a LEFT JOIN `domo_test_csv` b ON a.`Date` = DATE_ADD(b.`Date`, INTERVAL 1…