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: 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
- 3 days ago
- 1
- 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
- 3 days ago
- 3
- 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
- 6 days 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
- 9 days 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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 4 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
- 4 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
- 4 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
- 4 mths 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
- 4 mths 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
- 4 mths ago
- 5replies
- 71
- 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
- 4 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths ago
- 1
- Tech Blogs & Webinars
- Reported - view
Re: Sorting on Multiple Columns in Model
Interesting question, Dmitri! I sort - sorry: thought! - that I had understood the Sort Wizard and that you should add a second sorting instruction (i.e.…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 5 mths ago
- 1
- Questions & Answers
- 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
- 5 mths ago
- General
- Reported - view
Re: Replace no values with -, N/A, or no data
Hi Emily, I have already struggled with this a lot. And today I took your question as kind of a last attempt to wrestle down the beast. But I am quite sure that this - replacing "no values" with some…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 5 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Tip of the Day - Time Calculation Wizard
@Angelie Janssen, I like this video very much - especially the idea to utilize the wizard as an easy & lightweight entry to the sometimes confusing world of formulates...…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 5 mths ago
- Discover
- Reported - view
Re: Dashboard Gallery: Bourbon Selection
@Mark Oldfield, it works! Cheers ;-)
- Lead Consultant Advanced Analytics
- Michael_Daun
- 5 mths ago
- Pyramid Dashboard Gallery
- Reported - view
Re: Dashboard Gallery: Bourbon Selection
@Yash Dalal @Christian Langmayr - any ideas?
- Lead Consultant Advanced Analytics
- Michael_Daun
- 5 mths ago
- Pyramid Dashboard Gallery
- Reported - view
Re: Dashboard Gallery: Bourbon Selection
The link says: "You don't have access to the item" I am over 18 and drink reg... uh: responsibly! :-)
- Lead Consultant Advanced Analytics
- Michael_Daun
- 5 mths ago
- Pyramid Dashboard Gallery
- Reported - view
Re: Calculating a Rolling Average Containing Empty Values
@John Fonte , no, I do not think of Custom Columns but deeper in the backend: Is it possible to fill up your data in the database? So, can the loading process (ETL) be changed to have explicit zero…
- Lead Consultant Advanced Analytics
- Michael_Daun
- 6 mths ago
- Questions & Answers
- Reported - view

1 2

Back to top

Home

View all topics