Creating a Constant Key Figure

former_member604431 — Thu, 15 Oct 2020 20:39:43 GMT

Hello community,

I have a requirement to report on user adoption for various regions globally and by sales channel (or user groups). The metric is unique weekly logins as a percentage of users. Additionally we would like to adjust the counted users by a percentage as an adjustment for vacations/holidays.

Progress

New data source has been created which will provide all necessary data.
Restricted key figures have been created based on the existing Counter key figure with the following restrictions: Counted User Indicator = True; Region (custom field) = (region input); User Group (custom field) = (user group input)
To test the restricted key figure has been added to the Column Fields section of my report without any additional attributes.

The result is perfect until I add any type of selection criteria (eg Year Week (Logon Date) = Last 8 weeks). When this is introduced the count is completely wrong. My plan was to create a calculated key figure - Counter (which will change based on selection criteria) / Regional User Count by Channel (which I want to remain constant) to get my percentage.

My question

Is it possible to make your key figure constant so it is not impacted by your selection criteria or does anyone know a better approach to meet this requirement?

Thank you in advance for your help.

Larry

Re: Creating a Constant Key Figure

former_member497128 — Fri, 16 Oct 2020 14:03:32 GMT

Dear lgabbard,

We can not make key figure value constant, it will always be dependent on characteristics.

However to assist you in a better way with your requirement, we would request you to raise incident (you can mention my name there in incident) so that we can investigate your case and assist you accordingly.

Regards,

Saurav Kumar

Question Re: Creating a Constant Key Figure in CRM and CX Q&A

Creating a Constant Key Figure

Re: Creating a Constant Key Figure