DANIH Member

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'm trying both of those options. So would I then do a group by tile to group by sales with the new timestamp column?

Well that's the thing I'm trying to figure out. I know what all the months are from beginning to end so how would I use that is a beat mode? Then how does that filter the data automatically?

@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…