CASE WHEN {item.custitem_tss_inventory_rank} = 'Ne...
# suiteql
j
CASE WHEN {item.custitem_tss_inventory_rank} = 'New' THEN count /*comment*/ (distinct{item}) over (partition by {name}) END
w
Maybe something like this
Copy code
count(distinct case when {item.custitem_tss_inventory_rank} = 'New' THEN {item.id} Else null End)
And this channel is mostly related to SuiteQL, not saved searches. I think #C2A1ZEMF0 is for more general questions
j
Yeah sorry about that i didnt see a channel for saved searches.