Forum Discussion
Stacked column chart
You might think about un-pivoting your incoming data
Name
Date
Calculated Year
Opp A
02-01-2020
Yr 1
9
02-01-2020
Opp A
02-012020
Yr 2
25-
02-01-2021
Then a measure could just say, if Yr 1 use the date as is, if Yr 2 add one year to the date
Solution SageYou might think about un-pivoting your incoming data
Name | Date |
|
| Calculated Year |
Opp A | 02-01-2020 | Yr 1 | 9 | 02-01-2020 |
Opp A | 02-012020 | Yr 2 | 25- | 02-01-2021 |
Then a measure could just say, if Yr 1 use the date as is, if Yr 2 add one year to the date
Thank you for your reply.
Un-pivoting works a treat and combined with a calcualted column for the date the correct chart can be produced. 👍
Any ideas about how to go down to month level, ie. show the average by month instead of the yearly totals (9 and 25) ?
The final outcome should allow the user to drill down from year to quarter and month on the chart.