user016969

In the absence of other solution, through mysql I added a static column in table to store the total number of unique records and using that value in beast mode.

in Calculating total against subtotal Comment by user016969 September 2020

That's giving 0%

in Calculating total against subtotal Comment by user016969 September 2020

That is giving me 100% for all rows. I added a column just for the beast mode sum(count(distinct ID) over (partition by ID) and it gives same # as condition count.

in Calculating total against subtotal Comment by user016969 September 2020

ok, now I understand. Thank you! yes it worked!

in Table Subtotal not calculating beast mode Comment by user016969 June 2020

May be I should clarify that the 'Total' records are calculated using 'Subtotal' chart property and Sub vs. Issued is a beast mode calc. Original data is as follows: YearSourceSubmission CountIssued Count2016A96122016B14505172017A74192017B1962703 After beast mode addition it is - YearSourceSubmission CountIssued CountSub…

in Table Subtotal not calculating beast mode Comment by user016969 June 2020

Thanks but 'Subtotal' record should perform that logic. I removed all case statement and simply made the beast mode with 'Issued count / submission count'. Still, subtotal record does not calculate this baest mode and simply adds values. e.g. 2016 Total record should calculate 529/1546, but what it does is 13 (% of A) + 36…

in Table Subtotal not calculating beast mode Comment by user016969 June 2020

Hi, My beast mode calc is - case when `Year` != YEAR(CURDATE()) then (`Issued Count`/ 12) / (`Submission Count`/ 12) else (`Issued Count`/ MONTH(CURDATE()))/ (`Submission Count`/ MONTH(CURDATE())) end

in Table Subtotal not calculating beast mode Comment by user016969 June 2020

user016969 Member

Comments