How to hide (source) dimension from DS report
Just created a custom dimension based on an existing one to fill the empty rows with some default text like:
CASE WHEN 'SourceDimension'= "" THEN "empty" ELSE 'SourceDimension' END
Works well if SourceDimension AND DimensionWithFunction (based on SourceDimension) are both added to the report, however it would be great to be able to display only the custom dimension (DimensionWithFunction) in the report.
Once removing the source Dimension1 from report, configuration error message appears.
Do you guys know a solution for this?
Thank a lot in advance,