3 Replies Latest reply on Feb 3, 2019 11:19 PM by Aathithya Kuppusamy

# Need Individual Row count of Running Total, Where Value is Lesser than 50.

Hi friends,

As you see below, I have fields such as 1)Test Name, 2)Rank, 3)Duration, 4)Running Total of Duration and a 5)Calculated field which shows '1' for Running Total less than '50' and '0' for Rest.

(I am Rounding the Running total decimal value in Calculation 1).

I Only need to Display the Count of Rows which has Value '1' in the 'Calculation 1', in a single Page.

But if i drag only Calculation 1 on the Page, it is only showing '0' as it is taking Overall Running Total value.

I am Unable to use LOD's as the Running Total is an aggregated measure.

(Sorry for not attaching workbook as my employer don't encourage that.)

Regards

~Aathithya.

• ###### 1. Re: Need Individual Row count of Running Total, Where Value is Lesser than 50.

Could you create a mockup of the workbook and attach that?

• ###### 2. Re: Need Individual Row count of Running Total, Where Value is Lesser than 50.

Hi Ken,

Please refer to the attached workbook.

I need to display the number of rows which returns value '1' on Calculation 1.

Regards

~Aathithya

• ###### 3. Re: Need Individual Row count of Running Total, Where Value is Lesser than 50.

Hi,

So 'Calculation 1' is showing value '1' for Running Total Value less than 50, and value '0' for rest.

If we need the Count of rows where the value is '1' in 'Calculation 1', we just need to SUM the 'Calculation 1'.

Here's a Trick!

2)Create a Calculated Field as Below.

3)Keep 'Solution' in Detail. And Add it to the 'Title'.

(As this calculated field requires few fields in the view, i am adding it to the Title)

4)Now you got the Required Answer in the 'Title'.

5)Remove all fields except Test Name and Uncheck 'Show Header'. Change the Mark type to Polygon.

6)Set the Page to Entire View & it is ready to Display in Dashboard.

Done!

1 of 1 people found this helpful