Sandis Member

Interesting @GrantSmith Can fusion be pulled then in another fusion? 

Thank you @GrantSmith and @jaeW_at_Onyx It never was a problem but seems just recently started to happen. I don't want to add an extra tool as we're pulling from MariaDB, I'm thinking perhaps I need to split up this in 2 tables - 1 that loads everything that's older than 1 week and load it say 1x per day; and then download…

Hi @jaeW_at_Onyx I was testing it in the beast mode. I am surprised as I'd assume it would use the account settings for this?

As I cannot edit, adding a note, I was able it to save as "Saved Report", my bad in the previous post.

Thanks for the straight answer, will need to do calculations in SQL then, just worried the maintenance will grow into a big tripping area. 

Thank you for sharing the video, but it is not quite what I had in mind. I was looking for a way to read data from the actual selection in the card filters. So any user can select any period and based on that, it spits out the new adjusted numbers.

Thanks, the SQL storage was the thing that solved the problem. I was able to manually run the queries to pick up previous days and now 1x per day it will add the previous day's stats. I then run a simple ETL to de-dupe any data just in case. Sometimes the best solutions are the simplest ones ?

Thank you both - turned out that default instruction in the end was the correct way to go, just the data manipulations didn't seem to make sense, but now that it works, it makes a lot more sense. Thank you all!

Hi @MarkSnodgrass I'm very new to this so I wouldn't know much about Workbench. However, I have set up MariaDB Connector with a query and it pulls in yesterday's data and it updates 1x per day pulling previous day. So far so good. So what I cannot figure out is what to do next as this is the source DataSet but how do I…

Thank you for sharing this with me, I was going crazy by not being able to figure out how to go beyond the provided data views! Muchas gracias! 

Hi Jae, thanks for replying to my thread. Love the fact you have built YouTube videos! Cool hacks on that Profit/Loss video! You just doubled that video likes ?