Forum Discussion
Solved
YOY visualization question
hi all, I am having difficulties with displaying two diffrent series in the same visualization. I am trying to have a column chart with the first set based on a global fiilter that picks readings f...
The attached is only a rough draft. What you really want is a proper calendar table in your data model.
| ID | myDate(Year) | myDate(Quarter) | myDate(Month) | myDate(Day) | myBitField |
| 1 | 2024 | Q1 | Jan | 1 | 1 |
| 2 | 2024 | Q1 | Jan | 2 | 1 |
| 3 | 2024 | Q1 | Jan | 3 | 0 |
| 4 | 2024 | Q1 | Jan | 4 | 0 |
| 5 | 2024 | Q1 | Jan | 5 | 0 |
| 32 | 2024 | Q1 | Feb | 1 | 1 |
| 33 | 2024 | Q1 | Feb | 2 | 0 |
| 34 | 2024 | Q1 | Feb | 3 | 1 |
| 35 | 2024 | Q1 | Feb | 4 | 0 |
| 36 | 2024 | Q1 | Feb | 5 | 0 |
| 61 | 2024 | Q1 | Mar | 1 | 1 |
| 62 | 2024 | Q1 | Mar | 2 | 1 |
| 63 | 2024 | Q1 | Mar | 3 | 0 |
| 64 | 2024 | Q1 | Mar | 4 | 1 |
| 65 | 2024 | Q1 | Mar | 5 | 0 |
| 92 | 2024 | Q2 | Apr | 1 | 1 |
| 93 | 2024 | Q2 | Apr | 2 | 0 |
| 94 | 2024 | Q2 | Apr | 3 | 0 |
| 95 | 2024 | Q2 | Apr | 4 | 1 |
| 114 | 2024 | Q2 | Apr | 23 | 1 |
| 122 | 2024 | Q2 | May | 1 | 1 |
| 123 | 2024 | Q2 | May | 2 | 1 |
| 124 | 2024 | Q2 | May | 3 | 0 |
| 125 | 2024 | Q2 | May | 4 | 0 |
| 126 | 2024 | Q2 | May | 5 | 1 |
| 153 | 2024 | Q2 | Jun | 1 | 1 |
| 154 | 2024 | Q2 | Jun | 2 | 1 |
| 155 | 2024 | Q2 | Jun | 3 | 0 |
| 156 | 2024 | Q2 | Jun | 4 | 0 |
| 157 | 2024 | Q2 | Jun | 5 | 1 |
| 183 | 2024 | Q3 | Jul | 1 | 1 |
| 184 | 2024 | Q3 | Jul | 2 | 1 |
| 185 | 2024 | Q3 | Jul | 3 | 1 |
| 186 | 2024 | Q3 | Jul | 4 | 0 |
| 187 | 2024 | Q3 | Jul | 5 | 0 |
| 214 | 2024 | Q3 | Aug | 1 | 1 |
| 215 | 2024 | Q3 | Aug | 2 | 1 |
| 216 | 2024 | Q3 | Aug | 3 | 1 |
| 217 | 2024 | Q3 | Aug | 4 | 0 |
| 218 | 2024 | Q3 | Aug | 5 | 0 |
| 245 | 2024 | Q3 | Sep | 1 | 1 |
| 246 | 2024 | Q3 | Sep | 2 | 1 |
| 247 | 2024 | Q3 | Sep | 3 | 1 |
| 248 | 2024 | Q3 | Sep | 4 | 0 |
| 249 | 2024 | Q3 | Sep | 5 | 0 |
| 275 | 2024 | Q4 | Oct | 1 | 0 |
| 276 | 2024 | Q4 | Oct | 2 | 1 |
| 277 | 2024 | Q4 | Oct | 3 | 1 |
| 278 | 2024 | Q4 | Oct | 4 | 1 |
| 279 | 2024 | Q4 | Oct | 5 | 0 |
| 306 | 2024 | Q4 | Nov | 1 | 0 |
| 307 | 2024 | Q4 | Nov | 2 | 1 |
| 308 | 2024 | Q4 | Nov | 3 | 1 |
| 309 | 2024 | Q4 | Nov | 4 | 1 |
| 310 | 2024 | Q4 | Nov | 5 | 0 |
| 336 | 2024 | Q4 | Dec | 1 | 0 |
| 337 | 2024 | Q4 | Dec | 2 | 0 |
| 338 | 2024 | Q4 | Dec | 3 | 1 |
| 339 | 2024 | Q4 | Dec | 4 | 1 |
| 340 | 2024 | Q4 | Dec | 5 | 1 |
| 367 | 2025 | Q1 | Jan | 1 | 1 |
| 368 | 2025 | Q1 | Jan | 2 | 1 |
| 369 | 2025 | Q1 | Jan | 3 | 1 |
| 370 | 2025 | Q1 | Jan | 4 | 0 |
| 371 | 2025 | Q1 | Jan | 5 | 0 |
| 429 | 2025 | Q1 | Feb | 1 | 1 |
| 430 | 2025 | Q1 | Feb | 2 | 1 |
| 431 | 2025 | Q1 | Feb | 3 | 1 |
| 432 | 2025 | Q1 | Feb | 4 | 0 |
| 433 | 2025 | Q1 | Feb | 5 | 0 |
| 485 | 2025 | Q1 | Mar | 1 | 1 |
| 486 | 2025 | Q1 | Mar | 2 | 1 |
| 487 | 2025 | Q1 | Mar | 3 | 1 |
| 488 | 2025 | Q1 | Mar | 4 | 1 |
| 489 | 2025 | Q1 | Mar | 5 | 0 |
| 547 | 2025 | Q2 | Apr | 1 | 1 |
| 548 | 2025 | Q2 | Apr | 2 | 1 |
| 549 | 2025 | Q2 | Apr | 3 | 1 |
| 550 | 2025 | Q2 | Apr | 4 | 1 |
| 551 | 2025 | Q2 | Apr | 5 | 0 |
| 552 | 2025 | Q2 | Apr | 23 | 1 |
The attached is only a rough draft. What you really want is a proper calendar table in your data model.