Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to show text in near by this Value ?
I used Expression
Complete : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))/RangeSum(Above( ( Count(distinct [Release Name]) ) , 0, RowNo()))
& Total Count : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))
Example :
Total Count :80 & Complete: 100%
Thanks in Advance
I used Expression
Percentage : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))/RangeSum(Above( ( Count(distinct [Release Name]) ) , 0, RowNo()))
& Total Count : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))
Hi,
For a sample model table like this:
LOAD * INLINE [
record, count, percentage
1, 80, 100
2, 90, 100
3, 45, 80
];
You can use "record" as dimension, and aggr(Dual('Total Count: ' & sum(count) & ' & Complete: ' & Sum(percentage),Sum(percentage)),record) as your measure. After that, you must change number formatting as measure expression.
Then, you achive a chart like this:
I used Expression
Percentage : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))/RangeSum(Above( ( Count(distinct [Release Name]) ) , 0, RowNo()))
& Total Count : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))
Sorry, I had forgotten to add change of number formatting in measure settings. I added number formatting in original reply post.