Comments
-
YES! THANK YOU SO MUCH! This worked! You are my hero today!
-
Any suggestions? Please help!
-
Update: I removed the unified date filter and had it give me all time metrics - And the acceptance rate was correct. So it appears that I am back to square one, that when I filter for the current month, it is missing part of the data. I am filtering on the new unified date
-
That gave me a percentage - but an incorrect one. The Current numbers are 292 Accepted and 1954 Submitted which is 14.9% The calculation pulled 11.8%
-
Yes. And I formatted it to have like 8 decimals to see if there was any value - but there was none.
-
At this point the new counts are correct for both submitted and accepted. Now the problem is the acceptance rate calculation is not coming up properly. I have it as COUNT(CASE WHEN `Date Type` = 'Accepted' THEN `AcceptedDate` END) / COUNT(CASE WHEN `Date Type` = 'Submission' THEN `SubmissionDate` END) Its coming out to 0%
-
One more silly question. It wants me to add output data set in order to save But the SQL cant be blank in it. What do I need to put there
-
Oh I feel silly. Sorry - new to SQL in general. Its working! Now to do phase two!
-
I am getting an error. Will you please look?
-
OK thanks. I had not done that option before. I will try it now.
-
Thank you. So to confirm, the first bit of code is not a beastmode correct? Where would I put that code?
-
Im having this same issue. We have a form submitted Date and then an acceptance date. How did you get it to work with ETL its not making sense to me