Line Chart of groups which all are stored in one table

Question

Hello everyone,

i would like to build Line Chart from this following data structure:

I would like to set up the line chart with different lines with dates on the x axis and each line presents an group of column A, where Column B are the y-values for the corresponding x value.

I tried "CASE WHEN column A = 'AA' THEN Columb B END" as KPI and date as dimension but it doesnt work since the NULL values for BB and CC in Column A are still presented in the line chart. Also a component filter did not work with it.

Thank you for every help.

Best regards,

Jurgen

jurgen.gakov · Answer

Addition: The biggest problem here seems like that after the case when all other values which are not concordant with the statement are set to null, the component filter is processed before the case when statement (?), so that only initial null values are filtered out but not values which results from the case when statement. Does this makes sense and does someone has a solution for this?

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN