samuel alma's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Latest Posts

Re: How to do Window Aggregation calculation?
@Shuvankar Mondal If you want to "ignore" the other dimensions, then you need to add the "ALL" level to your formula - so it ignores the context of those other dimensions in your query.…
- samuel_alma
- 3 mths ago
- Questions & Answers
- Reported - view
Re: How to wrap text in a Cell in Discover. From Tips & Tricks Vol 5/21
@Shuvankar Mondal You can customize the width of each column - so you can stretch/shrink each column so it doesn't wrap. So your issue is not a problem IMO.
- samuel_alma
- 3 mths ago
- Discover
- Reported - view
Re: Charts Customization
It can. The value driving the volume should be based off a query. The query is based on live, slice-able data. So your graphic is based on data - not some static number.…
- samuel_alma
- 11 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Charts Customization
Use the Illustrate tools as described here in help: http://help.pyramid.local/Content/Root/MainClient/apps/Illustrate/Illustrate.htm https://help.pyramidanalytics.…
- samuel_alma
- 11 mths ago
- 1
- Questions & Answers
- Answer
- Reported - view
Re: How to hide Hierarchy/Measures for specific Role Types (CLS)
Option #1 already works as you would like. You need to ensure you login as that user, cleanly, and you'll see hierarchies and measures are not visible at all.
- samuel_alma
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Illustrator
@ArunKumar A different technique altogether: Put a column in your data model that references a URL that references images/icons. Make sure that this column is tagged as an "image URL" column type in…
- samuel_alma
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Date comparison with DateDiff
This is not correct. The text representation of a date is not how the datediff function operates. What matters is that its an actual date. Your first job, if you have your dates as text/string,…
- samuel_alma
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
How to chart the Top 5 along with an aggregate of the Other

How to chart the Top 5 along with an aggregate of the Other In a Question in the Q&A Section of the Community User @Bruce Campbell asked how to combine the Top 5 of a list with an Aggregate of the…
- samuel_alma
- 1 yr ago
- 1reply
- 117
- 2
- Discover
Re: Needs the tooltip feature in other dimension rather than only in Measure values.
Dimensions are present in every data cell of a query - whether you can see them or not. The only independent element in any given cell is the measure. And this too can be obfuscated,…
- samuel_alma
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Needs the tooltip feature in other dimension rather than only in Measure values.
Can you provide a good example where this would be applicable? Be explicit please.
- samuel_alma
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Pyramid #DataTipoftheDay on Youtube
Incredible!
- samuel_alma
- 1 yr ago
- 2
- What's New
- Reported - view
Re: Pyramid 2023.10: Your Product Ideas Delivered
Great stuff Pyramid !
- samuel_alma
- 1 yr ago
- 2
- Tech Blogs & Webinars
- Reported - view
Re: Feature Request: Reversing Axis Value Order in Attached Image
The USUAL case is to go from lowest on the bottom to highest at the top. That is how 99% of all column charts are presented. If you want this as a new feature, submit it to the product ideas section.
- samuel_alma
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Chart Top 5 Along with an Aggregate of the Others
@Ying Dong This works with ANY visual. The mechanism to pick elements or design calculations is entirely INDEPENDENT of how they are visualized. The trick is simply to put the right things in the…
- samuel_alma
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Chart Top 5 Along with an Aggregate of the Others
This can be done from the ground up by hand, first by building a top 5 list and then a formula to represent all others. You then select these items and show them in your chart.…
- samuel_alma
- 1 yr ago
- Questions & Answers
- Answer
- Reported - view
Re: Remove dimension from data label in tile plot.
Copy the State blue chip into the 'Labels' drop zone. Then switch the data labels from "Data Point" to "Value".
- samuel_alma
- 1 yr ago
- Questions & Answers
- Answer
- Reported - view
Re: Is it possible to toggle between 3 different date fields on a Present
There is no variable switch for entire hierarchies in Pyramid that we know of. Users can manually switch it out using the 'swap' context menu option. Instead we use the mini-tab tool for this.…
- samuel_alma
- 1 yr ago
- 3
- Questions & Answers
- Reported - view
Re: How to modify the WHERE clause conditions of SELECT statement before sending the query to database
@vinay valeti Slicer Prompts can be enabled with 'pre-query slicers'. I think this is only in 2023.
- samuel_alma
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to modify the WHERE clause conditions of SELECT statement before sending the query to database
First, from your diagram, you only need to join on ProductID to Fact. The ProductName to fact is redundant (and technically wrong). Next, build your semantic model as is,…
- samuel_alma
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Line Breaks
@NPANS agreed. We build a huge amount of data driven analysis and commentary in dashboards and publications like this. I have even built an entire analysis document that generates 2 pages of text…
- samuel_alma
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Web Page Illustration
The easiest way to do it is by putting something on the slide that tells the user to click on it (a button, text etc.) In the designer mode, right click on the item, and choose "click action".…
- samuel_alma
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Best Practices on CSS on Pyramid
We originally thought of this idea. But came to the conclusion it's not the right approach. So we set up the themes in Pyramid to reflect the styling of our hosting apps.…
- samuel_alma
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Automated Key Driver Analysis
This new tree capability looks like what the old "Decomp Tree" would have evolved too if MS didn't destroy it (and no, the new one in PBI is not anywhere as good). Great stuff.
- samuel_alma
- 3 yrs ago
- Tech Blogs & Webinars
- Reported - view
Re: Creating Parent Child Hierarchies
This is an insanely powerful capability - considering the amount of effort we need to build the matching functionality in MS SSAS. So many of my clients are going to love this. thx!
- samuel_alma
- 3 yrs ago
- 2
- Tech Blogs & Webinars
- Reported - view
Re: Pyramid's game-changing NLQ Chat Bot lets users analyze data in whole new way
We like the new chat bot because it works on every database we have without having to duplicate the data. We tried out thought-spot, only to realize that we need to copy the entire data warehouse…
- samuel_alma
- 4 yrs ago
- Tech Blogs & Webinars
- Reported - view

1 2

Back to top

Home

View all topics