Good afternoon everyone, comparing between 2 data (league index and total hours)
How do you categorise and filter a specific value? E.g i want to take out any number of league index that has spent a total of 800 hours and ABOVE, while letting people know that what the numbers are in league index that spent over 800 hours and above.(see photo for example)
If by total you mean sum of all the “TotalHours” values for each “LeagueIndex” value, then you have to use a GroupBy node and group the rows based on “LeageueIndex” and use “Sum” aggregation on “TotalHours”. After that use a Rule Engine node to label the records which exceeds 800 in sum of TotalHours.
But if by total you mean the current value in TotalHour column, then just use a Rule Engine node and label the rows with the value equal or higher than 800.
Thank you so much for the prompt reply! I have tried it out and it worked. However, Is there a node i can visually display each “league index” comparing whether are they above 800 hours or below 800 hours?
Also , i have 3341 rows , but it’s only displaying 500. Issit adjustable in the settings?