Tagged with category-filtering - Visokio Forums http://forums.visokio.com/discussions/tagged/category-filtering/feed.rss Mon, 30 Oct 17 16:47:10 -0400 Tagged with category-filtering - Visokio Forums en-CA Filtering: Creating categories from start and end dates? http://forums.visokio.com/discussion/2710/filtering-creating-categories-from-start-and-end-datess Wed, 10 Sep 2014 12:01:09 -0400 Phillipa 2710@/discussions
I have no experience of using date fields and need help.

Specifically, I have various types of chemotherapy that have a start date and an end date.
I need to be able to determine in which quarter a specific chemo took place. And really need separate fields for each quarter a bit like yes/no fields, as I split my data by quarters.

EG a chemo started on 01.02.2014 and ended on 14.09.2014 would be categorised in Q1, Q2 & Q3 but not in
Q4.

I have looked at buckets but can't seem to get my head around it.

Can anyone help please??

Thank you.
Phillipa]]> Filtering: Categories and nested sub-categories? http://forums.visokio.com/discussion/2466/filtering-categories-and-nested-sub-categoriess Fri, 07 Feb 2014 12:54:39 -0500 OmarKhan 2466@/discussions
To be more specific, imagine I have a category that divides countries between “emerging countries” and “developed countries”.
I would then like to affect the pertinent countries (that’s the subcategory) to its right category. For example, I would say
• Emerging countries
o Zambia
o Argentina
o Groenland
o Etc
• Developed Countries
o France
o Germany
o UK
o Etc
All of that, in the criteria tabs of Omniscope. I know you can do that in SQL and that its possible in Excel (please see below).
By your knowledge, is that something realizable on the dashboarding part of Omniscope?

The two fields I am trying to have merged together are “Markets” and “Market type”.
The details of which countries are emerging are contained in the formula. All countries that are not “emerging” are “developed”.
]]> Date/Time: Sorting Category filters by Date? http://forums.visokio.com/discussion/2038/datetime-sorting-category-filters-by-dates Wed, 06 Mar 2013 09:01:35 -0500 PaulChapman 2038@/discussions
I have not found a way of re-sorting the filter to let me choose the order I want. This is a problem when I want to use pane's side by side, with the oldest date at the top rather than the alpha date at the top. Can anyone suggest a way of doing this?

Thanks, Paul]]>