Hello everyone.. I'm working on an application which runs on some conditions as below:
Project_Status: 'Active'
at_feedback_rating_id <> 0
MaxCsatDate = at_csat_received_date (where MaxCsatDate is max(at_csat_received_date ))
project id <> 0
1) if the above conditions dont match, the result would be '0.00% from 0 projects'
2) if the above conditions do match, the average of rating and count of projects ids should also fulfilled the mentioned conditions while calculating KPI.
--------------------------------------------------------------------------------------------------------------------------------------------
Error I'm facing with this KPI syntax:
if(GetPossibleCount (at_projectid) =0 , '0.00% from 0 Projects',
repeat(chr(160),6) & if(GetPossibleCount(at_feedback_rating_id) = 0,'0.00%',
Num((Avg (If([project_status]= 'Active' and MaxCsatDate = at_csat_received_date, at_feedback_rating_id))/
max({1} total at_feedback_rating_id)) , '#0.00%')) & ' from ' &
count({<[project_status]= {'Active'},at_feedback_rating_id = {">0"}, MatchDate = {1} >} distinct at_projectid)
& ' Projects' & repeat(chr(160),6))
