Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Show empty-rows for cross-tab using date/time groups
Migrateduser
I'm trying to create a cross-tab that looks like the following:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
X
|
|
Sun. | 3 |
|
|
Mon. | 0 |
|
|
Tue. | 1 |
|
|
Wed. | 2 |
|
|
Thr. | 0 |
|
|
Fri. | 1 |
|
|
Sat. | 4 |
|
|
</pre>
<br />
I've setup my cross tab to have a Date/Time group where the "Day of Week" is selected. When I run the report, the cross tab only shows the rows with data it them (i.e. Mon. and Thr. are omitted). <br />
<br />
I know about the "Empty Rows/Columns" setting...but it is grayed out unless I add a higher level date/time grouping (i.e Month) to the cross-tab.<br />
<br />
My primary objective is to create a histogram (bar-chart) that shows the values grouped by Day of Week (or hour). If there is an alternate way of accomplishing that (without cross-tabs), I could use that approach.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
*
* *
* * *
* * * * *
S M T W T F S
</pre>
<br />
FWIW, I also want to build a similar chart with hours 00:00-23:00.<br />
<br />
Thanks,<br />
~Michael
Find more posts tagged with
Comments
There are no comments yet