
John Jacobsen
Activity overview
Latest activity by John Jacobsen-
John Jacobsen created a post, Calender as type of Object
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...
-
John Jacobsen commented, 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...
-
John Jacobsen commented, 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.
-
John Jacobsen commented, Hi Flemming You can drag and drop the row with your calculation and place it in any row you like.
-
John Jacobsen created a post, Sorting columns
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 = ...
-
John Jacobsen commented, 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.
-
John Jacobsen created a post, Custom Hierarchy with a Baseline
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...
-
John Jacobsen created a post, Totals and Subtotals in calculated columns
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...
-
John Jacobsen commented, Hi Ole, That helped, thanks. BR/ John
-
John Jacobsen commented, 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