How 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.2KViews1like3Comments
How do you make a scatter plot from this excel file about cancer rate and age?
Hi all, I am quite new to data viz and having a hard time to adopt. I want to make a scatter plot from the following incidental rate of cancer, depends on the age and part (e.g. throat, lung) Unfortunately i could not attach the file at the moment, I don't know if it helps but following is the part of data set I am using. As you can see, the ages are listed horizontal, parts and rate per age are listed vertical. I am not sure how I can change into handy data to enable scatter plot. On Tableau I could somehow use pivot to summarize the number but not on current Sisense so I am assuming that I have to do it on excel. Any advice is appreciated! Code Part ICD-10 Sex Year Rought Rate 0-4歳 5-9歳 10-14歳 15-19歳 20-24歳 25-29歳 30-34歳 35-39歳 40-44歳 45-49歳 50-54歳 55-59歳 60-64歳 65-69歳 1 All Part C00-C96 Total 2016 784.0 20.2 10.3 10.8 16.1 26.2 44.9 80.6 137.2 226.4 339.9 498.4 731.7 1086.3 1541.6 1 All Part C00-C96 Total 2017 771.4 20.3 10.6 12.3 15.2 24.5 43.2 77.2 132.8 221.1 337.2 470.5 693.9 1048.7 1514.1 1 All Part C00-C96 Total 2018 775.7 18.5 10.4 12.2 16.2 24.4 44.7 79.4 130.3 217.2 331.5 466.7 689.1 1028.9 1494.8 1 All Part C00-C96 Male 2016 917.3 22.4 11.8 11.4 16.3 23.3 32.7 48.2 76.2 123.1 197.6 396.3 746.1 1308.8 2036.7 1 All Part C00-C96 Male 2017 906.4 21.4 11.8 12.8 13.7 21.3 30.6 45.4 72.1 119.3 201.6 370.6 702.9 1262.5 2009.1 1 All Part C00-C96 Male 2018 908.3 20.4 10.7 12.8 15.7 20.6 32.5 50.2 73.5 119.0 197.2 357.0 693.0 1228.5 1973.9 1 All Part C00-C96 Female 2016 657.5 18.0 8.7 10.1 15.8 29.3 57.7 114.0 200.0 332.5 485.0 601.3 717.3 870.2 1077.5 1 All Part C00-C96 Female 2017 643.4 19.1 9.3 11.8 16.7 27.9 56.3 110.1 195.2 325.6 475.5 571.5 685.0 840.9 1050.4 1 All Part C00-C96 Female 2018 650.1 16.5 10.0 11.6 16.6 28.4 57.6 109.7 188.7 318.1 468.6 577.6 685.2 834.6 1045.8 3 口腔・咽頭 C00-C14 Total 2016 17.0 0.0 0.0 0.1 0.4 1.0 1.8 2.5 3.1 5.4 8.4 14.8 21.8 29.7 35.9 3 口腔・咽頭 C00-C14 Total 2017 17.4 0.1 0.1 0.2 0.4 0.9 1.8 2.8 3.3 5.5 8.4 13.1 21.2 30.2 36.9Solved3.6KViews0likes2CommentsIs it possible to have a columnset within an item of a columnset?
Hello, I'm trying to achieve to the right of these numbers a conditional up or down arrow and the percentage change. I do have more columns to the right but what I'm trying to achieve is more stuff to the right of those items. How do I achieve this? { "style": "", "script": "", "title": "", "showCarousel": true, "conditions": [ { "minRange": "-Infinity", "maxRange": 69, "color": "#54a254", "image": "/plugins/BloX/blox-images/StockUpdate/arrow-down.png" }, { "minRange": 70, "maxRange": "Infinity", "color": "#FA5656", "image": "/plugins/BloX/blox-images/StockUpdate/arrow-up.png" } ], "body": [ { "type": "Container", "items": [ { "type": "Container", "spacing": "none", "items": [ { "type": "Image", "url": "/plugins/BloX/blox-images/VerticalCard/east.png", "size": "auto", "spacing": "none", "style": { "width": "100%", "height": "200px" } } ] }, { "type": "Container", "separator": "true", "spacing": "medium", "items": [ { "type": "TextBlock", "spacing": "small", "text": "Accounts Receivable", "weight": "bold", "color": "grey", "style": { "padding-left": "20px" } }, { "spacing": "none", "type": "ColumnSet", "columns": [ { "spacing": "medium", "separator": "true", "type": "Column", "items": [ { "type": "TextBlock", "horizontalAlignment": "left", "text": "Total", "weight": "bold", "color": "grey", "size": "Medium" }, { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "{panel:Total AR_AMOUNT}", "weight": "bold", "color": "#232a2f", "size": "large" }, { "spacing": "small", "type": "TextBlock", "horizontalAlignment": "left", "text": "Insurance", "color": "grey", "size": "small" }, { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "{panel:AR_Insurance}", "weight": "bold", "color": "#72767f", "size": "medium" }, { "spacing": "small", "type": "TextBlock", "horizontalAlignment": "left", "text": "Patient", "color": "grey", "size": "small" }, { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "{panel:AR_Patient}", "weight": "bold", "color": "#72767f", "size": "medium" }, { "spacing": "small", "type": "TextBlock", "horizontalAlignment": "left", "text": "Other", "color": "grey", "size": "small" }, { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "$0", "weight": "bold", "color": "#72767f", "size": "medium" } ] },Solved2.8KViews0likes2Comments
Improvise, adapt, overcome! How to increase the adoption and user satisfaction of dashboards
Discover the art of creating user-friendly dashboards that truly resonate with your audience. Drawing from six years of experience with Sisense, this article dives into dashboard design. Learn practical tips on improving dashboard readability, integrating advanced filters, and using dynamic widgets. Whether you're a seasoned designer or just starting, this guide offers invaluable insights to ensure your dashboards are not only functional but also a delight to use.1.4KViews4likes1Comment
Selecting Hierarchies for Drilling
I am setting up hierarchies for the drill hierarchy feature in Sisense. Out of the box, I see that the user can right click and select a field to drill into. It shows every table and column that is available in the Data Model. To limit the options, I am planning to create hierarchies for the end user to select from. Are there suggestions on tables to not pull from? Is it not recommended to add tables/columns from parts of the data model that the widget in question does not use? Are there any general guidelines or is it case by case basis? Once I have drilled into a widget and am ready to export to CSV, I am left with only the last Drill Hierarchy in the file and no other useful information. For example, I look at all of the sports played in a district. Then I drill into soccer, then gender, then female, then grade in school. If I were to export from grade in school, I would be left with each grade and the count of female soccer players in each grade. The excel file will only show the grade and the count. There is no information indicating the gender or the sport. Is there the option to pull in additional fields? For example, once I have the number of female students in each grade that play soccer, I will then drill into just the Freshman and display their student IDs. is it possible to also bring in additional information per ID (like fist name, last name, hometown)? I wouldn't want to drill into a specific student ID, but show the first name, last name, and hometown for all Student IDs showing. Thank you.1.3KViews0likes0CommentsScript to reduce the size of the pie chart category labels is attached below
Hi Team , Script to reduce the size of the pie chart category labels is attached below widget.on("beforeviewloaded",function(widget,args){ var maxCharNum = 28 var value args.options.plotOptions.pie.dataLabels.formatter = function (){ value = chunk(this.key.trim(), maxCharNum).join('<br>'); return value; } args.options.plotOptions.pie.dataLabels.useHTML = true }); function chunk(str, n) { var ret = []; var i; var len; for(i = 0, len = str.length; i < len; i += n) { // console.log(str.substr(i, n)) ret.push(str.substr(i, n)) } return ret }; Thanks Sijo1.2KViews1like0Comments
Improvise, adapt, overcome! How to increase the adoption and user satisfaction of dashboards
Discover the art of creating user-friendly dashboards that truly resonate with your audience. Drawing from six years of experience with Sisense, this article dives into dashboard design. Learn practical tips on improving dashboard readability, integrating advanced filters, and using dynamic widgets. Whether you're a seasoned designer or just starting, this guide offers invaluable insights to ensure your dashboards are not only functional but also a delight to use.
