John Jacobsen

Total activity 27
Last activity July 04, 2025 07:50
Member since February 22, 2021 07:18

Following 0 users
Followed by 0 users
Votes 1
Subscriptions 14

John Jacobsen created a post, July 01, 2025 12:28
Calender as type of Object
1. Community
2. Feature requests / Ideas
It would be nice to have a new object type that displays a calendar, as known from the calendar function in Outlook. You should be able to choose a user-specific time range. This is particularly us...
- 4 followers
- 1 comment
- 2 votes
John Jacobsen commented, May 06, 2021 09:06
Hi Niels The syntax in the calculated columns is like this: sum(d-1, 0, m4) sum(d-1, 0, m5) sum(d-1, 0, m6) etc. and avg(all, 0, m4) avg(all, 0, m5) avg(all, 0, m6) When I try to make further calcu...
- View comment
- 0 votes
John Jacobsen commented, May 03, 2021 06:55
Hi Flemming I'm fairly sure that you have to be in Designer mode to do that. I don't know if the version has anything to do with it. We have version 2021.0 build 19280 and it works perfectly.
- View comment
- 0 votes
John Jacobsen commented, May 03, 2021 06:24
Hi Flemming You can drag and drop the row with your calculation and place it in any row you like.
- View comment
- 0 votes
John Jacobsen created a post, April 23, 2021 11:29
Sorting columns
1. Community
2. Frontend, Designer and Consumer
Hi all, I need help with sorting in my Analysis where I have both measures from my dataset, calculated measures and caluculated columns. M1 = Helårs Person = Measure from datasetM2 = Disp. Beløb = ...
- 2 followers
- 3 comments
- 0 votes
John Jacobsen commented, April 19, 2021 09:51
Hi, Louise You understood it correctly. It works very nice. I had to make small changes to the syntax in order to get the result that I'm looking for. Thanks a lot for the help.
- View comment
- 1 vote
John Jacobsen created a post, April 16, 2021 11:59
Custom Hierarchy with a Baseline
1. Community
2. Frontend, Designer and Consumer
In my analysis, I work with both a baseline and an ongoing change between the most recent statement and the previous statement at any given time. It is relatively easy to calculate the ongoing chan...
- 2 followers
- 2 comments
- 1 vote
John Jacobsen created a post, March 05, 2021 08:14
Totals and Subtotals in calculated columns
1. Community
2. Frontend, Designer and Consumer
Is there a workaround so that the totals and subtotals in calculated columns shows the sums of the column instead of the calculation of the individual row? As You can see in the example, the subtot...
- 3 followers
- 2 comments
- 1 vote
John Jacobsen commented, March 04, 2021 08:10
Hi Ole, That helped, thanks. BR/ John
- View comment
- 0 votes
John Jacobsen commented, March 04, 2021 07:08
Hi Ole, Good idea, I will do that. But it seems that I don´t have access, I can´t get in. Best Regards, John
- View comment
- 0 votes