-
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?
-
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
-
-
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)1 of 1 people found this helpfulHi,
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!