I have tried to use derived data (save expression as derived data subquery). In this definition, it has both dimensions and measures. Then I want to use measures from derived data as dimension, the validation went OK but it cannot produce chart or create SQL query.
|Date|Name| Test1| Test2| Test3|
Data needs to average all the dates first, become
Then Categorised how many people are failed using case e.g
Dimension: Case when AvgTest1 > 50 and AvgTest2 > 90 Then ‘Pass’ Else ‘Fail’ END
Above example just to show in fact we have other fields like date time so Name can be duplicated, data needs to average over perod.
I have tried to use derived query from save expression but still cannot make it work.