Skip to main content

Good afternoon,

I was wondering if there is a way to make it so that data goes directly into a grouped dimension? If you have data coming in daily from a database, how do you get it so that instead of going into it's original dimension and you having to update the group constantly, it goes straight into the group?

 

For example:

Say you have a timestamped field on your server and you want hours 0-12 to go into a grouped dimension called daytime and 13-24 to go into a group called nighttime or something. But instead you just keep getting timestamps coming in and have to manually place them into the group?

 

I hope that was clear. Thanks!

3 answers
  1. Apr 2, 2020, 1:57 PM

    You can create a calculated field

     

    IF DATEPART('hour',[TIMESTAMP]) <= 12 THEN "0-12"

    ELSE "13-24"

    END

0/9000