Hello! I’m building a dashboard based on a unx universe.
The dashboard tool doesn’t seem to group items like a webi report.
I need to count the rows with a flag of ‘Y’ or ‘N’ and then get the %:
Y / (Y+N)
I need to be able to use that % formula on groups/filters I.E. Program or Sub-Program, Fiscal Week #, etc. Tried using a case statement in the universe and the dashboard separates the rows each time.
Tried a decode in the view to convert the Y to 1 and N to 0 and then aggregate, but to no avail. It seems to work in a webi report. No matter what I do in the universe, the dashboard tool is being stubborn.
Thank you for any help or thoughts!
switchfire (BOB member since 2017-12-13)