I have a barchart with Days on X axis but this day is calculatet on a booking date showing days in future. I would like til show max of today() on the axis. I have tried to do this in the script without, did not work. Now I have generatet a variable $(vMaxViewDay) wich i based on today(). I have tried to make a if condition combined with Set Analysis but not getting this right. Anyone who can assist me.
if(booking_Day>$(MaxViewDay),count(Distinct{<Booking_Day={'$(vMaxViewDay)'}>}D__ADBConnected_Device_Ser_No) I now this is not working and Iam seeking a possibility to make this better.
