-
Building Custom Filters
Hello, I am trying to create a custom filter for my queries using the Filter() function that I have read documentation on. I believe this will be useful for what I am trying to use it for.…
- Answered
-
How can we have formulae appear in the text and a graph of the same data set appear in same discover.
How can we have formulae appear in the text and a graph of the same data set appear in same discover.
- Answered
-
Conversations - how to mark as read?
We are using conversations to communicate within our development team. How do we mark it as read?
- Answered
-
Chart Top 5 Along with an Aggregate of the Others
We have charts that display the top 5 countries; How can we aggregate the other countries that are not in the top 5 and display them in an "Others" bucket, as below?
- Answered
-
Can I create a custom hierarchy of measures
I saw this article, https://community.pyramidanalytics.com/t/h7h92p1/how-to-combine-values-from-different-measures-in-one-charts. Is it possible to create a custom hierarchy of measures?…
- Answered
-
get measure monthly count for last 12 months
I have a [Measure] and that I want to show it's trend on a monthly basis. Therefor I created the following logic: strtomember("[Date].[Calendar].[Date].["+ format(now()-1,"yyyy-MM-dd")+"]").parent.…
- Answered
-
How to save the Analysis measures.
Hi, I have calculated some measures by using Analysis like Forecast, Regression, Statistics so on. I couldn't able to share(right click -Mark shareable option) the measures.…
- Answered
-
"Classic Pivot table" design
Hi, I want to create a table that is similar in style to the classic pivot table in excel. In that sense I also wish to add multiple attributes from the same "dimension" from my data source/cube.…
- 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
-
Sankey Chart - Source and Target Same Dimension
Hi I am looking to create a Sankey chart where the source is a month (I want to select a start month using a parameter) and the target is the same month dimension however I want to select an end…
- Answered
-
PQL Date Query
I currently have a list that is relying on a parameter in a date format of "Mmm YYYY". This controls two separate formulations that utilise the YTD & lag functions so I can get a YTD and then a prev…
- Answered
-
differences in standard deviation
Hi, I am working on a scatter plot and want to show the standard deviation. I have used three different methods, one from formulate which gives one standard deviation line (green line),…
- Answered
-
Hide unwanted subtotals
Hello, I'm wondering if it is possible, when including subtotals in a grid, to select which columns you want the subtotals to show for? Currently when subtotals are added,…
- Answered
-
custom login page
Hello, How do I send the login credentials from a custom HTML login page with the link to the specific dashboard URL? Thanks
- Answered
-
Number formats - "#,##0;(#,##0);" Only works for some users.
Hi, I am have an issue with the need to format a report consistently. The issue is that within the discovery pivot we have added which we need format "#,##0;(#,##0);".…
- Answered
-
Drill Through within Measure?
I was wondering if there is a function in pyramid which allows me to drill down/through to a single line item (if it is not linked to a hierarchy)? I can always right click e.g.…
- Answered
-
How to set default value to Slicer(Filter) ?
I have week number Slicer(filter). If my current week is 47 then i want to set 47 in slicer.
- Answered
-
Call Stored Procedure
How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?
- Answered
-
Calculate difference between columns
I'm trying to create a very basic grid that has two Terms in the columns and several measures in the rows. How can I add another column that shows the difference between the measures for the terms?…
- Answered
-
Formating line chart series
When I try to set dashed line and data labels for only one series in line chart with roght click on item in the legend. That work for only one series and formating is not aplied to selected series,…
- Answered
-
Default to todays date on Date Filter
How do I get the Date Filter to default to todays date on a Discovery? ( Scenario : The user wants to look at a WTD?MTD etc up to a point in time but wants the Date Filter to defaults to today's…
- Answered
-
Displaying only yesterdays Date
The data my company collects is a day behind, is there a way to show just the data information from yesterday? Ex: Today is 4/10, the most recent data I have and want to show in the discovery is 4/9?…
- Answered
-
Transparency doesnt work ? (PA 2018 04.460)
Dear Colleagues, first of all, i just registered to the PA Community so please help me to orient myself if this isn´t the right place for this kind of question!…
- Answered
-
Background member
Hello, In the latest Q&A webinar I noticed that in the demo discovery there was a background element visible. What's the use case for this and how does this work? Br, Simo
- Answered
-
MS Tabular connection error
Hi Team, We are getting error while taking the MS Tabular and MS OLAP connection . We tried all the possibilities but we didn't get the connection could you please check it once. Thanks, Praveen.
- Answered
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.11 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
The DataShark Podcast
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help