Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i need help!
I need to create a chart where the dimention on the X-Asis is Month-Year (jan-2013, feb-2013 ...)
I really don't know how to do this?
any idea?
thanks a lot
F.
Did this not work
date(monthstart(date(date#(YourDateFieldName, 'YYYYMMDD'), 'YYYY-MM-DD')), 'MM-YYYY')
i'm using a line chart, the dimension are a month-year on X asis and Count ID on the Y axis
It has split the month?
How many IDs do you have for each mth. 13?
I have 15.000 different IDs only for jan i have 13 IDs.
i can't understand why now the id's are not more splitted...
According to this graph you have 13 IDs for every month.
Are you sure this is not correct?
You coudl try
COUNT (ID & Starting Date)
I reloaded the script and now everything is working!
thanks a lot for you help RJ!
best regards
Francesco
OK Good
Remember to mark answers as helpful or correct
Hi
If you change the formula like RJ sent to you it should work.
I tried by myself in a test app & it works fine.
Best regards
Ronny