Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a table containing a "billing month", a startdate of the projects and the enddate.
Now I would like to calculate the days somebody has been working on a projects. So when somebody starts the 15the of jan and ends the 20the of feb. I want to see a bar chart with 2 different values for jan and feb.
How can i accomplish this? Thanx a lot!
Hi,
You need to find out the Day of the date field like Day(DateColumn) and then use it as Dimension.
Regards
Anand