-
Displaying How far ahead or behind goals as weeks progress
I have an etl that is joining a google sheet that has weekly goals, to a dataset that have the actual weekly sales. I am currently showing the week by week results in a grouped bar card… each week side by side, actuals to goals. (see image) Is there a way with the data I have, to show how far ahead or behind we are up to…
-
Refresh dataset
I am trying to refresh my dataset (google sheet), And i do not see a drag and drop file in the details section of settings. I am not sure how else to do it, and my data preview is not showing the new data I have in my sheet
-
Goggle Sheets - Can a single cell be accessed and used?
I have a google sheet of goals that has a calculated cell that sums all in the column. Is there a way to access this number and use it? I have another dataset that gives me actual sales, and I want to use a filled gauge that shows actual to Goal. thanks, Brian
-
Dynamic Weekly goals
We have 2 tables: OrderDetail - which stores order info like date, sku, quantity, price, ect SalesGoals - DateWeekStart, DateWeekEnd, SkuQuantityGoal, etc Is there a way we can do a visualization that dynamically shows the weekly sales against weekly Goals? I am new to this, so I am not sure the best way to set up the sql…
