I'm trying to create a calendar in Targit and want to apply a grey color to the calendar dimensions "Saturday and Sunday" in a crosstab. Is there a way to apply colors to dimensions or a workaround that I'm not aware of? If not, I'd like to request such a feature.
Ole Dyring Good News!
This feature has been released.
[Cloud release: 2025.01.15]
[On-prem release: 2025 January]
[On-prem build: 25.01.21002]
Details here: https://community.targit.com/hc/en-us/articles/17792755367068-Rowname-and-Colname-calculations
Best regards / Ole
Marlene Knaup could you please add a mockup e.g. in Excel?
kim westendahl Here's a picture of what I have so far. Basically I want to add a grey color to every row with the letter L or S in it. The green color displayed is absence hours (metrik).
Marlene Knaup Hi, I think it is not possible to create a rule for this. But you can change each row manually:
kim westendahl I was looking for something more dynamic, but I appreciate the effort to help.
Ole Dyring Hi Kim and Marlene,
We are close at completing a new calculation function that will be able to do what you are asking for. It will be called "rowname()".
E.g., rowname("L") will return 1 or 0, which you then can use as a condition in a color agent.
BR / Ole
kim westendahl Interesting, I look forward to hearing more about that.
Comments
7 comments