Aggregation and grouping in Dashboards

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)

Kind of figured it out. Although the function on my fields was set to “Sum”, the dashboard tool didn’t recognize it and was separating each line.

I added sum([decoded field]) to the two fields and I’m getting aggregated info now in dashboard.

Maybe this will help someone else.


switchfire (BOB member since 2017-12-13)

Might have been the difference between SQL Aggregation versus Projection in the universe,

Andreas :de: (BOB member since 2002-06-20)