Hi team, just want help in implementing the below scenario. We have a table like below in one of our pages in a story
Article Date Count
| Article 1 | 01-02-2024 | 1 |
| Article 1 | 02-02-2024 | 2 |
| Article 1 | 03-02-2024 | 3 |
| Article 2 | 01-02-2024 | 1 |
| Article 3 | 02-02-2024 | 1 |
| Article 4 | 03-02-2024 | 2 |
| Article 5 | 04-02-2024 | 1 |
| Article 6 | 05-02-2024 | 3 |
| Article 7 | 01-02-2024 | 1 |
Articles & date are private dimensions, count is a measure.
The table is based on new model type(import connection), and the story is created using ODE. The table have details for articles, date and count, how can we find out those articles that shows up in multiple dates, as example in the above table, "Article 1" comes up on 01.02.2024, 02.02.2024 & 03.02.2024, we need to find such articles and create a new table that shows only those articles that repeatedly shows or at least shows more than one time from the source table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.