How to get Difference from column value

Hi Vikas,

Unfortunately calculating the difference between rows in a union query is not nearly as easy as calculating the difference between columns in an append query. Is there a reason why an append query will not work here?

Regards,

Nathan

append query is working fine but cant plot graph.(Having two Year)

we want to achieve same functionality with Union.

Hi Vikas,

I am a little confused as to what you are trying to go for in your plot. Could you send me a screen-shot of your desired end result?

Regards,

Nathan

Hi Vikas,

Have you had any luck in resolving this one? I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!

Regards,

Nathan

Hi Nathan,

Still I am trying to find solution.

For now you go ahead and close the ticket.

Regards,

Vikas

From: Yellowfin Support [mailto:support@yellowfin.bi]

Sent: Monday, July 10, 2017 9:43 PM

To: Vikas Bhorhari

Subject: New Comment in "How to get Difference from column value"

Hi Vikas,

I will close this but if you want to schedule a time to schreenshare I think it would be beneficial for me to see this in person.

Let me know a good time if so! I am on US Mountain time.

Regards,

Nathan