Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create a chart that only shows a specific value from a field. For example a field "type" might have Declassified and Open. How can i make it so that table chart only shows Open? Is this possible without having to click in the field "Type."
Thank you for your help,
Yes, you can supply additional conditions, for example:
IF(Type='Open' And Color='Red',Type)
Hi,
You can use set analysis in all you expressions.
For example, if your expressions are sum( Value) and sum (Qtd)
The adjusted expressions are sum ( {<type={Open}>} Value ) and sum ( {<type={Open}>} Qtd)
Hope it helps,
Erich
You could also specify an expression for your dimension in a straight table chart, i.e.
IF(Type='Open',Type)
Then select to Supress when it's Null
See attached.
Thanks,
That works, but I still get these '-' marks that changes the table chart. How can i get rid of those as well?
The first part works great.
I clicked on supress null value and it worked to get rid of the '-'. Can one add multiple variables. For instance, Type = open and color=red?
Yes, you can supply additional conditions, for example:
IF(Type='Open' And Color='Red',Type)
Hi,
On set analysis you can also use multiple filters:
sum ( {<type={Open}, Color={Red}>} Qtd)
or
sum ( {<type={Open}, Color={Red, Blue}>} Qtd) -> meaning, type equals to Open and (Color equals to Red or Blue)
Regards,
Erich
Thank you very much. It is working great.
Thank you Erich as well. Your solution works as well.
Nicholas