How to filter by date ASC/DESC when not using date field in graph

Question & Answer
, ,
1

I have a bar chart. It has caseID, by score, grouped by whether it passed or not. I had added the date in the tooltip, so when i hover over each bar i can see the date. The one problem is that the bars next to each other could be days between them. Is it possible to filter it so its date DESC (most recent - oldest). Therefore all the dates are inline and are in descending order.

Is it possible to do this considering i only use the date field in the tooltip, and not in my visual.

This chart is also filtered by rolling date - start of this month.

Any help is appreciated, thanks.

2

Hi @HarveyB-B
did you tried to use the sort option?
grafik
BR

1 Like
3

When i sort the caseID by date (processing_date), i can only sort by count / count distinct.

image
image280Ă—510 10.1 KB

4

Ok.
Can you create a new field where you cast the date into a number?
Like
grafik
You should the use that field as sort by using AVG as an aggregation.

1 Like
5

What function do i use to turn the date into an integer? I can only use toString(), as i get an error when using parseInt().

-Thanks

6

I parseInt() my date as string. I then used this new field which is the parseInt(Date), and ordered my caseID by this value, yet does not work as expected.

Currently, if i sort the caseID by ASC, it will show the first 100 cases. The graph is showing the last 100 cases when filtered to DESC. This shows the correct data, but i want it the other way round - Newest on right, oldest on left (out of last 100 cases).

To summarise, can i sort only the last 100 cases by ASC/DESC. As i can sort the casereference by ASC/DESC, and this aligns with the date.

If this doesn’t make sense, let me know and i can explain better

-Thanks

7

Hi @HarveyB-B

Did @ErikG 's solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

1 Like
8

In case you didn’t found a solution.

To be honest I don’t get it. Can you share a sample how it looks like and how it should look like?

1 Like
9

image
image1139Ă—493 31 KB

So this is the chart, where it shows the last 100 cases. (had to block the bottom axis, but is basically by the customer ID). However the most recent case is on the left side, and i want to basically flip it so the most recent is on the right side. I use no date on this chart, but whenever i try filter the bottom axis by date, i can only do it by count or count distinct?

image

Hope this helps.

10

Hi @HarveyB-B
is it still open?
Maybe you can create a Rank based on the processing_date and sort by Rank?

BR