MattLynn Member

Thanks @rco, I had a feeling it wasn't supported. I like your idea, I'll give it a try. Basically, need to perform all the "window functions" explicitly. It'll blow up the dimensions for calculating but I have a feeling this will still be faster than running a scripting tile.

Where can we access the same dummy data and dashboards to play around? This video mentions it around the 6:15 mark but I don't see where I can get an instance myself.

@ST_-Superman-_ Yeah that is actually how I have it in another dashboard! It works great for that field, but the survey stats ones are fields of their own. I may end up transposing those into another dataset one day but it'll be duped across the other dimensions.

@ST_-Superman-_ Thanks for the detailed response! Your method is how I had it previously, but I wanted to opt for something more concise. I still have the percent changes in separate cards shown as single values which are about the cleanest I can get the dashboard to view without scrolling on most desktop/laptop devices.…

@jaeW_at_Onyx Good point, I'll mess around with that some more, thanks for pointing that out!

Thanks for the comments everyone! I'll need to revisit this next week since I've been pulled into different project. I like the suggestions given and will try it out in ETL. @GrantSmith I did use the zero out all blanks method but like you mentioned it isn't quite what I need since they should be filled with the formula…

Thanks, both of you! I didn't think to use a window function in the beast mode (I've had it activated for a while now, guess I forgot about it). @MarkSnodgrass Using your formula, backwards, does give me the numbers I'm looking for so thanks! The function breaks down when I add extra dimensions, for example depending on…

Yeah, that is the same conclusion I came to, unfortunately. I'm currently just grabbing the data from Vimeo directly.

I did send in a support ticket too. I did not know about the quickstart app but looking over it, I have gone through each of the datasets with and without the basic data param set to yes (was hoping the extra rows would pertain to videos watched on different days, but that wasn't the case. The data is already…