Graph comparing previous quaters with current quarters of a year

[mallikagqlik]

Hi,

I am fairly new to QS and not able to arrive at a sol for below issue.

I have my data like below with dimensions being Portfolio, reporting date and  segment.

Portfolio	reporting_date	segment	account_volume
S	31Aug2019	S1	17987
S	31Aug2019	S2	19
S	31Aug2019	S3	1
S	31Jul2019	S1	29
S	31Jul2019	S2	14109
S	31Jul2019	S3	2
S	30Jun2019	S1	14
S	30Jun2019	S2	124121
S	30Jun2019	S3	42
S	31May2019	S1	4246
S	31May2019	S2	34
S	31May2019	S3	2
S	30Apr2019	S1	32
S	30Apr2019	S2	37
S	30Apr2019	S3	2
S	31Mar2019	S1	32
S	31Mar2019	S2	37
S	31Mar2019	S3	2
S	28Feb2019	S1	346
S	28Feb2019	S2	3
S	28Feb2019	S3	2
….	……..	……..	…..
H	31Aug2019	H1	4364
H	31Aug2019	H2	432
H	31Aug2019	H3	1
H	31Jul2019	H1	324
H	31Jul2019	H2	432
H	31Jul2019	H3	4
H	30Jun2019	H1	3
H	30Jun2019	H2	342
H	30Jun2019	H3	42
H	31May2019	H1	25
H	31May2019	H2	34
H	31May2019	H3	2
H	30Apr2019	H1	32
H	30Apr2019	H2	37
H	30Apr2019	H3	2
H	31Mar2019	H1	32
H	31Mar2019	H2	37
H	31Mar2019	H3	2
H	28Feb2019	H1	346
H	28Feb2019	H2	3
H	28Feb2019	H3	2

I select a Portfolio(H/S/….) and a reporting date ,lets say I select aug19 and S

I should see graph and data as below

	Aug-18	Nov-18	Feb-19	May-19	Aug-19
Accounts	148277	150958	351	4282	18007
Change	#N/A	0.01808	0.0115	0.01966	0.01368

and a combo graph plotting the both volume and change. (The %change formula in the example is probably not correct. I meant (previous value -current value)/previousvalue.

Can some one pls help

[sunny_talwar]

Hey Brett - I think we are looking help regarding @mallikagqlik  not seeing the attachment. Do you see the attachment posted?

[Brett_Bleess]

LOL, yeah, my counterparts pointed out my bonehead move, and they have kicked things over to the platform team, they should be checking into things shortly, sorry I misread things and missed the issue with the file.  It looked like it was there to us, so not sure what is going on at the moment, but the platform team should be able to sort it out, may take a day or two thought depending upon what is up with things.  Apologies again for the mix-up on my part.

Regards,
Brett

[mallikagqlik]

In the Chart graph I did this  and I got the result.

=Sum (
   {
     <
       reporting_date=
         {'$(=getfieldselections(reporting_date))','$(=date(monthend(addmonths(getfieldselections(reporting_date),-3))))','$(=date(monthend(addmonths(getfieldselections(reporting_date),-6))))',
         '$(=date(monthend(addmonths(getfieldselections(reporting_date),-9))))', '$(=date(monthend(addmonths(getfieldselections(reporting_date),-12))))'}
     >
   } account_volume
)

Since I am accessing it from my company network , I guess I am not able to view ur solution. But I am sure your approach is similar to this. Thanks a lot Sunny. That u are looking into the issue has given me a lot of confidence.

[Brett_Bleess]

I just reached out to the platform team myself, as I am a bit surprised they have not shouted back yet, so I am thinking something may have gotten lost, hopefully they can get to it in the coming days to see if they can spot something, sorry about the delay.

Cheers,
Brett

[Anonymous]

Hi @mallikagqlik, I looking into this and was able to see the download file when I viewed as your account.

Can you please check this post, and if the file doesn't appear for you, reply with a screen shot of the post?

Thank you,
Jeremy