Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I saw some similar questions & answers, but none was helping me... so thanks for helping.
I have a table with some records, N. and Type that I count distinct to chart, based on a date.
I'd like to have a bar chart that plots the count for each month (like I can do now) and also for the same month the previous year. I.e.
My data is like:
N. | Type | Date |
---|---|---|
1234 | A | 01/01/17 |
5678 | A | 01/01/16 |
8906 | A | 01/01/18 |
8906 | B | 01/02/18 |
So, the need of the distinct is because I want to count the same N. if a different type.
Any insight is appreciated.
Maurizio
Under sorting you might try using a custom expression like:
=MONTH([Date]) & '/' & YEAR([Date])
Under sorting you might try using a custom expression like:
=MONTH([Date]) & '/' & YEAR([Date])
addmonths(date,-12)