ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Rank based on each month Hi Angelina_QBeeQ , Could you please help me on this. Regards, Tulu Re: Rank based on each month Hi Angelina_QBeeQ , Still getting the same. Rank based on each month Hi Angelina_QBeeQ , I want to set the rank independently for each month based on measure. Rank logic: RANK([Overall Vol],"1224",[l3_demand],[Months in contact_date]) As per below sc, rank shd be 1,2,3....for Mar and similarly 1,2,3...for Feb and so on..but now it is not considering individual months while calculating rank. Re: How to link data to the blox Hi @Angelina_QBeeQ, I am trying to display max date in the box panel. Getting blank value. kindly help on below sc. Re: Set Conditional Formatting of cell Based on a Separate Measure Hi Ido_QBeeQ , You have written formula in the condition section(referring image) but how it will compare. In my case Overall Vol logic I can put but how will compare with 2000? Could you please make it more simpler. Set Conditional Formatting of cell Based on a Separate Measure Hi Angelina_QBeeQ , I want to set color(red & green) of Rank cell based on Overall Vol measure. if Overall Vol>2000 then Rank cell will be Red else Green. Logic of Overall Vol is Count(call) SolvedRe: Set Conditional Formatting of cell Based on a Separate Measure Hi Benji_PaldiTeam , This post won't help me because we need to provide the condition with another measure like below. if Overall Vol>2000 then Rank cell will be Red else Green Change sorting order of date filed in pivot column Hi Angelina_QBeeQ , Could you please assist me how to sort date field from column section in pivot table. I want the latest month first and so on. SolvedRe: How to center align and create url action Hi Angelina_QBeeQ , Thanks Angelina for your support. Now I am able to create url action in Sisense by taking your inputs but now just to make more customize I need your support again. Below is my blox code & output: { "style": "", "script": "", "title": "", "showCarousel": true, "backgroundImage": "", "body": [ { "type": "Container", "style": { "backgroundImage": "linear-gradient(#5CACEB, #5CACEB)", "box-shadow": "0 0px 0px 0px rgba(58,67,86,0.1)", "padding": "1px" }, "items": [ { "type": "ColumnSet", "columns": [ { "type": "Column", "separator": true, "items": [ { "type": "Image", "horizontalAlignment": "center", "size": "medium" }, { "type": "ActionSet", "actions": [ { "type": "Action.OpenUrl", "title": "Phone channel Unstructured data Summary", "style": { "align-self": "center", "font-weight": "bold" }, "target": "_self", "url": "https://visualanalyticse1.aexp.com/app/main/dashboards/6422b9062a518d003785edf1", "size": "large" } ] } ] }, { "type": "Column", "separator": true, "items": [ { "type": "Image", "horizontalAlignment": "center", "size": "medium" }, { "type": "ActionSet", "actions": [ { "type": "Action.OpenUrl", "title": "Number of Topics distribution by individual topic", "style": { "align-self": "center", "font-weight": "bold" }, "target": "_self", "url": "https://visualanalyticse1.aexp.com/app/main/dashboards/642536b79b71ae0037e7c50d", "size": "large" } ] } ] }, { "type": "Column", "separator": true, "items": [ { "type": "Image", "horizontalAlignment": "center", "size": "medium" }, { "type": "ActionSet", "actions": [ { "type": "Action.OpenUrl", "title": "Distribution of topics", "style": { "align-self": "center", "font-weight": "bold" }, "target": "_self", "url": "https://visualanalyticse1.aexp.com/app/main/dashboards/6425590161e44900388ae834", "size": "large" } ] } ] }, { "type": "Column", "separator": true, "items": [ { "type": "Image", "horizontalAlignment": "center", "size": "medium" }, { "type": "ActionSet", "actions": [ { "type": "Action.OpenUrl", "title": "Distribution of topics (including topic combination)", "style": { "align-self": "center", "font-weight": "bold" }, "target": "_self", "url": "https://visualanalyticse1.aexp.com/app/main/dashboards/64255ce461e44900388ae844", "size": "large" } ] } ] } ] } ] } ] } Output: Required output: There is difference in the design. kindly look into my code and suggest. Regards, Tulu Re: Prevent dashboard filter after JTD Hi Angelina_QBeeQ , Kindly look into my issues. Regards, Tulu