
1. Re: Aggregate Values
Joe Mako Oct 11, 2011 6:06 AM (in response to Markus Schreiner)your description seems to match the workbook you attached. I am unable to discern what you want instead.
what would you like for a result? can you provide a mockup?

2. Re: Aggregate Values
Markus Schreiner Oct 11, 2011 7:21 AM (in response to Markus Schreiner)I would like to have also the xaxis counted. So how many categories have the hight of e.g. 2 (in this case 2  A and B), how many categories have the height of 1 (in this case 1  C) and so on.

3. Re: Aggregate Values
Joe Mako Oct 11, 2011 7:48 AM (in response to Markus Schreiner)how about the attached?
a custom table calc of:
IF FIRST()==0 THEN WINDOW_SUM(AVG([Number of Records]),0,IIF(FIRST()==0,LAST(),0)) END
using "Raw" for its compute using, and "amount of articles" not ignored in table calcs.

articlesraws_edit.twbx 22.9 KB


4. Re: Aggregate Values
Markus Schreiner Oct 13, 2011 2:04 AM (in response to Markus Schreiner)This looks perfect, but I don't get the cumulative percentage line incorporated in the graph. In theory the calculation for this should be sum of column/total amount of datasets and this summarized with the result from the previous column.
The formula should be something like: running_sum([amount of articles] / TOTAL([amount of articles]))
But it displays exactly the same as in your formula.
What did I wrong and what do I need to adapt in order to get a cumulative percentage line over the columns.
Thank you

5. Re: Aggregate Values
Joe Mako Oct 13, 2011 4:30 AM (in response to Markus Schreiner)that would be a little more involved, as in the attached.

articlesraws_edit_v2.twbx 37.8 KB


6. Re: Aggregate Values
Markus Schreiner Oct 13, 2011 7:07 AM (in response to Markus Schreiner)Thank you for the quick response. This looks perfectly as I wanted to have this visual. As I was trying to do exactly the same thing with using the same calculation in another sheet, I got a different result. What did I do wrong?
Thank you for your patient and kind support

testdata.zip 40.7 KB


7. Re: Aggregate Values
Joe Mako Oct 13, 2011 8:23 AM (in response to Markus Schreiner)please save as a packaged workbook (.twbx) before attaching. you did not include your data.

8. Re: Aggregate Values
Markus Schreiner Oct 13, 2011 11:54 PM (in response to Markus Schreiner)sorry for that. Attached please find the full workbook. Thank you for your help.

articlesraws_edit_v2.twbx 52.0 KB


9. Re: Aggregate Values
Joe Mako Oct 14, 2011 6:24 AM (in response to Markus Schreiner)Just one minor detail, from your attached workbook, perform the following:
1. remove the pill "Last of Amount" from the Filter shelf
2. ctrldragndrop the pill "Last of Amount" from the Level of Detail shelf onto the Filter shelf (this creates a copy of the pill, retaining the compute using setting)
3. keep only when True

10. Re: Aggregate Values
Markus Schreiner Oct 17, 2011 2:37 AM (in response to Markus Schreiner)Thank you for the tip. This one I understood now. I am trying to perform the same calculation on a slightly extended database, but I think the calculation of the running percentage is not the right one. Within the tab "Running Percentage" you can see each part of the Running Percentage calculation as singular graph. I was expecting to have the following values for column 1,2 and 3 as running percentage: 0,25; 0,5; 1
Which means I would need the hight of each column (example column 1: result: 1) and the total hight of the table (result 4). The result of each column as running sum.
But I can not find any function for giving back the grand total (hights summarized of each column) and take this in consideration on above calculation.
Do you have any idea?
Thank you

articlesraws_edit_v3.twbx 69.6 KB


11. Re: Aggregate Values
Markus Schreiner Oct 17, 2011 6:45 AM (in response to Markus Schreiner)Trying different kind of calculation I came up with this formula for calculating the percentage for each column:
[Count of Amount]/(Last()First()+1)
When using bars as visualisation it looks good, so 0,25 in column 1, 0,25 in column 2 and 0,5 in column 3. But changing it to a line messes it up again. And I also struggle with cumulating each column percentage  So from left to wright.
Is the formula wrong and what's the solution for the cumulative percentage?
Thank you

12. Re: Aggregate Values
Markus Schreiner Oct 18, 2011 7:39 AM (in response to Markus Schreiner)does somenone has an idea on how to cumulate the calculated percentage and transform it to a line graph?
Thank you

articlesraws_edit_v3.twbx 70.6 KB


13. Re: Aggregate Values
Joe Mako Oct 23, 2011 8:29 PM (in response to Markus Schreiner)I am not sure what you are looking for as a result. Can you please mock up or detail the numbers that you expect as a result?

14. Re: Aggregate Values
Markus Schreiner Oct 25, 2011 12:03 AM (in response to Markus Schreiner)I would like to see a graph from left to right, which cumulates the percentages. So for column 1 it would start with 0,25 (equals value of "Count of amount"/total of "Count of Amount"). The next point in the graph would be in column 2 with 0,5 (equals 0,25 of column 1 + 0,25 of column 2) and the last point in this visual would be 1 (equals result from column 2  0,5 + 0,5 from column 3). You can see the precentages calculated with the measure "Percentage" in the row section.