Forum Discussion

jirazazabal's avatar
jirazazabal
Cloud Apps
08-11-2022

How to limit the values showed without altering values?

Hi, We have some scenarios when we need to calculate some metrics based on all the history. For example, contribution and more. We need to include several data to get the right value. But, for exam...
dashboards & reporting
jirazazabal's avatar
jirazazabal
Cloud Apps
08-11-2022

Two metrics:

YTDSum([Total Bin_Suscrip_Act_Instal (1)])

Contribution([Valor (1)])

 

harikm007's avatar
harikm007
Data Warehouse
08-11-2022

Here, instead of using 'Contribution' function, try calculating the contribution by using division operator:

If the formula is 'Contribution(SUM([Valor (1)]))', change it to :

SUM([Valor (1)])/(SUM([Valor (1)]), ALL([Date]))

-Hari