ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Transform Pivot - Rotate Column Headers Hi DRay - we dont have an account team. We're a customer of a 3rd party that uses Sisense as its analytics option within the system we have procured. We have a "builder license" and can create our own visuals etc. but I think anything wider than that (such as having an account team etc.) isnt something we have. I have raised a ticket with our vendor instead and asked if they can support with the code needed. Regards, Simon Re: Transform Pivot - Rotate Column Headers Hi DRay Apologies for the delay. I have just tried that but unfortunately get an "Access Denied" message: Regards, Simon Re: Transform Pivot - Rotate Column Headers Thanks DRay - apologies but i'm not sure how to open a support case i'm afraid. Are you able to advise? Re: Transform Pivot - Rotate Column Headers Hi DRay , thanks for your reply. Unfortunately that hasn't worked for me. Have applied but the hospital names within the pivot table below have remained the same I'm afraid. Transform Pivot - Rotate Column Headers Hi All, Is there any widget level code that would rotate column headers so that they can be displayed similar to the below: I have found various bits of script code online but these seem to relate more to changing font colours etc. Any help would be greatly appreciated! Regards, Simon Re: If Statement within Advanced Filters? Hi DRay - that would be hugely beneficial and appreciated, thanks Re: If Statement within Advanced Filters? Thanks AssafHanina, DRay - apologies for the delay, I'm still looking at how I can implement this at my side. Re: If Statement within Advanced Filters? Hi AssafHanina , Thanks for your reply and solution. I am trying to understand how this would work for me (as my understanding of Sisense is still of a relative beginner). Do I need to add a date filter as you've suggested - like so: And then the code will automatically change this to 1 or 3 days based upon a dashboard refresh (which is set to daily) ? Regards, Simon If Statement within Advanced Filters? Hi All, First time posting here and hoping for some advice around advanced filters if possible please. I currently have this filter which gives me results based upon the previous createddatetime: Unfortunately, this scenario is not always relevant - due to some departments being closed at weekends, there is nothing displayed when the report is ran on a Monday morning. Is there any way of applying IF logic within advanced for the following scenario? If dayoftheweek = 1 (i.e. Monday) count: 3, offset: 1 else count:1, offset: 1 Effectively, I want to show Friday, Saturday & Sunday data when the current dayoftheweek is Monday, otherwise I just want the previous days data. I've had a search around the knowledge base but couldn't find anything (however i'm relatively new to Sisense so it might just be that I've not understood what some of the forum posts meant!) Any help greatly appreciated. Regards, Simon