How to enable the count function for KPI in an UX page?

Keerthana99 · 2023-08-17T23:39:17+00:00

There was an error rendering this rich post.

I'm trying to enable my summary setting in a local KPI, the data is following from the module on the UX Page. The line item that I want to have the count function enabled is a list. I tried using a formula in the module to enable it but it has not been successful. What should I do?

Accepted answers

All comments

AlejandroGomez

Hi @Keerthana99

I am not totally sure I understood your message, but seems to me that you want to count how many times a list item is listed in your module, something similar to a Countif in excel.

Just create a line item next to your list-formatted line item called "count", formatted as number and with "1" as formula.

Then create a new module using as dimension the same list as used in the format which items you want to count

Finally, use the sum function with the following syntax: Sourcemodule.count[SUM:sourcemodule.list-formatttedLI]

see below for more details:

Cheers

Alex

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…