-
Major Updates to Help for PQL and APIs
A major update to help has been published with extensive documentation for both the PQL query language and the application's REST APIs. PQL The new help for PQL includes an overview of the Pyramid…
-
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
-
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
-
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
-
Usage of the Count Function in Present
This may be a pretty basic question: I have a presentation that allows users to select multiple elements from a slicer. I would like to place a dynamic text box that displays the count of selected…
- Answered
-
How to get a Discovery Bar Graph to Sort by One Specific Group ?
I am attempting to build a bar graph displaying data segmented by two bars and I want to sort the bars by magnitude, but I want the bars to only sort by one specific category.…
- Answered
Welcome to the Pyramid User Community
Pyramid User Community