Explore reporting on year and month in a single column

2 Commentaires

  • Elaine
    Zendesk Customer Care
    Hi Mark,

    I hope you are having a good day!

    I think what you're trying to achieve can be done by incorporating date-calculated metrics. If you wish to generate a report spanning from October 2022 to October 2023, you can follow the example provided in the screenshot below.



    I hope that helps!
    0
  • Mark Leci
    Zendesk Luminary

    Elaine unfortunately this isn't what I'm looking for unless I'm missing something. A calculated metric will measure the data along the provided date range, so for example provide a sum over the last 2 years. The sum calculated is incorrect but since this isn't what I was looking for, I didn't look into that further

    What I was looking for is a way to show the year and month in a single column and calculate based on that so it can be exported and be useful immediately. I was able to almost solve this using a calculated attribute, but this isn't quite right. Even when sorted like a time attribute, the dates are ordered alphabetically within the year, not by month. I am guessing this is because the result of the formula is a string, but converting to a number or date doesn't work. 

     

     

     

    0

Vous devez vous connecter pour laisser un commentaire.

Réalisé par Zendesk