Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table chart with one dimension Account, and one expression Sum(sales).
I then want a sparkline mini chart to show the trend of sales over time. So I created a second expression of Sum(Sales) and set Display Options - Representation Format to Mini Chart. In the Mini Chart Settings I set Dimension = Sales Date.
I also have a Dimension Limit to Show Only First 20.
But some of the mini charts are blank.
Even stranger, if I click on one of the Accounts with the missing chart so the application is then filtered to just that account the mini chart then appears for that account. Account B in the screen shot, which previously had no mini chart displayed.
Whats going wrong with the mini charts?
create another chart exactly same as the first chart and see if you are seeing the same issue.
Or maybe create another QVW and create a new chart with mini chart option.
I think it is being caused in some way by the Dimension Limit functionality.
If I remove the Dimension Limit and allow the table to show ALL accounts not just the top 20 then the sparkline is displayed for ALL the rows.
Note : the scroll bar on the right, chart no longer restricted to top 20 rows, There are now 1000s of accounts in there and the chart copes happily with rendering MANY mini charts. None are missing
I've often had problems with Dimension Limit. It seems very buggy.
You are right. Good finding.
I suspect this as a bug unless an explanation is found.
I'm able to reproduce this issue in my App by enabling the dimension limit.
I should have read the release notes!!
Page 8 states:
"Dimension limits should not be used in tables that contain mini-charts"
So I'm trying to do something that is not advised (basically it's a bug but they won't admit it/spend time fixing it )