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

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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 8 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
- 8 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
- 8 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
- 11 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: How to define a Design Theme for grids with a single-color background?
Many thanks to@Alex Scott &@NPANS for pointing out the Grid Designs. They provide a possibilty to achieve the desired result with a single-color grid background.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 yr ago
- Questions & Answers
- Reported - view
How to define a Design Theme for grids with a single-color background?

I'm afraid this is almost becoming a feature request, but maybe I've overlooked something... I would like to define a Design Theme that provides a completely single-color background for grids, e.g.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 yr ago
- 5replies
- 87
- Questions & Answers
- Answered
- Answered
Re: Where can I find the query text information in the Pyramid repository database?
I do not know if this post is still open for answers... ...but: In the repository table SERVER_LOG_TRANSACTION_TEXTS you find in the column QOM a JSON string which may contain the SQL you are lookig…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Dashboard Gallery: Population Survey
@Christian Langmayr for sure! And I'm almost finished with it...
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 yr ago
- Pyramid Dashboard Gallery
- Reported - view
Re: Dashboard Gallery: Population Survey
I recently completed a very interesting course, it was about Basic Dashboard Design Principles. I have the impression that the Population Survey Dashboard could also benefit from it...
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 yr ago
- Pyramid Dashboard Gallery
- Reported - view
Re: Learning Hub Course: Basic Dashboard Design Principles
Nice one! I liked the comparison between the current and the improved dashboard with the help of the slider very much! Perhaps I suffer from Right-Left-Weakness but is its description correct?…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 yr ago
- 1
- Tech Blogs & Webinars
- Reported - view
Re: Enabling Python Functionality on Servers with Limited Internet Access
Thank you for drawing attention to this,@Liran Levi! Is there an alternative to "allowing access" to the URLs in question? Can we download the correct packages and install them "offline" beforehand?
- Lead Consultant Advanced Analytics
- Michael_Daun
- 1 yr ago
- General
- Reported - view

1 2 3 4

Back to top

Home

View all topics