Forum Discussion
How to show evolution during time?
- Anonymous9 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
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