thanks for the video! I can get the unit chart, but my icons are out of order (the true and false arent grouped together, but dispersed throughout.) is there a way to fix this?
Hey there, really appreciate this tutorial. I'm using my own dataset and following the steps and it works great. However, i'd like to ask if we can get multiple dimensions on one of axis. For example, showing Germany, Italy (or couple more) at the same time. So the whole chart has several countries and unit charts for each countries. Thx
@SuperDataScience. Unless there is a common column how the blend here works?. The Unit Chart file doesn't have any common column to blend with the state file. So how the data got blended here?.
You can open a new book, then copy and paste the first worksheet to the new workbook where you will add a new connection. There is no union or join this way.
Not sure why Malta was rounded down to 0 instead of rounding up to 1? Since 429k is much closer to 500k than 0. Just a thought - thank you for making this instructional video!
I tried to do the waffle chart filtering by following this video. But it keeps reminding me that "a relation should be created between (two data sources)..." Is it the problem caused by different version?
Don't have it in the data sheet. Or use the "Hide all unused fields" function. But the real answer is that you can use parameter to create a better filter.
Hi, I got a few problem from using the color calculation field. They said that I have to do a data relationship between population and other data .However, there are no relationship i can custom because it is relationship between number and number. could you give me some advice
Hi Yanisa, Thanks for adding to this thread. You will not need to add a relationship between these two data sources as they work independently to create the unit chart visual. Please review the full video for instructions to complete. Regards
thanks for the video! I can get the unit chart, but my icons are out of order (the true and false arent grouped together, but dispersed throughout.) is there a way to fix this?
Hey there, really appreciate this tutorial.
I'm using my own dataset and following the steps and it works great.
However, i'd like to ask if we can get multiple dimensions on one of axis. For example, showing Germany, Italy (or couple more) at the same time. So the whole chart has several countries and unit charts for each countries.
Thx
Hi , Great Chart
Is it possible to create a Map where the markers or Yellow stars appear as per country selected with the country parameter?
@SuperDataScience. Unless there is a common column how the blend here works?. The Unit Chart file doesn't have any common column to blend with the state file. So how the data got blended here?.
You can open a new book, then copy and paste the first worksheet to the new workbook where you will add a new connection. There is no union or join this way.
Not sure why Malta was rounded down to 0 instead of rounding up to 1? Since 429k is much closer to 500k than 0. Just a thought - thank you for making this instructional video!
I tried to do the waffle chart filtering by following this video. But it keeps reminding me that "a relation should be created between (two data sources)..." Is it the problem caused by different version?
I have the same issue! I'm using version 2020.1
@@francisilustre3645 So did you figure out what happened?
@@anzhemeng8833 Need to inner join the "unit chart template.xlsx" . th-cam.com/video/pEmdKDPdnt8/w-d-xo.html
I also encountered this as well, but there is nothing to link up the relationship
What is unit chat area
Thank you for this helpful instruction. I have learnt a lot. Btw, is there any way to exclude NULL out of the filter bar?
Don't have it in the data sheet. Or use the "Hide all unused fields" function. But the real answer is that you can use parameter to create a better filter.
Hi, I got a few problem from using the color calculation field. They said that I have to do a data relationship between population and other data .However, there are no relationship i can custom because it is relationship between number and number. could you give me some advice
Hi Yanisa,
Thanks for adding to this thread.
You will not need to add a relationship between these two data sources as they work independently to create the unit chart visual.
Please review the full video for instructions to complete.
Regards
The calculation is suppose to blend the data but it doesn't work for me
@@joefromdc You don't have to blend the data if your filters return only one row from the other data source.
@@joefromdc It works just fine as is. No need to combine anything. It just works.
cannot see the letter/number before the SUM. Minute: 6'15
SUM([states].[Populiation(500k)]) >=sum([Value])