User Profile
LadaA
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Showing the Max of the Sum of a 12x24 Matrix in a Card (With Data and Examples)
Hi everyone, I am trying to make a card that displays the current max of the sums showed in a 12x24 matrix table. I have a 12x24 matrix that is made up of LB Produced by different farms broken down by the hour over the course of 12 months. The production of a farm is the same for every day in any given month. The data table is formated as the following: - Repeating for every HR (24) and Farm Farm HR Month LB Produced A 1 Jan 42 A 1 Feb 41 A 1 Mar 43 A 1 Apr 44 A 1 May 44 A 1 Jun 47 A 1 Jul 48 A 1 Aug 49 A 1 Sep 49 A 1 Oct 44 A 1 Nov 43 A 1 Dec 41 A 2 Jan 41 A 2 Feb 40 A 2 Mar 42 A 2 Apr 43 A 2 May 44 A 2 Jun 46 A 2 Jul 47 A 2 Aug 48 A 2 Sep 48 A 2 Oct 43 A 2 Nov 42 A 2 Dec 40 Currently my card that displays the peak hour of production between June-Sep will show the highest production out of all the individual farms rather than the highest hour of all the farms combine. Example: Farms A&B&C selected: If I wanted to get it to display the highest peak HR between the months of June-Sep of the following matrix the expected result would be a Peak of 241.8 for July hr 16 Farm A&B matrix: Expected result - Peaks at 155.6 for July HR 16 Farm A&C matrix: Expected result - 147.9 August HR 16 Farm A matrix: Expected result - Peaks at 60.8 August HR 18 Farm B Matrix: Expected result - Peaks at 96.4 July HR 16 Matrix C: Expected result - Peaks at 87.6 August HR 16 Any help would be greatly appreciated and thank you for your time!
