on 07-27-2020 7:34 AM
I made a calculation on a story where I'm dividing a number to its total (occupancy rate for hr dashboard). Due to the nature of the model, the only way to achieve this is by adding a calculation on the story. (I tried adding values to the modeler but unsuccessful) I'm expecting it to be displayed as a percentage but I cannot click on it:
Any help is appreciated. Thank you!
Hi Denisse,
Sorry I saw your rev 2 later. Uncheck the option of "Use Unit of underlying measures" and that should do the trick.
Regards
Afshin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Denisse,
May I ask why you were unable to create this calculation in the model?
Kind regards,
Martijn van Foeken | Interdobs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Martijn,
After numerous trials, I was able to do so BUT the percentage value only displays on the story if another measure (which it is depending on to and also part of its calculation) is also selected as a measure on the same chart. I think there's something wrong in my calculation even though I didn't put any category under the "Required Dimensions" column on the Modeler.
I'll try to check it again.
Regards,
Denisse
Hi Denisse,
A screenshot would help resolve a lot quicker, you can show decimals by selecting the measure in builder and you can then set the precision as per the attachment decimals.png
Regards
Afshin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.