Forum Discussion
Helper IIISynoptic Panel by OKviz question
Hello there,
Quick question using this visualization tool.
I have a custom calendar, I would like to link that calendar with my excel file file as follow:
In my excel file I have two columns
Day = All the days in a month 1-31
Status = could be 1,2,3,4,5
Depends on the day the user choose from 1-5
Being 1= Green, 2= Yellow, 3=Red, etc.
What I have so far is every single day I am getting a different color.
How can I change to reflect my color scale from 1 to 5?
Thank in advance
Hi sajarac
I think I solved it. The documentation on the Okviz site is a little dated but it is to do with the states field.
Here is what I came up with using your file. I will repost this to you in IM and you can see if this helps.
Cheers
Manfred
11 Replies
- mwimberger
Resolver II
Hi sajarac
I've used this visual a little before and the legend colour is based on the category. In the Format tab of this visual, you can select this under Data Colors, if you have the Status ( 1-5) under Category.
I've just used a map visual ( completely wrong for the example I know ) but hopefully it illustrates the solution.
sajaracHello, and thank you very much for your prompt response.
The problem that I have is, I guess the visual is using the column day and "Summing" or Counting"
As you can see the square for day 5 is showing Day = 164, which is basically summing the "Status" column where is equal to 5.
- mwimberger
Hi sajarac
Ah, ok, so to correct that you need to set the day to not autosum. The clue that that is happening, is the sigma (Σ) sign next to "day". To get rid of this , go to the modelling tab of the Desktop, and choose don't summarise. You could choose minimum or better yet, define a measure for this.