http://forums.visokio.com/discussions/tagged/fields_or_columns/feed.rss Mon, 30 Oct 17 19:28:46 -0400 Tagged with fields_or_columns - Visokio Forums en-CA http://forums.visokio.com/discussion/672/field-organiser-include-only-selected-rows-exclude-all-others Mon, 07 Mar 2011 10:55:40 -0500 Alk 672@/discussions Currently, when I get an update for some data, I have to check the columns match and if they dont, then I have to go through the Field Organiser and remove the new columns I do not need after replacing the file.

I would like an option in the Field Organiser which will automatically exclude/delete all new columns when the input is updated and only retain the previously selected ones.]]> http://forums.visokio.com/discussion/1038/formula-if-with-null-values-in-text-field Thu, 06 Oct 2011 12:44:50 -0400 Focus_Media 1038@/discussions
Steps to reproduce:

Create on new iok with 3 text fields: (Original, ChangedByUser, Formula)

Change field Formula and define this formula:
=IF(ChangedByUser="", Original, ChangedByUser)

If I write some text in the Original column, it should be shown in the Formula Field.

This worked fine until I installed yesterday last version.

Now, the condition (ChangedByUser="") ==> Is always False!!!

I think there are a little bit problem with Null/Empty values in a text field.

Because I didn't find a 'function' like IsNull(Value), i had to change the formula to:

=IF(("" & ChangedByUser)="", Original, ChangedByUser)

And then, it works fine... but I need to change a lot of formulas like this!

I think should be a 'function' IsNull(value) or IsEmpty(value), to avoid this problem.

Regards
]]> http://forums.visokio.com/discussion/838/text-filtering-any-vs-alls Wed, 22 Jun 2011 10:37:49 -0400 gayatri 838@/discussions
I am using a filter/device for company names (my filter type is text search). I want to enable tokenised text, so that user can enter multiple company names to view their data. I am using tokenised and using a comma (,) to separate company names. But when I test it using two company names, separated by a comma then it returns 0 results. (both the companies have data available in my Table view). I also tried using a semicolon (;) but to no effect. Could someone please help me.

Thanks,
Gayatri]]> http://forums.visokio.com/discussion/623/define-a-field-as-a-category-in-field-organiser-block Wed, 26 Jan 2011 05:14:36 -0500 edtclarke 623@/discussions
We would really love the ability to force a field to a category in the field organiser block in DM. We have had some mixed results trying to force the data into an explorer/omniscope block and changing to a category there.

Thanks]]>