http://forums.visokio.com/discussions/tagged/blanks_nulls/feed.rss Mon, 30 Oct 17 15:21:36 -0400 Tagged with blanks_nulls - Visokio Forums en-CA http://forums.visokio.com/discussion/968/idea-variable-column-names-and-de-pivoting Fri, 02 Sep 2011 13:59:16 -0400 ygulla 968@/discussions
Input data is stored in a csv file, it has a daily changing number of columns (say 20-25), 10 of which have fixed names while the rest are named with dates. I want to de-pivot only the date-named columns.

The problem is that the number and names of the date columns change daily. Hence a simple de-pivot operation doesn't work once the data has been changed. Ideally I want a de-pivot option where it de-pivots all the columns apart from the selected ones.

Is it possible to achieve such de-pivoting in Omniscope some way? And if not would an option 'de-pivot everything apart from selected columns' be possible to include into de-pivot operation?

P.S. I tried every combination of operations I thought might lead me somewhere, and almost got the result, but in Summarise operation selecting "All fields" doesn't keep all the fields selected after the field names changed, the way that most other operations work. Is that intended?]]> http://forums.visokio.com/discussion/3156/blank-spaces-at-the-end-of-cell-text-causes-the-row-lenth-to-differ Thu, 28 Jul 2016 10:43:14 -0400 TZABACK 3156@/discussions http://forums.visokio.com/discussion/1634/barline-view-displaying-null-or-zero-value-bars-on-x-axis Mon, 02 Jul 2012 11:18:14 -0400 misakch 1634@/discussions Thanks a lot, Michal]]> http://forums.visokio.com/discussion/2843/radar-view-parallel-coordinate-null-valuess Thu, 12 Feb 2015 05:35:37 -0500 daniel 2843@/discussions
]]> http://forums.visokio.com/discussion/2585/pivot-view-pivoting-by-more-than-two-categoriess Mon, 09 Jun 2014 12:14:43 -0400 benjamin 2585@/discussions
I am pivoting by two (2) fields horizontally e.g. [Field 1] , which contains A1, A2 and [Field 2] which contains B1,B2

[Field 1] [Field2]

  A1
            B1
            B2
  A2
            B1
            B2

My problem is that if in the data there is no row which has A2 in [Field 1] and B2 in [Field 2], in the Pivot View it will leave the associated rows empty with no row header or anything.
See example... most probably more clear.
For the Collateralised, Senior Unsecured and Supranational bonds they have only Tier *, however below Tier * there are gaps where Omniscope thinks other examples of tiers should go.]]> http://forums.visokio.com/discussion/2471/filtering-record-filter-looking-for-word-with-spacess Mon, 17 Feb 2014 05:40:18 -0500 Nemesis 2471@/discussions
I want to filter a list contains a word " CLO " i.e with blank SPACE in front and back but Visokio won't let me do it, it uses "CLO" without spaces as the only input. Is there any wildcard character to do this??

I have been searching this using below Excel forumla:

=IF(OR(ISNUMBER(SEARCH({" word1 "," word2 "," word3 "}," "&A1&" "))),"YES","NO")]]> http://forums.visokio.com/discussion/2051/pivot-view-suppressing-blank-values-in-pivot-view-2s Fri, 15 Mar 2013 10:11:12 -0400 grahamb 2051@/discussions http://forums.visokio.com/discussion/1789/filtering-no-value-freezes Thu, 27 Sep 2012 06:45:40 -0400 dszl136154 1789@/discussions http://forums.visokio.com/discussion/1631/mergejoin-nulls-on-both-sides Fri, 29 Jun 2012 09:12:45 -0400 davedunckley 1631@/discussions
Looks like when I merge two numbers in 2.7-rc b369 it turns the output to null. Any one else seeing this?

Dave
]]> http://forums.visokio.com/discussion/1162/summary-and-granular-level-data Mon, 12 Dec 2011 12:15:52 -0500 adam_varney 1162@/discussions
Sorry if this is not the best explanation for the issue but any help with gettining this data to the correct format would be appreciated

Thanks
Adam,]]> http://forums.visokio.com/discussion/670/formulae-ignoring-blank-cells-when-calculating-averages Mon, 07 Mar 2011 04:08:33 -0500 Paul 670@/discussions
Could someone help me please with the best way to configure Omniscope to calculate an average which ignores or excludes the blank cells, such that it calculates the average of the 4 fields in the above example as 10, as Excel would do as standard using the AVERAGE function?

The above example is the first row in a dataset - subsequent rows have decimal values in all 4 fields and so the AVG function calculates the average 'correctly'

Thanks, Paul
]]>