Some Data Visualization and BI websites have dashboard design competitions.. it could be interesting also for us since we are a growing community of Omniscope users, to explore the possibilities with some "shareable" data. There are already some sources such as the Demo data-sets, but it could be interesting to also create a bigger library of visualizations created with Omniscope.
Maybe the winner could get a personal Omniscope license? In any case, it could work as a PR tool too.
The usual structure is to provide a sample data-set + a brief and a deadline. It could be fun...
An example of a competition below:
http://www.perceptualedge.com/blog/?p=1308
Cheers,
]]>
Could we have an undo key, like Ctrl+Z]]>
In the attached snippet, I have one project and three activities. The activities are, respectively, Red, Amber and Green. When I filter out the completed activity (Red), I was hoping to see the Project status change, as now there's only a Green and an Amber in play. That doesn't happen - the overall project status stays Red, even when I show only the open activity, which is Green.
Is there a way to make SUBSET() functions recalculate on just filtered data? Or am I going the wrong way about this?
]]>
I can press "Reset" button and solve it. However, a user with only a free Viewer cannot do that (?)
Is it possible to "reset the query" before the data is loaded for the user?
Thanks]]>
I know that you can have only two versions of Omniscope on your machine. But is there a way to implement something for the future to have more than two ? I am currently working with three version. Whenever I want to use third version I need to reinstall Omniscope which is quite annoying in the long run. ]]>
Thanks.
Mai.]]>
What are the break points for the number abbreviations changing from k (thousands) to M (millions). Sometimes you will see 6,765k. Is it 10 million? Are there any rules from changing from singles to thousands and so on?
Thanks......Andy]]>
Can we have this available in Omniscope for one of our important report requirement?]]>
This would prevent users from updating everyone else's view of a file, while allowing them to save their local changes made from the browser. It would use far less server memory than having multiple copies of the IOK file, since the data would be shared. When a given user next logs in they would get their own configuration of the file as they left it, but will also have the ability to revert back to the master file configuration.
This would allow each user to have their own saved state of an IOK file; the master IOK file itself would hold the data (along with the original "master configuration").
A new user permission would control whether you could save back to the "master configuration" in the IOK itself or not.
We are also considering allowing some kind of URL query param to specify the "saved user id" which will be used to identify the user. There is a related discussion here about query params mentioned here:
http://forums.visokio.com/discussion/comment/9410/
Let us know of your thoughts and ideas and if you would be happy to help develop this idea.
]]>
At the moment we have implemented our first web report with a link to Microsoft SQL reporting services - we use the Omniscope report for top level view of a group of accounts then a linked field on the user account number to allow direct access to the SRSS report which shows all transactions on the account going back up to 10 years. Embedding report parameters in the URL effectively makes all data linkable within the scope of the designers imagination!]]>
Using a tab name to set a variable (this came off the idea of a different post about tab names http://forums.visokio.com/discussion/2680/idea-tab-links-accept-variables-for-resolving-tab-linkss)
IF(
Tab= "Tab_1", SetVar [VariableName] = "VariableOption1",
Tab= "Tab_2", SetVar [VariableName] = "VariableOption2"
)
OR using a variable to set filter conditions:
IF(
VariableName= "VariableOption1", set field filter [PostcodeSectorField] ="HA",
VariableName= "VariableOption2", set field filter [PostcodeSectorField] ="WC",
)
Also to use existing premade queries:
IF (
Tab= "Tab_1", Use Query state = "QueryName1",
Tab= "Tab_2", Use Query state = "QueryName2"
)
]]>
I am looking to have 3 pivot tables with brands on the Y Axis and then split by This year and last year, with a % Change. I have one table for each pack size (small mid large)
The issues is that I have some brands which only appear in one set of sizes (for example a brand may only have large packs). Because of this it a brand may appear in position 5 in one table and 7 on another. I would like it so they are always in the same position.
The 'pivot 2' in 2.8/9 does this perfectly, however I am unable to show % Change.
Does any one have a suggestion of how I can keep brands on the same 'line' / in the same order even though I will have to put them in multiple tables (In order to have my % change)
I have attached a file which has a 2.8 pivot on the left, which is just what I want (but doesn't have % Change) and then two 2.7' pivots which ave a % change but the brands may be in different orders
Many thanks
]]>In other words, is there a view I can use that allows the user to input numbers and then on the back-end use custom variables to make calculations that adjust my other views?]]>
https://developers.facebook.com/docs/reference/ads-api/]]>
https://developers.google.com/doubleclick-advertisers/reporting/v1.3/dimensions#reach-metrics
]]>
Is there a way of exporting not the data from a report but just the applied filters to the dataset?
Many Thanks
Danny]]>
For example, one could define the number of columns and rows and populate an empty table matrix of cells, which you can then fill in with values within the DataManager.
The idea is to actually reduce having to create separate lookup Excel/csv files and to have a way to do a free-text table all within the DataManager space. This will also make moving the IOK file around easier as it will have fewer external file dependencies if we can embed all the data (and not just a 10-record snapshot) within the DM space within the IOK file itself. ]]>
I have set up a Bar-Line view that is layered on 4 measures. 3 measures have values between 108 and 130. So that left axis is showing a range that is similar to the range of values! This works great.
However, I have a 4th measures with values from 1 to 12. I set up this value on a right axis. Now the left axis expands the range from 108-130 to 0-130. This results in (almost) flat lines of the 3 measures that are measured on this left axis.
I think this is a bug, because there is no lower value in the dataset that is plotted in the left axis, so the range should not change? I am available for a screen share today or tomorrow.]]>
Our workflows have very dynamic characteristics, and when new fields enter these operationblocks, they are standard ticked off. It would be nice to determine that all fields that start with "week*" are ticked on. ]]>
How do i remove these lines from the table? I only want the lines to show when exporting to the end of table and not of the view.
Thanks, Ben
]]>
I'd appreciate if the record filter was changed so there is a setting to grab the top ten (or N) items for each category. At present this isn't possible and you have to do four steps to replicate this.
As an example, I'm working with Google Analytics data for multiple websites (using the API connector which is very handy) and I'd like to see the top 10 landing pages for each site. Not the most exciting request, but I imagine this has applications elsewhere. Thanks]]>
Currently there is the ability to pull in data from BigQuery, but I'd love to see the option to also publish to it. It would save an extra step for myself of uploading data outside of Omniscope.
Does anyone else feel this way too?]]>
Just wondering if there is a way of replacing everything within brackets in a string of text.
I have a field that has a name, then a former name within parentheses. I would like to be able to remove the ( ) and also everything within.
Example:
Smith (jones)
Should become:
Smith
as should:
(jones) Smith
Thanks in advance
Dave]]>
]]>I have been asked to produce a Map view report by our marketing team. Basically we wish to show on the map all our locations. We will also show on the same map the locations of a partner of ours. I was able to get this to show by the usual methods. But what the marketing team would like is to show a small graphic instead of the default marker. So for all our locations we show a small graphic and for all the partner we show their graphic (small logos) This was we can show the complementary locations of both our sites.
Can you let me know how I can do this?]]>
I was wondering whether it is possible to customise the menu buttons in Omniscope browser versions?
For some purposes we do not want to show the view menus or the toolbar.
Thanks]]>
In their own words: "DataSift Inc. is enterprise social data platform, enabling companies to aggregate, filter and extract insights from the billions of public social conversations on Twitter, leading social networks and millions of other sources. DataSift provides access to both real-time and historical social data to uncover insights and trends that relate to brands, businesses, financial markets, news and public opinion."
http://www.datasift.com]]>
We pull a lot of real-time data into Elastic Search, it would be awesome to be able to connect visokio to this to pull the later stats. We total live search reports per day etc]]>