-
Is this doable? Seeing percent of total day sales by hour using Timestamp column.
Hello! I have a problem that needs to be visualized and it was phrased to me like this: I need to see what percentage of sales each hour had for the total day last year then I need that percentage multiplied by the daily goal to get an hourly goal for today. So we have this chart right now: this show us net sales today,…
-
Group Sales Data by Hour by Day
Hi! I have a dataset that has a timestamp as the date column. I need to sum the sales by hour for each day. I need this done in Magic ETL so I can do another part of my problem before putting it into a card. Is there a way to do this? I have been playing with 'Group By' tile and 'Rank & Window' tile but can't seem to…
-
Custom Month Filter for building cards
Hello! I am currently building simple gauge cards that show sales for today, week, and month vs our goal for each of those. (see screenshot) Is there a way for the 'This Month' card to have a custom date range each month and have that automated so I don't have to change all the cards each month to a new date range? I work…
-
Changing Background color of a cell based on other cell
I have this beastmode formula going right now: CASE WHEN SUM(`Real Time`) <= `Today Goal` THEN concat('<div style="background-color:red; color:white; margin:-20px; padding:20px">',SUM(`Real Time`),'</div>') ELSE concat('<div style="background-color:green; color:white; margin:-20px; padding:20px">',SUM(`Real…
-
Putting Current day and Previous day as columns instead of rows
Hello! I have run into a problem just like this link: I followed the sql transform but once I ran it the output dataset was the same as the input dataset. I don't know what I am doing wrong, I even uploaded a file that is exact to the example in the link above. If someone can help me figure out why it seems like its not…
