Pie Chart (SLOW)

[R_Mendoza]

Hello everyone,

How can I do that the Pie Chart does not load until the filters are completed...?

thanx.

Renzo

[dplr-rn]

unfortunatly no easy answer to the question.

By slow. how long does the load take?

What is the expression used in the pie chart?

You may need to check the whole app for performance issues as well. Use Robs document analyzer as well.

[R_Mendoza]

Hallo @dplr-rn 

Dimension:

=If($(vChartselect) = 'Produktlinie', $(vSprachfeld_PlanPL),
If($(vChartselect) = 'Land', $(vSprachfeld_LandKDNR),
If($(vChartselect) = 'HVT', [Hauptvertretername],
If($(vChartselect) = 'Kunde', [Name Hausgruppe 1],
If($(vChartselect) = 'Produktgruppe', $(vSprachfeld_PlanPGR),
If($(vChartselect) = 'ABCAnalyse', [Kz. ABC Kunde],
If($(vChartselect) = 'Retoure', $(vSprachfeld_RETG),
If($(vChartselect) = 'Reklamation', $(vSprachfeld_RKLA)))))))))

Kennzahlen:

=-$(eGSLJ_Euro) (SUM)

[dplr-rn]

hard to diagnose as most of it is in variables. But i think you are have your answer right there. 

If clauses are much slower than set analysis. i dont know if your logic can be convereted. but a lot it could be theoritically be done in set analysis . alternatively create flags while loading data and use  that in set analysis too

[Kushal_Chawda]

try to convert it into pick(match expression

=Pick(match($(vChartselect) , 'Produktlinie','Land','HVT','Kunde','Produktgruppe','ABCAnalyse','Retoure','Reklamation'),
$(vSprachfeld_PlanPL),
$(vSprachfeld_LandKDNR),
[Hauptvertretername],
[Name Hausgruppe 1],
$(vSprachfeld_PlanPGR),
[Kz. ABC Kunde],
$(vSprachfeld_RETG),
$(vSprachfeld_RKLA))