User Community

How to enable Javascript

Q&A

Latest Activity

Got stuck with a report? Start a discussion or help others to move forward.

TOPICS MEMBERS

Filter
Newest
Active
Popular
Status
- Answered
- Unanswered
Tags

Join this category to participate in conversations and receive notifications when new posts are added

JOIN

0
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?…
- Jeremy Willes
- Jeremy_Willes
- 2 days ago
- 7
- Q&A

0
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
- Robert ClarkTop Contributor
- Robert_Clark
- 9 days ago
- 4replies
- 17
- Last replyIan MacdonaldAdmin8 days ago
- Q&A
- Answered
- Answered

0
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.
- Yvonne Teng
- Yvonne_Teng
- 13 days ago
- 3replies
- 23
- Last replyYvonne Teng9 days ago
- Q&A
- Answered
- Answered

0
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.…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 wk ago
- 3replies
- 21
- Last replyRobert ClarkTop Contributor2 wk ago
- Q&A
- Answered
- Answered

3
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).…
- Dominique Nowak
- Dominique_Nowak
- updated 2 wk ago
- 1reply
- 21
- 3
- Last replyIan MacdonaldAdmin2 wk ago
- Q&A
- Answered
- Answered

0
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.…
- Jeremy Willes
- Jeremy_Willes
- 4 wk ago
- 1reply
- 44
- Last replyItamar BirenzweigAdmin3 wk ago
- Q&A
- Answered
- Answered

0
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.…
- Dave CarberyPartner Certified Level 2
- Dave_Carbery
- 4 wk ago
- 2replies
- 24
- Last replyLara GrysczykPartner Certified Level 23 wk ago
- Q&A
- Answered
- Answered

0
Optimizing a Star Schema Data Model
Is there any best practice documentation or tools available for optimizing star schema data models in Pyramid?
- Elaine CharboneauUser Certified Level 1
- Elaine_Charboneau
- 1 mth ago
- 5replies
- 30
- Last replyIrad Gillett4 wk ago
- Q&A
- Answered
- Answered

0
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…
- Yakov ShorTop Contributor
- Yakov_Shor
- 1 mth ago
- 4replies
- 31
- Last replyYakov ShorTop Contributor1 mth ago
- Q&A
- Answered
- Answered

0
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…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 mth ago
- 2replies
- 24
- Last replyNicholas CampbellTop Contributor2 wk ago
- Q&A
- Answered
- Answered

0
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...…
- Dave CarberyPartner Certified Level 2
- Dave_Carbery
- updated 1 mth ago
- 1reply
- 14
- Last replyRoryPyramid Employee Level 3 Certified1 mth ago
- Q&A
- Answered
- Answered

0
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…
- Benjamin Reed
- Benjamin_Reed
- 1 mth ago
- 2replies
- 24
- Last replyDavid GordonCommunity Team1 mth ago
- Q&A
- Answered
- Answered

0
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.…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 mth ago
- 1reply
- 19
- Last replyIan MacdonaldAdmin1 mth ago
- Q&A
- Answered
- Answered

2
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…
- anonymous client
- quantenabler
- 1 mth ago
- 2replies
- 29
- 2
- Last replyNPANS1 mth ago
- Q&A
- Answered
- Answered

0
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…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 mth ago
- 2replies
- 30
- Last replyNicholas CampbellTop Contributor1 mth ago
- Q&A
- Answered
- Answered

0
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.…
- anonymous client
- quantenabler
- 1 mth ago
- 1reply
- 11
- Last replyIan MacdonaldAdmin1 mth ago
- Q&A
- Answered
- Answered

0
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.…
- Benjamin Reed
- Benjamin_Reed
- updated 1 mth ago
- 2replies
- 33
- Last replyIan MacdonaldAdmin1 mth ago
- Q&A
- Answered
- Answered

0
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?
- Aadhil KhanPartner Certified Level 2
- BI Consultant
- Aadhil_Khan
- 2 mths ago
- 6replies
- 44
- Last replyChristian LangmayrAdmin2 mths ago
- Q&A
- Answered
- Answered

0
Existing or custom area chart with measure for x axis.
This is quite obscure so not sure if possible, but is it possible to create some sort of stacked area chart where the X-Axis is a rank (so numeric) instead of a dimension (so 1,2,3,4,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 2 mths ago
- 4replies
- 35
- Last replyAvi PerezAdmin2 mths ago
- Q&A
- Answered
- Answered

1
how to create not a dynamic calculation
Hi, I have a case where I need to make the next calculation: In a table with the columns: week | store name | item name | sales For each item: In each store,…
- Maria Rozenblit
- Maria_Rozenblit
- 3 mths ago
- 4replies
- 51
- 1
- Last replyMaria Rozenblit2 mths ago
- Q&A
- Answered
- Answered

2
PDF / Document files as a Data Source in Modeller

Hi Avi / Pyramid Dev team, Often, information useful for a Pyramid client is stored in PDF or other document formats - for example where the Pyramid client itself has many suppliers who do not…
- Richard VarleyPartner
- Richard_Varley
- updated 2 wk ago
- 2replies
- 33
- 2
- Last replyRichard VarleyPartner2 wk ago
- Q&A
- Answered
- Answered

0
Eliminate visual indicator on eliminate datapoint
Hi is it possible to eliminate a visual indicator on a data point? I have a report which shows by Quarter , i only want to show Q1 to Q3, and eliminate Q4,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 3 mths ago
- 6replies
- 33
- Last replyChristian LangmayrAdmin2 mths ago
- Q&A
- Answered
- Answered

0
Is the Job Spooler available in Viewer version?
Some of our users have been moved to Viewer licenses. They have reported not being able to find the Job Spooler icon now. Is the Job Spooler functionality available in Viewer?
- alicia_me
- alicia_me
- 3 mths ago
- 2replies
- 24
- Last replyalicia_me3 mths ago
- Q&A
- Answered
- Answered

0
Merge separate lines into one single line whilst retaining separated stacked columns
Hi there, For some context, the 'Gross Incurred Claim' measure refers to the stacked columns whilst the 'Rolling Average 12 Gross Incurred Claim' refers to the four separate dashed splines.…
- Benjamin Reed
- Benjamin_Reed
- updated 3 mths ago
- 2replies
- 35
- Last replyBenjamin Reed3 mths ago
- Q&A
- Answered
- Answered

0
Legend not showing on Matrix grid.
How can I show a legend in a matrix grid? mine doesn't show up even when I turn it on. I would also like the legend to show the break points between colors (it's a band).
- Guillermo Dominguez
- Guillermo_Dominguez
- 4 mths ago
- 1reply
- 18
- Last replyIan MacdonaldAdmin2 mths ago
- Q&A
- Answered
- Answered

1 2 3 4 5 23 Next

Got stuck with a report? Start a discussion or help others to move forward.

Members

View all members

Recent Tweets

Follow @PyramidAnalytic

Welcome to the community!

User Community

Q&A

Possible to have an Embed Dashboard dynamically resize based on container dimensions?

After focusing on a member in a Discovery, how do you unfocus?

Discover: sort isn't working as expected

How to reset running total by a dimension value

Make reports with no longer existing measures editable for a viewer license

Why are my formulas not showing up

Predictive Modelling Use Case Problem

Optimizing a Star Schema Data Model

Slicer ID Embedded Content

Distinct Count if Line Size Value >= Max Line Size for Group

import a .pie file

Retain standard deviation values when removing a column

Using MIN in formulate but only where > than another value

Models and alternatives to “scheduled” time to process

total filter but without the dimension in discovery.

legend location

Retaining unique row combinations from query preview to discover

Pyramid Analytics API

Existing or custom area chart with measure for x axis.

how to create not a dynamic calculation

PDF / Document files as a Data Source in Modeller

Eliminate visual indicator on eliminate datapoint

Is the Job Spooler available in Viewer version?

Merge separate lines into one single line whilst retaining separated stacked columns

Legend not showing on Matrix grid.

Members

Recent Tweets

Home

Key Resources