Forum Discussion

dberrocal's avatar
dberrocal
New Member
9 years ago
Solved

How to show evolution during time?

Does anyone know how i can show data divided in months in the last 3 years? It only lets me show either the total by year, or the total by month, but i want the information to disaggregate the inform...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi dberrocal,

     

    >> It only lets me show either the total by year, or the total by month, but i want the information to disaggregate the information.
    Based to your description, you want to divided the month and year data like below ?

     

    If it is a case, you can use matrix to achieve your requirement.
    Create the matrix visual, drag date to “Rows” field, drag the amount to “Values” field.

     

     

     

    Remove the quarter and day.

     


     

    You can also use ankitpatira’s point of view, add the year/month column, drag the year/month column and value column to table visual:
     

     

    Regards,
    Xiaoxin Sheng