Convert table to graph with hidden rows
I need to make a bar chart and a line chart of the number of primary school students with +15% absence for each school. In order for me to do this I need to count how many students (social security number) who has over 15% absence. When I've done that I use a calculation to count the number of students (sum(0,all(c),m3)). Since I have to make a graphic presentation the social security numbers have to be hidden, which I simply do in visibilities. This works fine when I create a table (yellow marks where I hide social security numbers)
But if I choose a bar chart or line chart I get an error which says there is not enough data.
I don't quit understand why Targit can handle to hide the social security numbers when it is a table and not a chart. For me the table and the table behind chart look identical.
Does somebody have any good suggestions on how to make the above table to work in a bar chart or line chart? I can read that someone had a similar question and the suggestion was to switch rows to columns (https://community.targit.com/hc/en-us/community/posts/360015702358-Diagram-visualization-of-column-total-of-row-wise-calculation-with-time-dimension?input_string=Convert%20table%20to%20graph%20with%20hidden%20rows), that unfortunatly won't work in my case.
Comments
Hi Gia,
I have this example, where 'Customer Country' equals your 'Institution Institutionsnavn', and 'Item Name' equals your 'Borger Personnummer'.
Object 1:
allcount(0, all(s), m1)
Object 2 (copy of Object 1):
allcount(d1, all(c), m1) = 0 and allcount(d1, d1:0(s), m1) > 1
Object 3 (copy of Object 2, turned into a column chart):
BR / Ole
Please sign in to leave a comment.