STAR ratings

[#1]

I intend to use the star ratings in my dashboard where the rating from (1-5) is selected according to quantity of sales of a particular product.
Can anyone explain how will i get this functionality??
Any help will do.
Thanks in Advance

Regards,
Rohan Shetty

[#2 · Accepted solution]

Hi Rohan

If the text stars using repeat() are not suitable *,*** etc then there are 2 alternatives so you can use pictures:

1) Create a bar chart, with the number of sales, and overlay with an image that looks like the stars, except that the background is blank and the stars are transparent. That way the stars will "fill up" with the data from the bars, which is actually behind them. You can also do this in a table

2) Create a set of images, which look  like a full star, a half star, as much detail as you want. Create a table with the product as the dimension, and 5 expressions. Check out the bundle load functionality in the script, this is how you load images. Then the expression in each one should look like:

star1:

if(sum(sales)/sum(total sales)<=0.5,'Half picture','full picture')

star2: if (sum(sales)/sum(total sales) >=1.5, 'full picture' ,

if(sum(sales) / sum(total sales) >=1,'alf picture'))

And so on

Erica

[#3]

Rohan im asking to you.

If im at your place i will use just simple Star images and conditional hide and show.

[#4]

The 2nd pt suggested by Erica will do!!

Prabhu

[#5]

Rohan i have got a idea please find attached file hope this will help

[#6]

Thanks Erica And adeel

[Anonymous]

Hi,

I've defect table and want to display top 3 defect owners using expression and assign star rating to corresponding defect owners.

For Example:

Owner Name     Defects Count(closed)          Rating

1.Person1                    25                              3-star(image)

2.Person2                    20                              2-star(image)

3.Person3                    10                              1-star(image)

Note: I'm not using any aggregate functions in my queries and I want all calculations only in expression.

Thanks,

Prakash