Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to filter a table to only display rows with an InputType of 'Error'. This is really easy to do by simply clicking the table and filtering that column by error. But I would like to permanently apply that filter to that table.
If I did it through set analysis it would aggregate the data which is what I don't want. Example data looks like:
Header 1 | Header 2 | Header 3 | Header 4 | Header 4 |
---|---|---|---|---|
Date | Version | Site | Error | InputType |
2017-12-09 | 2.5 | AAA | Things broke | Error |
2017-12-09 | 2.3 | SSS | 0.74 | Stat |
2017-12-07 | 2.3 | BBB | 0.65 | Stat |
2017-11-31 | 2.1 | AAA | Something went wrong | Error |
I would only like to show all the individual rows with InputType = 'Error'.
Any help would be much appreciated.
Thanks
Hi,
Method 1:Using back end script where clasue method
Fact:
LOAD * INLINE [
Date, Version, Site, Error, InputType
2017-12-09, 2.5, AAA, Things broke, Error
2017-12-09, 2.3, SSS, 0.74, Stat
2017-12-07, 2.3, BBB, 0.65, Stat
2017-11-31, 2.1, AAA, Something went wrong, Error
] where InputType like '*Error*';
method 2: if it's only one chart object then u can create calculated dimension like below
=pick(wildmatch(InputType,'*Error*'),InputType)
make sure to suppress null value for this Cal.Dimension
Thanks,
Deva
Hi,
Method 1:Using back end script where clasue method
Fact:
LOAD * INLINE [
Date, Version, Site, Error, InputType
2017-12-09, 2.5, AAA, Things broke, Error
2017-12-09, 2.3, SSS, 0.74, Stat
2017-12-07, 2.3, BBB, 0.65, Stat
2017-11-31, 2.1, AAA, Something went wrong, Error
] where InputType like '*Error*';
method 2: if it's only one chart object then u can create calculated dimension like below
=pick(wildmatch(InputType,'*Error*'),InputType)
make sure to suppress null value for this Cal.Dimension
Thanks,
Deva
Awesome, method 2 worked perfectly. Thank you.