LinkedIn
Twitter
I made a dashboard view with the 3 views (entrySearchDetail, queryTransactionDataList, querySumList).
| table | slice | view | description |
| search | entrySearchDetail | entrySearchDetail | search table has only one row. |
| transactionData | queryTransactionDataList | queryTransactionDataList | queryTransactionDataList slice is a filtered transactionData by the entrySearchDetail. |
| sum | querySumList | querySumList | sum table sums queryTransactionDataList slice. |
The change of the criteria at entrySearchDetail view produces the real time change of queryTransactionDataList view.
By the way, it takes about 20 seconds changing the querySumList view.
Is it possible to be updated faster?
Thank you in advance.
Solved
1 ACCEPTED SOLUTION
Here is my test.
Details is a detail view of table Filter. [val] is an ENUMLIST. There is only one row.
FILTER Detail 2 is another view of table Filter showing [SUM Value] with expressions (Case 1 & 2) shown below.
SLICE Parents is filtered on[f1] based on [val].
SLICE changes instantly both in Cases 1 and 2.
For [SUM Value], Case 1 takes 10 (or more) seconds to change whereas Case 2 is updated instantly. The only difference is the format used in the SELECT statement's filtering expression.
Case 1. Using table[col]
SUM(
SELECT(
parents[f3],
IN([f2], INDEX(FILTER[val],1))
)
)
Case 2. Using [_THISROW].[col]
SUM(
SELECT(
parents[f3],
IN([f2], [_THISROW].[val])
)
)
