Basically the title. I am using a dataset that pulls Month of the Year instead of Date, as the User count with the Date metric isn't accurate. However I have run into issues trying to convert Month of the Year into a date format. Here is the original format:
As you can see, each month is numbered from 1-12. I used Value Mapper to convert the numbers to more of a date format, see here:
I thought from there I should be able to convert the integer strings to a Date. However I am having difficulties with that part. I'm not sure if I'm using the wrong formulas in the Formula tile. I tried DATE_FORMAT(Month of the year
, '%M %d, %Y') but it didn't work in Magic ETL, though it did in Beast Mode. The Date Operations tile wasn't working for me either. Would really appreciate some guidance on this.