@Michael Hi Michael, the reason why the chart has no data is because there is currently no row in the slice. To verify this, you can create a test table view that is hooked up to the slice, and this table view will have no row. After investigating, I believe this is actually the result of an inconsistency between the server and the app.
If you test the slice filter in the expression builder, you’ll see that there are rows that will be included in the slice. However, this test result comes from computations that are performed in the server. In the app, the slice filter will exclude all rows in the table when it is applied.
This inconsistency arises because the result of “Month(TODAY())/4)” is rounded to an integer value in the server, but is kept as a decimal value in the app. In the server, because this value is rounded, it is possible for the final result to be equal to the integer values stored in column [QTR]. In the app however, because the result is not rounded, the final result will be a decimal value and thus will never be equal to the integer values in column [QTR]. As a result, when the slice is evaluated in the app, no row is included in the slice.
This inconsistent rounding is something that is on our list of things to fix. In the meantime, you can work around this problem by modifying your slice filter as follows:
FLOOR((Month(TODAY())/4) + 1) = [QTR]
The FLOOR expression will round down a decimal value to the largest integer smaller than the decimal value itself. For example, 1.7 will be rounded down to 1. This should fix the problem.