Hi all. I've been struggling with one requirement for about 2 months now and when I thought I had a solution, the data on the back end didn't look right. I've received pieces of helpful info from a few people but I haven't been able to pull it all together and I am about to give up.
I tried using a post regarding flags but it didn't work for me. I think I need a better understanding of how to load the data first as I don't think simply adding ' 1 as Flag ' works for me.
In my data, I have a an APP table with fields called ALLOC_HRS, ACT_HRS and TASK_ID.
I have a DM_TASK table with fields called TASK_ID and TASK_IS_PTO flag with a possible result of 'Y' or 'N'.
The requirement is to display a combo bar chart with FTE (full time equivalent) ALLOC_HRS in one bar compared to FTE ACT_HRS but the TASK_IS_PTO time need to be called out separately on the second bar. Also, the ALLOC bar should be before the ACT bar.
FTE is calculated by using the following denominator: sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR, FLAG_PTO))
- First, am I loading the Flag right or do I need to add something in my script? It doesn't apply to ALLOC_HRS but I am getting a null Flag for those values.
- What about the Flag as the Dimension?
- Why does the graph work with hours but not when I have the FTE denominator?
- How can I get Alloc to show before Actuals? (I tried to make the dimension alt(FLAG_IS_PTO,0) but that did not work.
Thank you all for any help.
Cassandra
