MR: User to select columns for variance

Hi fellows,

New variance feature is a long awaited one. And finally we have it!

But this feature is almost a hardcode and it does not allow an end user to select which of the two columns to be compared.

Would be great if a user could decide it while presenting something like he can do with page selectors. Or any similar way...

I want to know what you guys think. How would you resolve this inconveniance? Or maybe you agree and want to add something. Let me know below.

I'd like to raise it in Idea exchange, but first want to discuss it here.

Accepted answers

All comments

lis.degeus

Thanks for raising the topic. I've been anxiously waiting for this feature for years and I was so excited when it got released. I had tested a prototype as part of the user research program a long time ago.
Indeed it's missing two things IMO:

- should 100% be something that end users can create ad-hoc when needed in any grid - and the prototype was like that
- should be available in boards and worksheets as well, not just management reporting pages

KirillKuznetsov

@lis.degeusthanks for your comment.

Totaly agree with you! Could you tell a little bit more about the prototype? Are you saying that it had some additional UI to select columns while presenting or in edit mode only?

lis.degeus

Yes!
Not sure if you've ever done a user research session with the team, but they show really a "fake" prototype. Kind of like a slideshow of how they want to make the product look like, but nothing actually working in the tool at that point, as it's usually very early stage. So I usually don't expect something exactly like what I tested.
But indeed if I remember correctly (this was 2-3 years ago), the users had a button "add comparison card" or something similar. This would prop up a screen where they could select Columns 1 and 2 to compare (could be a month, a version, a cost center, whatever dimensions applied to the table). Then add as many variance columns afterwards (choose from difference, % variance, etc). It looked awesome 🙂

KirillKuznetsov

@lis.degeus

Sounds promising! Thank you for revealing it.

obriegr

What was the point if the end user can't just do it?

This is literally a waste of time/coding otherwise. I as a workspace admin would include it in the line items if needed otherwise.

It is a sparsity saving thing??? Silly, because if that is how close you are to making out a workspace, you have other issues with regards to sparsity that can relieve them...

I am so glad Anaplan is spending their time on features that are beneficial/helpful, versus something that makes no sense /s

jziemer

@KirillKuznetsov I absolutely agree that an easy to use and select variance feature should be built into Anaplan. Ability to select which columns to compare would be a huge improvement. For this to be a truly value-add feature, it needs to be on Boards and Worksheets, not just Management Reporting. After all, a key part of any planning process is to look at variance analysis. While there are definitely ways to build variance analysis into an Anaplan model, it tends to take space and time to build, and there are still tradeoffs that need to be made. This feature would help keep Anaplan a strong competitor in the market space.

Tiffany.Rice

Great mention - I lost steam on my excitement for this new feature when I realized it requires continual maintenance to the report design (i.e. the hard coding you mentioned). Flexible variance calculations would be a game changer and go a long way towards enabling the autonomous planner!

KirillKuznetsov

Hi everyone, thank you for sharing your thoughts.

I have submitted the Idea. Please support User to select columns for variance analysis

Quick Links

Can you help?

Unanswered questions

Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…