1 of 1 people found this helpful
have you tried using groups for the "level-2" grouping, rather than a calculated field?
My guess is that the data is going into a spin with calculations trying to calculate based on calculations before the calculations have been calculated (yes - that very poor sentence was intentional!)...
You also said that you're drawing the data from mysql? Could you push any of the 'codename' calcs back into the original query so that your tableau datasource receives a concrete 'codename' which could then be grouped?
Keep in mind that string based calcs are very resource intensive - so the more you can do to simplify these (and use other techniques such as 'groups' or 'sets') - the better your performance will be.
I hope this helps!
Yes indeed your guess (which what I was thinking also) is correct. I played a bit with the groups in the strings calcs and it was fine but yeah, it eats sometimes huge ressources.
My example was pretty simple but I'm building financial statement who looks like this :
I was defining level like this with simple string based calcs with IF/ELSE statement for this but I guess I found the limitation on performance side for this... The groups features can work also but may be less flexible, I'll try to replace some in order to maintain the workbook effiency !
You’re welcome! I’m glad we were able to get to a workable solution!
Would you please mark my response as ‘correct’ or ‘helped’? Many thanks!!