Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a small Issue while writing Set Analysis
This is My exp displayed in KPI Object
Avg({<ReferenceDate={'EDACloseCompleteDate'},EffortType={'Research/POC'}>}DataWranglingDays)+
Avg({<ReferenceDate={'ETCloseCompleteDate'},EffortType={'Build'}>}[EDA-GovDays]) +
AVG({<ReferenceDate={'POC-BuildDecisionDate'},EffortType={'Build'}>}[POC-BuildDays])
I am summing up all the Avg Days, but what the issue if due to filter if any column doesn't meet the selection it is Showing blank. but other two i have values. I would want to display Values of Others if one is not meeting the criteria of selection on Front end.
Let me know how to correct the expression.
Thanks
Ravi
Try it with: rangesum(avg1, avg2, avg3) instead of: avg1 + avg2 + avg3.
- Marcus
expression looks good try to make as suppurate and see which one has problem
try use = before expression and use open close for each expression
Try it with: rangesum(avg1, avg2, avg3) instead of: avg1 + avg2 + avg3.
- Marcus
Thanks Markus. This Worked