First, you want to put the file into a data module, do your modelling there, and then use the module in the dashboard.
There really isn't enough modelling functionality built in to dashboard to do what you want to do to get done as you need to model your data.
It isn't clear what you mean by 'editing'. I'm guessing the values which appear are your 'edited' values. They are not date values. You can look at the properties of the query item and determine what the data type is.
You have several options. You will need to cast your query item to get it converted into a date data type. Another option is instead of casting the date column, you might want to edit the data in your source file. Data in the format 2021-08-21, when uploaded, will be understood generally as being a date data type.
Here is an example expression which takes a numeric data type column very much like your column and casts it into a date.
cast (
substring(
cast( SHIP_DAY_KEY as varchar(10)) ,1,4 ) || '-'
+
substring(
cast( SHIP_DAY_KEY as varchar(10)) ,5,2 )|| '-'
||
substring(
cast( SHIP_DAY_KEY as varchar(10)) ,7,2 )
, date)
What is the provenance of the data? Is is from an existing FM package etc.? If so you might want to think about extending the package by including it in a module and do your modelling there. (the experience for that is far better and more flexible in 11.1.x and 11.2.x as you can create views to extract metadata from the package and model those with your other stuff) Given the nature of the data it is possible you have gotten it from on-line so that isn't really relevant.
It looks like you are using 11.0.x.
In 11.1.x there are more filter options. For example you could select the parent query item and in the manage filters dialog choose to create a filter via the expression editor, which would give you a rich filter definition experience.
No matter what version, if you want to use the filter conditions UI, if the data type of the query item is date then there will be an appropriate filter UI. The attached pictures shows the 11.0.x filter dialog for a query item which has a data type of date.
Please refer to the documentation and my blog topic about filters and my topic about the expression editor.
https://community.ibm.com/community/user/businessanalytics/blogs/ian-henderson1/2020/12/22/module-filter-types
https://community.ibm.com/community/user/businessanalytics/blogs/ian-henderson1/2019/10/17/cognos-analytics-modelling-expression-editor
Hope that helps.
------------------------------
IAN HENDERSON
------------------------------
Original Message:
Sent: Wed August 18, 2021 10:45 AM
From: Ed Finn
Subject: First Time Filtering on Date...How to get better filter options?
Hi, I recently pushed my first csv into Cognos.
Have a background using some BI tools, but never this one.
I pushed a date field formatted as YYYYMMDD (20210821, for example). Cognos recognized it as a number, so I did some editing and it seems to recognize it as a date now.
I pushed about 2 years of data with the intention of splitting my analysis into 2 separate years (pre-covid vs during covid), but the filter options for date don't include 'Between', 'less than', or 'greater than'. I only have contains, does not contain, starts with, ends with, does not start with, does not end with...etc. I also have the option of manually selecting each individual date I want to include, which is also not ideal.
Is there a way I should maybe re-do the format settings to get more appropriate filter options?
I am trying to do this within a Table, within a Dashboard. Using Cognos Analytics 11.1 R3
Thanks,
Ed
------------------------------
Ed Finn
------------------------------
#CognosAnalyticswithWatson