Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How can I achieve this bar chart (stacked)
I have 2 dimensions :
the first is calculated
=if( TrancheHebdo <= 9 , 'Lundi à Vendredi' , if( TrancheHebdo=10 , 'Samedi Matin' , 'Samedi Après-Midi'))
The second is DOMAIN
The expression should be the % of sales for each value of DOMAIN
I know how to achieve is the first dimension is not calculated = Sum( Sales) / Sum( <MyFirtsDim > All Sales)
But with the formula I can't figure out to get the correct result. Of course, I don't want to create the dimension is the script.
Thanks for any help
Jean-Jacques
I tried and couldn't figure it out. What's bad about doing it in script?
I don't have the source and the time to modify the original data (more than 100 millions records with a load time of 10 hours).
I found out a solution but I don't like it. I just created one expression for each value of DOMAIN.
Thanks anyway JohnW
JJ
Jean-Jacques Jesua wrote:I don't have the source and the time to modify the original data (more than 100 millions records with a load time of 10 hours).
Ouch! Yeah, my worst load is about 3 hours, and I certainly hate making modifications to that script. Sorry I couldn't think of another solution. At least you figured out something that works, even if you don't like it.