Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Disabling "Panel Tools" for Individual Visualizations
Hi @TKH TKH , Just turn off the panel for that object in the object panel formatting settings: Uncheck this box: Gives you: No panel on selected object. Hope that helps! Ian
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- Questions & Answers
- Reported - view
Re: How to show URL icons in matrix grid?
Hi again @Natalie-Anne Botha , If your data is very static, i.e. you only ever have 3 cities and 3 questions in those respective dimensions, i.e. you always have a 3x3 grid of URLs,…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How to show URL icons in matrix grid?
Hi @Natalie-Anne Botha , Pyramid does not currently support images in the data cells of Grids. However, we can post process the grid that contains URLs in Present using Dynamic Text.…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- 3
- Questions & Answers
- Reported - view
Re: Filters-Two Different Models
Hi @Immanuel Gem I can see why you might want the geolocation perform like that as it forms a natural hierarchy, but Race, Ethnicity, Language, Gender, Military Ve...…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Static value list for a dimension
Hi @Puneet Mehta , It comes down to how you have built your data model. If you are deriving your month and year dimension from your data and there are no records for months June - December in 2024,…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Filters-Two Different Models
hi @Immanuel Gem , Let me restate your challenge to make sure I have understood it correctly. 1st Question You have a dashboard with analytic content from two models.…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Custom Date Time Format with Time Zone
Hi @Kyle Jordan Use the backslash character "\" to escape the M thus: yyyy-MM-dd hh:mm G\MT Z Gives you: Hope that helps! Ian
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- 4
- Questions & Answers
- Reported - view
Re: Custom Date Time Format with Time Zone
Hi @Kyle Jordan , Where are you setting the format? Sorry, but from the small screen grab I can't tell the context in which you are working. Can you show the complete screen?…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- Questions & Answers
- Answer
- Reported - view
Re: Concerns about Python Access
@Dmitri Kanounnikov As it can be difficult to anticipate the resources consumed by the IMDB service, it is recommended practice for production systems to isolate the IMDB service on its own server so…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
@Immanuel Gem Oops! I just noticed from your last post i still got the algorithm wrong! Same approach, but different lag options! Ian
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
Hi @Immanuel Gem OK. First off, if this is a model you have built, then it would be much, much easier if you created a dimension of year-month or alternatively easier if you have a year --> month…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
OK, that's clear now. Do you have a dimension of year-month? And what are you counting?
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
@Immanuel Gem I'm still not entirely clear on your algorithm for selecting the months to count. Are you saying it is the three months prior to the year/month selected? Also,…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
Hi @Immanuel Gem Just to make sure the above is not a typo, you want the count of the three months counting backwards from the month selected of the year preceding that selected?…
- VP Product Management
- Ian_Macdonald
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Forecasting Label
Hi @ArunKumar , In order to have the AI driven Forecast Labels available in the drop down, then the Pyramid AI integration must be enabled. Without it, the only Forecast Label Option available is the…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Rolling average formula
@Mark Oldfield, @Katie Easton Works well, but it will become cumbersome when looking at wider rolling average ranges. It is also very static in terms of how the user to interact with it.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 3
- Questions & Answers
- Reported - view
Re: PPT related queries.
Hi @Vijayan Krishnan 1. This appears to be a PowerPoint screenshot. All PowerPoints have Notes sections for each slide, whether they are used or not. it may be you haven't noticed them before.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Create a Text Column
If you mean a grid as a set of columns, change the grid type from Matrix to Column.
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Create a Text Column
Hi @RAJESH Gonuguntla , Any text column in the underlying data tables will show up as a dimension / hierarchy in your model provided it is identified as such (i.e.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: How to define a common scale for primary and secondary Y-axis?
Hi @Michael Daun You are correct. However there is a workaround whereby we show the stacked measures and single measures together on the primary axis. In fact,…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Case Statement in model
Hi @Tabitha DeCaprio , Your syntax is incorrect for the PQL CASE() statement. See the Help page for detailed syntax, but your example correctly specified in Pyramid would be :…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Local storage of "In Memory" DB
Hi @Jose Redondo, When you build a model that includes a data flow (vs a direct query model) you can choose where to store the data that is output from the data flow in the "Target" block.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Pyramid Geospatial for Postal Code
@Ying Dong BTW, the file I found was free and includes the lat/long centre of the full postcode. That might be helpful to you. You can find the website here. Hope that helps some more! Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Pyramid Geospatial for Postal Code
@Ying Dong I've done some testing by downloading the complete list of Canadian post codes by City and Province. I took the first 3 characters of the post code to give the Forward Sorting Areas (FSA)…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Pyramid Geospatial for Postal Code
@Ying Dong Don't forget to set the map locale to Canada. That way you have a better chance of resolving the post codes correctly Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view

1 6 7 8 9 10 25

Back to top

Home

View all topics