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
14 Oct 2016
994
posts
321
likes received
13
followers
Badges
17
3
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
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 hrs 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 days 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 days 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
7 days 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
7 days 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
10 days 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
10 days 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
12 days 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
12 days 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
12 days 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
12 days 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
13 days 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
13 days ago
1
Questions & Answers
Reported - view
Re: Help needed with Real-time data input and String search
Hi @Sanjeeth Baliga For the numeric input, simply use a numeric global parameter and then use that parameter in your formulate calculations. For the customer name,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 wk ago
1
Questions & Answers
Reported - view
Re: Replace no values with -, N/A, or no data
Hi @Emily Kund@Michael Daun A very good explanation by @Michael Daun of this problem. If you had a data table of the structure you describe in your data source and queried it with Pyramid,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 wk ago
1
Questions & Answers
Reported - view
Re: Discrepancy Between Displayed Rows in Visualization and Row Limit
Hi @TKH TKH Seems ok for me: Are you sure you checked the box under the row limit value and pressed "Apply"? Hope that helps. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 wk ago
Questions & Answers
Reported - view
Re: Limitation on the Number of Items in the Favorites List
Hi @TKH TKH , This is by design to keep the number of favourites to a manageable number. As the 21st favourite is added, the 1st is dropped off the list, and so on.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 wk ago
1
Questions & Answers
Reported - view
Re: Conditional formatting in tabular grid
Hi @Arabi Moorthy , Yes, you can do the same thing in Pyramid, but with many more wondrous and varied options, but you have to be using a Matrix Grid. A Tabular Grid displays data as a table of rows…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
3 wk ago
Questions & Answers
Reported - view
Re: Managing Bookmarks when Replacing a Present
Hi @Heinrich Nel Closing this thread as no response after more than 3 months. Please reopen / reply to this post if further information is required. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Is there a way to view expired conversations?
Hi @Robert Clark The conversations are stored in the Pyramid repository, but currently are not exposed in any formal way. You could dig around in the repository tables to try and find them,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: How to get the SQL text of the executed SQL Query Node into a variable
Hi @Kush Maniar It would seem not. Closing this thread as no response after 1 month. Please reopen / reply to this post if further information is required. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: How to Identify Pyramid Workflows that are Using Python Scripts
hi @Raveena Mariappan , It would seem not. Closing this thread as no response after 1 month. Please reopen / reply to this post if further information is required. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Incorrect handling of strings with different cases in in-memory
@TKH TKH reloading or restarting?
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Incorrect handling of strings with different cases in in-memory
@TKH TKH Did you restart the IMDB Server after changing the .ini file? Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Advanced Totals: Only sum up current turnover of a year
Hi @Jona Löneke When you have different Measures in your grid, you can change the totals logic and/or suppress totals for specific Measures. However, we can't do that when it is the same Measure,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 mth ago
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