Niels Thomsen

1. Community
2. Frontend, Designer and Consumer
3. Pausing and going back/forward in slideshow

Hi Karoline Currently there is no option to pause or go back/forward in the slideshow. Very soon we will open up to feature requests in this forum - so I guess this should be a candidate when we ge...

• View comment
• Created September 30, 2021 09:54
• 1 vote

1. Community
2. Data Discovery
3. Several rows per dimension if empty categories - after upgrading to 2021 ?

Hi Louise This is unfortunately a known bug in this version (2021 summer release). There will be an update in a few days that fixes this and other issues. The only workaround I can think of, until ...

• View comment
• Created August 24, 2021 13:39
• 1 vote

1. Community
2. Frontend, Designer and Consumer
3. Color Advanced Calculation Column

Hi Aaron  If you just want to color the two cells that make the intersection between calculated column and the 2 calculated rows, you might want to look at this article: https://community.targit.co...

• View comment
• Created August 16, 2021 07:45
• 1 vote

1. Community
2. Data Warehouse Developer
3. Creating a global dimension ?

Hi Louise Your XML-file seems correct and it's also placed in the correct folder. Restarting the TARGIT server is enough - it makes sure that the cache is cleared the latest version of your xml fil...

• View comment
• Created May 27, 2021 09:31
• 1 vote

1. Community
2. Frontend, Designer and Consumer
3. Sorting columns

Hi John Some calculations have relative references like: sum(d-1, d1:0, m1) This formula will accumulate the numbers from the first row to the current.  When you have this kind of relative referenc...

• View comment
• Created May 06, 2021 06:29
• 1 vote

1. Community
2. Frontend, Designer and Consumer
3. Is it possible to make a trigger to an e-mail? 

Hi Gia I just tried it - and it seems to work fine. So just choose to trigger to a URL and in the URL put in mailto:xxx@xx.dk - like this: Then the users default mail program should open and be rea...

• View comment
• Created May 06, 2021 05:40
• 1 vote

1. Community
2. Frontend, Designer and Consumer
3. How to create a chart with buckets? (small guide)

Hi Jora Since Dynamic dates are always calculated from today, you should be able to make a user dimension with different dynamic filters to create these buckets. First create a user dimension with ...

• View comment
• Edited April 06, 2021 06:44
• 1 vote

1. Community
2. General Discussion
3. Calculating Bradford Factor on your absence data in TARGIT

Hi Raf Thanks a lot for bringing this to my attention. I wasn't aware that such a decision existed. I guess we all still have a lot to learn about the implications of GDPR and other data protection...

• View comment
• Created March 31, 2021 10:21
• 1 vote

1. Community
2. Data Discovery
3. Use dimensions from a facttabel

Hi Gia If your data model only has one fact table, it's perfectly ok to use dimensions from that one facttable. However - if your model has 2 or more facttables, you will need dimension tables to q...

• View comment
• Created March 26, 2021 06:14
• 1 vote

1. Community
2. Frontend, Designer and Consumer
3. How to use the calculation "Count" so only rows with an amount different from 0 is counted

I agree with Louise and Tyler.  This is a general approach that I use very often - making intermediate calculations that are "flags" identifying something - and then making my final calculations ba...

• View comment
• Created March 25, 2021 08:02
• 1 vote