Trend in Straight Table

[Anonymous]

Hi

I have 2 straight tables , in one I was able to display trend and the other I cannot .. not sure what the issue is .. can someone please take a look .. I want the trend of Total Exception by Query date .. the line does not appears only the MAX values are marked

Thanks!

[rupamjyotidas]

When you make a Table with Query Date, the Mini chart with dimension Query Date will show just one value, as the table you have column with Query Date.

To display trend you need multiple values across the dates.

[rupamjyotidas]

When you put the trend for the 3 dates in pivot table with Dimension:Query Date already present(Query Date,Group,Count), it will plot just one dot for each day.

Probably if you year in dimension instead of Query Date, mini chart will work

Yeah,,Group,Count for this the mini chart will work

Query Date,Group, Count: Mini chart will show one dot as you are breaking the dates apart.

[rupamjyotidas]

This will work

[Anonymous]

But I am ignoring Query Date in the expression , attached the app again .. I actually tried ignoring all the fields given in dimension also but it did not work

[rupamjyotidas]

Add date in Equation

Remove Query Date from Dimension .

[Anonymous]

Oh I think you have added a wrong field the field I wanted is Query Date and if I add that this is how it looks

[rupamjyotidas]

I am sorry but if you put 'Query Date' in 'chart dimension' and 'Query Date' also in 'Mini Chart Dimension', Your mini chart won't work.

[Anonymous]

Can someone confirm that there is no way I could show Query Date in the table along with trend.

[Frank_Hartmann]

If you connect your "QueryDate" field to a mastercalendar you will be able to show your expected output!

See attached qvw

Hope this helps!