Forum Discussion

marotta44's avatar
marotta44
Regular Visitor
5 years ago
Solved

First and Last Issue

When I am trying to show data in a Decomposition Tree, it is only giving me the option to show "First or "Last".  I just want it to show the actual value.  How do I make that happen?
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi marotta44 ,

    If you are putting the field Actual Start under the Tooltips option, you can only use it by selecting the aggregation function in conjunction with it. If the data type of field is Text or Date type, the corresponding aggregation function as Figure 1.  If the data type of field is numeric, the corresponding aggregation function as Figure 2. Please refer to this official documentation for more details.

    Date or Text fieldNumeric field

    Best Regards

marotta44's avatar
marotta44
Regular Visitor
5 years ago

Hi Mark, I should have clarified. It works correctly Explained By section. But it will only give me first and last in the Tooltip section. Does that make sense?  I apologize I didn't explain that properly initially. The same thing happens with some of my dates where it only shows earliest and latest. 

  • marotta44's avatar
    marotta44
    Regular Visitor
    5 years ago

    • DataVitalizer's avatar
      DataVitalizer
      Super User
      5 years ago

      Hi marotta44 

      Those are the only available options when the field's format is TEXT

       

      Did it work ? Mark it as a solution to help spreading knowledge.

      A kudos would be appreciated

       

      • marotta44's avatar
        marotta44
        Regular Visitor
        5 years ago

        Its a date field.  So are you saying in the tooltip, I cant show the actual like I can in the explain by?