en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Henrik Jørgensen  
#1 Posted : Tuesday, November 27, 2018 3:34:33 PM(UTC)
Henrik Jørgensen
Rank: Newbie

Groups: extranet\Forum
Joined: 11/27/2018(UTC)
Posts: 3

Hi there, apoligies, if this is easy to solve, but I am new to Targit.

I work with data series, that have different frequency. Some data is with minute resulution, some hourly.

The dataset looks like this, when presented:
( strange, the BBCODE monospace is not supported, apoligies, but using underscore to make tables)

_____1minvalue___5minvalue
1_____3_____________22
2_____3_____________
3_____4_____________
4_____3_____________
5_____5_____________
6_____3_____________100
7_____3_____________

Unfortunately, the blank data is interpreted as 0 not NULL, so what is read by targit is


_____1minvalue___5minvalue
1_____3_____________22
2_____3_____________0
3_____4_____________0
4_____3_____________0
5_____5_____________0
6_____3_____________100
7_____3_____________0

Needless to say, the graph is not pretty - the 5min value is 22 for the entire time period, so what really should be read is

_____1minvalue___5minvalue
1_____3_____________22
2_____3_____________22
3_____4_____________22
4_____3_____________22
5_____5_____________22
6_____3_____________100
7_____3_____________100

Thanks to the good video on syntax, I could quickly do a custom formula to fix the data:

if sum(d-3, 0, m1) = 0 then sum(0, -1, m1) else sum(d-3, 0, m1)

Unfortunately, the result is not entirely recursive:


_____1minvalue___5minvalue___my formula
1_____3_____________22_____22
2_____3_____________0______22
3_____4_____________0______0
4_____3_____________0______0
5_____5_____________0______0
6_____3_____________100____100
7_____3_____________0______100

So the formula is working, I pick the value above the present cell, if the column I am looking into is zero, but only once, not every time. It appears, that the formula does not recognize the calculated field above. I tried using c1 instead of 0 as column, but that was not working

So either I need to find out how how to handle NULL as previous value, or something like the above.

I see in the forum that I am not the only one with this issue, but others try to hide NULL data, I try to overwrite it.

NULL problems!

Thanks in advance

Henrik
Ole  
#2 Posted : Friday, November 30, 2018 8:54:39 AM(UTC)
Ole
Rank: Administration

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

Hi Henrik,

That is a bit strange - I can make the recursive thing work, just like you meant to do it.

Are you sure you are not hiding any rows? In that case your syntax should read sum(0, -1(v), m1).

If you cannot make the recursive thing work, you should still be able to hide the zeros in your 5minvalue column. Either you can do it generally through number formatting (Advanced format, no digits on zero numbers), or you can do it with a visibility agent (hide value when value = 0).

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
Henrik Jørgensen  
#3 Posted : Sunday, December 2, 2018 11:59:30 AM(UTC)
Henrik Jørgensen
Rank: Newbie

Groups: extranet\Forum
Joined: 11/27/2018(UTC)
Posts: 3

How strange. The exact formula I posted here is working fine now.. Anyway, now it's there for anyone with the same problem

Thanks for testing though

BR

Henrik
Henrik Jørgensen  
#4 Posted : Sunday, December 2, 2018 12:12:32 PM(UTC)
Henrik Jørgensen
Rank: Newbie

Groups: extranet\Forum
Joined: 11/27/2018(UTC)
Posts: 3

ok, recreated the problem. If I add a new column with a formula it Works. But if I add a calculated field, Target adds three extra columns, and the depicted behaviour shows up.

BR

Henrik
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