Skip to main content
User Community
Pyramid
Help
Learn
Support
Generative BI
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Search for answers here or
ask a question
Questions & Answers
Explore Pyramid
Product
Events & News
Latest Activity
Home
Profile
Ian Macdonald
Admin
Ian_Macdonald
Senior Director of Product
UK
Follow
Joined
Fri Oct 14 14:58:14 UTC 2016
1008
posts
326
likes received
13
followers
Badges
18
3
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
Re: Access Multiselect Parameters values in Formulate
Hi @Raja Sambasivam , Unfortunately, there is no way currently to accurately retrieve the captions of selected members in a multiselect parameter. We can "manually" traverse the list of members in…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
yesterday
2
Questions & Answers
Reported - view
Re: How can we give a specific colour to Subtotals in a schema?
Hi @Aaron Yohannan , @Michael Daun is correct in that the subtotals colour is set in the grid formatting, not the theme. Click on the Format control when in the Grid sub menu:…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
yesterday
Questions & Answers
Reported - view
Re: How to define a Design Theme for grids with a single-color background?
Hi @Michael Daun Something like this? Theme attached. Hope that helps. Ian
Attachment
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 days ago
Questions & Answers
Reported - view
Re: Calculating percentiles
Hi @Jair Rangel In what context are wanting to calculate the percentile? The Percentile function returns the defined percentile from a list of values of a Measure.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 days ago
1
Questions & Answers
Reported - view
Re: How to create quantities sales report
Hi @Lukasz Godon Fair enough!
Ok, what is your starting position? What data do you have and in what format? If you can share an example of dummy or anonymised data in the same format,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 days ago
Questions & Answers
Reported - view
Re: Alternate header row shading
Choose the alternate shading theme as well.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
5 days ago
Questions & Answers
Reported - view
Re: Date Range Slicer for Two Dates on a table
Hi @Roman Lyakhovsky , You will need slicers for each date. Because the slicer values are made up of members form that hierarchy, you cannot apply the values from one hierarchy to another.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
5 days ago
Questions & Answers
Reported - view
Re: Add a total line to a graph.
Hi @Paul Herdegen , Pyramid currently does not let you assign a different chart type to a member of the same series, in this case the total line. Instead,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
5 days ago
1
Questions & Answers
Reported - view
Re: Where can I find the query text information in the Pyramid repository database?
Archiving as no response.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
6 days ago
Questions & Answers
Reported - view
Re: Alternate header row shading
Hi @Emily Kund , Use the "alternate Rows" button in the visual menu ribbon. Hope that helps. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
6 days ago
Questions & Answers
Reported - view
Re: Sorting on Multiple Columns in Model
Hi @Dmitri Kanounnikov ,@Michael Daun It's been pointed out to me that my method above of concatenating the fields and then sorting on the concatenated filed will not always work correctly.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
8 days ago
1
Questions & Answers
Reported - view
Re: Date Range Slicer for Two Dates on a table
Hi @Roman Lyakhovsky , Your post is a little confusing. Are you saying you need the same date range applied to both dates? Or are you asking to be able to specify a date range,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
8 days ago
Questions & Answers
Reported - view
Re: Maps in Pyramid
Hi @James Thibaud You'll actually need geojson files to import the map shapes into Pyramid. Use this page instead: https://data.humdata.org/dataset/geoboundaries-admin-boundaries-for-kenya?…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 wk ago
Questions & Answers
Reported - view
Re: Sorting on Multiple Columns in Model
Hi @Dmitri Kanounnikov I think both myself and @Michael Daun thought you were talking about Discovery. My answer above holds true for Discover, but not for Model.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 wk ago
1
Questions & Answers
Reported - view
Re: Sorting on Multiple Columns in Model
Hi @Dmitri Kanounnikov ,@Michael Daun , Unfortunately the sorting dialogue currently only supports one level of sort. Multilevel sort (sort by, and then by) is in development and will be delivered in…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 wk ago
2
Questions & Answers
Reported - view
Re: Help needed with Box plot on Discover
Hi @Sanjeeth Baliga I OCR'd your data and it produces this: But your numbers are completely different. Did you post the right set? Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
3 wk ago
Questions & Answers
Reported - view
Re: Help needed with Real-time data input and String search
Hi @Sanjeeth Baliga I'm still confused. So your user has entered a customer name that does not exist in the data. Obviously the grid will show "Not enough information" as there are no customers in…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
3 wk ago
Questions & Answers
Reported - view
Re: Help needed with Real-time data input and String search
Hi @Sanjeeth Baliga The first part is simple, just create a grid with customer name on the rows and choose to display the filtered customer name list. Then add whatever other attributes and measures…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
3 wk ago
Questions & Answers
Reported - view
Re: How to create quantities sales report
Hi @Lukasz Godon , Assuming you have already built your model or connected to your database and also assuming you have the appropriate attributes and measures available, this is very simple.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
3 wk ago
Questions & Answers
Reported - view
Re: Conditional formatting in tabular grid
Or apply them to the Prior and Current Results
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 wk ago
Questions & Answers
Reported - view
Re: Is there a way to get the current logged in user?
Hi @Raveena Mariappan Can you please reply to Or's question with the details requested? Thanks, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 wk ago
Questions & Answers
Reported - view
Re: Help needed with Box plot on Discover
Hi @Sanjeeth Baliga Can you attach your sample data here as an Excel or CSV file? Rather than me tediously typing in the numbers. Thanks Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 wk ago
Questions & Answers
Reported - view
Re: Conditional formatting in tabular grid
Hi @Arabi Moorthy Tabular grids do not support the in-depth conditional formatting in the way that matrix grids do. But there is a simple fix here to allow you to order your columns the way you want…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 wk ago
Questions & Answers
Reported - view
Re: Help needed with Real-time data input and String search
OK, this is a bit more complicated. Everything in Pyramid is driven by queries, there is no direct link between entering a text string and testing it against data, we have to go via queries.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 wk ago
1
Questions & Answers
Reported - view
Re: Help needed with Real-time data input and String search
@Moshe Yossef I think that was what I suggested above! Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 wk ago
1
Questions & Answers
Reported - view
1
2
3
4
5
21
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
Publish
SAP
Security
Events & News
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
View all topics