Percent Difference Calculation with sort field

Question & Answer
, , , ,
1

Hello community
I have a query, about how I could use the “PercentDifference” function so that it can show the correct calculation as I currently do, but showing the year and isoweek as it did before(It started to fail because I was doing it on the isoweek field, which not being sorted as IsoWeek Sortfield the percentages were not calculated in chronological order). Can it be by modifying the visualization or should I modify the IsoWeek Sort Field formula? The Growth table should be ,for the IsoWeek Sort Field 25 , ‘2024-20’ for example, thats what i want to modify.

Captura de pantalla (179)
Captura de pantalla (179)755×709 44.2 KB

Captura de pantalla (180)
Captura de pantalla (180)377×800 10 KB

Captura de pantalla (194)

2

Hey @Juan ,

is there a real date field in your data or maybe an index? You could use this as a sorting field. That would be the best way to sort chronological. If there is no other field you could use for sorting, I think your solution with a sorting field is the best.

BR
Robert

3

Hi Juan,

You are doing it manually, in future when your data increased this will failed. It is hard to manage it manually.

You can you try this, I it will create a week number, you can sort your data on it.

dateDiff(truncDate(‘MM’, mydate), mydate, ‘WK’) + 1

Hope this will help you.

If you have no data field in your dataset you can manage it in you data source but manual approach no good. :slight_smile:
Regards,

Naveed Ali

4

Hi guys @robert.eibers @Naveed thanks for the time and replys!
I do not have a date field, so any solution with that aproach would not work for me in this analysis, but i managed to order the week number so that it matched the Iso Week number at least, for example now Iso Week 2024-23 would be ‘23’ instead of 28. And i guess that i will have to keep it manual, because i have no date field, unless i managed to transform somehow the IsoWeek number into a date, but i think theres is a something like that in Q&A already.

5

Hi @Juan,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your original topic?

If we do not hear back from you within the next 3 business days, I’ll go ahead and archive this topic.

Thank you!

6

Hi @duncan
No additional questions, feel free to close this topic, i solve the issue as i mentioned above so there is no need to keep this open. Thanks!

1 Like