-
Convert measure to dimension & measure
Hello everyone. I'm seeking to create a dimension from a current measure column so that I have this column visible as both a measure and dimension. Cheers, Dave
- Answered
-
Comment modéliser mes données correctement
Bonjour à tous, je dois réaliser un reporting en fonction de ce fichier excel. Sur des graphiques, je dois afficher le nombre de journées CP en fonction du nombre de journées.…
- Answered
-
Which organization makes successful use of conversations in Pyramid?
Hi everybody, we see the potential of chatting in Pyramid but it’s behavior is less intuitive than we expected. Nevertheless we think that we can start using this functionality if we introduce it…
- Answered
-
how can i insert a 60 second pause before next iteration of while loop??
assume i need query result from table1 to equal query result of table2 before having a model "process". i thought there might be some sample pql statement that would be similar to "sleep 60" before…
- Answered
-
Line Banding, different bandings for different classes. Swap dimensions.
Is it possible to have a dimension switch similar to how we deal with measures, so a set of buttons to pick x or y dimension? The reason being I have a report which shows exposure,…
- Answered
-
How to un-show header in a table
Tableau had a feature that allowed you to add a column to a table but hide it by deselecting 'show header' Is there a similar feature in Pyramid? Here's a table I created in Pyramid and I could like…
- Answered
-
HR Cube - Absenteism hours - Formulate
PYRAMID Hello could someone help me on this one ? I have a HR table, in which I have 3 columns : Absenteeism days Contract hours Calculation of absenteeism hours=absenteeism days*contract hours…
- Answered
-
Possible to have an Embed Dashboard dynamically resize based on container dimensions?
We are using pyramid embed, due to the different screen size of users, wanted to know if it is possible to have the height and width set dynamically based on browser/container?…
- Answered
-
After focusing on a member in a Discovery, how do you unfocus?
Hello, We have had a couple of occasions where users have focused on something and saved the report. How do I turn off the focus so it goes back to it's original state? Thanks, Rob Clark
- Answered
-
Discover: sort isn't working as expected
As shown above, sort is set to order by the average score measure, however the visual is still showing bars not sorted properly.
- Answered
-
How to reset running total by a dimension value
We want to create a running total over time for each state and we want it to reset for each state. If I create a running total quick calc off of an existing measure it totals across all states.…
- Answered
-
Make reports with no longer existing measures editable for a viewer license
We have some year based measures that our viewer users use in their reports. For example these measures are always provided for the last three years (e.g. list price 2020, 2021 and 2022).…
- Answered
-
Why are my formulas not showing up
I have a handful of formulas that execute successfully in a Public Content folder. However, in Discover, only 2 of them show up Even if it is a blank discover panel.…
- Answered
-
Predictive Modelling Use Case Problem
Hello everyone. I'm having problems working through the Predictive Modelling case study. All is going fine until I get to Step 2. Training The Model, Part 4.…
- Answered
-
Optimizing a Star Schema Data Model
Is there any best practice documentation or tools available for optimizing star schema data models in Pyramid?
- Answered
-
Slicer ID Embedded Content
Hi We are building a website in which we use embedded dashboards. We are looking to build some sort of bookmark/favorites solution on top of it, which would allow the customers to save the slicer…
- Answered
-
Distinct Count if Line Size Value >= Max Line Size for Group
Hi So I have a measure showing count(distinct aggregate reference) and it works as expected but now I need to only count if the line size value is greater than the maximum size allowed for the…
- Answered
-
import a .pie file
Hello everyone, I'm quite new with pyramid and I'm working through through the newby badges. I have started the level 1 formulate course and have stalled at the first fence...…
- Answered
-
Retain standard deviation values when removing a column
Hi there, I currently have the following grid: I'd like to attain a grid that doesn't include the Development Month column but retains the standard deviation result (shown above) for each department…
- Answered
-
Using MIN in formulate but only where > than another value
HI I am looking to create a box and whisper chart, I have got it working using Min / Max and average however we have a lot of Min entry where the value is 1 or 0, so the min is always near zero.…
- Answered
-
Models and alternatives to “scheduled” time to process
Outside of pyramid analytics I “know” when my data is available (that my model needs to downsample and append to an memory database) rather than having the model run at specific time of day can I…
- Answered
-
total filter but without the dimension in discovery.
Hi I have a discovery where I have a set of premium values by reference. I want to exclude any reference where the premium value is above a set value. This is possible using the total filter which…
- Answered
-
legend location
i like having discovers render "legend" centered on bottom. when i try to add the discover to present or publish i only see legend on left, right, or off as options.…
- Answered
-
Retaining unique row combinations from query preview to discover
Hi there, In my SQL query preview section (first screen grab) which has two columns, 'Section_Reference' and 'Max_NSP_24Months', I have unique row combinations.…
- Answered
-
Pyramid Analytics API
Good Day. I would like to connect Excel to Pyramid and extract a database using the REST API's. Is there any guidance on how to use these APIs?
- Answered
Got stuck with a report? Start a discussion or help others to move forward.