Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Mayil,
Its possible to display through code in the text object?
Thanks & Regards,
Sivakumar
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.
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.
Possible in text box. Check this
Without group by in Load