Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Entering target data and Setting Dynamic target lines

Hey Everyone, Hope this message finds you safe and well. On one of my report, I need to add a dynamic target line to a line chart. So I entered the target data as new table region wise. The idea is ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thank you so much everyone for all the help . As this was a small table, I tried recreating the issue again by manually entering the data and this time it read as whole number. I was able to make the joins and it works perfectly:)

v-xicai's avatar
v-xicai
Community Support
5 years ago

Hi Anonymous ,

 

For this errors "dataformat.error we couldn't convert to number", you  may enter into Query Editor, select on this query, go to APPLIED STEPS, find the step named "Changed type" (maybe in the 2nd, 3rd step), then you can do the data type transform which converts the data type from text to number on this step, make sure click "Replace Current" in pop up page.

 

If you need to unpivot the 4 columns to combined column, you may remove the relationship first of all, then go to Query Editor to unpivot the 4 columns. After that, you may recreate Many to Many relationship between the two tables.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.