http://forums.visokio.com/discussions/tagged/Table_view/p1/feed.rss Mon, 30 Oct 17 13:49:37 -0400 Tagged with Table_view - Visokio Forums en-CA http://forums.visokio.com/discussion/3106/table-view-lock-displayed-fields-to-prevent-new-fields-from-appearing-in-the-existing-tables Mon, 07 Mar 2016 12:30:14 -0500 dabay 3106@/discussions
Is there a way to lock the displayed fields for each existing table view, so if you add extra fields to the Omniscope block in the data manager tab it does not mess up your existing tables? e.g. see screenshot below where the extra columns appear appended to the table which is undesirable.
]]> http://forums.visokio.com/discussion/2904/table-view-different-behaviors-of-details-pop-upss Fri, 10 Apr 2015 06:36:05 -0400 fcavalieri 2904@/discussions In the 2.9 release, in Table View, I have different random behaviors of details links (i.e. in attachment).

I'd need always get the unaggregated data, when I open details in an aggregated table view (like in details3).

Thanks!]]> http://forums.visokio.com/discussion/2615/idea-pivot-view-table-s-query Fri, 27 Jun 2014 07:19:08 -0400 dpawley 2615@/discussions
Thanks, Danny]]> http://forums.visokio.com/discussion/2870/table-view-display-images-in-a-total-lines Wed, 11 Mar 2015 12:37:23 -0400 Avizua 2870@/discussions
I did a Table view and inserted a total line. One column is displaying images and I would like to show the image on the total line (just like in the columns).



Would it be possible to do that ?

Thanks in advance]]> http://forums.visokio.com/discussion/2872/table-view-disable-colour-keys Wed, 11 Mar 2015 15:12:55 -0400 rajeshbalu29 2872@/discussions I am unable to disable the colour key in the Table View as attached in the snipping on both Visokio 2.8 & 2.9.
Can you please assist.

Thanks & regards
Rajesh B]]> http://forums.visokio.com/discussion/2864/table-view-in-view-aggregation-unique-value-sort-orders Tue, 10 Mar 2015 08:24:47 -0400 rng 2864@/discussions
The comma separated unique values displayed in those columns are being auto-sorted which is misaligning the sequence of values & potentially misrepresenting the list value mapping. Could I prevent this sorting of the unique-value-lists?

Thanks, Rohan]]> http://forums.visokio.com/discussion/2822/display-display-two-tables-with-different-groupings-expandeds Wed, 21 Jan 2015 04:16:05 -0500 enrico68 2822@/discussions Since expanding all categories will result in a wide table difficult to be read when printed, I created, copying the first one, a second table equal to the first one as indicated in Figure 2.

The idea was to expand some of the groups on the first table and the others on the second table (in this way in both tables it is possible to read the total of each category - expanded or not - and the overall total).

Unfortunately it seems almost impossible to do this because when I choose the groups to expand on the first table, these are expanded also on the second one and when I change the expanded groups on the second table, these are expanded also on the first one.

The only way I was able to obtain two tables with different expanded groups was to change the order of the columns in one of the tables (as reported in fig.3 and fig.4). But if I return the copied table columns in the same order of the original table, the order 'magically' change again and the table return equals. Also changing the order of the original table as in the copied table, results in a grouping change.

So the question is: how to get two equal independent tables in one Omniscope .iok?]]> http://forums.visokio.com/discussion/2786/table-view-freeze-columns-in-a-scrolling-tables Mon, 15 Dec 2014 10:50:52 -0500 ALC 2786@/discussions http://forums.visokio.com/discussion/2773/filtering-automatically-hide-all-empty-colums-in-table-view Thu, 27 Nov 2014 11:06:17 -0500 aeastwood 2773@/discussions
I would like to be able to automatically hide all columns which are left completely empty or full of zeros by the query currently in use in table view. For small numbers of columns it would be possible to manually hide columns, but ideally they would be dynamically hidden and restored as I changed the query (i.e. if I was changing the query/filters in such a way that unpopulated and repopulated certain fields).

If this is not possible, being able to select something like 'automatically hide this particular column if it's empty' would help.

Please let me know if such a feature already exists.

This is similar to an idea raised a couple of years ago (http://forums.visokio.com/discussion/comment/6796/#Comment_6796), but nothing from that thread seems to help me.

Thanks!]]> http://forums.visokio.com/discussion/2768/idea-filtering-auto-hide-empty-columns-in-table-views Tue, 25 Nov 2014 08:21:44 -0500 DominicChan 2768@/discussions
In the DataManager operations list, there is a nice operation: Field Filter, that can remove columns that have no values.

Is there a way that the Table View can do the same thing?

For example, I have 4 fields: Client, Max, Min, Med. Client B only have field "Max" populated. When client B is selected in the filters, the Table view would only display 2 columns: Client and Max.

It would hide/not display Columns Min and Med as there is nothing populated for the selected data subset.

Is this possible?
Dom]]> http://forums.visokio.com/discussion/2752/export-grouped-table-view-data-to-excels Sun, 02 Nov 2014 14:06:51 -0500 kmatrix999 2752@/discussions
I have grouped and filtered data in table view. I have tried to export the data to Excel but lose the grouping.

Is there a way to export data to Excel and retained the grouping and sub totals?]]> http://forums.visokio.com/discussion/2426/idea-table-view-grouped-headers-displays Fri, 13 Dec 2013 09:25:09 -0500 TomRiggs 2426@/discussions http://forums.visokio.com/discussion/1495/table-view-fading-of-colourss Tue, 24 Apr 2012 09:47:23 -0400 bgrovens 1495@/discussions
I searched the forms based on the table view coloring and this is all I could find was an idea:
http://forums.visokio.com/discussion/727

It appears that you can color code the view based on a given field. That works fine, the probelm is that Visokio automatically changes the color. For example you set the color to amber view the options menu CTRL-f. Turn the color key on via the toolbar/styles menu. You will see the color key is darker and the actual table is lighter. It looks as if Visokio is automatically making the color ligher. This process is almost always making the color look terrible. Is there an option to turn this process off?

Please refer to my attached picture below. Notice the color key shade and what actually populates on the page. I would want the colors to be the same.



Thanks for the help,
Brian]]> http://forums.visokio.com/discussion/2316/table-view-grouping-options Fri, 13 Sep 2013 05:33:36 -0400 davedunckley 2316@/discussions
I don't seem to have any option of fields to Group by in Table View. Any reason why this might be?

Thanks, Dave
]]> http://forums.visokio.com/discussion/2166/idea-table-view-column-header-styling-optionss Thu, 23 May 2013 11:14:43 -0400 jraich 2166@/discussions Header height and Bold header. (and alignment via Field menu)
I'd suggest adding some additional styling options:
- Gridline strength (so it can match the row and column gridlines styling)
- Background colour

Jordi]]> http://forums.visokio.com/discussion/2113/table-view-sort-by-grouped-totalss Mon, 29 Apr 2013 11:30:13 -0400 Mees 2113@/discussions Sorting a column in a grouped table works not as expected... it sorts the underlying records (I assume).
We would want sorting the values you see in front of you, the totals...?

Thanks, A]]> http://forums.visokio.com/discussion/2099/table-view-grouping-value-functions-optionss Fri, 19 Apr 2013 04:39:56 -0400 enrico68 2099@/discussions
Please, for details consider the example in the attached file.

Thanks]]> http://forums.visokio.com/discussion/2096/colouring-table-view-variations-to-colours-selecteds Wed, 17 Apr 2013 10:49:23 -0400 Mees 2096@/discussions
We are trying to color the rows in a table based on a value. Nothing special and it works.
However, Omniscope is not showing the colors we defined.

In the picture attached there is an example. The colored record numbers are the colors we need. We can't find the setting that provides what we need.

What we do not want is the Variation function under the Coloring button as it variates within a color as well.

Hope you can help
Thanks
]]> http://forums.visokio.com/discussion/2060/idea-table-view-export-scrollable-htmljs-tables-for-webs Mon, 18 Mar 2013 10:31:21 -0400 grahamb 2060@/discussions http://forums.visokio.com/discussion/2000/table-view-scroll-bar-optionss Wed, 30 Jan 2013 21:28:36 -0500 shaji_o 2000@/discussions
I've tried squeezing the column size to make it all fit, but there are too many columns]]> http://forums.visokio.com/discussion/1984/table-view-columnfield-headers-multi-line-text-wraps Mon, 14 Jan 2013 01:26:41 -0500 shaji_o 1984@/discussions http://forums.visokio.com/discussion/1925/idea-tablepivot-view-column-and-values-stylings Thu, 29 Nov 2012 04:23:28 -0500 enrico68 1925@/discussions
- apply formatting to reported values (including different dates and numbers representations) -
example: show all values scaled/divided by 1000, ..., 1,000,000;
- apply formatting to whole columns and rows
examples: centering values, representing negative values in red or between brackets, show different kinds of border to divide sections of a tables - e.g. details and summary).
]]> http://forums.visokio.com/discussion/1914/ideas-table-view-more-formatting-optionss Fri, 23 Nov 2012 05:01:40 -0500 enrico68 1914@/discussions
I have to say that most of the reports required are tables of various format; considering this I'm particularly interested in tryint to exploit all the table view features.

I have no problem in getting the required data but unfortunaltely I have to say that it seems to me that at the moment there are many graphical formatting limitations.
I've read other discussions about this needs and I'd like to know it these issues are solved or if they will be considered in future releases.

In particular I think it will be useful to have the possibility to:

- insert a table title including variable parts (such as formulas) or logos;
- format column headers (changing column header color and font, centering headers);
- have table headers based on multiple rows and different disposition (like the colspan and rowspan html command) including also descriptions and not only column data headers;
- apply format to reported values (including different date and numbers representation - es: apply /1,000,000);
- apply format to columns (centering values, representing negative values in red or between brackets, ....);
- ....

At the moment the only way I've found to make a table applying some of these features is to create a Content view and produce the table using scripting, but I would really like to be able to do the same without programming.

Thanks ]]> http://forums.visokio.com/discussion/1892/table-view-sort-by-grouped-subtotalss Sun, 11 Nov 2012 10:52:51 -0500 Alexander 1892@/discussions Am I doing something wrong or is this not possible? Thanks!]]> http://forums.visokio.com/discussion/1862/idea-table-view-hide-all-empty-fields-options Wed, 24 Oct 2012 05:15:02 -0400 ZhouNan 1862@/discussions
I have a data file which generates six different data sources from database, and each data source is populated in an individual tab. Because there is few overlapping column names, it ends out about 150 fields in total.
So, the problem now is that when user clicks any parts of the data in any tab and view the details, it shows all the fields including 100 or more empty and unrelated columns (as shown in the attachment) although the unrelated data sources are filtered out by Source filter.

I am wondering if there is a easy and centralized way to manage the fields shown in Details view on each tab. Or, do I have to manually hide all the unrelated columns in each graph and do the same for the other tabs which might a huge amount of zombie work.

Thank you very much!

]]> http://forums.visokio.com/discussion/1777/idea-table-view-units-display-formatting-of-numberss Thu, 20 Sep 2012 14:57:23 -0400 benjamin 1777@/discussions
I know there is a way around by dividing by 1000 and 1000000 retrospectively and then adding a suffix but this is a hassle.

Thanks - Ben
]]> http://forums.visokio.com/discussion/1735/table-view-grouping-contains-function-issue Wed, 29 Aug 2012 08:12:47 -0400 JfJf 1735@/discussions #1 group named "Group 1" = contains the text "group1", #2 group named "Group 2" = contains the text "group2", #3 group named "Other" = everything else that doesn't have the "group1" or "group2" text.

The problem that I am having is that when I put the values in a table, and group them by the category function I've created, the 3 categories are isolated properly, but the name value that appears on the table is "Other", which is the group I've created to include everything else that is not in group 1 & 2. Instead of the 3 categories: 'Group 1', 'Group 2' and 'Others'.

Some help on this would be appreciated! Thank you, JF

]]> http://forums.visokio.com/discussion/1589/column-alignment Mon, 11 Jun 2012 05:41:25 -0400 aknotts 1589@/discussions
Thanks]]> http://forums.visokio.com/discussion/883/table-view-improve-table-view-grouping Tue, 26 Jul 2011 03:26:56 -0400 steve 883@/discussions 1. formula calculation precedence options should mirror aggregation (formula result per field, rather than view-wide precedence setting)
2. wysiwyg, i.e. you have to show fields for them to work in formulas precedence setting (because otherwise you can't configure the mean/sum function for hidden fields)
3. you can currently only group by category fields
4. you can't show summaries in blank collapsed grouping columns
5. memory-inefficient

Ideas: improve the options so it is identical to aggregation, except the aggregation fields are in a chosen order, and you can expand/collapse them, and sort the resulting data.

Or, consider merging aggregation with grouping, by making aggregation have the collapse/expand capabilities currently only available with grouping.]]> http://forums.visokio.com/discussion/824/formatting-questions Wed, 15 Jun 2011 13:16:35 -0400 hgross 824@/discussions
Is there a way to have the records/values/percentage of a pie chart show on the label instead of on the pie slices? Also, is there a way to show values in the pie for larger percentages and pull them out for smaller wedges?

And finally, is there a way to hide rows of a table so it only shows a specific # of rows?

Thanks!]]>