Sparkline not displaying

[Anonymous]

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?

[juleshartley]

Is the date dimension roughly the same period for the different Accounts?

[juleshartley]

ps. it might be helpful to have a sample app....

[senarath]

Hi,

You could trouble shoot by converting the same into a Bar/Line chart and see whether working with period wise (as a dim)

thanx

[sujeetsingh]

Cross check values and nulls

[Anonymous]

I tried that, It's the same with all mini chart types. Some are just missing.

[Anonymous]

I have heard of nulls causing problems before.

In the example above Account B. which was missing it's sparkline, has no nulls, it has sales for each day. And as we can see from the second screen shot, once Account B is filtered on, the sparkline magically appears.

[juleshartley]

...and it displays fine on a normal line chart when the other accounts are included?

[kiranmanoharrode]

Use AGGR in your Expression..

It will solve your issue

[Anonymous]

My expression is =Sum(Sales) it is an aggregated expression rather than an atomic value like =Sales

How will using AGGR() change this? And what should I AGGR()?