How to extract date when sales value reach exactly 100k?

[anindya_manna]

Hello Experts,

I am creating a chart with the columns id ,name ,sales,100K break date.I want to show id and names whose sells more than or equal to 100k and also the aook break date in which it exactly touch 100k milestone.

How to do it in a single table?

[Anonymous]

Hi,

try with below two expressions.

Expression1: If(Sum(Sales) >= 100000 , [Date Field])

Expression1: Concat(DISTINCT if(Sum(Sales) >= 100000, [Date Field]),',')

Thanks,

Venkata Sreekanth

[anindya_manna]

Yes able to get it.

But instead of previous function if there is any alternative way then please help me.

Table may not be always sorted in that case previous will not work.

[anindya_manna · Accepted solution]

Yes able to get it.

date(aggr(Min({<[New_Sales]={">=1000"}>}[Process Date]),Name,ID))

But instead of previous function if there is any alternative way then please help me.

Table may not be always sorted in that case previous will not work.

[jyothish8807]

You can use order by name, date in the script. Then you can use previous function