Wonderful, it was this one.  ... View more

I sam. More or less. I know that I can use custom category. But these categories are always the same.  I read a post that allowed creating intervals dynamically using calculations. For example, I could specify that I wanted a step of 5, and it would automatically create categories like 0-5, 5-10, and so on. But I can't find this post anymore ... View more

Thanks,   I did it but it doesn't match     ... View more

Hi Madely, thanks for your first answer.   To answer this question, I have 2 separate reports. The user chooses from a drop-down list what he wants to see in report 1. Let's imagine it's eye color, for example. In Report 1, I've added a shortcut to Report 2 to go further. Now, when the user goes to report 2 (which is fed from another source) but which also includes the eye color field, he has to choose again from the list. What I'd like is for the user not to have to select again, and for report 2 to be filtered automatically on opening with the choice of report 1. I hope this is clearer   ... View more

A parralel Question. INTCK is perfect with weekday but it take the saturday and sunday. When i put the table on WORK, I can use INTCK("WEEKDAY1W",(DATEPART(Date1)),(DATEPART(date2))) and it works and it only remove the sunday. But when i change and i work on CAS. It's KO.    Is it normal?   ... View more

Not Clearly. My target is to do the same thing as INTCK but by using Existing formula.   ... View more

Excuse me for the delay and thank you for your answer. I know that a can use INTCK on a program or on a flow. But my data table is already here. I want to calculate a delay in days between two date without the saturday ou sunday for example. Only working days.  But i need or want to know if we can do it by using only Calculated items (and formula) in visual analytics. ... View more

thanks 🙂 It's a french word. It's a a day where our company don't work like esater or christmas. I already use intck in sas studio but i want tu find a solution on visual analytics with the existing formula ... View more

Perfect, it's good. Thanks.  Last question, i don't see the table on a the caslib when i try to find it on sas visual analytics. I think that i have to promote it but i don't kow how to write it correctly at the end at my program.   Happy new year !! ... View more