Filter for x-axis values

Is it possible to filter for the values that are used for the x-axis on a bar graph?

For example, have a chart that is currently showing volume by month. I'd like to have a filter that will allow the user to switch the x-axis values between month and week. Is it possible to do?

I want to allow the users to switch between these two views by selecting the value in a filter: Monthly Monthly Weekly Weekly

Find more posts tagged with

Accepted answers

ST_Superman

You could use a drill path to have the user click on the month they want to explore and have the underlying view aggregate at the week level.

Also, would having them use the "Graph By" option work for you?

All comments

I'm unaware of a way to have a filter disaggregate a card configured on one dimension and have it aggregate on another dimension. I dont' believe the underlying query engine is set up that way.

What you could do is provide a sumo card that users can edit on the fly, without making permanent changes to the card. They can alter the date grain by clicking on the date column header and choosing either option of week or month.

ST_Superman

You could use a drill path to have the user click on the month they want to explore and have the underlying view aggregate at the week level.

Also, would having them use the "Graph By" option work for you?

AttuAk

thank you...I think I'll go with this option.