hkkwon89
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Is there a way to pass specific filters for Jump to Dashboard?
hmm.. it still doesn't seem to work. prism.jumpToDashboard(widget, { drilledDashboardDisplayType:1, displayFilterPane:true, excludeFilterDims:"[NOTES.OldestNoteDateOfVisit]", displayDashboardsPane:false, displayToolbarRow:false, displayHeaderRow:false, drillToDashboardNavigateType:1, dashboardId:"62fd12cc9162f000395da2cc" });7KViews0likes1CommentRe: Is there a way to pass specific filters for Jump to Dashboard?
Hi sneak , Thanks for your reply. I did try that route as well but it did not work for me. I am pasting the script I have below. prism.jumpToDashboard(widget, { drilledDashboardDisplayType:1, displayFilterPane:true, excludeFilterDims:["[NOTES.OldestNoteDateOfVisit]"], displayDashboardsPane:false, displayToolbarRow:false, displayHeaderRow:false, drillToDashboardNavigateType:1, dashboardId:"62fd12cc9162f000395da2cc" }); Thank you7KViews0likes3CommentsIs there a way to pass specific filters for Jump to Dashboard?
I have a pivot table with a few columns with JTD enable to another dashboard. However, I want the OldestNoteDateofVisit column to not pass as a filter. Is it possible to exclude specific column to be passed as a filter in JTD?Solved7.2KViews0likes8CommentsRe: How do I display the earliest date as a column in a pivot table?
harikm007 Hi Hari, Thank you for your response; however, I'm having some issues implementing your solution. First, this being a pivot table it's requiring some kind of aggregation on the date field as you can see on the left hand panel for DATE_OF_VISIT. Second, I'm not sure how you achieved the Date Rank you created using rank(max([Days in Date]),"ASC","1223",[provider]) to be as a widget filter? I am only able to choose the existing columns in my data set as a filterable item. Thank you4.2KViews0likes1CommentHow do I display the earliest date as a column in a pivot table?
Hi, I need to create a healthcare pivot table with three columns. Provider Name, number of claims by provider, and earliest date of encounter for each provider. Something like above.. However this being a pivot table is it possible to achieve the last column? I did put in a calculated column to rank them, ToInt(rankasc(assigned_reg_userid,Date_of_visit)) Any help/workaround is appreciated!Solved4.3KViews1like3CommentsRe: Blox conditional formatting up and down indicators
harikm007 Hi Hari, Sorry to be pinging you into a post but would the above be possible? I'm basically trying to change what's in the first screenshot attached (arrows and percentage) to what's in second screenshot. Thanks a lot!4.5KViews0likes1CommentBlox conditional formatting up and down indicators
Hi, I currently have conditional formatting for a blox widget. Based on the percentage change, it changes the font color (green or red) and a up or a down arrow. However, instead of the arrows I want a textblock with a background color. I tried taking a stab at it but it's changing the entire widget color. Attaching my current CSS snipet. Thank you { "style": "", "script": "", "title": "", "showCarousel": false, "conditions": [ { "minRange": "-Infinity", "maxRange": 2000, "backgroundColor": "#fd6e69" }, { "minRange": 2000, "maxRange": 10000, "backgroundColor": "#FAA0A0" }, { "minRange": 10000, "maxRange": "Infinity", "backgroundColor": "#3adcca" } ], "body": [ { "type": "ColumnSet", "columns": [ { "type": "Column", "spacing": "small", "items": [ { "type": "ColumnSet", "height": "40px", "style": { "border-radius": "6px 6px 0px 0pc", "background-image": "linear-gradient(330deg, #F7941D 10%, #703971)", "box-shadow": "1px 1px 2px #a6a4a4" }, "columns": [ { "type": "Container", "style": {}, "items": [ { "type": "TextBlock", "id": "", "class": "", "text": "Accounts Receivable", "horizontalAlignment": "left", "style": { "color": "#edeef0", "font-weight": "500", "font-size": "12px", "margin": "15px 0px 15px 10px" } } ] }, { "type": "Image", "id": "", "class": "", "url": "https://www.svgrepo.com/show/419269/avatar-human-person.svg", "altText": "image descriptions", "style": { "margin": "0px 10px", "width": "20px" } } ] }, { "type": "Container", "style": { "background-color": "#FFFFff", "margin-bottom": "1px", "border-radius": "0px 0px 6px 6px", "box-shadow": "1px 1px 10px #a6a4a4" }, "items": [ { "spacing": "none", "type": "ColumnSet", "columns": [ { "spacing": "medium", "separator": "true", "type": "Column", "items": [ { "type": "TextBlock", "horizontalAlignment": "left", "text": "Total", "weight": "bold", "color": "grey", "size": "medium" }, { "type": "ColumnSet", "columns": [ { "type": "Column", "style": { "flex-grow": "0" }, "items": [ { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "{panel:Total AR_AMOUNT}", "weight": "bold", "color": "#232a2f", "size": "large", "style": { "margin": "0px" } } ] }, { "spacing": "small", "type": "Container", "items": [ { "type": "Image", "class": "conditional_image", "size": "small", "spacing": "none", "horizontalAlignment": "center" } ] }, { "spacing": "none", "type": "Container", "style": { "flex-grow": "100" }, "items": [ { "spacing": "small", "type": "TextBlock", "class": "condition_data", "text": "5000%", "horizontalAlignment": "center", "size": "small", "weight": "bold", "color": "red" } ] } ] }, { "type": "TextBlock", "horizontalAlignment": "left", "text": "Insurance", "weight": "light", "color": "grey", "size": "small", "spacing": "none" }, { "type": "ColumnSet", "columns": [ { "type": "Column", "style": { "flex-grow": "0" }, "items": [ { "spacing": "small", "horizontalAlignment": "left", "type": "TextBlock", "text": "{panel:AR_insurance}", "weight": "bold", "color": "#232a2f", "size": "medium", "style": { "margin": "0px" } } ] }, { "type": "Column", "items": [ { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "2.5%", "weight": "bold", "color": "#232a2f", "size": "small", "style": { "margin": "10px 0px 0px 30px" } } ] }, { "type": "Column", "style": { "flex-grow": "100" }, "items": [ { "type": "Image", "class": "conditional_image indexsp-stock", "url": "/plugins/BloX/blox-images/StockMarket/arrow-up.png", "style": { "margin": "0px 0px 0px 0px" }, "size": "small", "spacing": "none" } ] } ] }, { "type": "TextBlock", "horizontalAlignment": "left", "text": "Patient", "weight": "light", "color": "grey", "size": "small" }, { "type": "ColumnSet", "columns": [ { "type": "Column", "style": { "flex-grow": "0" }, "items": [ { "spacing": "small", "horizontalAlignment": "left", "type": "TextBlock", "text": "{panel:AR_patient}", "weight": "bold", "color": "#232a2f", "size": "medium", "style": { "margin": "0px" } } ] }, { "type": "Column", "items": [ { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "-4%", "weight": "bold", "color": "#232a2f", "size": "small", "style": { "margin": "10px 0px 0px 30px" } } ] }, { "type": "Column", "style": { "flex-grow": "100" }, "items": [ { "type": "Image", "class": "conditional_image indexsp-stock", "url": "/plugins/BloX/blox-images/StockMarket/arrow-down.png", "style": { "margin": "0px 0px 0px 0px" }, "size": "small", "spacing": "none" } ] } ] }, { "type": "TextBlock", "horizontalAlignment": "left", "text": "Other", "weight": "light", "color": "grey", "size": "small" }, { "type": "ColumnSet", "columns": [ { "type": "Column", "style": { "flex-grow": "0" }, "items": [ { "spacing": "small", "horizontalAlignment": "left", "type": "TextBlock", "text": "$0", "weight": "bold", "color": "#232a2f", "size": "medium", "style": { "margin": "0px" } } ] }, { "type": "Column", "items": [ { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "0%", "weight": "bold", "color": "#232a2f", "size": "small", "style": { "margin": "10px 0px 0px 30px" } } ] }, { "type": "Column", "style": { "flex-grow": "100" }, "items": [ { "type": "Image", "class": "conditional_image indexsp-stock", "url": "/plugins/BloX/blox-images/StockMarket/arrow-down.png", "style": { "margin": "0px 0px 0px 0px" }, "size": "small", "spacing": "none" } ] } ] } ] } ] } ] } ] } ] } ] }4.6KViews0likes3CommentsRe: Goal line in a bar/column chart, is it possible to take an user input to set the goal?
harikm007 Hi Hari, Quick follow up question. Is it possible to have that blox kind of merge into the bar chart so the button and input space is within the chart? i.e. top left of the bar chart.7.4KViews0likes6Comments