BusinessObjects Board

How to create a % avg reports in BI? do i need to create a formula if yes how to create a fromule to generate rep

building reports
#1

i need to generate reports on % Completed or % Canceled Contracts .

#2

If you have detailed data with individual rows tagged as complete or canceled, you will first need to create variables to calculate the total number of complete orders and the total number of canceled orders. Then divide each of those by the total number of orders to get your percentages.

1 Like
#3

how to tag a row?can you guide on this

#4

You would need to have a field(s) in your dataset that identifies the row as complete or canceled. It could be a status field, date field or anything that differentiates and tells you which it is.

1 Like
#5

If([Engt Candidate Disposition Status] InList(“Disengaged-Good”;“Disengaged-Hired”); “Good”;“Bad”)
after this i want to count how many disengaged good - how to count

#6

some logic like below at row level

if condition_true then 1 else 0

You can sum this to get totals and use that as a divisor to get averages

#7

how to put a else condition on above quary

#8

count( [Unique ID Field Name] ) where( [Engt Candidate Disposition Status] InList( “Disengaged-Good” ; “Disengaged-Hired” ) )

1 Like