Count ID by month

[#1]

Hi All,

I have date field (DD/MM/YYYY HH:MM:SS:YYY), and I have calculating month in vMonth, how do I get : TextCount (ID) based on my vMonth variable?

Thanks,

Lakshmi.

[MK_QSL]

Lakshmi, didnt understand from your explanation properly... can you elaborate little more please?

[Anonymous]

Please elaborate more on this post

[fabio_vallone]

Instead vMonth, try this:

Dimension: =Date(Monthstart(<DATE FIELD>), 'MMM/yy')

Expression: =TextCount(ID)

[#5]

Hi Manish,

I have 4 text boxes, 4 variables (vMth1, vMth2, vMth3, vMth4)

In table I have 2 fields: Date, Count.

In the text boxs, I have to show TextCount (ID) based on the vMth.

e.g. vMth = Apr; TextCount (ID) = 20

vMth1 = Mar; TextCount (ID) = 25

vMth2 = Feb; TextCount (ID) = 5

vMth3 = Jan; TextCount (ID) = 30

[#6]

Laxmi Do you want only month from that date field values???

[#7]

HI Fabio,

My Diminesion should be Status (another field)

Is:-  Date(Monthstart(<DATE FIELD>), 'MMM/yy')

will give total records of that month for different status? the expression telling that Month start.

[fabio_vallone]

The Dimension Date(Month Start(<DATE FIELD>), 'MMM/yy') ignore days and hours and cumulate TextCount(ID) for each Month and Year. Using this dimension AND the "Status" Dimension you will have Bars or lines "by Month/Year and Status".

[#9]

Hi Fabio,

Thanks for clarification.

this is working for me.

=TextCount({<Month = {'$_3(vMonth)'}, Year = {'$(vYear)'}>}ID)