Is it possible to use an expression of one chart in the expression of another chart?
In my first chart i have Authors as dimension and in the expression i am calculating the number of documents by each author
In my second chart i have to use the number of documents by each author calculated in the first chart in order to calculate the median of the number of documents.
I can't use the Authors as dimension in the second chart.
I can't precalculate these expressions in the load script as these values are dependent on various filters in the sheet and have to be calculated on the fly depending on what user selects from different list boxes.
Can someone please suggest me the ways in which are can solve this problem.