Flemming Hjerrild Kristensen
Posts
-
Calculated line in a dot chart
We have a dot chart where the size of the Turnover per customer is shown on the X axis and the Discount-% percent is shown on the Y axis. There are 2 dotted lines showing the average (Discount and ...
-
Use Quarters in scheduled jobs
Hi Is it possible to make some kind of workaround in scheduled jobs, so a specific job only gets sent out once each quarter?
-
Accumulated sum on dimension value
I need some help to solve the following issue: I would like to change the last column "Akk.sum" (standard calculation in Targit), so it starts from zero each time I have a new "Item next level" So ...
-
Make Ranking able to handle Equals
The current standard ranking calculation can't handle equals like shown below in the first picture from targit. Then second picture is from our old BI-system where it was possible. TARGIT: OLD B...
-
Answered
Tæl synlige medlemmer og vis kun totalen
Hejsa Jeg har nedenstående top 10 over dimensionsmedlemmer med største positive budget afvigelse. Jeg forsøger, at udarbejde en ny analyse/KPI nedenunder på samme datasæt, der skal vise antallet af...
-
Conditional number format
Hi I have made an advanced row calculation with a number of columns. To my understanding I can only have one number format to a row calcultion. Is it somehow possible to make a conditional number f...
-
Empty value as a result of an if then else calculation
I have a have a simple calculation: "if sum(0, 0, m1) <= 0 then -1 else sum(0, 0, m1)" Instead of the value "-1" I would like to have the value NULL (empty). Is it possible to do that?
-
Advanced calculations (row) in the top of an analysis
Hi Is it somehow possible to see an advanced calculation (row) in the top of an analysis in the same way as a standard total? I would like the row "Total" and "growth" to be shown in the top of the...