Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Lakshmi, didnt understand from your explanation properly... can you elaborate little more please?
Please elaborate more on this post
Instead vMonth, try this:
Dimension: =Date(Monthstart(<DATE FIELD>), 'MMM/yy')
Expression: =TextCount(ID)
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
Laxmi Do you want only month from that date field values???
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.
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".
Hi Fabio,
Thanks for clarification.
this is working for me.
=TextCount({<Month = {'$_3(vMonth)'}, Year = {'$(vYear)'}>}ID)