Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count when the dates match

Status
Not open for further replies.
darklord2

darklord2

MIS
Sep 25, 2019
2
0
0
US
Hello,
So I have this report which is using date in the format (yyyy-mm), I need to count the number of published programs when I select a particular month and corporation.
So I select Ahold and select time as 2019-05, it should show me 5 published programs.
The attribute being looked at has the 'yyyy-mm-mm' format. What I wanna know is if 'Apply Aggregate' function can be used to like ' if the main date matches the first 6 digits of attribute, it counts'?

Best
 
Status
Not open for further replies.

Similar threads

lithium78
  • Locked
  • Question
New to Microstrategy, rows disappears when column value 0
Replies
1
Views
58
AnaFlorTech
AnaFlorTech
Mscherer
  • Locked
  • Question
View Filter changing values when applied
Replies
0
Views
29
Mscherer
Mscherer
mstrpup
  • Locked
  • Question
Displaying single date when metrics filtered by two diff date attr
Replies
2
Views
53
mstrpup
mstrpup
venkatesancs
  • Locked
  • Question
Count distinct metrics in the OLAP cube.
Replies
2
Views
47
bi4fun
bi4fun
sunnyphoenixier
  • Locked
  • Question
Sort Metric by Dynamic Dates
Replies
2
Views
31
sunnyphoenixier
sunnyphoenixier

Part and Inventory Search

Sponsor

Back
Top