Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Tim intelligence: % Change, Overall Usage %, & Position Change

I'm hoping someone can assist. I have a table of document reference numbers, datestamps of when they were validated ("Hits"), and who validated them, as part of a support process:   DocId Hit U...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi  mhutchens81,

    You could refer to my sample file to see whether it work or not.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Community Support
6 years ago

Hi  mhutchens81,

You could refer to my sample file to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi dax , that looks to be 95% of what I need - I really appreciate your quick response!

     

    Would it be possible to avoid hard-coding month names and numbers into the calculations? That way I can use this as a rolling monthly report as it would refer to 'last month' and 'the month before last month', rather than 'August' or 'month 8' (for example) specifically:

     

    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi

      You could use below expression to replace september(9)

      MONTH(TODAY())-1

      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Perfect, dax ! You are a star :) Thank you so much.