Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
what should be expression to merge two different calculation in single chart ?
I might be asking something trivial . But please help me to get a set expression with does below
I want below two separate to be merged
Something like
How to get it ?
Thanks & Regards
Shekar
Check attached
@sunny_talwar
Hi Sunny Bhai , in order to get above views i had made some changes with original data , and by doing so , i almost got similar structure but getting YOY calculation in the same chart with clear distinction is not happening for me .. Please suggest /help .
Attached raw data .
Check attached
Thank You Sunny Bhai ..
Apart from using synthetic dimension , is there any way to solve this doing data model changes to original data .
By joining the result instead of keeping them as separate tables...
Sunny Bhai .. Thanks for the Reply .
What i meant to ask was that , according your solution we have to create synthetic dimension (script level) and had to do sorting using only function (UI) .
But if i have to use only this - > sum(vlues) in expression tab , rest all to be done at script level , in order to get the exact view . What should be the script ?
Sorry , if i am trying to over complicate .
This will require some scripting. Unfortunately, I don't have the time to do this right now... may be someone else can check this out.
I understand .
Many thanks for this and upcoming questions as well !