Multiple dimensions in bar chart

Question & Answer
, ,
1

I have a dataset with the following columns:
Item Pre-Processing Quatlity Post-Processing Quatlity

Item: Numeric value
Possible values for Pre- and Post-Processing Quality: Low, Medium, High

I need to show the quality results before and after applying a process.

For the initial results, I simply used a bar chart and displayed the “Pre-Processing Quatlity” field:
image

The final results corresponds to a combination of the Pre- and Post-Processing Quality values:
I created this calculated field:

Combined quality
ifelse(
    {Pre-Processing Quatlity} = "High" OR {Post-Processing Quatlity} = "High", "High",
    {Pre-Processing Quatlity} <> "High" AND (isNull({Post-Processing Quatlity}) OR {Post-Processing Quatlity} = ""), {Pre-Processing Quatlity},
    {Post-Processing Quatlity}
)

Then I created this chart:
image

The analysis and dataset ara available in this link:
Quality results

Is there a way to create a chart like the following one where the figures for Initial and Final results are shown together?
image

If I add a second dimension to the Y-axis, it’s added as a drill-down layer.

*Quatlity = Quality

2

Hi @PabloP
any chance you bring the Initial and Final as values into one dimension?
BR

3

@ErikG, not quite feasible. In the real dataset I have some other columns in the dataset that are related. Basically, they shown values before and after processing. So if I move the Initial and Final as values into one dimension I would lose the relationship between them.

4

Maybe you can build something with two visuals and overlap

grafik