-
How can I get the count of days for every month using Formulate (Custom column)?
I need to get the count of days in each month using the custom column option in a formula or any other ways in Discover. Does anyone have a solution for this?
- Answered
-
Data Model - summarize column, unique row
Hello, I am running into a problem when developing my data model. I have two rows of data: ID AMT CREDITS COUNT_REG UID1 24775 18.00 1.00 UID1 -1286 18.00 1.…
- Answered
-
Case Statement in model
Hello! Wondering if someone could help me with a case statement that i have been unsuccessful with and have tried it many ways... Any help would be greatly appreciated.…
- Answered
-
PQL Dynamic text formatting
Hi, I'm trying to write a PQL for dynamic text, so that when the data value selected in my matrix is equal to or greater than 0 it's formatted as Green.…
- Answered
-
Creating "1st Month of the Year of the Previous Month" in a list
I have the following as a Range List which is the *First Month of Current Year* until previous month I want to change the start of the list to be the first month of the previous year instead.…
- Answered
-
Is there any way to count filtered rows in formulate?
Hi together, Is there any way to count filtered rows in formulate? SID Status 1 True 2 False 3 True 4 True I need to count all rows and then just rows which are true,…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.