Hi support, in my Collect database I have some boolean fields (e.g. whether a sample point belongs to a certain special management or not). These boolean fields don't show up in Saiku, but I need them as filters. How to get them there? Do I need to define a category for that? A small example code would help me a lot.

This question is marked "community wiki".

asked 05 Jun '15, 07:29

Fehrmann's gravatar image

Fehrmann
7731935
accept rate: 0%


Hi. In Calc, I got (computed) boolean variable to Saiku, works quite similarly with boolean fields:

1) create category:
0='no', 1='yes'

2) R script: tree$tree_is_alive <- ifelse( tree$tree_health ==5, 0, 1 )


Regards, Lauri

permanent link

answered 15 Jun '15, 12:07

Lauri%20%28OF%29's gravatar image

Lauri (OF) ♦♦
6952816
accept rate: 20%

Hi Lutz,

Thanks Lauri for your answer and for posting some sample code!

Boolean fields are not supported by Calc, you should instead use a category with two possible values (Yes/No) when you collect your data, or as Lauri suggested, you can create a new calculation step type category in Calc.

Please let us know if you need more info.

Regards,

Mino

permanent link

answered 18 Jun '15, 12:33

Mino%20Togna's gravatar image

Mino Togna ♦♦
52116
accept rate: 12%

Hi Lauri and Mino,

thanks you for the example, it helped me a lot. Seems to work fine! Lutz

permanent link

answered 18 Jun '15, 14:16

Fehrmann's gravatar image

Fehrmann
7731935
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×42

question asked: 05 Jun '15, 07:29

question was seen: 6,089 times

last updated: 18 Jun '15, 14:16