Engineer_0 Member

@ST_Superman - I'm using YEARWEEK() in MagicETL and BeastMode to identify the previous week (Sunday-Saturday). The function in MagicETL works as expected; it allows the YearWeek value to cross over the year. However, the BeastMode version does not work correctly, counting more weeks than it should in 2024. I've submitted…

I've also had issues the YEARWEEK() function not working as it should in BeastModes. However, it is worth noting that the same function (name, anyway) works perfectly, as expected in MagicETL. I've opened a support ticket (case: 05895315) about this. MagicETL leverages native MySQL, which is why YEARWEEK() works as it…

I understand Collections are unique to the user, but I'm curious how that changes anything. The goal is to keep cards organized for the user in these sections.

@DataMaven My apologies; I meant to save this as a draft earlier, but it should be ready now. The request concerns the Collections underneath these sections that we've set up to keep reports organized.

ORDER BY inside GROUP_CONCAT() should be supported everywhere GROUP_CONCAT could appear. I mention that because it should be allowed in the Group By tile, but it should be supported in the SQL Tile as well, which is in Beta right now, but neither tile allows this currently. Since SQL Tile is in Beta, maybe it makes sense…