Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show bottom 5 in the bar chart excluding zero values.
My expression is : Total expenses/total budget *100
I found this Showing Top 5 and Bottom 5 on Bar Chart which shows bottom and top excluding zero.
But i am little bit confuse while using my logic with the given logic in the link.
Please help me with this issue..
Its urgent...
Regards,
Kavita
Try this expression:
(sum({<Location={"=rank(-
(sum({<Location={`=sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)>0`},LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)/
sum({<Location={`=sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)>0`},LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}[Op.Bal]))
)<6"},LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)/
sum({<Location={"=rank(-
(sum({<Location={`=sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)>0`},LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)/
sum({<Location={`=sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)>0`},LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}[Op.Bal]))
)<6"},LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}[Op.Bal]))
HI
Can you post a sample data?
uncheck Show Zero values at expression tab.
It might help.
Yes...
PFA !
There's no such option in expression tab
Check at Presentation Tab, Suppress Zero-Values option
Can u pls check the sample data...
I already checkd those options
Hi,
may be
If(Rank((sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)/
sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}[Op.Bal]))) <= 5,
(sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)/
sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}[Op.Bal])))