Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can I obtain the number of store_id by month (startMonth and endmonth)
example :
Month startMonth EndMonth
1 XXXX xxxx
2 XXXX XXXX
...
12 XXXX XXXX
Thank you for your help.
See attached qvw
Thank you Gysbert!
Hi Gysbert.
My (wrong) logic was like this
=COUNT({<CALENDAR_SITE_DTM="$(=DATE(MAX(CALENDAR_SITE_DTM),'DD/MM/YYYY'))"}>}DISTINCT(PUDO_ID))
Would you mind to tell why this does not work?
I assumed that the =DATE(... will return the MAX day and the whole expression the correct number
The set of a set analysis expression is calculated at the chart level, not at row level. Your expression will create a set with only the maximum possible date. You'd see a result only for the last month.
SO in your formula the agrr function is taking the formula to row level?
Why did you use FirstSortedValue?
Thank you for your time.
See these tutorials: