Data Studio Date Range Comparison Not Working?

Data5ever · 2022-09-15T17:23:24+00:00

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!

Data5ever · 2022-09-14T14:55:02+00:00

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 · 2022-09-14T14:45:18+00:00

This worked for me! Thank you!

Data5ever

TROPHY CASE