en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Markus Helm  
#1 Posted : Thursday, January 4, 2018 2:47:53 PM(UTC)
Markus Helm
Rank: Member

Groups: extranet\Forum
Joined: 6/4/2012(UTC)
Posts: 6

Hi

I recently created a bridge Chart with the "waterfall chart object"
To change the minimum value of the left axis depending on the applied criterias, i added the formula (Axis.max - Axis.min) * 0.4 into the chart properties (Measure axes / Minimum / Custom). That works so far so good, but i'd like to know more about ths Feature.

Does anybody know, where I can find a documentation about the formula syntax in the new 2K17 charts?

Kind regards
Markus



UserPostedImage

Ole  
#2 Posted : Thursday, January 4, 2018 3:02:22 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 418

Hi Markus,

I have it included in the TARGIT Visualization Wizard class - from where I have extracted this little handy guide:

Appendix 4: Labels formula syntax

Column/row and axis calculations

List of column calculations

These refer by default to column 1 in your crosstab – note that you can work with lookup values to point to a particular column or row.

column calculations Description
column.sum Sums up the total of the column
column.avg Calculates the average of the column
column.min Returns the minimum value of the column
column.max Returns the maximum value of the column
column.stdev Returns the standard deviation of the column
column.median Returns the median of the column
column.percentile(pct) E.g. column.percentile(0,25) returns 25% percentile
column.count Returns number of values in the column
column.membercount Returns numbers of members in the column


row calculations Description
row.sum Sums up the total of the row
row.avg Calculates the average of the row
row.min Returns the minimum value of the row
row.max Returns the maximum value of the row
row.stdev Returns the standard deviation of the row
row.median Returns the median of the row
row.percentile(pct) E.g. row.percentile(0,25) returns 25% percentile
row.count Returns number of values in the row
row.membercount Returns numbers of members in the row

axis calculations Description
axis.sum Sums up the total of the axis
axis.avg Calculates the average of the axis
axis.min Returns the minimum value of the axis
axis.max Returns the maximum value of the axis
axis.stdev Returns the standard deviation of the axis
axis.median Returns the median of the axis
axis.percentile(pct) E.g. axis.percentile(0,25) returns 25% percentile
axis.count Returns number of values in the axis

Best regards,
Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Markus Helm  
#3 Posted : Thursday, January 4, 2018 3:18:03 PM(UTC)
Markus Helm
Rank: Member

Groups: extranet\Forum
Joined: 6/4/2012(UTC)
Posts: 6

Hi Ole

Thanks for the fast reply, that's exactly what I'm looking for. Is there also an operator to round the results (like round(x,y)?

Greetings
Markus

Originally Posted by: Ole Go to Quoted Post
Hi Markus,

I have it included in the TARGIT Visualization Wizard class - from where I have extracted this little handy guide:

Best regards,
Ole


Ole  
#4 Posted : Friday, January 5, 2018 7:17:33 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 418

Hi Markus,

Sure - you can find round(x,y) modifiers.

These, however, are directly available from the online help (F1) within the client.

Search for "round" or more specifically for "Arithmetic result modifiers" - and you will find explanations for Round, Mod, Int, Floor, Ceil, Div and Abs.

BR / Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Ray Cleary  
#5 Posted : Tuesday, February 6, 2018 4:42:56 PM(UTC)
Ray Cleary
Rank: Advanced Member

Groups: extranet\Forum
Joined: 9/30/2011(UTC)
Posts: 15

Hi Ole
This is a very interesting page and has answered a few questions for me. I am stuck on how to

"work with lookup values to point to a particular column or row". Can you give some ideas for this ? I want to get to the second last column.

Thanks

Ray
Ray Cleary  
#6 Posted : Wednesday, February 7, 2018 4:11:18 PM(UTC)
Ray Cleary
Rank: Advanced Member

Groups: extranet\Forum
Joined: 9/30/2011(UTC)
Posts: 15

Hi Ole
I think I sorted out my own problem. I created Lookup Values and then modified them to select the first and last row of a bar chart and then the total fro all bars and created a good demo chart for our users

Thanks

Ray
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.

ok