Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
My Date Dimension is CreatedDate and I want the graph to dynamically show values for the recent 2 years using 2 different lines/bar but event after lots of searching through community nothing seems to work
right now I am using Month(CreatedDate) along with year(CreatedDate) but it will just keep adding more lines as year count increases
Please help me with it
Thanks
Create Month & Year field in your data model using calendar.
Then create line chart
Add 2 Dimensions:
1) Month
2) aggr(only({<Year={">=$(=max(Year)-1)"}>}Year),Year)
Measure:
Sum(Sales) or whichever measure you want to select
Create Month & Year field in your data model using calendar.
Then create line chart
Add 2 Dimensions:
1) Month
2) aggr(only({<Year={">=$(=max(Year)-1)"}>}Year),Year)
Measure:
Sum(Sales) or whichever measure you want to select
Thank you very much i really helped