Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a distribution plot with the informaction of today for default,update to the current time, the problem is that filtering by day does not show anything. I want to show the information of the selected day and by default the information of the current date.
On the y axis are the channels and on x axis the hour (only number without format). Measure if there were spots at the given time.
The dimension: if([AJTV_Fecha.autoCalendar.Date]=today(),AJTV_Hora)
y axis: if(SOPO_Abrev='TC' OR SOPO_Abrev='RED' OR SOPO_Abrev='TVN' OR SOPO_Abrev='MEGA' OR SOPO_Abrev='CHV' OR SOPO_Abrev='UC13' OR SOPO_Abrev='TV+',SOPO_Abrev)
(I do not think it's necessary, just filter some channels)
x axis: AJTV_Hora
I Attach images. thanks.
Your dimension is limiting to only today(). If you select an earlier day, there will be no match. What you want is the selected day or current day if no selection. A simple way to do that is filter to the max(date):
if([AJTV_Fecha.autoCalendar.Date]=max([AJTV_Fecha.autoCalendar.Date]),AJTV_Hora)
or better yet, use [AJTV_Fecha.autoCalendar.Date] as the dimension and use set analysis in the expression.
-Rob
Can you post a small qvf sample?
OK, is only the distribution plot and date range picker extension.