-
1. Re: Create latest date for an entry and add specific rows to columns
Hope Stiles Jun 30, 2016 5:34 AM (in response to Mihai Adrian Negru)1 of 1 people found this helpful
Mihai,To get the most recent reporting date for each project, I think you want to use a LOD calculation fixed on project.
Try: {FIXED[Name] : MAX([Reporting Date])}
Replace the MDY(Reporting Date) pill on the row column. Click the carrot on the pill and choose the date format you want and then make the pill discrete.
Hope that helps you get closer to the goal.
-Hope
-
2. Re: Create latest date for an entry and add specific rows to columns
Mihai Adrian Negru Jun 30, 2016 6:07 AM (in response to Hope Stiles)Hi hope,
Indeed the LOD calculation works. Thank you so much. Could I ask one more question?
How would I show the planned start and end date for each of the projects corresponding to each project and reporting date.
Another LOD calculation would be in place but it would have to be based on the Project Code, reporting date and project phase.
How can I do it?
Kind regards,
Mihai
-
4. Re: Create latest date for an entry and add specific rows to columns
Mihai Adrian Negru Jun 30, 2016 6:30 AM (in response to Hope Stiles)I think we are almost there. An LOD calculation for the start date would work in this case but for the end date is problematic.
For example a project manager could be in the first stages of the project and there might not be a planned date for Phase 6. I would need to display the exact date or a NULL value corresponding with Phase 6.
-
5. Re: Create latest date for an entry and add specific rows to columns
Hope Stiles Jun 30, 2016 6:37 AM (in response to Mihai Adrian Negru)Are there always 6 phases??? I"m assuming the answer is no, but it can't hurt to ask.
-
6. Re: Create latest date for an entry and add specific rows to columns
Mihai Adrian Negru Jun 30, 2016 6:43 AM (in response to Hope Stiles)There will be a fixed amount of phases for each project. There will be 6 phases for each.
-
7. Re: Create latest date for an entry and add specific rows to columns
Hope Stiles Jun 30, 2016 6:54 AM (in response to Mihai Adrian Negru)Ok, that was tricky but I think I found a solution.
First, go to the Data Page, Right click on the column for Project Phase and Split them. This will put the text in one column and the number in another.
Then change the Project End Date Calc to:
{FIXED[Name] : (CASE MAX([Project Phase - Split 1]) WHEN "6" THEN
MAX([Gate Planned Date])END)}
This is still fixed on the project name, but only returns the Max End date when the Phase is 6. In the example book you posted I got a null for Project Y because there is no Phase 6 in the data.
How's that?
-
8. Re: Create latest date for an entry and add specific rows to columns
Mihai Adrian Negru Jul 1, 2016 1:58 AM (in response to Hope Stiles)Hello Hope,
Thank you. This works like a charm. The Level of detail calculation seem to be pretty effective.
Buy maybe I need a bit more detail. For example if I am looking for more specific information such as fixed name and fixed reporting date.
Would something like this be possible? {Fixed[name] AND Fixed [Reporting date]: (CASE MAX(....
Thank you so much. I have learned a lot from you, especially the last trick.
Wish you a wonderful day,
Mihai
-
9. Re: Create latest date for an entry and add specific rows to columns
Hope Stiles Jul 5, 2016 6:20 AM (in response to Mihai Adrian Negru)Mihai,
I am not sure that you can fix a calc on 2 dimensions...maybe someone with a little more LOD experience will chime in.
Maybe it's because I haven't looked at the data in a couple days, but I'm wondering why you want to fix it on Reporting date. I thought we created another calc to ensure we always got the most recent reporting date.
Have a good day,
Hope
-
10. Re: Create latest date for an entry and add specific rows to columns
Mihai Adrian Negru Jul 5, 2016 6:33 AM (in response to Hope Stiles)Hope,
Thank you very much for everything. I learned quite a few things from our discussion.