Anyone run into an issue where they lose the abili...
# suiteanalytics
r
Anyone run into an issue where they lose the ability to export a single Analytics data set? Others still export fine, but no user can get this single one to export. It's not especially large (~10k lines) and larger ones export fine. No error message, just nothing happens. I've tried logging out and back in, clearing cache, all that good stuff, still nothing. Runs fine without errors, but just won't export. I'm guessing there may be some corruption or something? This is a fairly complex one, so I'd prefer to not have to rebuild it if I can help it.
In case anyone else runs into this, it seems that the problem was that I was using a TO_DATE formula without the format clause. Meaning my formula was TO_DATE('2022-06-09') and when the formula was written that way, the data set wouldn't export. Once I adjusted it to TO_DATE('2022-06-09','YYYY-MM-DD'), it worked as expected. Weird.🤷‍♂️