-
Log Storage Table in Pyramid Repository Database
I want to make the system logs and scheduled job logs visible to users by creating a dashboard in Pyramid. Is there a table in the Pyramid repository database that stores these logs? If so,…
- Answered
-
Fixed Static Parameter
Hi I'm new to Pyramid. How do I create in a report or KPI that has a fixed static parameter please. I want a report or KPI that counts a distinct value when a range is between 1 and 1000.…
- Answered
-
How to Limit Color Logic to a Single Column
In the screenshot, there is a color-coded "Med Surg Supply Cost / Equiv. Patient Day" measure, where the red-green split is based off the average of those values. How do I 1.…
- Answered
-
Formatting For Multi-Select Drop Down
Is there a way to make the search box in the multi-select drop down the same size as the slicer elements? It seems I can change the size of the elements but the search box stays the same size.
- Answered
-
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
-
Difference in Filters
In Model, what is the difference between filtering on a table node and with a filter node? 1. Filter on the Table node: 2. Filter node after the month:
- Answered
-
Is there a way to get the modelId for the /API3/dataSources/addRolesToModel API without using the Admin Console?
The /API3/dataSources/addRolesToModel API requires an itemId as an input parameter. To obtain the itemId, I currently need to navigate through the Admin Console by going to Source Manager >…
- Answered
-
Dynamic caption for lag member
Hi, I want to add a dynamic caption, which displays the member name rather than the name of my formula. My formula finds the lag 4 of a member which is selected through a parameter.…
- Answered
-
Last 'N' dates list Based on Date Filter
I want to get the list of last 90 days based on Date Parameter ( Date filter Selection). How can we achieve this ?
- Answered
-
AVG OF WEEKDAY AND WEEKENDS
I have two columns weekday column and count column I want to find the average for each day and weekends based on month or year …How can we achieve this ?
- Answered
-
Display Text Value Instead of Numeric Value
I have three columns one language column, gender column and count column (numeric). Inside my language column I have different languages as text , inside my gender column I have more than three…
- Answered
-
Create Patterns Within Bar Graphs
Hi, Does anyone know to create patterns within a bar graph? Right now there is a "pattern" option but it does not create a pattern within a solid bar graph.…
- Answered
-
Tiled Layout Inside Fixed layout in same presentation
I have three slides in a presentation that I initially set to a fixed layout. Now, I want to insert a fourth slide in the same presentation using a tiled layout. How can I achieve this?
- Answered
-
Charts Customization
I have male female COUNTS in gender column .The requirement is that the SVG should be filled only for the count based on gender. For example if male count is 40 and female count is 60 ,…
- Answered
-
Mapping with "Layers"
Is it possible to add addresses to the shown example of a map of a sales area color coded by amount of sales? If so, how would I do that? TY
- Answered
-
How to get the SQL text of the executed SQL Query Node into a variable
I have an SQL query executing as an SQL Script Node in the Master flow. This SQL query is dynamic, as it inserts values like process_id and dynamic database_name,…
- 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
-
Creating a Line Graph With Year as X-Axis and a String as Y-Axis
I want to create a line graph in discover that shows all of the years as the x-axis and the company name as the y-axis. So like a line graph that shows that a company existed from 2009-2024 and…
- Answered
-
including google charts in Formulate ( custom visual )
how can i use google charts in formulate-custom visuals , I have a code for for a chart - (have attached the code below) , how can I integrate it in FORMULATE_ CUSTOM VSUAL ,…
- Answered
-
Sub Totals only if there is more then 1 element
Hello! Is it possible to show the sub totals only if there are more then 1 element to calculate? Here is an example. If there is only 1 element i'd prefer not to see the Subtotal.…
- Answered
-
Last non empty function Modell Pro
Hello Pyramid Community, is it possible to select the function 'last non empty' for Measures in the modell pro designer? I want to show the last filled amount for the month.…
- Answered
-
Plotting values on line chart without aggregating
Hello Pyramid Community! I have plotted a line chart on monthly data as shown in attached screenshot. I want to remove dates from axis, instead have only year on x-axis (the way I have at the bottom…
- Answered
-
Wrapping legend values in a line chart
Hello Pyramid Community! I have a very simple query on legend text. I am creating a line chart and the dimension I am using has long text values. Is there a way we can wrap legend text(each value…
- Answered
-
How to hide Hierarchy/Measures for specific Role Types (CLS)
This use case is around column level security and hiding certain columns based off of user role. I am trying to hide certain dimensions and measures depending on the role of the user that is looking…
- Answered
-
Disabling "Panel Tools" for Individual Visualizations
Hello, PA team! I would like to be able to hide the "Panel Tools" for only one or more visualizations on a presentation slide, for example, have "Panel Tools" for one visualization and none for…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.