Forum Discussion

icdns's avatar
icdns
Icon for Post Patron rankPost Patron
6 years ago

CALCULATE WEEKLY RANGE AVERAGE

Hello,   Would like to ask for your help in getting and show the "Weekly Average" per assigned manual and assigned fieldman in the line graph:  For my date range in the X axis, im using this...
Need Help
  • icdns's avatar
    icdns
    Icon for Post Patron rankPost Patron
    6 years ago

    Hello,

     

    For example, i have data, I have a matrix table where in it displays the total fieldman assigned in Manual and fieldman for that week range. 

     

    So in my line graph, I wanted to show the average fieldman per assigned manual and assigned fieldman in my line graph per WEEK RANGE. 

     

    This is my line graph: 

     

    X axis shows my week range and Y axis shows the percentage. 

    The points are the average. 

     

    Thank you. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI icdns,

      Please share some dummy data that similar to your raw table structure to help us clarify your data structure and test coding formula on your sample data. It is hard to direct coding formula on visualization records.

      How to Get Your Question Answered Quickly 

      Regards,

      Xiaoxin Sheng