Creating a HAR file and importing


  1. Go to the game world where you want to gather the data
  2. Press F12 and click on the Network tab
  3. Press F5 (this is required to load yourself, if you skip this step, then you'll be missing from the gathered data)
  4. Click on guilds and players that you want to collect. Keep in mind that you need to click all members of the guild (only clicking on guild is not enough)
  5. Click on Save all as HAR or similar
  6. Now navigate over to the Files tab inside the Statistics module. Click upload button and select the file you've just saved.

Table structure


You can create columns that suit your needs. Before creating a column, you need to create a category that the column will belong to.

Creating a category


You can create a category using the keyword category and its name. The name can contain all characters, including spaces. If you want a category without a name, you can leave it empty.
A single category can contain one or more columns.
Keep in mind, that there is a one reserved category that behaves like a single column. The name of the category is Potions and it includes three columns with potion sizes.

category General

# The only reserved category
category Potions

Creating a column


You can create a column using the keyword header and its name. The name can contain all characters, including spaces.
Keep in mind, that there are some reserved header names (they are shown on the bottom of this page). The reserved headers often contain already predefined expression and sometimes their own formatting.
You can override the expression using the expr keyword if you want, but in some cases you will lose all special formatting (if you are using Album, Mount, Awards, Last Active or Knights header).

# Category must be created for the column to exist in
category General
header Level
header Album

Creating a itemized column


You can create a itemized column using the keywords itemized by. First parameter is a itemizable header name, the second itemized header name, which will be applied to the itemizable value. Please be aware that using this column type can cause severe performance issues when generating the table.

# Category must be created for the column to exist in
category General
itemized Items by Item Attribute

Header names


Headers that are available for all players.




Headers that are avaiable only to you and your guild members. Using them for other players will result in unknown ? value to be displayed.




Headers that are avaiable only to your own characters. Using them for other players will result in unknown ? value to be displayed.




Special headers for the Fight Simulator.




Itemizable headers




Headers useable only within itemized headers




Options


Option can be set before first category.
Option can be set before creating a header within a category.
Option can be set after creating a header.
Option overrides the effect of another option.
This option does work only in tables within the Guilds tab.
This option does work only in tables within the Players tab.
Me
This option does work only in tables within the Me tab.

alias Local


Use this option to change the name of the column when necessary.
If you are using expr option, then you do not need to change the name even if it is reserved.

header Level
alias New Column Name

align Local


Use this option to realign the content of the cell. You can use left, right or center.

header Level
align left

border Local Shared Global


Use this option to display a border around the column. You can use left, right or both sides.

header Level
border right

brackets Local Shared Global


Use this option to enable or disable brackets around the difference.
Please note that this option requires the difference option to be enabled, otherwise you will not see any changes.

header Level
difference on
brackets on

color Local Overrides expc option


Use this option to create a rule that will apply a color to the cell when a condition is met. You can use several conditions, including equal, above, below, above or equal and below or equal.
Please note that their order matters, so the color of the first met condition will be applied.
If you want a color used by default, when no condition is met, then use default condition. The position of this default condition does not mattter.
You can use constant or any valid css color (omit # character if your color has one).

header Level
color default orange
color above or equal 300 red
color above 200 @green
color equal 100 ff15ff

clean Local


Use this option to ignore any global or shared settings for the specified header. In the example, the Level header will not have a difference shown even when the rest of the category does.

category
difference on

header Level
clean

difference Local Shared Global Guilds Me


Use this option to show a difference between current and previous value. You have to select a reference time for the difference to appear.
In case that the player was not present at the selected time, then the earliest one is picked instead.

header Level
difference on

expr Local Overrides reserved column name


Use this option to specify which value should the cell contain. You can use most of common operators, constants, header names and functions.

header Resistance
expr trunc(min(Armor / Level + (Class == @battlemage ? 40 : 0), ((Class == @warrior || Class == @battlemage || Class == @demonhunter) ? 50 : (Class == @mage ? 10 : 25))))

expc Local


Use this option to specify with which color should be the cell highlighted. You can use most of common operators, constants, header names and functions.

header Resistance
expc Class == @BattleMage ? 'red' : 'orange'

extra Local


Use this option to append a string at the end of a cell. This option does not work for values made using format or value option.

header Life Potion
expr player.Potions.Life
extra %

flip Local Shared Global


Use this option to treat lower values as better. This will have effect only when sorting and when showing difference.

header My Rank
expr Rank
flip on

font Global


Use this option to set the font used in the table. The value can be any font that is valid css font.

font 1.5em Arial

font bold 35px

scale Global


Use this option to set the scale of the table itself. It affects only the widths of the columns, so it is helpful when used together with the font option. The value is in percent.

scale 125

format Local Overrides extra option


Use this option to change the displayed value of the cell. Does not work if a value option is specified.
This option functions the same way as expr does and you can use most of common operators, constants, header names and functions.
The keyword this is used to get the current cell value.
Any of number, fnumber, duration, date and default arguments can be also used without specifying a complete expression.

header Active Before
expr Timestamp - Last Active
format duration(this)

format difference Local


Use this option to allow formatting of difference using the format option.

header Level
format this + 5
difference on
format difference on

grail Local Shared Global


Use this option to indicate whether player has found the Holy Grail. Does work only for Album header.

header Album
grail on

hydra Local Shared Global


Use this option to indicate whether player has the Dehydration achievement. Does work only for Awards header.

header Awards
hydra on

indexed Global


Use this option to show row numbers. You can use static to prevent the row number from changing.

indexed static

large rows Global


Use this option to make all rows larger (They will fit two lines of text by default).

large rows on

layout Global Guilds


Use this option to modify the layout of the table. Keep in mind that only the used blocks will be shown, resulting in blocks missing if you write just single value.
Always keep it a combination of these four parameters: table, statistics, details and members.
Not used values will cause that block to disappear. The same way, using the block multiple times will result in it being duplicated.

layout statistics, details, table, members

lined Global


Use this option to separate players with lines. Use thick to show thick line or thin/on for thin line.

lined thick

maximum Local Shared Global


Use this option to show the maximum amount of knights that player can have. Does work only for Knights header.

header Knights
maximum on

members Global Guilds


Use this option to show amount of players per class and a list of players that left and joined between now and a reference point in time.

members on

name Global Guilds Players


Use this option to change the width of the name column.

name 200

opaque Global


Use this option to show rows with alternating background colors.

opaque on

outdated Global Players


Use this option to highlight players that are not up to date. This option is enabled by default.

outdated off

order by Local Guilds Players


Use this option to change how the column behaves during sorting. You can use difference keyword to sort by the difference. It will be equal to undefined when no difference is present.

header Level
order by difference == undefined ? Level : difference

percentage Local Shared Global


Use this option to show the value as a percentage instead. Does work only for Album and Mount header.
In case of Album header, the percentage of collected items instead of the amount of collected items is displayed.

header Album
percentage on

performance Global Players


Use this option to limit the maximum amount of displayed entries in the Players tab. Sorting and search will display only the top number of results.
This is meant for performance reasons, when you reach player count above 2000.

performance 500

server Global Players


Use this option to hide or set the width of the server column. You can use off to hide it completely, or specify a number or a constant that will serve as the column width.

# Remove the column completely
server off

# Set the column to be huge
server @huge

set Global


You can use this option to create a custom variable that can be later used in any expression.

set Resistance as Armor / Level
set Max Resistance as (Class == @warrior || Class == @battlemage || Class == @demonhunter) ? 50 : (Class == @mage ? 10 : 25)

header Resistance
expr min(Resistance + (Class == @battlemage ? 40 : 0), Max Resistance)
format trunc(this) + "%"

set withGlobal


You can use this option to create a function that can be later used in any expression.

set Between with Value, Min, Max as Value > Min && Value < Max

header Between 1M and 5M
expr Between(Items.Wpn1.SellPrice.Gold, 1000000, 5000000)

set with allGlobal


You can use this option to create a variable, that requires a parameter name and a array function. It will be applied to the whole player list and can be later used in any expressions.
The result of this expression should be always a constant value. Having an array as an output and manipulating it further within non-withall option can cause unnecessary performance issues.

set Pet Average with all Players as each(slice(Players, 0, 25),P.Group.Pet) / Players.length

header Pet Difference
expr trunc(Pet - Pet Average)

show asGlobal Guilds


You can use this option to show a row under the statistics block with a value you specified. You can use the difference option to specify whether you want to show the difference.

set TotalKnights with all Players as each(Players, Knights)

show Knights as TotalKnights

statistics as Global Guilds


You can use this option to show a row in the statistics block with a value you specified. Using this option will remove the default Minimum, Average and Maximum rows.

statistics Minimum as min(this)

simulatorGlobal Guilds


Use this option to enable simulator function for guilds. Specify the amount of repeats per single fight to maximize the accuracy. Higher values however lead to significant performance loss, so use at your own risk.

simulator 100

header Simulator Average

statistics Local Shared Global Guilds


Use this option to enable statistics for a column. It will show minimum, maximum and average values.

header Level
statistics on

value Local Overrides format option


Use this option to create a rule that will apply a value to the cell when a condition is met. You can use several conditions, including equal, above, below, above or equal and below or equal.
Please note that their order matters, so the value of the first met condition will be applied.
If you want a value used by default, when no condition is met, then use default condition. The position of this default condition does not mattter.
This option will override format option.

header Level
value default Small
value above or equal 300 > 300
value above 200 > 200
value equal 100 100

visible Local Shared Global


Use this option to hide the value if the cell is colored. The value will still be there but will be drawn with background color instead.

header Level
color above or equal 100 red
color below 100 green
visible off

width Local Shared


Use this option to change the width of a column. You can use a number or any of tiny, small, normal and large constants.

header Level
width @large

Expressions


You can use all available operators, functions and constants in the expression. That includes also self created variables and functions.
You have also undefined and null values available to you for use.
You can use " and ' within strings, but they must be escaped with \ and start and end with the same character.
If you want to reduce an array (for example count the amount of crystals in ones equipped items), then you can use the function each which takes the array object and a custom function as a parameter. It will return a sum of all values created by the function. The function should accept one parameter, but it is not required.
When creating an expression for format option, you can access the original value of the cell by using the this word.

Operators


-A
!A
(A)
"A"
'A'
A[B]
{A, B}[C]
A + B
A - B
A * B
A / B
A % B
A > B
A < B
A == B
A != B
A >= B
A <= B
A && B
A || B
A ? B : C

Predefined objects


this
player
reference

Functions



Array Functions


each
slice
filter
map
min
max
sum

Constants



Search keywords

You can combine classic search with any of these keywords (you can use multiple keywords of the same type at once). Use & to divide search terms and | to specify multiple possibilities.


c:
Filter by class name, where you can use warrior, mage, scout, assassin, battle mage, berserker or demon hunter as an argument.
p:
Filter by player name. It does not require exact match.
g:
Filter by guild name. It does not require exact match.
s:
Filter by server name. It does not require exact match.
l:
Show only the latest entries.
e:
Filter by an expresssion. You can use any normal expression that you would use within the expr option in your settings.
f:
Show only the first amount of entries. This keyword does bypass the performance option in your settings.
r:
Force recalculation of set with all values. Using this keyword can cause unwanted effects when filtering by expression and using set with all values.
x:
Enable simulator within the Players tab.
a:
Merge own & other players within the Me tab.
h:
Show hidden players within the Me & Players tab.
o:
Show other players within the Me tab.