Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
agastya
Creator
Creator

Count over aggr (in text object)

hello all  as you seen in screenshot x handled in UI level i.e Row no(Total) need to handle ever calculation in UI i want X  total count in Text object like if(Len(year)>0,count(Month)) in text object 18 count is refelecting

thanks in advance@

Capture1.PNG

2 Replies
Chanty4u
MVP
MVP

Not sure can you explain with your sample qvw?  or 

sample data with expected output you want to see?

Anil_Babu_Samineni

May be this? If you are expecting 17 in your KPI, Please use this?

count({<year = {"=Len(year)>0"}>} Month)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful