Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Wondering how I could use an expression to hide any rows, that use the status '8'
i.e
Customer Job No. Location.
123Customer.com 1234 8
You can get the result expected by creating a new dimension on the data model that does not contain records that reference Location 8, then use that dimension on a chart. When you do that, make sure yo uncheck the option to "Allow null values". That will remove that entry from the chart.
I've attached an example for you.
🙂
you can try this
If(Status<>'8', Status) as Status at script level
Expression:
add this condition Status -={8} or Status={*}-{8}
@Lhelpqlik You can try,
If(Status<>'8', Status)
If it is in set analysis, try with {<Status-={8}>}
Hide null values in the Customer dimension. Then in the dimension expression:
=if (Location<>8,Customer)
Thank, you but this only removed the location section show '8' i want to remove the whole row of information i.e row hides if use location '8'
You can get the result expected by creating a new dimension on the data model that does not contain records that reference Location 8, then use that dimension on a chart. When you do that, make sure yo uncheck the option to "Allow null values". That will remove that entry from the chart.
I've attached an example for you.
🙂
you can try this
If(Status<>'8', Status) as Status at script level
Expression:
add this condition Status -={8} or Status={*}-{8}
Try this
=IF(Location <> '8', Customer)