thank you for feedback, but this will show all values of horizontal dimension (from 1 to 40), I think. I need to keep only values associated with Republican Party (16-38), and omit other. Just to keep values surrounded from both sides with green fields.
In this case it's propably irrelevant, but I have similar problem with a horizontal time dimension containing 3 thousands values, and need to show task solution timeline.
1) Chart properties/Dimension Tab/
Dimension "Sequence" Show All Values - CHECK
2) Chart properties/Presentation Tab/
Suppress Zero Values UNCHECK
After these steps you will see 0 value!!! If you don't want see zero then you should correct expression:
if (count(Name) = 0, '', count(Name))
After this you will see chart as figure 3.
thank you for post, and please accept my apology for late response.
This method is functional, but after selecting Republican as a filter, I can see all values (1-45), not just the interval, when Republican Party presidents were involved (16-43). I need to remove outer values, and keep the rest, as on figure no.3.
I thought about a solution, and the only possible method (in my opinion) is creating a virtual president for each party, which would reign for the entire period, I would like to show in a table. Using aggr function and min and max.