Set analysis

[François]

Bonjour,

je cherche à compter le nombre de [JOURNAL - content_thread_id]
selon le 1er évènement[Journal Creation Date Time], [JOURNAL - name]={'task.created'},
la dimension étant [JOURNAL - category_name]
Dans l'exemple ci dessous, je veux compter uniquement 1 thread Id dans la catégorie Front Office Externe

L'expression ci-dessous affiche, les 3 évènements task.created
count({<[Source Type]={'Twitter'},
[Journal Creation Date Time]={"=min([Journal Creation Date Time])"},
[JOURNAL - name]={'task.created'},
[JOURNAL - category_name]={'*Office*'}>} DISTINCT [JOURNAL - content_thread_id])

EN vous remerciant

[JordyWegman]

Hi,

Could you ask the question in English maybe? More people can help!

Jordy

Climber

[François]

Hello,

I'm trying to count the number of [JOURNAL - content_thread_id]
according to the 1st event [Journal Creation Date Time], [JOURNAL - name] = {'task.created'},
the dimension being [JOURNAL - category_name]
In the example below, I want to count only 1 thread Id in the External Front Office category

The expression below displays the 3 task.created events
count ({<[Source Type] = {'Twitter'},
[Journal Creation Date Time] = {"= min ([Journal Creation Date Time])"},
[JOURNAL - name] = {'task.created'},
[JOURNAL - category_name] = {'* Office *'}>} DISTINCT [JOURNAL - content_thread_id])

THANKING YOU

[tresesco]

Try with a quick fix in the date field like:

[Journal Creation Date Time] = {"$(=Date( min ([Journal Creation Date Time])))"},

[François]

Thank You @tresesco 

but the solution is not available.

3 result with my expression, none with yours

[tresesco]

Try putting the same date format as your field [Journal Creation Date Time] in the set as well, like:

[Journal Creation Date Time] = {"$(=Date( min ([Journal Creation Date Time]), 'FieldDateFormat'))"},