Data Filteration

[mohan2391]

Hi,

I have 2 fields Region & Date and a few charts

Region            

--------

A

B

C

Date field is having data from JUNE-2016 to FEB-2017

My requirement is that,

1. When i select A in Region -- all charts&date fields should show data from only JAN-2017

2. When i select B in Region -- all charts&date fields should show data from only DEC-2016

3. When i select C in Region -- all charts&date fields should show data from only NOV-2016

if nothing is selected should show all data.

How to achieve this ?

[kamielrajaram]

Hi Mohan,

Hope this helps.

Kind Regards

Kamiel

[mohan2391]

When i'm selecting A,B,C in your example, it is showing data for only Jan-17, Dec-16,Nov-16.

But i need to see data FROM Jan-17, FROM Dec-16, FROM Nov-16 depend on selection

Ex: If I select C, i should see data for Nov-16, Dec-16, Jan-17 & Feb-17 as well..

[vardhancse]

Hi,

It depends on the data what you are loading into the dashboard.

For specific region you need to have the specified month only data.

[kamielrajaram · Accepted solution]

Hi,

Change the expression to

=if(GetSelectedCount(Region) =0, Sum(Quantity),

Sum({<CalendarMonthStart =  {'>=$(vPreviousMonth)'}>} Quantity))

[mohan2391]

It's working good.

If suppose u have a week field in that along with month and showing data week wise in charts.

How will you restrict it same like month ?

[kamielrajaram]

Hi Mohan,

Adding in another dimension should not affect the months displayed.

Kind Regards

Kamiel

[mohan2391]

No, instead of having Month as dimension i want to use Week as dimension.

Dim : Week

Exp : Same as earlier

How to restrict on week depend on Region same as earlier