Hello,
I have to create a report something like on the pickture below. It is something like calendar for 2 years, where the red line indicates today day(ignore blue bars). Does anybody have any ideas how to create this?
Thank you.
Have you tried a crosstab with project names on row and dates in column?
what dates should I put in the columns? I need all days for 2 years...
How about that?
| Row 1 | | yr | |
| row 2 | Month | Month | Month |
thanks,
what whould I put in the middle of the crosstab?
count (date) and after that some conditional formatting :
if (count(date) > 0 ) then ('blue') else('')
what whould be right expression for conditional variable?
2005-10-05=[Year]+'-'+[Month]+'-'+[date] ?
why do you want to do that?
If you do "count(date)" then you would get null or "1....31"
and not null means blue color...
you need the count(date) in order to get something in the crosstab in order to indicate that that date must be blue... you could also use "1" instead of "count(date)"
thank you i will try that- it is kind of working......
but How would i do the current date vertical red line?
you must create a condition format for every day... So 730 conditions ....
if your case has been solved plz close it (how to do that read board rules)
thank you for your advise,
but my problem is not solved yet...
is it possible to do with chart item??
How do you think that would be possible?
Quoteyou need the count(date) in order to get something in the crosstab in order to indicate that that date must be blue... you could also use "1" instead of "count(date)"
date is not measure- How would I count date??
you can count anything you want, doesn't have to be a measure.
Little reminder: close the topic if it's been solved (see board rules)