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.

Aathithya Kuppusamy Jan 24, 2019 11:47 PM

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.

Please Help!

(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.

Ken Flerlage Jan 25, 2019 9:41 AM (in response to Aathithya Kuppusamy)

Could you create a mockup of the workbook and attach that?
Like Show 0 Likes(0)

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

Aathithya Kuppusamy Jan 27, 2019 11:03 PM (in response to Ken Flerlage)
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

Upload.twbx 334.7 KB
Like Show 0 Likes(0)

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

Aathithya Kuppusamy Feb 3, 2019 11:19 PM (in response to Aathithya Kuppusamy)

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!

1) In Below Image, All the Required fields are there.
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
Like Show 1 Likes(1)

Actions