on 10-26-2017 12:53 PM
Hi experts
I would like create a key figure (new row in Account dimension) that works as a counter. I managed to create a new key figure in the Account dimension by just adding the formula (1), but I am not allowed to set the Aggregation Type. Therefore no aggregation is done and I just get the value 1 no matter drilldown. Is there a way to create both a general "count" and a "count distinct" key figure in SAP Analytics Cloud?
Erik
Hi Erik - in this case I use a column that is not being reported on and then create a transform to replace all with "1" and use that as a counter. If it is a dimension, I change it to a measure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Erik,
Excluding the modeler side of the application, and depending on your use case, when building a story widget or grid on a canvas, there is an ability to "add Calculation". In this scenario, you select the Aggregation, name the calculation, select the object type "Count" select the measure (account) to count, then define the parameters of the count by dimension. For example, if you have an account of UnitsSold, then wanted to see the the count of products by location included in the Units Sold account, you add this calculation to review the variation of products sold by location. It is just another option.
Hope this helps.
Petar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is a new feature that helps with this too. Select Create Measure-->Aggregation--> Count Dimension. It will do the count you are looking for.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks. In my planning solution I´m using a quite high number of accounts. If I want to validate the number of records I´d always need to create a measure with Aggregation/Count Dimension which causes efforts.
Is there a simplier way just to get the number of records per account?
Regards,
Thomas
Hi Steve,
Did you get an answer to this? Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for coming to SAP Community for answers. Please post your question as a new question here:
https://answers.sap.com/questions/ask.html Since you're new in asking questions here, check out our tutorial about asking and answering questions (if you haven't already), as it provides tips for preparing questions more effectively, that draw responses from our members. Please note, that your post here won't be answered.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.