Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Alternate header row shading
Choose the alternate shading theme as well.
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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.…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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,…
- Senior Director of Product
- Ian_Macdonald
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Where can I find the query text information in the Pyramid repository database?
Archiving as no response.
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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.…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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,…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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?…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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.…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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.…
- Senior Director of Product
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Conditional formatting in tabular grid
Or apply them to the Prior and Current Results
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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.…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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,…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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,…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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.…
- Senior Director of Product
- Ian_Macdonald
- 2 mths 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…
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view

1 2 3 4 5 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Alternate header row shading

Re: Date Range Slicer for Two Dates on a table

Re: Add a total line to a graph.

Re: Where can I find the query text information in the Pyramid repository database?

Re: Alternate header row shading

Re: Sorting on Multiple Columns in Model

Re: Date Range Slicer for Two Dates on a table

Re: Maps in Pyramid

Re: Sorting on Multiple Columns in Model

Re: Sorting on Multiple Columns in Model

Re: Help needed with Box plot on Discover

Re: Help needed with Real-time data input and String search

Re: Help needed with Real-time data input and String search

Re: How to create quantities sales report

Re: Conditional formatting in tabular grid

Re: Is there a way to get the current logged in user?

Re: Help needed with Box plot on Discover

Re: Conditional formatting in tabular grid

Re: Help needed with Real-time data input and String search

Re: Help needed with Real-time data input and String search

Re: Help needed with Real-time data input and String search

Re: Replace no values with -, N/A, or no data

Re: Discrepancy Between Displayed Rows in Visualization and Row Limit

Re: Limitation on the Number of Items in the Favorites List

Re: Conditional formatting in tabular grid

Home