Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

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
- 7 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
- 7 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
- 8 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
- 8 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
- 8 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
- 8 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
- 8 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…
- VP Product Management
- Ian_Macdonald
- 8 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.…
- VP Product Management
- Ian_Macdonald
- 8 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
- VP Product Management
- Ian_Macdonald
- 8 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,…
- VP Product Management
- Ian_Macdonald
- 8 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,…
- VP Product Management
- Ian_Macdonald
- 8 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
- VP Product Management
- Ian_Macdonald
- 8 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.…
- VP Product Management
- Ian_Macdonald
- 8 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…
- VP Product Management
- Ian_Macdonald
- 8 mths 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
- VP Product Management
- Ian_Macdonald
- 8 mths 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,…
- VP Product Management
- Ian_Macdonald
- 8 mths 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
- VP Product Management
- Ian_Macdonald
- 8 mths 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
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Incorrect handling of strings with different cases in in-memory
@TKH TKH reloading or restarting?
- VP Product Management
- Ian_Macdonald
- 8 mths 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
- VP Product Management
- Ian_Macdonald
- 8 mths 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,…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Download Pyramid Discovers on a schedule to an OS folder
Hi @Mad Amruthur No, the identity that the Pyramid Server is running under. If you're running it on a Windows server, it will likely be the machine name on the network.…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view
Re: YTD and Prior YTD Measures
BTW, This cumulative measure can be used in conjunction with Year and other time period filters to show the cumulative total (YTD): Ian
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- 1
- Questions & Answers
- Reported - view
Re: YTD and Prior YTD Measures
Hi @Daniel Van Wyk We can take a different approach to this. Essentially a YTD function returns the cumulative value of the measure. starting at beginning of the Year.…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- 2
- Questions & Answers
- Reported - view

1 3 4 5 6 7 25

Back to top

Home

View all topics