summaryrefslogtreecommitdiff
path: root/macros/latex/contrib/datatool/samples/sample-piechart.tex
blob: 2bcd49dcf611052b4c29476815a958783c4fe087 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
 % This file is public domain.
\documentclass[captions=tableheading]{scrartcl}

\usepackage{datapie}

\DTLloaddb{marks}{sample-student-records.csv}

\begin{document}

% Compute average mark for each student:
\DTLforeach{marks}{%
\assignI=Assignment 1,%
\assignII=Assignment 2,%
\assignIII=Assignment 3}{%
\DTLmeanforall{\theMean}{\assignI,\assignII,\assignIII}%
\DTLround{\theMean}{\theMean}{0}\DTLclip{\theMean}{\theMean}%
\DTLappendtorow{Average}{\theMean}}

% Sort according to average mark
\DTLsort{Average=descending}{marks}

\begin{table}
\caption{Student Marks}
\centering
\DTLdisplaydb[Address,RegNum,Title]{marks}
\end{table}

\begin{figure}
\caption{Pie Chart}
\centering
\DTLpiechart{variable=\Average,outerlabel={\Surname, \FirstName},rotateouter}{marks}%
  {\Average=Average,\Surname=Surname,\FirstName=First
Name}
\end{figure}

\end{document}