Current Month and Previous month data in chart and waterfall chart same time

[saumyashah90]

Hi ,

I have data like,

Table1:

CGID	DATE	ID
16234	30/04/2016	1
16238	31/03/2016	2
123445	31/03/2016	3
423712	30/04/2016	4
213213	30/04/2016	3
34234	31/03/2016	4
5453254	30/04/2016

Table2:

CGID	DATE	Type	SubType
16234	30/04/2016	NC	a
16234	31/03/2016	DC	b
123445	30/04/2016	NC`	a
213213	31/03/2016	NC	d
5453254	30/04/2016	DC	e
5453254	31/03/2016	DC	d
213213	30/04/2016	DC	e
423712	31/03/2016	NC	b
423712	30/04/2016	NC	a

No i have key of CGID&DATE between both

I want waterfall chart based on SubType

Start month will  be count(CGID) for March

and all others will be count(CGID) for April.

In a chart i have DATE Type as  a dimension and expression i need countof CGID for current month and previous month.

And all this should filter with ID's.

and Current month (April) is selected.

[saumyashah90]

any help?

[saumyashah90]

guyz anyhelp?

[jagan]

Hi Saumya,

Do you want two dimensions in chart? DATE and Type?  Can you attach sample file so that it will save time.

Regards,

Jagan.

[saumyashah90]

Yes i need Date and Subtype in dimension and in expression 1 column i need count of CGID for previous month and

2nd column of current month

For example when i select April month.

Dimension

I should have April Month dates and their subtype in dimension and Count of CGID in expression for April month in and 2nd expression will have count of CGID in previous month.

Will try to attach example if possible.

[Anil_Babu_Samineni]

Like this? You are expecting

[Anil_Babu_Samineni]

Or this

[saumyashah90]

Hi Anil,

On selection of April month. only 30/04/2016 records should be seen.

And their subtypes current month count and previous month count.

If you see i my image attached.

e subtype is having some count in April and Mar.(both should come in same row).

And output i need is

DT	SubType	CurrMonth	PrevMonth
30/04/2016	e	2	2
30/04/2016	a	3	0

This should be the output when i select April month in filter. and ID i a filter which should affect this chart.

Similarly it should work the same with Mar month filter showing march month records