create a chart that only shows a specific value from a Dimension field

[koguma]

I am trying to create a chart that only shows a specific value from a Dimension. 

I created a dimension call Expiry_flag.  The valid values are Active and Inactive.  Instead of making the user select "Active" or "Inactive" and the bar chart will change accordingly, can I  make it so that there will be one bar chart for Active and one for Inactive.

I tried using the "Limitation" -> Fixed Value, but it doesn't work.

Thanks.

[Channa]

in measure expression

=Sum({$<Dimesiom={'Active'}>} value)

second chart measure

=Sum({$<Dimesiom={'Inactive'}>} value)

[pradosh_thakur]

1st chart

expression

sum({<Expiry_flag='Active'>} field)

2nd chart

expression

sum({<Expiry_flag='Inactive'>} field)

When you create a field that is binary tey to create it with 1 and 0 so it takes less resource of the dashbaord

[koguma]

Hi Both

Thanks for the reply. I tried both expressions, and I got the same bar chart with the same data values for both Active and Inactive. 

This is how I define my Dimension Expiry_Flag, anything wrong with this?

if(field_name > Today(), 'Active', 'Inactive')

Thanks.

[pradosh_thakur]

Is the field with which you are comparing today() is date ? If it is a strinf then it could be an issue.

Again did you use Expiry_Flag or Expiry_flag in the set expression ? It is case sensitive so make sure to sue the name of your field.

Please show us the expression you have written , considering your flag name is Expiry_Flag

the expression would be

Sum({<Expiry_Flag={'Active'}>}Measure)

Sum({<Expiry_Flag={'Inctive'}>}Measure)

This doesn't work , please tell us your expression as well.

Thanks

Pradosh

[koguma]

Hi Pradosh

My bad. The dimension I created is Expiry_Flag.

Actually the bar chart I created originally is working. However the user needs to select "Active" in the Expiry_Flag  field to see the Active bar chart. Then he needs to between "Active" and "Inactive" to select "Inactive" in the Expiry_Flag  field to see the Inactive bar chart.

Hence I thought of creating 2 different charts, one showing Active, one showing Inactive. In this case, the user don't have to select any value in the Expiry_Flag  field.

I tried to follow the expressions that both of you have given. However I noticed that both the charts are exactly the same.

expiration_date_gmt is the field which i want to sum.

=Sum({<Expiry_Flag={'Active'}>}expiration_date_gmt)

=Sum({<Expiry_Flag={'Inactive'}>}expiration_date_gmt)

[pradosh_thakur]

Just match with your data, may be they are matching . If not upload a sample for us to look at.

Thanks

Pradosh