Hello, could you help me, please, understand how to sparklines property in the table.
I created a very simple model and data to check one of my issues
All values in 2019 have are 10000 and all values in 2020 are 20000 for each month (22 rows in the Data-table).
Then I created a simple table with columns for the current and previous years and dynamics.
When I do not have any filters I get these results. I have 13 points/columns in my sparkline columns. And the last point looks like an average between 10000 and 20000. Why? All values in 2020 are 20000
I specify the field “Year-Month” as a dimension for sparkline indicator to get unique for each row in my Data table.
In this case, I expect 22 points in the sparkline columns. The total value in sparkline columns is correct.
When I select let say three months in my filter like I also get strange results.
I expected only 6 points in the last sparkline columns(3 for months of 2019 and 3 months of 2020) , but there are 4.
How I should change my formulas in KPI to get dynamics for all dates?
Thanks in advance.
Qvf file in the attachment
