Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1. I want to create a table based in calculations as in the example below.
report for client cli1: |
|
| ||
Mylabel1: | 0.40=OK/ RECORDS COUNT=2/5 | 0.25 =OK/ RECORDS COUNT=1/4 | ||
Mylabel2: | 20=METRICS_COUNT * RECORDS_COUNT | 16=METRICS_COUNT * RECORDS_COUNT | ||
Mylabel3: | 5= Records Count | 4 = Records Count |
2. Notice that I’ll have a listbox with the client name, and the results table should show up when I click on the client name.
3. Also this as to be discriminated by dates as columns, so the number of columns is not fixed.
Source:
RUN_ID | EXECUTION_DATE | CLIENT | METRICS_COUNT | RECORDS_COUNT | OK |
1 | 18/09/2013 12:00 | cli1 | 4 | 4 | 1 |
1 | 18/09/2013 12:00 | cli2 | 4 | 4 | 1 |
2 | 23/09/2013 12:00 | cli1 | 4 | 5 | 2 |
2 | 23/09/2013 12:00 | cli2 | 4 | 3 | 0 |
This can be done using a Pivot table and using CLIENT and EXECUTION_DATE as dimensions. But I'll have Mylabel2 and Mylabel3 to the right of Mylabel1, instead on the next row.
So how to put these labels on next rows?
Use a straight table instead of a pivot table with dates as dimension AND GROUP BY EXECUTION_DATE and label 1, label 2 and label 3 as expressions.
Then in properties / Presentation, you click on Horizontal.
Hello,
If you use a straight table instead of a pivot table with dates as dimension and label 1, label 2 and label 3 as expressions.
Then in properties / Presentation, you click on Horizontal.
that' s solve your problem ?
Best regards
Yoann DUVAL
Almost!
Your solution creates all the rows I need and the first column (first date).
I'm missing how to create the following date columns with your solution.
But if you put Dates in dimensions, you should have all the dates in your columns
Can you send your qvw file ?
Yes that should work. After I try it I'll let you know.
Thanks,
Miguel.
Use a straight table instead of a pivot table with dates as dimension AND GROUP BY EXECUTION_DATE and label 1, label 2 and label 3 as expressions.
Then in properties / Presentation, you click on Horizontal.