This content has been marked as final. Show 3 replies
This was my question from a couple of years ago, and I'm bringing it up again because I'm running into the same issue. Maybe since then someone has run into the same issue or has some insight...?
Still the same version as before (Discoverer Desktop 10.1.2.2). On the worksheet I'm dealing with now, the items I'm hoping to sum are all based on calculations similar to this (at the detail level):
item: "A Grades" - Calculation: case when student_grade like 'A%' then 1 else 0 end
item: "B Grades" - Calculation: case when student_grade like 'B%' then 1 else 0 end
... and so on - basically I want to get a sum of all A+/A/A- grades, of all B+/B/B- grades, etc.
I can create totals for the individual calculations, but the "All Data Points" option is missing. I'm wondering if it doesn't consider the items to be data points, for some reason. (There are no "data points", as defined in Admin, among the other items I'm selecting - just "top".)
This is not a show-stopper, since I can create the totals individually, just wondering if there's something I can do differently in the calculation to make it a "Data Point".
Edited by: mrigg on Aug 1, 2012 12:41 PM
to correct typo in "B Grades" calc.
You will only have the "All Data Points" option when creating a new total if there is a data point in the report. Unlike a crosstab report where you can drag an item into the crosstab table to make it a data point, in the table report there is no way to tell Discoverer that a calculation is a data point.
Items (including calculated items) in a folder can be changed to be a data point by changing the default position property to "Data point" using Disco Administrator. If you add a data point item into the report then the "All Data Points" option will be available.
Also you can trick Discoverer into using a calculation as a data point by using an aggregate function e.g. sum(case when student_grade like 'A%' then 1 else 0 end), but Discoverer will then use a group by in the query and this may give you a different result.
Thanks, Rod, that confirms what I'm seeing as well. I later made some updates to the sheet I was referring to - users decided they only wanted summaries, not detail - so I created calculations with "sum" like your example. Sure enough, I had the "all data points" option for totals. Minor mystery solved, I guess.