Michael Daun's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

CI Decision Design GmbH - Cologne Intelligence

Country

Latest Posts

Pyramid Analytics SWAG

YEAH - I was randomly selected to get some Pyramid Analytics SWAG! Simply by introducing myself in the Member Lounge... it was definitely worth the effort! THANK YOU, Pyramid!!! Michael P.S.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 2 wk ago
- 1reply
- 30
- 6
- Member Lounge
Re: Pyramid 2025 "Newton" Released !
And another Yay! from me... [What about Version 2023.17.xxx, which was somewhat announced in the support channel. Will this also be published or does it become obsolete?]
- Lead Consultant Advanced Analytics
- Michael_Daun
- 3 wk ago
- Product Announcements
- Reported - view
Re: Turn off time changes
@Friedrich Schmid, thanks for clarification. I understand your problem now... ...but I have no idea how to solve this! Perhaps an issue for support or for the Pyramid colleagues here (@Ian Macdonald,…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Turn off time changes
Hi Friedrich, where exactly in Pyramid did you encounter the time changes (summer/winter time)? I do not know many places in PA where I could think of such configurations.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 3 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Is there a way to disable the drop zone pop ups in Discover?
Hi Alexander, I do not think that this is possible - but I'd be happy to be proven wrong! There is a "Hide Tooltips" button in Discover but AFAIK it has no effect on the drop zones but on the…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Pyramid 2023.16 Released
@Itamar Birenzweig, in the meantime a hotfix is available for 2023.16, as I could detect in the Version's drop down in the support forum (V2023.16.083) General question:…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- Product Announcements
- Reported - view
Re: Building cascading filters/slicers that contain only relevant values of charts at the presentation layer
@Obee1, yes, good addition, I forgot to mention this! @Shuvankar , you can see "Lists" in the first screenshot and the "Fx" symbol circled in yellow in the second screenshot.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Building cascading filters/slicers that contain only relevant values of charts at the presentation layer
To be honest: I don't know whether you really need all the filters or whether fewer interactions would improve performance. I also doubt that the highlight mode is sufficient to really enable…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Union of custom columns (Static Values)
Hi Ananth, this sounds as if you are looking for a Parameters! This is an option when opening Formulate... At Step 1 select "Global" (i.e. the values do not come from your model!…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Building cascading filters/slicers that contain only relevant values of charts at the presentation layer
Hi Shuvankar, for the first part of the question: Have you already checked "Interactions"? You can define the interactions between every interactive object of your slide, i.e.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: The first workday does not appear as set up
@Daniel Jaldin - okay, but that's not exactly what I tried to say in my German English... ;-) My idea was, perhaps there is a setting in the model which overrules the tenant setting - like the…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- Questions & Answers
- Reported - view
Re: The first workday does not appear as set up
I am not sure,@Daniel, but between the tenant settings and the slicer settings there might be some extra settings within your model. For example, if you use Time Intelligence you can configure the…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Hiding of Filters in Discovery
Hi Jeevitha What is the intention of hiding a filter? I guess, it still shall filter the result set, e.g. the products in your discovery, but the user shall not change (or just not see) this filter.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Colored Stacked Bar Chart with Grey Area Overlay Displaying 75%-125% of the Average Count
Hi Travis, I did it like that: I have a simple column chart (measure: AKTIVIERUNG_NEUVERTRAEGE, color: BLUE) and additionally three formulas, delivering three measures, i.e.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- 3
- Questions & Answers
- Reported - view
Re: Is there a way to create a parameter for a user to choose the time display (eg month, quarter, year)?
@NPANS &@Robert Clark - Ha, nine months ago I wrote a “Tip of the day” for NPAN's second technique. It should fit the requirement exactly... https://community.pyramidanalytics.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Welcome to the Community - Introduce Yourself!
Alright, let me be the first to introduce myself from the folks on the other side of the Nile… I’m Micha, from near Cologne, Germany, and I’ve been working as an IT consultant for 27 years.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- 9
- Member Lounge
- Reported - view
Re: PQL lookup second largest value
Hi Katie, I think it's easiest if you design the grid that serves as the basis for your dynamic texts (?) in such a way that the second largest value is always in the same position, i.e.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Highlighting the column and grid setup *help*
Close but no cigar? Crazy requirement - but i liked it, quite challenging... First, I transformed your EXCEL data to look like this, as Pyramid expects the first row to be the column headers:…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Is there a way to calculate a date off of a date parameter?
Hi Rob, I am not sure if my suggestion presents the type of object you are searching for... ...but the Custom Column "End of Prior Year" generates the date of the last day of the previous year for…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 2 mths ago
- 3
- Questions & Answers
- Reported - view
Re: Slicer to switch between months and weeks with same amount of bars in a barchart
@Moshe Yossef yes, exactly! We have two Custom Columns (cf. Fabian's two "If"-statements) which are triggered by one global text parameter, i.e. the toggle button.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Slicer to switch between months and weeks with same amount of bars in a barchart
Hi@Moshe Yossef, two inspiring ideas to solve this - THANK YOU. But I still wonder why it should have something to do with sorting... As far as I understand it seems to be a problem with the…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Ability to make number of user inputs dynamic
Hi! Most probably I did not get your idea correctly - but why don't you provide a "Multi Select Drop Down" as a filter for the user to make him select the products he wants to analyze?
- Lead Consultant Advanced Analytics
- Michael_Daun
- 5 mths ago
- Questions & Answers
- Reported - view
Re: How can we give a specific colour to Subtotals in a schema?
@Ian Macdonald - Thank you very much, Ian! Most probably the bold font for the white area is to sort out, too. I guess all the numeric values are part of the "Data" area, i.e.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 6 mths ago
- Questions & Answers
- Reported - view
Re: How can we give a specific colour to Subtotals in a schema?
@Ian Macdonald, unfortunately this does not work for me. I suspect that it has something to do with these "special options buttons" like "Totals Formatting", "Readability" or "Auto Colorize"...…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 6 mths ago
- Questions & Answers
- Reported - view
Re: How can we give a specific colour to Subtotals in a schema?
@Aaron Yohannan - as far as I see this does not work by means of the design theme. In the design theme you define - besides colors for fonts, lines or background 16 "Report Colors" ("Report color #1"…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 6 mths ago
- 1
- Questions & Answers
- Reported - view

1 2 3

Back to top

Home

View all topics