ObeeOne's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Anon

Country

Latest Posts

Re: How to calculate 90 percentile based on category
Please attach a sample dataset that you're trying to analyze as an Excel file perhaps. Also, please be clear: do you want the 90 percentile of a metric looking across a set of results in a query,…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Pyramid Analytical
Venkatesan I suggest you do more homework here. 'Session' operates off cookies. If you don't like cookies for some reason, you don't like session. Worse,…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Pyramid 2023.11 Released
Wow - the new Chatbot capabilities shown in the video are ridiculously cool!! And it smokes Power BI's copilot when you consider all of copilot's limitations.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- 1
- Product Announcements
- Reported - view
Re: Weighted Product Distribution %
These are the following steps. You can use point-and-click to do this if you are happy using the drop down like your image above. If you want the products on the rows,…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Dynamic calculation measure for Prev Qtr End using selected date of report
Here is a less formulaic way of doing this. Point and click. Lots of small steps. But uncomplicated. Right click on the 'quarter' attribute in Discover >> Create Parameter Right click on the new…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Publication - Use Parameters to determine a selected date range
The technique to getting this to work requires a small hack. The Pyramid team knows about the work-around, and have been looking into better functional support for this scenario.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- 2
- Questions & Answers
- Answer
- Reported - view
Re: Show an average of the selected members of a filter.
This is not currently possible - because the underlying query does not allow for 2 levels of granularity in the same response. I believe there is a feature request on the forum for this already.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Show an average of the selected members of a filter.
@Jair Rangel please provide some examples of what you're trying to do - maybe via some images.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Previous Month Value
@Paul Narup It works fine for me. I would suggest you make all the calcs sharable. I think there is added complexity when using some or all as one-off items in a report.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Previous Month Value
Create a formula in 'Formulate', using a single 'data point'. The Data point should be your measure, then select the date attribute/hierarchy. Instead of picking a specific element in the date,…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: How to calculate an average at a lower Time level of detail than a Discovery
It sounds like you need to add (or change) the stock cover measure in the semantic model to an aggregate type of "average". As your queries are built, it will then average all the values for that…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Question on distinct count for each value
Have you tried using distinct count measures and bidirectional joins in the model design?
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Difference actual week- week prev year
What is KW - a measure or an attribute? Also clarify what you mean by '6 week filter'. Are you Including this inside the KPI somehow or are you using the filter in your report that contains the KPI?
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view

1 2

Back to top

Home

View all topics