For modules building, it would be helpful to have a ENDOFQUARTER formula to identify the end of quarter date of a date.
You could do 3 line items (Date, Period, End Date) line item—-Format—————————Formula. Date.———-Date. —————————-Start() ← Should already be in the model Period ——-Time Period (quarter)—- period(Date.) ← Would probably already be in the model End Date —-Date —————————-"end(period)" but I agree it would be quicker with one command
@MarionCarrie,
ENDOFQUARTER(Date) = IF MONTH(Date) <= 3 THEN DATE(YEAR(Date), 3, 31) ELSEIF MONTH(Date) <= 6 THEN DATE(YEAR(Date), 6, 30) ELSEIF MONTH(Date) <= 9 THEN DATE(YEAR(Date), 9, 30) ELSE DATE(YEAR(Date), 12, 31)
This formula checks the month of the given date and returns the end of the corresponding quarter.
THANK YOU SO MUCH !
I would like the ability to wrap text in list member name or display name, especially when its pivoted into rows. On my views, I pivot multiple dimensions into my rows. I would like to keep the "row columns" small, since they aren't a huge value add. The problem here is that the list name gets cut off. There is so much…
The open and close cards from the insights panel is great functionality. My ask is the ability to have more cards expanded. For example, I would want the main grid, and 2+ secondary grids expanded at once. This impacts all end-users.
There should be more resizing options in the UX. It would be nice if Page Builders could control the default, and end-users can dynamically adjust. Idea 1 The ability to resize the grids/graphs/sections on the fly. I imagine this similar to when a second card is expanded on a worksheet, the user gets the ability to change…
