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

Data model Hierarchy - Tree slicer

Hi everyone, I have a Data model (MS-SQL Target). I've set up a Drill Path Hierarchy for my company's org structure. The problem I have is that it works well with double click and drill down,…

• Answered

change start of week in Data Flow (Advanced Time Intelligence)

Hi everyone, I managed to successfully use the Time Intelligence widget to change the start of our fiscal Year and training week, as advised by @Avi Perez in the Product Ideas forum.…

• Answered

Concatenate dimension values

Hello, Is there a way to concatenate two dimension values, like customer number and customer name, in a formula? As an example we have customer number "123" and customer name "ABC Appliances" and we…

• 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

Notification for failure of scheduled model refresh?

Is there any way to send a notification when a schedule model refresh fails?

• Answered

Creating a calculation to provide difference between two columns of numbers

We have reports that use named sets to provide four years of data and need to show the difference between the last two. We've done it with a quick calc using data points but we find that these hard…

• Answered

Top N - List

Hi We have a list of days which are numeric but not a measure. the values range from 0 to 900. We want to only show the element where they are greater than a specific value set by a continuous…

• Answered

Get notified if Pyramid Services go down

We have had sporadic instances where some of the Pyramid Services crash. It gets reported in the logs. Is there a way to have Pyramid notify our admins when this happens so they can restart the…

• Answered

Date Parameter Slicer Issues

I’m new to Pyramid 2020, coming into it from BI Office and struggling to create parameters for date selection. In most of our BI Office reports we created an Advanced Data Set from a Date Hierarchy…

• Answered

What is required for my company to use Pyramid on mobile devices?

I want to use Pyramid on my mobile device. How do I get access to it? Is the functionality included or does it cost extra?

• Answered

Do Desktop and Mobile dashboards use the same URL link?

When I convert the desktop dashboard to a mobile dashboard then do we keep the same link for both the dashboards or there are two different links to access the dashboard?

• Answered

Authentication by Azure Active Directory (AAD)

Dear Pyramid, on behalf of my company's system admin I would like to ask the following question: Are there any plans to support native Azure Active Directory Authentication using Microsofts…

• Answered

Unique Customers count that bought multiple items at a site

Okay, banging my head and it hurts. While the actual data is patient centric around different codes styles of Veterans Administration will ask it in sales terms.…

• Answered

What resources are currently available for users looking to start building ML models in Pyramid?

• Answered

How to use ML to categorize or classify comments?

I have a comments field that people want to classify into around 10 different values. Is there a built in algorithm that would help with this type of text classification?

• Answered

Is it possible to use SSAS Tabular models as sources for other Pyramid models?

Can SSAS Tabular models be used in the Data Modeler as a data source?

• Answered