How to display two metrics on a bar chart with no X-axis values

[asdf1]

Hi,

This is a super basic question, but I’m trying to solve this using the Quicksight functionality, rather than applying it to the SQL in the data source.

I have two fields, a created_at and a deleted_at, that I want to show the count of in two separate charts. so one chart is count(created_at) and the other is count(deleted_at). The issue I’m having is that there is no inherent x-axis and I would like to just call these two bars “created” and “deleted”. I cant label them in a single calculated field because created at and deleted at are not mutually exclusive. What is the solution for this?

Thanks!

[andrepgn]

Hi @asdf1 ,
a workaround can be create a dummy field, with whatever single value you want for all the rows, and then hide the “Labels” from the Y Axis, so that you can just show the title or the legend and show only what you want. Can this work?

The results can be something like this:

Hope this helps,
Andrea

[asdf1]

That worked! Thanks!