Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator III

%

Hi Community,

I had already had to make a relationship between a total (automatically calculated) and value.

I seem to have used the function dimentionality but can't remember how to apply it.

Could you help me?

Example:

Total (automatically calculated = 177

Value (count([PROGRESSIVO SEGNALAZIONE]) = 115

Fornula: Count([PROGRESSIVO SEGNALAZIONE]/ TOTAL and rapresent the result as a percentage

Immagine.png

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

to calculate share you can use this

count([PROGRESSIVO SEGNALAZIONE])/count(TOTAL [PROGRESSIVO SEGNALAZIONE])

sunny_talwar

Or may be this:

Count([PROGRESSIVO SEGNALAZIONE])/Count(TOTAL <PRIORITY> [PROGRESSIVO SEGNALAZIONE])

Read about The Aggregation Scope