Hello
I have a reportcreatedate for a report
Imagine I have 5 report instances of a report named A in one day
| timechart dc(reportcreateddate)
_time. Dc(reportcreateddate)
05-10. 5
05-11. 10
05-12 3
I am getting a time chart
So each report instance has a size
It means on 5-10 we have 5 reports with diff sizes
5.6kb,7kb,4kb,10kb,15kb
So I decided a threshold reports under 6kb are empty
So I want a time chart in a way that
It shows count of reports over time
And I want the chart bars to be covered by percentage of good reports that r present on that day for example
On 5-11 we have 10 reports if 5 of them r below 6kb and remaining five or above 6kb
So in the time chart
The bar of that day should be fifty percent green and fifty percent red
Is this possible ? How ? What will be the query
Reportcreateddate
Reportsize
_time are the required fields
Thank you
... View more