Forum Discussion
Use value resultant from multiple filters to filter another table
CrisSalgado So, assuming those are all source tables, what would be the expected output?
Hi, Greg_Deckler and all,
What I expect to see is each line chart plotted with values from tbValue for the idsource filtered on the card from tbcause.
The dashboard has a slicer where the user can select a datetime. Table datetime has an iddatetime which is already present on tbcause and tbvalue.
The dashboard also has 4 cards. The iddatetime selected filters the tbcause, what results in 4 registers, with levels 1 to 4. One card filters this result to show the sourcename (tbsource) of the idsource which is level =1. Another card shows the sourcename of idsource that is level=2.... Keep in mind that is for the iddatetime selected only. If iddatetime changes, others 4 idsources will be filtered in cause. Up to here, we were able to do.
What I can't do:
The dashboard also has 4 line charts. First line chart should present the values and datimetime from tbvalue filtered by the idsource that is shown in card. No filter in datetime will be applied to tbvalue. I want to show the trend specifically of the idsource filtered on the first card, no matter if this tag wasn't the first level in other datetimes or even if it was in tbcause in other datetimes.
Using the data in the post, if iddatetime=4 is selected by the user, first card will show "B" - 6.6, that is the sourcename and value of idsource=2 and iddatetime=4, second card will show "C" - 9.8 that is idsource=3 and iddatetime=4 ..... (sorry, the example do not fill all cards but we can use only 2 as example). OK. This is working.
Now comes the part that is not working:
I want linechart 1 shows all values contained on tbValue for idsource = 4, which means the pair of (iddatetime, value) = (1, 7.0), (3, 2.9), (4, 6.6), (6, 6.5). Linechart 2 must show all values for idsource = 3, whiche means (1, 7.9 ), (4, 9.8), (6, 6.9)
I