how to compare two different characteristics at the same time in polestar

[Former Member]

Hi Gurus,

I would like to analyse the e fashion universe in polestar with comparison of previous year product line with current year product line at the same time.

is there any way to do that we can compare two years of the product line sales revenue at the same time with comparison chart like 2003 T shirts vs 2002 T shirts

in polestar we can compare the two measures at the same time but i want to compare the sales revenue of product lines of two years in a comparison chart at the same time.

Regards and thanks

Abid Paul

[former_member142702 · Accepted solution]

Hi

workaround: create for each of your measures an additional one containing the corresponding value from the previous year. This way you can compare to measures.

Regards,

Stratos

[Former Member · Accepted solution]

Hi Stratos,

I am actually able to compare the Measures but i want the comparison between the two different characteristics like this year productline vs last year productline at the same time with say one measure like sales revenue or any other.

Is it possible to compare the both and it should represent in the chart as well at the same time.

In the polestar i can compare three measures at the same time but i want to compare characteristics like year 2009 productline VS 2008 productline with one measure say sales revenue.

I would really appreciate if you could help me out.

Regards and thanks

Abid

[HerveMinvielle · Accepted solution]

You can't do such a thing unless you create additional measures in the universe in the universe.

For the measure 'Measure1' for example, you will need to create 2 measures 'This year Measure1' and 'Last Year Measure1'.

Another option will be and create a 'version' object (dimension), that will contain the version of your measure ("This Year", "Last Year", "Previous month", "This month" etc ...).Again, this will be a calculated object, based on some date field you have in the BD.

There is no standard function in Explorer that allow to do this without a calculation added in the universe.

[Former Member · Accepted solution]

Hi Herve,

Thanks a lot for the information and let me try out this.

Regards and thanks

Abid Paul