Forum Discussion
Assign column field to custom filter
Hey guys,
I created a custom table as you can see here:
I am sorting the column "Status" using the column "Preset order".
After that, I created a filter and connected it to my custom table:
| Two fields from the column "Status" in my table | Settings of the filter |
|
|
This was the preparation for filtering the complete report. Now I need to connect this filter to my data model.
In my data model I have a column with a lot different entries, but they can be split up in the two entries of my custom table.
Here is an example:
| Custom table field | Data model fields (all in one column) |
| Meldungen in Arbeit (Example A) | MIAR OFMA GNOK IT MIAR AMER GNOK RC |
| Abgeschlossene Meldungen (Example B) | MMAB AMER GNOK RS MMAB OFMA LÖVM GNPF IT MMAB AMER GNOK IT CINF |
How can I assign the entries of my data model to the two different entries of my custom table/filter? This would be very nice to have an easy filter method for the complete report.
Do you have any idea how to do that?
Thanks in advance!
Thank you for your answers!
It turned out, that it was a lot easier to just "translate" the data model field with the original status (e.g. "MIAR OFMA") to the desired status (e.g. "Notification closed").
I did this with the CONTAINSSTRING-function in a new column, which is giving me a TRUE or FALSE.
This TRUE or FALSE is translated to "Notification closed" or "Notification in progess" with a simple if-function in a seperate new column.
The first four letters of the original status are containing enough information for me to distinguish between "Notification closed" or "Notification in progess".
I don´t know if thats a super clean solution, but it works for me.
Thanks again!
3 Replies
- lbendlin
Super User
Learn about Column Groups. You may not even need the custom table.
- Ashish_Mathur
Hi,
Not sure of what you want but try this. In the Query Editor, split the second column by rows. Now create a relationship (Many to One and single) from the first column of the table to the first column of the Custom table.
Thank you for your answers!
It turned out, that it was a lot easier to just "translate" the data model field with the original status (e.g. "MIAR OFMA") to the desired status (e.g. "Notification closed").
I did this with the CONTAINSSTRING-function in a new column, which is giving me a TRUE or FALSE.
This TRUE or FALSE is translated to "Notification closed" or "Notification in progess" with a simple if-function in a seperate new column.
The first four letters of the original status are containing enough information for me to distinguish between "Notification closed" or "Notification in progess".
I don´t know if thats a super clean solution, but it works for me.
Thanks again!
