Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
Found a similar thread on the community and applied the solution available on the community. but my requirement is bit different and not able to apply this logic to solve my issue and need assistance. Please help
In the attached qvw I’m trying to display the max, min and average value in a quarter not sure how to achieve that. Please help
For example: In Q12015- The chart should display: Max value-42(CPIZ)
Min Value- 19(CME)
Average- (42+19+30+33)/4= 31
Thank you,
Ramya
Hi Anil,
Thank you for the response. In the attached qvw now there are 3 expressions (max, min and avg). So basically the max expression should display only the maximum number of days in a given quarter (there are multiple orders with different number of days in each quarter). The minimum should display only the lowest number of Days and the average should display the average number of days for all the orders in a given quarter. Also attached an excel with expected output format. Hope this will help you to understand, if it's still not clear please let me know. Thank you so much and appreciate your help.
Ramya
Hi Harini,
Thank you for the response actually I used that thread only but my requirement is slightly different. Here all the days(order) were displayed but my requirement is need to show only Max, Min and average days in each quarter.
ramya
Are you after this
Hi Sunny,
Thank you so much really appreciate it.
Ramya