Best Of
Re: "Reset" on UX Page
Hi @mthakker!
There is a special button for such cases.
However I believe it's more useful than just "reset". And it makes sense to replace "reset" button with "reset page"
Thanks,
Kostya
Re: how to average on roll up
@SnehaPrabha It sounds like you want UPT to:
- Sum across Products
- Average across Time (at quarters, years, etc.)
- Average across Geo (at Region, etc.)
If that's the case, a simple solution is to have three line items:
- Value (Divisor)
- Formula: 1 (a simple count to calculate the divisor)
- Summary Method: SUM
- Dimensions: Only the dimensions you want to average (which sounds like Country and Time)
- Value (Sum)
- Formula: [your calculation or user input]
- Summary Method: SUM
- Dimensions: All dimensions relevant to this metric
- Value (Output)
- Formula: =Value(SUM) (this looks like a daisy chain, but it's necessary in order to summarize correctly)
- Summary Method: RATIO ( Value (SUM) / Value (Divisor) )
- Dimensions: All dimensions relevant to this metric
Here's what the blueprint looks like:
And here's what the output in my model looks like (where region and quarters average but product sums across the active dimension):
If you want summary method behavior to be different within different levels of the same hierarchy, you need to get more complicated. (Similar to what @nvilkko described)
Re: UX related question!
To improve on this, create a list for each Salary Band and put the text there; then use a list formatted line item for display, not text. Also, there's no need to be doing the text concatenation here…
Re: UX related question!
@aishabhy05, Write the formula for the text format line item with emojis, using IF and ELSE statements for different emojis.
IF Salary < 50000 THEN "🔻" & "Low Salary" ELSE "⬆️" & " High Salary"
Dikshant
Re: Managing Hierarchy with members moving between levels
@Nipsa That is something which should not happen ideally. You need to have stable hierarchies for a system to work.
If members move from one level to another, I believe you are going to lose all the input data at that level - To fix that you will have to load all the new children of this member which moved from being a child to parent to get the data back. And if the data is end user input then end users need to re input their data.
Thanks,
Misbah
Misbah
Re: Delete Dormant Users from the Anaplan Tenant Admin Tool
Hi,
Is there any update on this function?
Thank you!
Amy
AmyX
Anaplan Models Not Opening Up/Loading
I am having multiple models not being able to open up in different workspaces. It's stuck on the loading screen and I can't even access production models.
A conversation with Misbah Ansari — Journey | Anaplan Community Podcast
We’re kicking off our 2024 podcast season with a well-known Community name! Join host Kas Gengadaren (@KasG), Anaplan’s APAC Ecosystem Manager, as she interviews one of top Community members — Misbah Ansari (@Misbah), Certified Master Anaplanner, Anaplan Community Boss, Planual co-admin, and CEO and Founder at Miz Logix.
Misbah’s expertise and helpful demeanor has positioned him as one of the most knowledgeable people in the Anaplan ecosystem. With over 200 discussions started and 2,500+ comments, we are continuously impressed with the time and energy he lends to the Anaplan Community.
A little background on Misbah: he is an experienced information technology operations manager with a demonstrated history of working in the consumer goods/service industry. He is skilled in Anaplan, project management, data analysis, business development, accounting, customer relationship management, and FP&A.
Listen in as Kas and Misbah discuss how Misbah got started with Anaplan, his involvement with the Planual and Community, what it means to be a Community Boss, and his plans for the future.
“To all newcomers, I would say — if you feel that you have questions, please go ahead and post in Community. You will find ten different meaningful responses. And it’s for you to choose which one you will want to go with. And all ten of them will be right. It expands your horizon when you look at one problem with ten different answers.” – Misbah Ansari
Tune in and let us know who you would like to see in future episodes. And a huge shout-out to Misbah — THANK YOU for being an integral part of Anaplan!
View all past podcast episodes here.
Re: January 2024 Community Q&A Challenge — join the discussion and collect a badge!
I guess,
I'm late for the bage, but I wonder how nobody mentioned ability to work with pages in the model interface for admins 😅
No more jumping between interfaces 👍️
