Mis
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Indicater for number in columb
Hi, so I would like to show a number (11.4) of the column (the name can be anything, let's say Field3 for now) Japan 2019 11.4 8.9 As an indicator on widget but it shows the count of the whole column which is 2, including N/A. How do I present only "11.4" on the indicator? thank you!Solved3.1KViews0likes2CommentsHow 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.7KViews0likes2CommentsData visualization based on Crosstab questionnaire result
Hi newbie again, I was working on visualization of questionnaire not only with Sisense but I am new to it in general. I have a below result of questionnaire about healthy life expectancy ("Do you know the term?") and exercise habit. However as soon as I list 2nd value, it's shut automatically and I cannot display different percentage of the value depend on age. Here is the reference of the column i used. Sex Answer 20-29 30-39 40-49 50-59 60-69 70 > Male Knew both term and meaning 10.4 9.4 8.8 15.7 17.3 25.4 Male Knew term but not meaning 7.9 10.4 11.8 13 17.9 19.4 Male Knew neither term or mearning 81.8 80.2 79.4 71.3 64.8 55.2 Female Knew both term and meaning 21.7 10.1 19 22.5 29.9 29.4 Female Knew term but not meaning 14 11.8 12.6 13.8 18.8 15 Female Knew neither term or mearning 64.3 78 68.4 63.7 51.3 55.6 Sex Answer 20-29 30-39 40-49 50-59 60-69 70 > Male Do exercize 16.4 16.7 26.1 28.9 40.2 49.7 Male Do not exercize 47.9 55.7 51.5 47.5 36.9 26.8 Male Not sure 35.7 27.6 22.4 23.6 22.9 23.5 Female Do exercize 23.2 29.3 37.6 44.6 56.8 50.8 Female Do not exercize 47.6 43.5 42.6 36.8 24.7 22.9 Female Not sure 29.2 27.1 19.8 18.6 18.5 26.3 And this is something I am aiming for. Would really appreciate if you could help me work this out. Sincerely MisSolved3.5KViews0likes2CommentsMatching charts with different level of number
Good day fellow members, I have a quick question. So here are temperture data (e.g. 11.5 celicius) and the number of cases (e.g.50k) and I want to correlate them in a same graph. However since the measure level is different the temperature bar went really low and almost invisible (see attached), could you tell me if there is anyway I can match them same level like Tableau?? Thank you!SolvedYear cannot be recognized
Hi! I just started using Sisense and so shame that it's such a basic problem, but I cannot seem to visualize the following columns about the year and number of crimes in Japan. when I visualize it, the year only shows as 1905? (see attached) Year 合計(人) 2002 22,294 2003 23,971 2004 22,568 2005 20,388 2006 18,649 2007 16,922 2008 15,922 2009 15,271 2010 14,878 2011 14,144 2012 14,581 2013 14,596 2014 14,051 2015 12,565 2016 11,546 2017 10,888 2018 10,544 2019 9,899 Please let me know how I can resolvSolved