-
Filter on non-existent values (Custom filter)
Hi together, I which to create a filter in publication which also preserves filtering on values which are currently not in the data, so that I get a blank output.…
- Answered
-
List Printing
Hello everyone, Is it possible to print in Presentation or Publication, a list that is larger than one page? This list would continue on the next page. Guillaume A.
- Answered
-
Showing a comparator "geography type" in a chart
Hi all this is tediously basic i assume, sorry. A line chart shows all items that are in "Geography_Type A" where the user can choose the Type: And what i need to do is have a second…
- Answered
-
How do we adjust area chart colouring?
Hi all, ok so i have a stacked Area Chart with two values over time, the final result needs to be showing just the upper area, the lower totally invisible.…
- Answered
-
Indicators with multiselect measures
Hello! Does somebody know how to use the indicators in combination with the multiselect measures? See attachment. The indicator will be removed when I change to another dynamic measure.…
- Answered
-
Multiselect Dynamic measure
Hello! Is it possible to use multiselect with Dynamic measures? The way I tried in the picture is not working. Kind regards, Dennis.
- Answered
-
Dynamic Date Parameters
Are you able to make the maximum year in a date parameter dynamic? So that right now it would give options up to 2020 – but next year, it would automatically update to 2021 without requiring us to…
- Answered
-
Passing Parameters to Stored Procedures
If we have a Stored Procedure in the database server to which I need to pass a decryption key (string/text) in order to decrypt the numeric sensitive data,…
- Answered
-
SSAS Currency Symbols
Does Pyramid support dynamic Currency Symbols that are configured in the SSAS cube using "Language( )" MDX? I'm not seeing that the symbols are being allowed through to Pyramid. Is this supported?
- Answered
-
In Explore Further is there any easy way to filter out records with $0 measures?
We have users using explore further and add a measure but have no way, that we can see, to easily filter out the records with 0 as the measure value. Is there a way for them to do this?
- Answered
-
Calculating max/min difference in context
Hi there i want to reduce a range of time series lines into a single area spanning the max and min values in each time point. I've had a go with creating an Fx but i suspect i need a context…
- Answered
-
Population pyramid part 2 - axis extents
Hi all, thanks again to Ian for your help in my other post https://community.pyramidanalytics.com/t/60hxcbn/making-a-population-pyramid-chart-specify-total-for-and-reverse-axis-direction I've used…
- Answered
-
YTD Functions
For the YTD to work properly, do you need to have a date field in your model? Or can it also work on 'text fields' set as your periods?
- Answered
-
Client help search problem?
Hi there i'm not getting any answers when searching the Client Help, even if i search for a phrase i can see in a help page, when using Chrome. Seems fine in Edge though.…
- Answered
-
Related content -> metadate available as source in model?
Hi, I'm new to Pyramid. I've searched the forum but haven't found an answer to the following question: For operational purposes (Something is broken, where is the impact?…
- Answered
-
Making a population pyramid chart - specify total for %, and reverse axis direction
Hi all, i need to be able to create these charts. Percent of total, in agebands split by sex, displayed as a bar chart with one of the sexes using an inverted x-axis.…
- Answered
-
Show Empties - In Memory
Hello, I have built a new in-memory Pyramid model, and I have a table with a list of Pack Benches (numbered 1-10). When I don't include a measure, it shows all elements of the dimension (see…
- Answered
-
Line chart - multiple items, all one colour
Hi I've a bar chart which was multicoloured when new, i dragged the Geography item from Colour zone to Categories zone and the chart bars all became default blue which is just excellent.…
- Answered
-
External Actions / Workflow
HI, Does Pyramid have the ability to support a 'sign off' workflow -- ex: user reviews a dashboard and clicks to indicate that the visuals have been reviewed. We'd like to capture the signoff.…
- Answered
-
Cumulative Rate Changes
Hi all, I am trying to replicate the example seen in the picture. As you can see, with each different year the rate % changes. I want to be able to track the cumulative change from a given year…
- Answered
-
Click or drag to add measure - any difference?
Hi all, when i tick a measure Pyramid will add it to in this case a table - adding it to both the Values card, and the Columns card, the column it creates is also named with the Measure name.…
- Answered
-
Best practice for embedding Pyramid presentation into Salesforce
We want to embed graphs and presentations into Salesforce. What is the recommended approach for doing this?
- Answered
-
Cumulative context but to exclude specific status measures
Good evening I have a report I'm trying to replicate and I've managed to get most of it working but I need to either eliminate two cells as part of a measure or or recalculate the cumulative total…
- Answered
-
Motion ranking
Hello all, very new to Pyramid (day2) and I've got a bar chart with date driving motion and am trying to sort the display order of the bars to always be descending (so they may have to swap places…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.