Quarterly values should be plotted

[#1]

Hi All,

I have one dimension and three Expressions.

Dimension is calaculated - =if(DATE>='06/30/1947', (DATE))

Expresion 1 -     =IF(YEAR >='1949',(Avg({<NAME={'A'}>}VALUE))/100)

Expression2 -      = Avg({<NAME={'B'}>}VALUE))/100)

Expression3-       =Avg({<NAME={'C'}>}VALUE))/100)

now below image is the display of my final ouput of chart.

In the above image i want yellow cells data to be display like this.

9/30/1950           -                                      -0.86%                                       9.95%                            6.12%

6/30/1951                                                    18.06%                                    -2.45%                            2.41%

In Every month if we have two dates with values then we have to club these values into one date value for that month.

Please let me know if you required any additional information

jagan‌   deepaktibhe‌   protossrulus‌  

[sunny_talwar · Accepted solution]

Try this as your dimension in that case:

=If(DATE>='06/30/1947', Date(Floor(MonthEnd(DATE))))

or

=If(DATE>='06/30/1947', Date(Floor(QuarterEnd(DATE))))

[#3]

No Its not working sunny.

[sunny_talwar]

Really? those two dates are not getting grouped into one? I am amazed? Can you share a sample where it doesn't seem to work?

[deepakqlikview_123]

Hi Avinash,

As suggested by sunny

=If(DATE>='06/30/1947', Date(Floor(MonthEnd(DATE))))

Should work .this was handled previously on ETL side. Why there are so many changes.

thanks

[#6]

I am really Sorry sunny. The solution is correct and i forgot to sort the order from DATE to QUARTER. Thats why it is showing as a wrong chart but values are correct. It solved thanks a lot sunny