Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below Data Set, I want to plot line chart with Dimension as YearQuarter and Type, Measure is QTY.
But my requirement is to take only latest 12 Quarter i.e. 3 Years. (YearQuarter is in Text format)
YearQuarter | Type | QTY |
Q1-13 | AB | 451 |
Q2-13 | PQ | 156 |
Q3-13 | RX | 245 |
Q4-13 | ZS | 352 |
Q1-14 | VT | 154 |
Q2-14 | UV | 254 |
Q3-14 | NA | 325 |
Q4-14 | YZ | 342 |
Q1-15 | MN | 315 |
Q2-15 | ZS | 421 |
Q3-15 | VT | 432 |
Q4-15 | UV | 421 |
Q1-16 | NA | 412 |
Q2-16 | YZ | 142 |
Q3-16 | MN | 254 |
Q4-16 | UV | 325 |
Q1-17 | NA | 342 |
Q2-17 | YZ | 315 |
Q3-17 | MN | 421 |
Q4-17 | ZS | 412 |
Q1-18 | VT | 142 |
Q2-18 | UV | 254 |
Please suggest set analysis for this erquirement.
Thanks,
Villyee.
Hi,
you can do something like this:
create a counter using autonumber(YearQuarter) and use it on your set analysis
PFA
Thanks for your valuable feedback.
Can we have any other option, Cause i will not able to update script. I have to do it on chart level.
Regards,
Villyee
I would not recommend it, but here is one way to do it:
=sum({<YearQuarter={"=rank(total right(YearQuarter,2)&Mid(YearQuarter,2,1))<13 and rank(total right(YearQuarter,2)&Mid(YearQuarter,2,1))>=1"}>}QTY)