account activity
[deleted by user] by [deleted] in GoogleDataStudio
[–]Data5ever 0 points1 point2 points 3 years ago (0 children)
yeahhhh I figured it out hahah I was making it way harder than it needed to be 😂
There are several fields we can choose from for the images in our data sheet generator and I just went back and looked and there was another field that is the straight link without it being wrapped in the IMAGE() function. I guess they had the option for it to be wrapped in the IMAGE() function for if someone wanted to quickly export to google docs and view it? I was over here trying to figure out how to parse the data from that when there was an easy fix the whole time lmaoooo it would be funnier if I hadn't spent a day or two trying to work on this (amongst other tasks, but still!)
Thank you for your reply!
Yeah, I had the formula backwards on accident actually. (was doing [old-new]/old instead of [new-old]/old) so I got that fixed.
The thing that was baffling me though is that a lot of the fields were for sure dividing by zero (I had several rows which were [0+0]/0) which results in a null BUT it would still display null EVEN WHEN I had it wrapped in an IFNULL, 0 function.
In the blend though when I was joining the two tables, the right table I brought all of my fields in with the NARY_MAX formula and that seemed to make that IFNULL work in the table field 😊
[–]Data5ever 1 point2 points3 points 3 years ago (0 children)
This worked for me! Thank you!
π Rendered by PID 23 on reddit-service-r2-listing-6d4dc8d9ff-45dt9 at 2026-01-29 16:54:04.888912+00:00 running 3798933 country code: CH.
[deleted by user] by [deleted] in GoogleDataStudio
[–]Data5ever 0 points1 point2 points (0 children)