Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Could you ask the question in English maybe? More people can help!
Jordy
Climber
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
Try with a quick fix in the date field like:
[Journal Creation Date Time] = {"$(=Date( min ([Journal Creation Date Time])))"},
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'))"},