-
Calculate the number of days from a date to the current date
Hello, How do you calculate the number of days from a given date in the model to the current date. We tried the following but cannot get it to work. We consistently get an empty set. Thanks, Rob Clark
- Answered
-
Comparing dates in a formula
What would be the best practice for comparing two date dimension fields in a formula? Here's an example formula we are trying to create: if(created_date<=evaluation_date, 1,…
- Answered
-
In a Discovery, how to identify records that do not have a corresponding child record
Hello, Here is the scenario. We have insurance policies in a policy table which joins to a coverage table by a policy_id primary key which is a foreign key in the coverage table.…
- Answered
-
Is there a way to create a parameter for a user to choose the time display (eg month, quarter, year)?
Our users would like to be able to choose, on a presentation, to display all the discoveries by either week, month, quarter or year. Is there a way to have a drop down that would change each…
- Answered
-
Is there a way to calculate a date off of a date parameter?
Hello, We have an evaluation date parameter and we want to create a prior year end date value for a formula. In other words the user chooses March 2024 for premium and then for the "Prior Year End…
- Answered
-
Ability to show just AI chat bot on Hub page
I know that users can click on the Pyramid icon on a discovery in a presentation and do NLP and use AI. Is there a way to have a chat box on the Hub when they login for them to simply ask a question…
- Answered
-
Is there a way to view expired conversations?
Hi All, Once a conversation is expired, is there a way to go back and see it. I can't seem to find anything in the documentation to explain how to do this or what happens to expired conversations.…
- Answered
-
Is there a way to list all assets in the repository with the folder they are in?
Hello, I have created a listing off all assets in our repository by creating a data model on top of the repository and then creating a Discovery. See screen shot below.…
- Answered
-
Is there an example of how to use the API's to export a discovery as a PDF?
Hello, I've read that it's possible through the API's to export discoveries. Does anyone have example code of how to export a discovery to a PDF using the API's? Thanks, Rob Clark
- Answered
-
Is there a way to add a discovery to a tabulation without it merging fields?
Hello, Is there a way to add a discovery to a tabulation without it merging the fields? It can be difficult to do formulas against merged columns. I know when I export to Excel I can turn merging off,…
- Answered
-
Use API's to extract data from a discovery
Hello, Is there a way to make an API call to export data from a specific Discovery? Thanks, Rob
- Answered
-
What is the "AI Driven Value" option?
Hello, I see there's a new option, when right clicking on dimension attribute, labeled "AI Driven Value" How do I use this? I searched the help documentation and the community forums and can't find…
- Answered
-
Can R or Python models be easily imported into a Data Model?
Hello, We have existing R and Python models developed in RStudio. Is there a way for us to import these models into a Pyramid Data Model? Thanks, Rob
- Answered
Latest Posts