Forum Discussion
Get count in filtered context
- 2 years ago
Thank you
- some_bih2 years ago
Community Champion
Hi Mahmed1 check file version v2 for part occurance
For 16.12.2023 according to table there is only one row of entry
- Mahmed12 years ago
Helper IV
Thank you for getting back to me
it doesnt quite work but think its on the same lines
for eg
say Blueberry category on the
06/11 had a length of 13 twice so
06/11 13 Blueberry
06/11 13 Blueberry
and the parameter had 15 selected
the result in this case as the max is 13 will return a blank but its actually 26 the total length so should return a 1
i get rather than the max in needs to look at the sum for that category and then compare it
do i just need to change to Sum from Max?
- Mahmed12 years ago
Helper IV
Hey
even if i change to sumx or sum and comare that value against parameter i get incorrect result
It ahould check for total length per day for that category and then compare
so if i had 2 rows on 01/11 both 9 mins each (18 mins total) comparing against 15 mins in parameter box, that ahould be 1
If exactly the same on 02/11 then that would be another 1 so in total 2 occurences for both days
- Mahmed12 years ago
Helper IV
Hey - For eg see this example file - tried amending with new data but used same measure you created
- some_bih2 years ago
Community Champion