Discussions
-
Fix ROUND() in ETL
It was noticed that ROUND() function rounds down in ETL when the last decimal is 5. It acts correctly in the card's beast mode.
-
Can I dynamically group data to two periods (Current 12 month and Prior 12 months) ?
Can I dynamically group data to two periods (Current 12 month and Prior 12 months) using window function so I can select time periods to compare. Client wants to be able to select months in the past and compare rolling 12 month as of the last date select date. I tried this formula for Current period, but it doesn't…