Dynamic chart (with standardization)
Hallo,
I have this chart:
Is it possible to normalize the chart to 100 each time I change the initial date?
-
-
-
3. Re: Dynamic chart (with standardization)
is it possibile to start at 100 or 1 each time i change the start date? Does somebody know a work around?
-
4. Re: Dynamic chart (with standardization)
Norbert Maijoor
Oct 18, 2017 8:06 AM
Hi Vincenzo,
It will help Shawn Wallwork and the community if you could share a workbook with dummy data. The question "is it possible to start at 100 or 1 each time i change to start date" is very difficult to "imagine" .
Upfront thanks a TON helping Shawn Wallwork and the community.
Regards,
Norbert
-
5. Re: Dynamic chart (with standardization)
Try to change the date in the dashboard and you will see that the two charts will have different starting points. I' m searching for a method to normalize the two charts each time the user changes the starting date.
Thanks.
Best,
Vincenzo
-
6. Re: Dynamic chart (with standardization)
Norbert Maijoor
Oct 18, 2017 8:41 AM
Hi Vincenzo
Please add data to the workbook as an extract
Regards,
Norbert
-
7. Re: Dynamic chart (with standardization)
Does it work now. Do you understand my problem?
best
Vincenzo
-
8. Re: Dynamic chart (with standardization)
Norbert Maijoor
Oct 18, 2017 9:39 AM
Hi Vincenzo,
In "un-ticked" the "Include zero" box
Hope it will give you the expected "behavior"
Regards,
Norbert
-
9. Re: Dynamic chart (with standardization)
Doesn't work. My aim is to have a normalized Chart each time I change the start date. So that we have the same start point of 100 for each start date.
Bests
Vincenzo
-
-
11. Re: Dynamic chart (with standardization)
Norbert Maijoor
Oct 19, 2017 8:38 AM
Hi Vincenzo,
I would like to ask Shinichiro Murakami to the table. Hi Shin, do you have any idea's on this one.
Upfront, Thank you for your valuable input.
Regards,
Norbert
-
12. Re: Dynamic chart (with standardization)
Shinichiro Murakami
Oct 19, 2017 11:53 AM
HI Norbert and Vincenzo
I don't have enough time to digest the all conversation, but this might help?
Filters and Level of Detail Expressions
Thanks.
Shin
-
13. Re: Dynamic chart (with standardization)
Thank you Shinichiro Murakami and Norbert Maijoor!
Great community!
-
14. Re: Dynamic chart (with standardization)
Norbert Maijoor
Oct 20, 2017 2:32 AM
Hi Vincenzo,
Your are welcome....Glad we finally made it happen. Many thanks to Shinichiro Murakami
Regards,
Norbert
