0 Replies Latest reply: Aug 7, 2015 4:32 PM by Cassandra Baqir RSS

    Flags Tutorial

    Cassandra Baqir

      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))

      1. 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.
      2. What about the Flag as the Dimension?
      3. Why does the graph work with hours but not when I have the FTE denominator?
      4. 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.