Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
is it possible to complete remove data of a field from entire dashboard.
for example I have
the data loaded below .
I would like to completely remove data for Fruit Segment - Apple from entire chart . Since the graph does not have any figures. I am counting the total number of fruits in fruit segment and name .
so it is throwing the number off . Even if i exclude apple in script editor by excluding it . when i count(fruit segment) it still shows up .
This will throw out entire object for Apple.
Count({<[Fruit Segment] -= {'Apple'}>} Fruit)
Even if i exclude apple in script editor by excluding it . when i count(fruit segment) it still shows up .
Impossible, May be you have case insensitive data. Can you try with UPPER() and do exclude instead of simple ..
Hi,
You can try this one into your expression:
If(not Wildmatch(fruit,'Apple'),Count(Fruit))
Regards,
Mithilesh
You need exclude the data from all the table ..i.e. if your eliminating apple data then you need eliminate in fact and Dimension tables also so that it won't affect the count