Using Set Analysis for 2 Fields

[microwin88x]

Hello!

I have a line chart with the following expression:

COUNT ({$<ID_DATE#={">=$(='$(vDateFrom')<=$(='$(vDateTo)')"}>} DISTINCT TD_ENTRY_ID)

Where it counts # Tasks in my app for a Date range from a calendar.

That works ok, but now I need to include another filter for that set analysis expression:

CATEGORY should be equal to 'Payment'.

How could I do that, in order to consider the filter for ID_DATE and then also the CATEGORY filter?

Thank you!!!

[jerem1234 · Accepted solution]

separate it with a comma in the set analysis like:

COUNT ({$<ID_DATE#={">=$(='$(vDateFrom')<=$(='$(vDateTo)')"}, CATEGORY = {'Payment'}>} DISTINCT TD_ENTRY_ID)

Hope this helps!

[microwin88x]

Excelent! It worked! Thanks!