ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: How to add two (or more) Target/Benchmark lines to a chart? Can I use a field from my datasource in line chart as the base line value? Re: Last Weekday in filter a board Hi DRay , I tried the solution and it works as I wanted. Thanks for the help. Last Weekday in filter a board Hi, We send daily reports in the form of pdf (of dashboards) to our client. We do it in the automated way, for that we use DateTime field as filter and using "Time Frame". Right now, we use "Yesterday" as a filter (see ss) checking day at the script level to not send report on Sun-Mon (respectively for Sat-Sun data). Can we have "Last Weekday" in here or a piece of code I can put in Advanced Filters which can give me Last Weekday. (Mon to Fri). It will be great help, if we can have something like that. Thanks, Animesh SolvedGradient Conditional Formatting In Pivot Tables Gradient Conditional Formatting In Pivot Tables I found this article in Sisense Community, and I want to replicate the same for a pivot table as given in the post . But I was informed we can't do this in the latest version of Sisense. Can we somehow still replicate this? Basically, requirement is to highlight max & min values of a particular column. Thanks, Animesh Re: Gradient Conditional Formatting In Pivot Tables Sure DRay , I would be helpful if you could. I will also post that question in forum. Thanks Re: Gradient Conditional Formatting In Pivot Tables Hi intapiuser , This code is not working for me. I checked that data bars are on. Also, just in case I tried making the structure of table same as yours but still it didn't work. Can you please help me? Thanks Naming Convention of Combined sheet sent via Report Manager with Filters on it. When we send more than one Combined Excel Report while using a dashboard having different filters on it. Names of those combined Excel sheet we get from them is same as they were using same dashboard for creating a report, which is difficult to identify when downloaded simultaneously. Can we base the name of excel sheet on Report Name itself rather than dashboard name as it will be more convenient. Thanks, Animesh Gupta Re: Input Parameters using BloX for What-If Analysis Hi Trie, When I am using your BLoX rather than my BLoX for displaying and performing action, it is not refreshing even after refreshing. Can you please tell me the reason for this. Does BLoX widget has some hidden settings? Also, I wanted to know how to create those [swap_lever]. I thought they were shared formulas, but they are working with cubes which don't have [swap_lever] saved as shared formula. Thanks Re: Input Parameters using BloX for What-If Analysis Hi Tri, thanks for the response, Yes, I have added swap_lever as a formula in BLoX widget. I suspect that, we have added the code to add outlier filter on dashboard using the same action in which we are doing this swap_lever value change, maybe that's why it is not fully functional. It is working on the board provided in the post. Re: Input Parameters using BloX for What-If Analysis Hi, Thanks for this article I am able to create it. But as you claim that it will not lose values even after refreshing the page. That is not happening. Can you please help me with that.