Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Is there a way to communicate with external models real-time
Hi @Pranoy Karun Vijay The short answer is no. You could potentially take your value and pass it to some external system via a parameterised HTML link in a Web window on the slide and that web page…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Sub Total Color Formatting - to be exported in Excel
Hi @Aaron Yohannan If you take your formatted Discovery and use it to populate a Tabulate sheet, then export that as an Excel file, it will preserve the subtotal formatting. That's one option.…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view
Re: Is there a way to set a process to automatically copy a presentation from folder to another?
Hi @Jack Massey Unfortunately no, not in the general UI. This could be achieved using the Pyramid API…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view
Re: How can we give a specific colour to Subtotals in a schema?
@Michael Daun We need to understand why my approach does not work for you. That's very strange. I've got pretty close to what you are looking for: Just the grand total in bottom right hand corner to…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view
Re: How can we give a specific colour to Subtotals in a schema?
@Aaron Yohannan SubTotal formatting of background colour does not export to Excel. Ian
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view
Re: Sub Total Color Formatting - to be exported in Excel
Hi @Aaron Yohannan SubTotal formatting of background colour does not export to Excel. Ian
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view
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…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- 3
- 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:…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- 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
- VP Product Management
- Ian_Macdonald
- 9 mths 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.…
- VP Product Management
- Ian_Macdonald
- 9 mths 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,…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view
Re: Alternate header row shading
Choose the alternate shading theme as well.
- VP Product Management
- Ian_Macdonald
- 9 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.…
- VP Product Management
- Ian_Macdonald
- 9 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,…
- VP Product Management
- Ian_Macdonald
- 9 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.
- VP Product Management
- Ian_Macdonald
- 9 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
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- 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,…
- VP Product Management
- Ian_Macdonald
- 9 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?…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- 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
- VP Product Management
- Ian_Macdonald
- 9 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…
- VP Product Management
- Ian_Macdonald
- 9 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…
- VP Product Management
- Ian_Macdonald
- 10 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.…
- VP Product Management
- Ian_Macdonald
- 10 mths ago
- Questions & Answers
- Reported - view
Re: Conditional formatting in tabular grid
Or apply them to the Prior and Current Results
- VP Product Management
- Ian_Macdonald
- 10 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
- VP Product Management
- Ian_Macdonald
- 10 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
- VP Product Management
- Ian_Macdonald
- 10 mths ago
- Questions & Answers
- Reported - view

1 4 5 6 7 8 26

Back to top

Home

View all topics