Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
in measure expression
=Sum({$<Dimesiom={'Active'}>} value)
second chart measure
=Sum({$<Dimesiom={'Inactive'}>} value)
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
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.
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
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)
Just match with your data, may be they are matching . If not upload a sample for us to look at.
Thanks
Pradosh