Combine and the dates and display the resuls in the Text object

[Anonymous]

Hi All,

Now i have date field as below and calls  field, now i have to display the result as below,i want to show the one date and the count of calls as 20,can any one help on this.

Result:

Date                     Calls

1/1/2014                   20

Date                       Calls

1/1/2014                   5

1/1/2014                   5

1/1/2014                   5

1/1/2014                   5

Thanks & Regards,

Sivakumar

[Anonymous]

Hi Mayil,

Its possible to display through code in the text object?

Thanks & Regards,

Sivakumar

[jagan]

Hi,

Use Straight table, it is difficult to manage in Text object, to get the Text object view do this

Chart Properties-> Expressions -> TotalMode -> Select No Totals

Chart Properties -> Presentation -> Select Supress Header Row option

Chart Properties -> Style -> Deselect Vertical Dimensions Cell Borders and Vertical Expression Cell Borders

Chart Properties -> Style -> Select Cell Borders Transparency as 100%

Chart Properties -> Caption -> DeSelect Show Caption option

Hope this helps you.

Regards,

Jagan.

[tresesco]

Possible. But that would not be a dynamic solution. When your number of days would increase, you have to again work on for that to be displayed. Hence, output in text object might not be a good option.

See attached sample qvw.

[anbu1984]

Possible in text box. Check this

[anbu1984]

Without group by in Load